ClickHouse安装

上传ClickHouse rpm安装包到/opt/bpasoftware/

clickhouse-client-21.9.7.2-2.noarch.rpm
clickhouse-common-static-21.9.7.2-2.x86_64.rpm
clickhouse-common-static-dbg-21.9.7.2-2.x86_64.rpm
clickhouse-server-21.9.7.2-2.noarch.rpm

使用rpm包安装：期间有让输入密码的交互，记住该密码，后面配置中要使用

rpm -ivh *.rpm

查看安装情况

rpm -qa|grep clickhouse

修改配置文件打开远程访问，把<listen_host>::</listen_host> 的注释打开

vim /etc/clickhouse-server/config.xml

服务启动

启动Server

systemctl start clickhouse-server

客户端连接

clickhouse-client -m --password <密码>

Jar包适配

将ClickHouse驱动包 放入Spark安装目录jars下

cp clickhouse-jdbc-0.2.4.jar /opt/bpasoftware/spark-2.0.2-bin-hadoop2.6/jars/

将guava-16.0.1.jar 放入Spark安装目录jars下

cp guava-16.0.1.jar /opt/bpasoftware/spark-2.0.2-bin-hadoop2.6/jars/

jar包适配操作需要应用于每一台集群服务器节点