Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB