Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Re: [jira] [Commented] (HIVE-4614) Support outer lateral view


Copy link to this message
-
Re: [jira] [Commented] (HIVE-4614) Support outer lateral view
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) <[EMAIL PROTECTED]>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
>