[
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)
