程裕强的专栏

1、当前版本20.3.9.70[root@node1 ~]# clickhouse-client --passwordClickHouse client version 20.3.9.70 (official build).Password for user (default):Connecting to localhost:9000 as user default.Connected to ClickHouse server version 20.3.9 revision 54433.ela

参考官方文档https://clickhouse.tech/docs/en/getting-started/example-datasets/ontime/1、下载数据https://yadi.sk/d/pOZxpa42sDdgm2、加压缩[root@elastic1 data]# lltotal 15439336-rw-r--r-- 1 root root 3532492212 Sep 14 15:38 ontime.csv.xz...[root@elastic1 data]# xz -

参考官方教程：https://clickhouse.tech/docs/en/getting-started/tutorial/1、新建数据表Yandex.Metrica is a web analytics service, and sample dataset doesn’t cover its full functionality, so there are only two tables to create:YandexMetrica是一个网络分析服务，样本数据集不包括其全部功能，因此只有两个

1、创建数据库实例[root@elastic1 ~]# clickhouse-client --query "CREATE DATABASE IF NOT EXISTS tutorial"Code: 210. DB::NetException: Connection refused (localhost:9000)[root@elastic1 ~]#发现不能本地登录，修改配置文件[root@elastic1 ~]# vi /etc/clickhouse-server/config.xml &

编辑配置文件/etc/clickhouse-server/config.xml1、允许远程访问<listen_host>用于限制来源主机的请求 <!-- Listen specified host. use :: (wildcard IPv6 address), if you want to accept connections both with IPv4 and IPv6 from everywhere. --> <!-- <listen_host

1、明文密码（1）查找user.xml文件[root@elastic1 app]# cd /etc/clickhouse-server/[root@elastic1 clickhouse-server]# lltotal 40drwxr-xr-x 2 root root 4096 Sep 11 13:39 config.d-rw-r--r-- 1 root root 22601 Sep 11 13:45 config.xmllrwxrwxrwx 1 root root 41 Sep 1

1、原因由于公司内网服务器环境是不能联网的，没法通过在线方式安装。这里记录一下通过RPM包离线安装Clickhouse 20.3（LTS版本）的过程。2、下载RPM包https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/下载三个RPM包clickhouse-client-20.3.9.70-2.noarch.rpmclickhouse-common-static-20.3.9.70-2.x86_64.rpmclickhouse-server-

1、DBeaver 简介DBeaver 是一个基于 Java 开发，免费开源的通用数据库管理和开发工具，可以运行在各种操作系统上。DBeaver 通过 JDBC 连接到数据库，可以支持几乎所有的数据库产品。2、新建连接3、通过DBeaver操作ClickHouse...

1、TabixOpen source simple business intelligence application and sql editor tool for Clickhouse.https://github.com/tabixio/tabix官方提供了五种安装方式，请参加https://tabix.io/doc/Install/#variant-5-from-docker，这里我们使用从Docker启动方式。2、启动Tabixdocker run -d -p 8080:80 spoon

https://docs.docker.com/docker-for-windows/install/下载https://hub.docker.com/editions/community/docker-ce-desktop-windows/

1、查询ClickHouse镜像docker search clickHouse2、 拉取镜像docker pull yandex/clickhouse-clientdocker pull yandex/clickhouse-server3、启动server端容器D盘下新建数据文件目录clickhouseD:\Users\chengyq>docker run -d --name clickhouse-server --ulimit nofile=262144:262144 --v