clickhouseInsert bulk TSV data into table
cat data.tsv | clickhouse-client -q "INSERT INTO tbl FORMAT TSV"ctrl + cdata.tsvfile with TSV data to insert | clickhouse-client -qexecute given query through client interface |
tbltable to insert data into | FORMAT TSVuse |
More of Clickhouse
- Convert array to rows
- Get total database size
- How to execute SQL query from a file
- Select where date column is between dates
- How to restart Clickhouse server
- List all tables from all database
- Select sumIf query example
- Using variables in queries
- Convert array to string
- Select countIf usage example
See more codes...