clickhouse

http://repo.red-soft.biz/repos/clickhouse/stable/el6/

yum search libicu

yum install libicu.x86_64

rpm -ivh clickhouse-common-static-19.9.5.36-1.el6.x86_64.rpm

rpm -ivh clickhouse-server-common-19.9.5.36-1.el6.x86_64.rpm

rpm -ivh clickhouse-server-19.9.5.36-1.el6.x86_64.rpm

rpm -ivh clickhouse-client-19.9.5.36-1.el6.x86_64.rpm

rpm -ivh clickhouse-test-19.9.5.36-1.el6.x86_64.rpm

 

 ln -s /etc/clickhouse-server/ conf

 

clickhouse-server --config-file=/etc/clickhouse-server/config.xml

修改ip, 密码

service clickhouse-server stop

service clickhouse-server start


rpm -ivh clickhouse-common-static-1.1.54390-1.el6.x86_64.rpm
rpm -ivh clickhouse-server-common-1.1.54390-1.el6.x86_64.rpm
rpm -ivh clickhouse-server-1.1.54390-1.el6.x86_64.rpm
rpm -ivh clickhouse-debuginfo-1.1.54390-1.el6.x86_64.rpm
rpm -ivh clickhouse-client-1.1.54390-1.el6.x86_64.rpm
rpm -ivh clickhouse-test-1.1.54390-1.el6.x86_64.rpm

rpm -e xxxx.rpm

[root@rabbitmq3 new]# rpm -e clickhouse-client
[root@rabbitmq3 new]# rpm -e clickhouse-test
[root@rabbitmq3 new]# rpm -e clickhouse-server
[root@rabbitmq3 new]# rpm -e clickhouse-debuginfo
[root@rabbitmq3 new]# rpm -e clickhouse-common-static
[root@rabbitmq3 new]# rpm -e clickhouse-server-common

 

 

• 删除数据

     ALTER TABLE [db.]table DELETE WHERE filter_expr
  

• 更新数据

    ALTER TABLE [db.]table UPDATE column1 = expr1 [, ...] WHERE filter_expr

 

ALTER TABLE `default`.activity_click DELETE WHERE code='029'

添加列

ALTER TABLE `default`.activity_click ADD COLUMN saleChannel String AFTER deviceType;

CREATE TABLE activity_click(id String,activity_code String,func_name String,mobile String,ip String,d Date, createDate DateTime) ENGINE = MergeTree(d, (id), 8192)

CREATE TABLE activity_click(id String,activity_code String,func_name String,mobile String,ip String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/click', '1', d, (id), 8192)

CREATE TABLE activity_click(id String,activity_code String,func_name String,mobile String,ip String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/click', '2', d, (id), 8192)

CREATE TABLE activity_click(id String,activity_code String,func_name String,mobile String,ip String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/click', '3', d, (id), 8192)

CREATE TABLE activity_click(id String,code String,name String,platformId String,deviceType String,mobile String,ip String,host String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/click', '1', d, (id), 8192) 
CREATE TABLE activity_click(id String,code String,name String,platformId String,deviceType String,mobile String,ip String,host String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/click', '2', d, (id), 8192)
CREATE TABLE activity_click(id String,code String,name String,platformId String,deviceType String,mobile String,ip String,host String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/click', '3', d, (id), 8192)

CREATE TABLE appstat(messageId String,startTime UInt64,endTime UInt64,accountId String, targetUrl String, originalUrl String,serviceId String,resultCode String,messageCode String,message String,method String,contentType String,originalContentType String,requesterIp String,pointStage String,debugMode String,debugParamData String,contentLength UInt64,pointTags_category String,pointTags_targetId String,deviceType String, platformId String, appVersion String, tokenId String, tokenId2 String, deviceAppId String, appChannel String,userAgent String,host String,pointCode String,clientId String,headerTags String,userTags String,respTags String, d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/appstat', '1', d, (messageId), 8192)

CREATE TABLE appstat(messageId String,startTime UInt64,endTime UInt64,accountId String, targetUrl String, originalUrl String,serviceId String,resultCode String,messageCode String,message String,method String,contentType String,originalContentType String,requesterIp String,pointStage String,debugMode String,debugParamData String,contentLength UInt64,pointTags_category String,pointTags_targetId String,deviceType String, platformId String, appVersion String, tokenId String, tokenId2 String, deviceAppId String, appChannel String,userAgent String,host String,pointCode String,clientId String,headerTags String,userTags String,respTags String, d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/appstat', '2', d, (messageId), 8192)

CREATE TABLE appstat(messageId String,startTime UInt64,endTime UInt64,accountId String, targetUrl String, originalUrl String,serviceId String,resultCode String,messageCode String,message String,method String,contentType String,originalContentType String,requesterIp String,pointStage String,debugMode String,debugParamData String,contentLength UInt64,pointTags_category String,pointTags_targetId String,deviceType String, platformId String, appVersion String, tokenId String, tokenId2 String, deviceAppId String, appChannel String,userAgent String,host String,pointCode String,clientId String,headerTags String,userTags String,respTags String, d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/stat/appstat', '3', d, (messageId), 8192)