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);
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);