Clickhouse常用sql
数据合并:OPTIMIZE TABLE iap_test1.iap_ticket_list final字符串截取:select distinct substr(row_key, 5, 2) from iap.iap_personnel_dic三元运算组:select distinct substr(row_key, 5, 2) == '11'? 238:3 from字符串切分数组:select distinct arrayElement(splitByChar('-',row_key),2) ...
原创
2021-09-23 15:03:42 ·
354 阅读 ·
0 评论