Clickhouse 导入数据
SQL
单行导入 JSONEachRow
INSERT INTO mydata FORMAT JSONEachRow {json}
从 HTTP static server 导入
INSERT INTO qq_phone FROM url('http://192.168.1.1:8000/sql_0.ndjson') FORMAT JSONEachRow;
HTTP API
Send SQL
echo 'INSERT INTO qq_phone FORMAT JSONEachRow {"email_address":"[email protected]","phone":"12345678","qq":"12345678","message":"12345678","id":"12345678","ts":"2023-05-09T22:06:20Z"}' | curl 'http://clickhouse:[email protected]:8123/?database=my_database' --data-binary @-
GUI
Ref
- https://clickhouse.com/docs/en/getting-started/quick-start#7-insert-your-own-data
- https://clickhouse.com/docs/en/sql-reference/table-functions/url
- https://clickhouse.com/docs/en/sql-reference/statements/insert-into#multiple-files-with-from-infile-using-globs
- https://clickhouse.com/docs/en/sql-reference/statements/insert-into#inserting-data-from-a-file