1.这个是hiveSQL
hive -e "
select
col1,col2,col3,col4
from kuName.tableName
" | tr "\t" "," > /abcd/efg/fileName.csv
2.在ClickHouse某台机器上执行:
clickhouse-client -u userName -h 120.0.0.1--password mima --query 'INSERT INTO ckKuName.ckTableName FORMAT CSV' < /abcd/efg/fileName.csv
本人亲测没有问题,简单明了