[
https://issues.apache.org/jira/browse/HIVE-591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xinzhang updated HIVE-591:
--------------------------
Description:
It will be useful to support a new type of join:
say:
.
select .. from JOIN TABLES (A,B,C) WITH KEYS (A.key, B.key, C.key) where ....
The semantics are that for a given key only 1 row is created - nulls are
present for the the tables which do not contain a row for that key.
There is no limit on the number of tables, the number of keys should be the
same as the number of tables.
was:
It will be useful to support a new type of join:
say:
select .. from JOIN TABLES (A,B,C) WITH KEYS (A.key, B.key, C.key) where ....
The semantics are that for a given key only 1 row is created - nulls are
present for the the tables which do not contain a row for that key.
There is no limit on the number of tables, the number of keys should be the
same as the number of tables.
> create new type of join ( 1 row for a given key from multiple tables)
> (UNIQUEJOIN)
> ----------------------------------------------------------------------------------
>
> Key: HIVE-591
> URL: https://issues.apache.org/jira/browse/HIVE-591
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Emil Ibrishimov
> Fix For: 0.5.0
>
> Attachments: HIVE-591.1.patch, HIVE-591.2.patch, HIVE-591.3.patch,
> HIVE-591.4.patch
>
>
> It will be useful to support a new type of join:
> say:
> .
> select .. from JOIN TABLES (A,B,C) WITH KEYS (A.key, B.key, C.key) where ....
> The semantics are that for a given key only 1 row is created - nulls are
> present for the the tables which do not contain a row for that key.
> There is no limit on the number of tables, the number of keys should be the
> same as the number of tables.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
