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

Support partitioning spec in CTAS statements

    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.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.01.patch
          103 kB
          Jesus Camacho Rodriguez
        5. HIVE-20241.02.patch
          138 kB
          Jesus Camacho Rodriguez
        6. HIVE-20241.03.patch
          139 kB
          Jesus Camacho Rodriguez

          Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-14493 Partitioning support for materialized views

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link RB link

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: