ClickHouse导出格式
csv格式,里边是字符串,以逗号分隔,可以使用excel打开(类似于表格)
//(导出为csv格式)
clickhouse-client --query "select * from t_order_mt where create_time='2020-06-01 12:00:00'" --format CSVWithNames> /opt/module/data/rs1.csv
//(导出为json格式):
clickhouse-client --query "select * from t_order_mt where create_time='2020-06-01 12:00:00'" --format CSVWithNames> /opt/module/data/rs1.json