hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6393) Support unqualified column references in Joining conditions
Date Mon, 10 Mar 2014 18:51:43 GMT

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

Harish Butani commented on HIVE-6393:
-------------------------------------

bq. I'd say "Hive" instead of "we" and mention the release number (with a link to this jira).
Or should it be "the query optimizer" instead of "we"?
Agreed, I prefer Hive 0.13 over 'the query optimizer'

bq. This can go in a version-info box at the end of the Join Syntax section
Agreed.

bq. so the first example in the wikidoc can't use unqualified column references
Yes
A simple e.g. is:

{noformat}
create table A(k1 string, v1 string)
create table B(k2 string, v2 string)

select k1, v1, k2, v2
from A join B on k1 = k2;
{noformat}

bq. I can put this in the wiki after you fine-tune it, unless you'd rather do it yourself.
Go ahead. Thanks for doing it.

> 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.2#6252)

Mime
View raw message