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-6393) Support unqualified column references in Joining conditions
Date Mon, 20 Oct 2014 07:21:33 GMT

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

Lefty Leverenz commented on HIVE-6393:
--------------------------------------

At long last, this is documented at the end of the Join Syntax section in the wiki:

* [LanguageManual Joins -- Join Syntax | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins#LanguageManualJoins-JoinSyntax]

To match the other version-info box, I included the example in the box instead of putting
it at the end of the Examples section.  Key words are capitalized and the create statements
have semicolons.

> Support unqualified column references in Joining conditions
> -----------------------------------------------------------
>
>                 Key: HIVE-6393
>                 URL: https://issues.apache.org/jira/browse/HIVE-6393
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Harish Butani
>            Assignee: Harish Butani
>             Fix For: 0.13.0
>
>         Attachments: HIVE-6393.1.patch, HIVE-6393.2.patch, HIVE-6393.3.patch
>
>
> Support queries of the form:
> {noformat}
> create table r1(a int);
> create table r2(b);
> select a, b
> from r1 join r2 on a = b
> {noformat}
> This becomes more useful in old style syntax:
> {noformat}
> select a, b
> from r1, r2
> where a = b
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message