hive与presto炸裂函数

hive炸裂函数

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

presto炸裂函数

SELECT student, score
FROM tests
CROSS JOIN UNNEST(scores) AS t (score);
1
2
3