1、导出
远程导出命令,默认分割符是tab:(本地就ip=127,0,0.1)
echo 'select * from table_name' | curl ip:8123?database=mybi -uroot:password -d @- > table_name.sql
2、导入数据,以tab作为分割符:
导入数据库的本机执行:
cat table_name.sql | clickhouse-client --query="INSERT INTO database.table_name FORMAT TabSeparated"