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);
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
