clickhouseClickhouse HTTP GET query example
curl "127.0.0.1:8123?query=select+now()"ctrl + ccurluse curl to send HTTP request | 127.0.0.1Clickhouse host IP |
8123Clickhouse server port | querysend SQL query in |
select+now()URL-encoded SQL query | |
Usage example
curl "127.0.0.1:8123?query=select+now()"output
2022-01-12 19:02:22More 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...