How to insert data to Clickhouse from file by HTTP-interface?

Question

I want to insert data to ClickHouse per HTTP-interface from file. CSV, JSON, TabSeparated, it's doesn't matters.

Or insert data to Docker-container uses yandex/clickhouse-server.

Using HTTP-interface, for example:

cat source.csv | curl 'http://localhost:8123/?query=INSERT INTO table FORMAT CSV'

Using Docker-container, for example:

docker run -it --rm --link some-clickhouse-server:clickhouse-server yandex/clickhouse-client --host clickhouse-server {THERE SOME OPTIONS ABOUT INSERT FROM FILE}

Thanks.

Answer 1

curl 'http://localhost:8123/?query=INSERT+INTO+TABLE(field)+VALUES(data)%3b'

or

curl -d 'INSERT INTO T FORMAT JSONEachRow {"dataTime":"2020-12-19 03:00:00","transmit_bytes_max":123};' 'http://9.118.102.189:9200/?database=default'

or

curl 'http://localhost:8123/?query=INSERT%20INTO%20TABLE%20FORMAT%20CSV' --data-binary @source.csv

Answer 2

cat source.csv | curl 'http://localhost:8123/?query=INSERT%20INTO%20table%20FORMAT%20CSV' --data-binary @-