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

multi-partition inserts

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
    • 0.6.0
    • 0.6.0
    • None
    • None
    • Reviewed

    Description

      We should allow queries like this into a partitioned table:

      CREATE TABLE (a STRING, b STRING, c STRING)
      PARTITIONED BY (ds STRING, ts STRING);
      
      INSERT OVERWRITE TABLE x PARTITION (ds = '2009-12-12')
      SELECT a, b, c, ts FROM xxx;
      

      Basically, allowing users to overwrite multiple partitions at a time.
      The partition values specified in PARTITION part (if any) should be a prefix of the partition keys.
      The rest of the partition keys goes to the end of the SELECT expression list.

      Attachments

        1. HIVE-1002.patch
          1.06 MB
          Ning Zhang
        2. HIVE-1002.1.patch
          1.07 MB
          Ning Zhang
        3. ASF.LICENSE.NOT.GRANTED--HIVE-1002.2.patch
          1.22 MB
          Ning Zhang
        4. ASF.LICENSE.NOT.GRANTED--HIVE-1002.4.patch
          1.26 MB
          Ning Zhang

        Issue Links

        Activity

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

          People

            nzhang Ning Zhang Assign to me
            zshao Zheng Shao
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment