SELECT log_map, t.key, t.value
FROM (
SELECT log_map
FROM table
WHERE dayno = 20200920
) a
lateral VIEW explode(log_map) t AS key, value
如果log_map里多个key和value,则拆成多行。
SELECT log_map, t.key, t.value
FROM (
SELECT log_map
FROM table
WHERE dayno = 20200920
) a
lateral VIEW explode(log_map) t AS key, value
如果log_map里多个key和value,则拆成多行。