hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-591) create new type of join ( 1 row for a given key from multiple tables)
Date Thu, 10 Sep 2009 01:47:57 GMT

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

Namit Jain commented on HIVE-591:

1. Can you add more tests: one in which the join key is a expression ?

> create new type of join ( 1 row for a given key from multiple tables)
> ---------------------------------------------------------------------
>                 Key: HIVE-591
>                 URL: https://issues.apache.org/jira/browse/HIVE-591
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Emil Ibrishimov
>         Attachments: HIVE-591.1.patch, HIVE-591.2.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 is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message