Reformat CSV to clickhouse-compatible TSV

csv2tsv.py

#!/usr/bin/env python
import csv, sys
csv.register_dialect('clickhouse', escapechar="\\", doublequote=0, quotechar='\'',skipinitialspace = 0,delimiter   = '\t', quoting=csv.QUOTE_NONE, lineterminator='\n')
csv.writer(sys.stdout, dialect='clickhouse').writerows(csv.reader(sys.stdin))

# install:
#  put in $PATH
#  chmod +x csv2tsv.py

# usage:
# cat file.csv | csv2tsv.py | clickhouse-client ... --query='INSERT ...'