9951 explained code solutions for 126 technologies


clickhouseInsert bulk TSV data into table


cat data.tsv | clickhouse-client -q "INSERT INTO tbl FORMAT TSV"ctrl + c
data.tsv

file with TSV data to insert

clickhouse-client -q

execute given query through client interface

tbl

table to insert data into

FORMAT TSV

use TSV format for reading data