[DRILL-3373] CTAS partition by with empty list of partitioning columns should be blocked in parser

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: SQL Parser
• Assignee: Jinfeng Ni
• Reporter: Jinfeng Ni
• Created: 25/Jun/15 18:46
• Updated: 28/Jun/15 17:57
• Resolved: 28/Jun/15 17:57

Description

Sql parser should raise parsing error, when the CTAS statement has "PARTITION BY", yet the list of partitioning column is empty.

create table nation_par 
partition by
as 
select n_nationkey, n_name, n_comment 
from cp.`tpch/nation.parquet`;

The expected behavior would be SQL parer error :

Error: PARSE ERROR: Encountered "as" at line 3, column 1.
Was expecting:
    "(" ...