ck
专注于大数据技术栈
记录点点滴滴
展开
-
ClickHouse表引擎介绍
https://blog.csdn.net/a1373712651/article/details/103608340转载 2020-08-19 16:26:33 · 257 阅读 · 0 评论 -
ClickHouse简单操作
1、创建表(clickhouse不支持换行)CREATE TABLE数据库名.表名(`id` UInt16, `port` String, `create` Date) ENGINE = MergeTree(create, id, 8192);2、远程导入mysql数据并新建表CREATE TABLE表名ENGINE = MergeTree ORDER BY id AS SELECT * FROM mysql('ip:端口', '数据库', '表名', '用户名', '密码') as ...原创 2020-08-18 10:22:49 · 629 阅读 · 0 评论 -
将Hive数据写入ClickHouse中
1.这个是hiveSQLhive -e "selectcol1,col2,col3,col4from kuName.tableName" | tr "\t" "," > /abcd/efg/fileName.csv2.在ClickHouse某台机器上执行:clickhouse-client -u userName-h 120.0.0.1--password mima --query 'INSERT INTO ckKuName.ckTableName FORMAT C...原创 2020-07-29 18:35:33 · 1663 阅读 · 0 评论