TIDB支持Hive的高阶函数吗? 比如WITH CUBE
创建立方体
比如按 (省、市、区、手机型号、app版本、下载渠道)维度 组合计算日活数,
结果行数有: *省维度的基数 * 市维度的基数 * 区维度的基数 **
INSERT INTO TABLE cube
SELECT
province,
city,
district,
device_type,
os_name,
app_version,
release_channel,
hour_segement,
count(distinct guid) as dau_cnt
FROM t_src
GROUP BY
province,
city,
district,
device_type,
os_name,
app_version,
release_channel,
house_segment
WITH CUBE
;