Hive lateral view explode

select 'hello', x from dual lateral view explode(array(1,2,3,4,5)) vt as x

结果是:
hello   1
hello   2
hello   3
hello   4
hello   5




posted @ 2015-06-08 14:29  lishouguang  阅读(247)  评论(0编辑  收藏  举报