9951 explained code solutions for 126 technologies


clickhouseRestore single table from TSV dump


clickhouse-client < structure.tsv
zcat data.tsv.gz | clickhouse-client -q "INSERT INTO tbl FORMAT TSV"ctrl + c
clickhouse-client

CLI client

structure.tsv

table structure file created during backup

data.tsv.gz

backup file with table data in gzipped TSV format

tbl

table name to restore

INSERT INTO

will insert given data to tbl table