[ https://issues.apache.org/jira/browse/DRILL-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14601840#comment-14601840
]
Venki Korukanti commented on DRILL-3373:
----------------------------------------
+1
> CTAS partition by with empty list of partitioning columns should be blocked in parser
> -------------------------------------------------------------------------------------
>
> Key: DRILL-3373
> URL: https://issues.apache.org/jira/browse/DRILL-3373
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Reporter: Jinfeng Ni
> Assignee: Venki Korukanti
> Fix For: 1.1.0
>
> Attachments: 0001-DRILL-3373-Raise-parsing-error-when-CTAS-has-partiti.patch
>
>
> Sql parser should raise parsing error, when the CTAS statement has "PARTITION BY", yet
the list of partitioning column is empty.
> {code}
> create table nation_par
> partition by
> as
> select n_nationkey, n_name, n_comment
> from cp.`tpch/nation.parquet`;
> {code}
> The expected behavior would be SQL parer error :
> {code}
> Error: PARSE ERROR: Encountered "as" at line 3, column 1.
> Was expecting:
> "(" ...
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
|