CSV导入
1, 新建表:
CREATE TABLE zhanguo(
name String COMMENT '姓名',
age UInt8 comment '年龄',
Country String comment '国家',
Job String comment '职业'
)ENGINE = MergeTree()
ORDER BY (name,age,Country)
SETTINGS index_granularity = 8192 ;
2, 准备CSV数据
嬴政,23,秦,王
赵括,24,赵,将军
王翦,53,秦,上将军
屈原,25,楚,士大夫
李冰,30,秦,郡守
韩非,32,韩,士大夫
赵高,31,秦,太监
李斯,33,秦,丞相
3, 导入:
[root@A014002337 ~]# cat zhanguo.csv | clickhouse-client -h 127.0.0.1 --database wang --query "INSERT INTO zhanguo FORMAT CSV"
default@127.0.0.1:9000 [wang] :) select * from zhanguo;
SELECT *
FROM zhanguo
┌─name─┬─age─┬─Country─┬─Job────┐
│ 嬴政 │ 23 │ 秦 │ 王 │
│ 屈原 │ 25 │ 楚 │ 士大夫 │
│ 李冰 │ 30 │ 秦 │ 郡守 │
│ 李斯 │ 33 │ 秦 │ 丞相 │
│ 王翦 │ 53 │ 秦 │ 上将军 │
│ 赵括 │ 24 │ 赵 │ 将军 │
│ 赵高 │ 31 │ 秦 │ 太监 │
│ 韩非 │ 32 │ 韩 │ 士大夫 │
└──────┴─────┴─────────┴────────┘
8 rows in set. Elapsed: 0.003 sec.
default@127.0.0.1:9000 [wang] :)
CSV导出:
[root@A014002337 ~]clickhouse-client -h 127.0.0.1 --database wang --query "select * from zhanguo format CSV" > zhanguo.csv
[root@A014002337 ~]# cat zhanguo.csv
"嬴政",23,"秦","王"
"屈原",25,"楚","士大夫"
"李冰",30,"秦","郡守"
"李斯",33,"秦","丞相"
"王翦",53,"秦","上将军"
"赵括",24,"赵","将军"
"赵高",31,"秦","太监"
"韩非",32,"韩","士大夫"