clickhouseClickhouse HTTP query example
curl "127.0.0.1:8123" --data "SELECT * FROM tbl"ctrl + ccurluse curl to send HTTP request | 127.0.0.1Clickhouse host IP |
8123Clickhouse server port | --datasend raw data to server |
SELECT * FROM tblsample request to execute on Clickhouse server | |
Usage example
curl "127.0.0.1:8123" --data "SELECT * FROM tbl"output
1970-01-01 Donald 0 125
2022-01-07 Donald 0 0
2022-01-10 Donald 0 0
...More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Select rows with certain value in array column
- Create table example
- Using variables in queries
- Add row number to results
- List all tables from all database
- Select where date column is between dates
- Create table with UUID column
- String concat
See more codes...