hive与presto炸裂函数

hive炸裂函数

SELECT student, score
FROM tests
LATERAL VIEW explode(scores) t AS score;

presto炸裂函数

SELECT student, score
FROM tests
CROSS JOIN UNNEST(scores) AS t (score);
版权声明：本文为qq_36593748原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。