[IMPALA-4167] Support insert plan hints for CREATE TABLE AS SELECT

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.5.0, Impala 2.4.0, Impala 2.6.0, Impala 2.7.0
• Fix Version/s: Impala 3.0, Impala 2.12.0
• Component/s: Frontend
• Labels: ramp-up
• Epic Link: Improve the reliability and effectiveness of ETL
• Target Version: Product Backlog
• Assignee: Csaba Ringhofer
• Reporter: Alexander Behm
• Created: 20/Sep/16 00:50
• Updated: 23/Feb/18 22:51
• Resolved: 23/Feb/18 02:21

Description

In order to tune ETL processes we should also support the same plan hints for CREATE TABLE AS SELECT (CTAS) statements that we already support for INSERT statements. Otherwise, the convenience of a CTAS may be somewhat lost, or the generated data may not be as efficient as it could be with CREATE + INSERT + hints.

The placement of the hint should be as in Oracle's syntax:

CREATE /*+ clustered  sort(day,hour) */ TABLE t AS
SELECT * from src;

Issue Links

• is related to: IMPALA-2521 Introduce CLUSTERED plan hint for insert statements
• is related to: IMPALA-4166 Introduce SORT BY clause in CREATE TABLE statement
• relates to: IMPALA-4191 standardize query hint syntax

Sub-Tasks

• Impala 2.12 & 3.0 Docs: Support insert plan hints for CREATE TABLE AS SELECT: Closed