文章浏览阅读2.7k次。hive中的爆炸函数写法:SELECT student, scoreFROM testsLATERAL VIEW explode(scores) t AS score;爆炸函数在presto中的写法:SELECT student, scoreFROM testsCROSS JOIN UNNEST(scores) AS t (score);_presto explode...
文章浏览阅读2.9k次。presto语法:substr(string, start, length) → varchar而且start必须从1开始Hive 中语法:substr(STRING|BINARY A, INT start [, INT len])start 可以从0开始,也可以从1开始,结果是一样的这点要注意_presto substr...