hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4614) Support outer lateral view
Date Sat, 06 Jul 2013 22:17:48 GMT

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

Lefty Leverenz commented on HIVE-4614:
--------------------------------------

That is, please update the wiki when Hive 0.12.0 gets released.  (And sorry about spamming
the list just now when I replied to the email instead of commenting here.  Slipped a cog ...
or two.)
                
> 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

Mime
View raw message