s
https://clickhouse.yandex
clickhouse 基础知识
https://www.jianshu.com/p/a5bf490247ea
《大数据实时分析领域的黑马ClickHouse》二次解读
https://blog.csdn.net/haitianxueyuan521/article/details/80983001
ClickHouse 1秒,Vertica 5.42秒,Hive 279秒;
ClickHouse比Vertia快约5倍,比Hive快279倍,比My SQL 快801倍
ClickHouse是一个用于联机分析(OLAP)的列式数据库管理系统(DBMS)。
https://clickhouse.yandex/docs/zh/
常见的列式数据库有: Vertica、 Paraccel (Actian Matrix,Amazon Redshift)、 Sybase IQ、 Exasol、 Infobright、 InfiniDB、 MonetDB (VectorWise, Actian Vector)、 LucidDB、 SAP HANA、 Google Dremel、 Google PowerDrill、 Druid、 kdb+。
安装clickhouse步骤,依次如下执行安装。
[root@centos7 ~]# grep -q sse4_2 /proc/cpuinfo && echo “SSE 4.2 supported” || echo “SSE 4.2 not supported”
“SSE 4.2 supported”
1、安装rpm -ivh clickhouse-common-static-19.5.3.8-1.el7.x86_64.rpm 2、安装rpm -ivh clickhouse-server-common-19.5.3.8-1.el7.x86_64.rpm 3、安装rpm -ivh clickhouse-server-19.5.3.8-1.el7.x86_64.rpm 4、安装rpm -ivh clickhouse-client-19.5.3.8-1.el7.x86_64.rpm
[root@centos7 ~]# clickhouse-server -V
ClickHouse server version 19.5.3.1
[root@centos7 ~]# /etc/init.d/clickhouse-server restart
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
DONE
end