Navis created HIVE-4614:
---------------------------
Summary: 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
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
