clickhouse
lin502
这个作者很懒,什么都没留下…
展开
-
DBeaver连接ClickHouse实操
DBeaver和ClickHouse已经安装好。DBeaver连接ClickHouse需要开放远程访问权限。先查看ClickHouse server端监听端口的状态:[root@cdh-node001 clickhouse-server]# lsof -i :8123COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE...原创 2019-10-22 16:11:43 · 4728 阅读 · 5 评论 -
从hive导入数据到clickhouse中
一、从hive中导出csv格式的数据:hive -e "select * from tablename limit 1000" | tr "\t" "," > /opt/hadoop/tablename.csv二、把csv格式的数据导入到clickhouse中:clickhouse-client -h 127.0.0.1 --query='INSERT INTO tablena...原创 2019-10-17 16:58:39 · 4730 阅读 · 2 评论