Oops! Premature request, sorry. (Instead, please remember to update the wiki when Hive 0.12.0 gets released.)
– Lefty On Sat, Jul 6, 2013 at 2:27 PM, Lefty Leverenz (JIRA) <j...@apache.org>wrote: > > [ > https://issues.apache.org/jira/browse/HIVE-4614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701415#comment-13701415] > > Lefty Leverenz commented on HIVE-4614: > -------------------------------------- > > Please update the wiki: [ > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+LateralView > ]. > > > Support outer lateral view > > -------------------------- > > > > Key: HIVE-4614 > > URL: https://issues.apache.org/jira/browse/HIVE-4614 > > Project: Hive > > Issue Type: New Feature > > Components: Query Processor > > Reporter: Navis > > Assignee: Navis > > Priority: Trivial > > Fix For: 0.12.0 > > > > Attachments: HIVE-4614.D10947.1.patch, HIVE-4614.D10947.2.patch > > > > > > New grammar suggested by [~appodictic] in > https://issues.apache.org/jira/browse/HIVE-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13665247#comment-13665247 > > If UDTF-alias for lateral view forwarded nothing for a input row, regard > it as nulls are forwarded keeping columns on select-alias, for example. > > {noformat} > > >select * from src LATERAL VIEW explode(array()) C AS a limit 10; > > {noformat} > > returns nothing because UDTF-alias forwards nothing. But with new > grammar, > > {noformat} > > >select * from src LATERAL VIEW OUTER explode(array()) C AS a limit 10; > > ... > > 238 val_238 NULL > > 86 val_86 NULL > > 311 val_311 NULL > > 27 val_27 NULL > > 165 val_165 NULL > > 409 val_409 NULL > > 255 val_255 NULL > > 278 val_278 NULL > > 98 val_98 NULL > > 484 val_484 NULL > > {noformat} > > -- > This message is automatically generated by JIRA. > If you think it was sent incorrectly, please contact your JIRA > administrators > For more information on JIRA, see: http://www.atlassian.com/software/jira >
