来获取key为monthSales的数据
hive (hive_explode)> SELECT get_json_object(explode(split(regexp_replace(regexp_replace...hive (hive_explode)> SELECT get_json_object(concat('{',sale_info_1,'}'),'$.source') as source,get_json_object...(concat('{',sale_info_1,'}'),'$.monthSales') as monthSales,get_json_object(concat('{',sale_info_1,'}'...,以最左侧的维度为主,从该维度进行层级聚合。...比如,以month维度进行层级聚合:
hive> SELECT month,day,
COUNT(DISTINCT cookieid) AS uv,
GROUPING_ID
FROM test_t5
GROUP