
Hive
谜失落的世界
这个作者很懒,什么都没留下…
展开
-
Lateral View Outer
语法: lateralView: LATERAL VIEW [OUTER] udtf(expression) tableAlias AS columnAlias (',' columnAlias) * fromClause: FROM baseTable (lateralView)* Lateral view outer:当table function不输出任何一行时,对应的输入行在Late...原创 2019-12-17 16:39:36 · 3079 阅读 · 0 评论 -
explode和LATERAL VIEW的使用
一:explode使用 1.1解释 hive wiki对于expolde的解释如下: explode() takes in an array (or a map) as an input and outputs the elements of the array (map) as separate rows. UDTFs can be used in the SELECT expression l...原创 2019-12-17 16:10:45 · 637 阅读 · 0 评论