ClickHouse 入门实战01

秒速五厘米 2022-01-11 03:25 200阅读 0赞

1，官网 [http://clickhouse.com.cn/?tab=all][http_clickhouse.com.cn_tab_all]

2，下载 地址 [https://packagecloud.io/altinity/clickhouse][https_packagecloud.io_altinity_clickhouse]

需要下载的东西：![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70][]

每个点击去都可以看到右侧下载地址：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 1][]

在linux执行，下载完5个rpm包之后，在下载路径执行命令 rmp -ivh \*

3，安装

**一、在CentOS上部署clickhouse**

vim /etc/clickhouse-server/config.xml
        
        <path>/data/dmp/ipgclickhouse</path>

mkdir -p /data/dmp/ipgclickhouse #这个是我自定的路径，因为该路径在fastdfs上
    chown -R clickhouse:clickhouse /data/dmp/ipgclickhouse
    /etc/init.d/clickhouse-server restart
    Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /data/dmp/ipgclickhouse
    DONE

ps aux | grep clickhouse 
    发现没有clickhouse进程，查看日志：
    tail -n10 /var/log/clickhouse-server/clickhouse-server.log 
    <Error> Application: Net Exception: Cannot assign requested address: [::1]:8123

不能绑定ipv6

vim /etc/clickhouse-server/config.xml
    
           ##注释掉该行，因为我们的网卡不能监听ipv6
        <listen_host>0.0.0.0</listen_host>

重新启动，ok

/etc/init.d/clickhouse-server restart
    
    ps aux | grep clickhouse
    clickho+  39803  0.0  0.0 248756 27756 ?        Ssl  19:56   0:00 clickhouse-server --daemon --pid-file=

[http_clickhouse.com.cn_tab_all]: http://clickhouse.com.cn/?tab=all
[https_packagecloud.io_altinity_clickhouse]: https://packagecloud.io/altinity/clickhouse
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70]: /images/20220111/1c10d4ea6c7c4f159bbb650dc6dd6f68.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 1]: /images/20220111/1781e48365df44948cda9e0a40fd91eb.png