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

Support partitioning spec in CTAS statements

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.2.0, 4.0.0
    • Component/s: Parser
    • Labels:
    • Target Version/s:

      Description

      Currently, for partitioned tables we will declare the table and insert the data in different operations. This issue is to extend CTAS statement to support specifying partition columns.

      For instance:

      CREATE TABLE partition_ctas_1 PARTITIONED BY (key) AS
      SELECT value, key FROM src where key > 200 and key < 300;
      

        Attachments

        1. HIVE-20241.01.patch
          103 kB
          Jesus Camacho Rodriguez
        2. HIVE-20241.01.patch
          103 kB
          Jesus Camacho Rodriguez
        3. HIVE-20241.01.patch
          103 kB
          Jesus Camacho Rodriguez
        4. HIVE-20241.02.patch
          138 kB
          Jesus Camacho Rodriguez
        5. HIVE-20241.03.patch
          139 kB
          Jesus Camacho Rodriguez
        6. HIVE-20241.patch
          103 kB
          Jesus Camacho Rodriguez

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              jcamachorodriguez Jesus Camacho Rodriguez Assign to me
              Reporter:
              jcamachorodriguez Jesus Camacho Rodriguez

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment