[HIVE-20241] Support partitioning spec in CTAS statements

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.2.0, 4.0.0-alpha-1
• Component/s: Parser
• Labels: TODOC3.2
• Target Version/s: 4.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 26/Jul/18 00:32
• Updated: 27/Feb/24 22:24
• Resolved: 31/Jul/18 16:20

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;

Issue Links

• blocks: HIVE-14493 Partitioning support for materialized views
• links to: RB link