clickhouse架构及存储方式
clickhouse架构未开源
用于对干净,结构良好且不可变的事件或日志进行分析。建议将每个这样的流放入一个带有预加入尺寸的单一宽事实表中。
可行的应用程序的一些例子:
Web和App分析
广告网络和RTB
电信
电子商务和金融
信息安全
监测和遥测
时间序列
商业智能
线上游戏
物联网
事务性工作负载(OLTP)
高请求率的键值访问
Blob或文档存储
超标准化的数据
不适用场景
系统要求
ClickHouse可以在任何具有x86_64,AArch64或PowerPC64LE CPU架构的Linux,FreeBSD或Mac OS X上运行。
官方预构建的二进制文件通常针对x86_64进行编译,并利用SSE 4.2指令集,因此,除非另有说明,支持它的CPU使用将成为额外的系统需求。下面是检查当前CPU是否支持SSE 4.2的命令:
$ grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
要在不支持SSE 4.2或AArch64,PowerPC64LE架构的处理器上运行ClickHouse,您应该通过适当的配置调整从源代码构建ClickHouse。
RPM安装
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/stable/x86_64
sudo yum install clickhouse-server clickhouse-client
你也可以从这里手动下载安装包:https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/
简单的使用 服务起停
停止:
service clickhouse-server stop
启动:
service clickhouse-server start
用clickhouse-client连接本机clickhouse-server服务器:
Clickhouse-client
用本机clickhouse-client连接远程clickhouse-server服务器:
clickhouse-client –host 192.168.3.54 –port 9000 –database default–user default –password “”
DDL(data definition language)
create table funtest(id UInt32, name String ,age UInt32,times Date)ENGINE=Log
drop table funtest
alter table ontime_all add COLUMN name String;
DML(data manipulation language)
insert into funtest values(3,'xiaoming',22,'2017-11-09')
insert into funtest values(32,'xiaolan',33,'2017-11-08')
insert into funtest values(35,'xiaotong',33,'2017-11-07')
insert into funtest values(4,'xiaohuang',33,'2017-11-08')
insert into funtest values(44,'xiaolvas',34,'2017-11-05')
insert into funtest values(6,'xiaohuanasg',32,'2017-11-28')
select * from funtest
select * from funtest order by id
select * from funtest order by id desc
select avg(age) from funtest
select count(name) from funtest
select age from funtest group by age
select round(age/3) FROM funtest
select cast('2015-12-22' as date) from funtest
select cast('2015-12-22' as date)+30 from funtest
select stddev_samp(age) FROM funtest
select upper('hhh') from funtest
select upper(name) from funtest
select abs(-1) from funtest
select * FROM funtest where times =cast('2015-12-22' as date)
select max(age) from funtest
select case when name ='xiaoming' then concat(name,'dddd') else 'ddddfdfdfdf' end from funtest
select substring(name,1,3) from funtest
select rand() from funtest
下一篇: Redis 的几种数据导入导出方式→