Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-591

create new type of join ( 1 row for a given key from multiple tables) (UNIQUEJOIN)

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.5.0
    • Query Processor
    • None
    • Reviewed

    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.

      Attachments

        1. HIVE-591.1.patch
          15 kB
          Emil Ibrishimov
        2. HIVE-591.2.patch
          22 kB
          Emil Ibrishimov
        3. HIVE-591.3.patch
          22 kB
          Emil Ibrishimov
        4. HIVE-591.4.patch
          22 kB
          Emil Ibrishimov

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            eibrishimov Emil Ibrishimov Assign to me
            namit Namit Jain
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment