[ 
https://issues.apache.org/jira/browse/HIVE-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13659184#comment-13659184
 ] 

Edward Capriolo commented on HIVE-3534:
---------------------------------------

This patch adds a left explode UDF. Works like a left join in that if the thing 
being exploded is empty it returns NULL so the right row matches with something.
                
> Add left Lateral view syntax
> ----------------------------
>
>                 Key: HIVE-3534
>                 URL: https://issues.apache.org/jira/browse/HIVE-3534
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Edward Capriolo
>            Assignee: Edward Capriolo
>         Attachments: hive-3534.diff.txt
>
>
> A lateral view is like a join and if the function in question (like 
> explode()) produces zero rows then you lose the row
> whereas conceivably you could keep the row and just fill all entry with nulls.

--
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

Reply via email to