【数据库】clickhouse 列数据库学习记录

linux安装：https://clickhouse.tech/#quick-startsudo yum install yum-utilssudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPGsudo yum-config-manager --add-repo https://repo.clickhouse.tech/r

bandaoyu

686人浏览 · 2020-08-03 21:17:09

bandaoyu · 2020-08-03 21:17:09 发布

linux安装：

https://clickhouse.tech/#quick-start

sudo yum install yum-utils
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
sudo yum install clickhouse-server clickhouse-client

启动

关闭防火墙 
systemctl stop firewalld.service #停止firewall 
systemctl disable firewalld.service #禁止firewall开机启动<


启动clickhouse服务端 
service clickhouse-server start

通过客户端连接 
clickhouse-client –m

更快的体验方式是：拉取clickhouse 实例到本地运行

JDBC 客户端

github链接	描述
clickhouse-jdbc	官方提供，基于 http 实现，与 server 的 8123 端口进行通信
ClickHouse-Native-JDBC	第三方lib，基于 tcp 实现，与 server 的 9000 端口进行通讯 *性能相对更优，推荐使用*

可视化工具：

clickhouse的可视化工具DEeaver：https://blog.csdn.net/weixin_39025362/article/details/105631540

下载：https://www.cnblogs.com/cbugs/p/13358246.html

错误记录：

Address family for hostname not supported (version 20.5.4.40 (official build)) Address family for hostname not supported (version 20.5.4.40 (official build))

是禁用了IP6的原因：开启IP6

https://www.cnblogs.com/betx/p/7115396.html

用户配置

设置个新用户玩玩吧~~~（https://blog.csdn.net/jz1993/article/details/82914187）


[root@pcdnasdevapp03 etc]# cd clickhouse-server/
[root@pcdnasdevapp03 clickhouse-server]# cat users.xml
<?xml version="1.0"?>
<yandex>
    <profiles>
        <default>
            <max_memory_usage>10000000000</max_memory_usage>
<use_uncompressed_cache>0</use_uncompressed_cache>
            <load_balancing>random</load_balancing>
        </default>
        <readonly>
            <readonly>1</readonly>
        </readonly>
    </profiles>
    <users>
        <default>
            <password></password>
            <networks incl="networks" replace="replace">
                <ip>::/0</ip>
            </networks>
            <profile>default</profile>
            <quota>default</quota>
        </default> 
        <dba>
            <password_sha256_hex>e6cfd8b39bd6c6503a5486e9d7ff23ccca72b1876a7ccdb6e3fb2f8e6a927476  </password_sha256_hex>
            <networks incl="networks" replace="replace">
                <ip>::/0</ip>
            </networks>
            <profile>default</profile>
            <quota>default</quota>
            <allow_databases>
               <database>test</database>
            </allow_databases>
        </dba> 
        <readonly>
            <password></password>
            <networks incl="networks" replace="replace">
                <ip>::1</ip>
                <ip>127.0.0.1</ip>
            </networks>
            <profile>readonly</profile>
            <quota>default</quota>
        </readonly>
    </users>
    <quotas>
        <default>
            <interval>
                <duration>3600</duration>
                <queries>0</queries>
                <errors>0</errors>
                <result_rows>0</result_rows>
                <read_rows>0</read_rows>
                <execution_time>0</execution_time>
            </interval>
        </default>
    </quotas>
</yandex>
[root@pcdnasdevapp03 clickhouse-server]#

dba随便命名

密码是参照：https://www.cnblogs.com/gomysql/p/6708796.html

[root@pcdnasdevapp03 ~]# PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-'
3iD5SG6L
e6cfd8b39bd6c6503a5486e9d7ff23ccca72b1876a7ccdb6e3fb2f8e6a927476

仅输入PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-'生成

密码：3iD5SG6L

密文：e6cfd8b39bd6c6503a5486e9d7ff23ccca72b1876a7ccdb6e3fb2f8e6a927476

[root@pcdnasdevapp03 clickhouse-server]# clickhouse-client -u dba -h 127.0.0.1 --password 3iD5SG6L
ClickHouse client version 18.12.17.
Connecting to 127.0.0.1:9000 as user dba.
Connected to ClickHouse server version 18.12.17 revision 54407.
pcdnasdevapp03 :)

客户端连接成功！

用idea在连接下

ggggggggggg