clickhouse3

查看update/delete是否执行完毕：

select is_done from system.mutations where table='view_bht_user_reg_info' order by create_time desc limit 1

CREATE TABLE yztreg(id String,startTime DateTime,reqChnlId String, regChnlId String,saleChannel String,activityCode String,sourceId String,referralCode String,parentReferralCode String,accountId String,mobile String,certNo String,certName String,certType String,certLevel String,birthday String,sex String,certExpBegin String,certExpEnd String,email String,shareToken String,shareType String,regTime String,reqDate String,highRiskOps String,userLoginId String,refID String,refStaffNo String,refMobile String,refName String,refOrganCode String,refOrganName String,refCertNo String,refCertType String,refStatus String,refCreateAT String,transactionCode String, error String, message String,targetClz String,methodName String,code String,sourceType String,userCertInfoJson String,userInfoJson String,requestJson String,traceThirdUserInfos String,costTime String,scope String,IP String,partId String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/user/{shard}/yztreg', '{replica}', d, (id), 8192)

==》》》》》》》》》》》》》》》

CREATE TABLE yztreg(id String,startTime DateTime,reqChnlId String, regChnlId String,saleChannel String,activityCode String,sourceId String,referralCode String,parentReferralCode String,accountId String,mobile String,certNo String,certName String,certType String,certLevel String,birthday String,sex String,certExpBegin String,certExpEnd String,email String,shareToken String,shareType String,regTime String,reqDate String,highRiskOps String,userLoginId String,refID String,refStaffNo String,refMobile String,refName String,refOrganCode String,refOrganName String,refCertNo String,refCertType String,refStatus String,refCreateAT String,transactionCode String, error String, message String,targetClz String,methodName String,code String,sourceType String,userCertInfoJson String,userInfoJson String,requestJson String,traceThirdUserInfos String,costTime String,scope String,IP String,partId String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/user/yztreg', '1', d, (id), 8192)

CREATE TABLE yztreg(id String,startTime DateTime,reqChnlId String, regChnlId String,saleChannel String,activityCode String,sourceId String,referralCode String,parentReferralCode String,accountId String,mobile String,certNo String,certName String,certType String,certLevel String,birthday String,sex String,certExpBegin String,certExpEnd String,email String,shareToken String,shareType String,regTime String,reqDate String,highRiskOps String,userLoginId String,refID String,refStaffNo String,refMobile String,refName String,refOrganCode String,refOrganName String,refCertNo String,refCertType String,refStatus String,refCreateAT String,transactionCode String, error String, message String,targetClz String,methodName String,code String,sourceType String,userCertInfoJson String,userInfoJson String,requestJson String,traceThirdUserInfos String,costTime String,scope String,IP String,partId String,d Date, createDate DateTime) ENGINE = ReplicatedMergeTree('/clickhouse/bdx/user/yztreg', '2', d, (id), 8192)



/////

<!-- Maximum memory usage for processing single query, in bytes.10000000000 -->
<max_memory_usage>3000000000</max_memory_usage>

 

<macros>
<shard>01</shard>
<replica>rep2</replica>
</macros>

 

<macros>
<shard>01</shard>
<replica>rep1</replica>
</macros>