Clickhouse 安装
官网安装方法
版本升级降级
官网安装包下载路径
- 下载安装包
- clickhouse-client-21.8.5.7-2.noarch.rpm
- clickhouse-common-static-21.8.5.7-2.x86_64.rpm
- clickhouse-common-static-dbg-21.8.5.7-2.x86_64.rpm
- clickhouse-server-21.8.5.7-2.noarch.rpm
- 升级或降级
sudo rpm -Uvh ./*.rpm
yum downgrade ./*.rpm -y
systemctl restart clickhouse-server
导入导出数据
clickhouse-client -h 127.0.0.1 --port 9001 --password 123456 --database="dpaas_db" --query="select * from dpaas_db.dws_mall_product_item_df FORMAT CSV" > dws_mall_product_item_df.csv
clickhouse-client -h 172.26.20.120 --port 19000 -u u1 --password 123456 --database="default" --query="insert into default.dws_mall_product_item_df FORMAT CSV" < ./dws_mall_product_item_df.csv