[
https://issues.apache.org/jira/browse/HIVE-4614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-4614:
------------------------------
Attachment: HIVE-4614.D10947.1.patch
navis requested code review of "HIVE-4614 [jira] Support outer lateral view".
Reviewers: JIRA
HIVE-4614 Support outer lateral view
New grammar suggested by Edward Capriolo 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.
returns nothing because UDTF-alias forwards nothing. But with new grammar,
...
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
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D10947
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/exec/UDTFOperator.java
ql/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g
ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/java/org/apache/hadoop/hive/ql/plan/UDTFDesc.java
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/UDTFCollector.java
ql/src/test/queries/clientpositive/lateral_view_outer.q
ql/src/test/results/clientpositive/lateral_view_outer.q.out
MANAGE HERALD RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/26175/
To: JIRA, navis
> 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
> Attachments: HIVE-4614.D10947.1.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
