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

Support partitioning spec in CTAS statements

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.2.0, 4.0.0-alpha-1
    • Parser

    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
          jcamachorodriguez
        2. HIVE-20241.01.patch
          103 kB
          jcamachorodriguez
        3. HIVE-20241.01.patch
          103 kB
          jcamachorodriguez
        4. HIVE-20241.02.patch
          138 kB
          jcamachorodriguez
        5. HIVE-20241.03.patch
          139 kB
          jcamachorodriguez
        6. HIVE-20241.patch
          103 kB
          jcamachorodriguez

        Issue Links

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: