[
https://issues.apache.org/jira/browse/DRILL-2229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14539073#comment-14539073
]
Sean Hsuan-Yi Chu commented on DRILL-2229:
------------------------------------------
1. Parser Error:
(1). select n_nationkey where n_nationkey >= 2
org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR:
Encountered "where" at line 1, column 22.
(2). select n_nationkey from cp.`tpch/nation.parquet` group by n_name
org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: From line
1, column 8 to line 1, column 18: Expression 'n_nationkey' is not being grouped
2. Unsupported Operation:
(1). select * from cp.`tpch/nation.parquet`, cp.`tpch/region.parquet`
org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION
ERROR: This query cannot be planned possibly due to either a cartesian join or
an inequality join
(2). select cast(n_nationkey as TINYINT ) from cp.`tpch/nation.parquet`
org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION
ERROR: TINYINT is not supported
See Apache Drill JIRA: DRILL-1959
> SQL syntax errors should use SQLSyntaxErrorException
> ----------------------------------------------------
>
> Key: DRILL-2229
> URL: https://issues.apache.org/jira/browse/DRILL-2229
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Reporter: Daniel Barclay (Drill)
> Assignee: Aman Sinha
> Fix For: 1.2.0
>
> Attachments: DRILL-2229.1.patch
>
>
> SQL syntax errors should be reported with SQLSyntaxErrorException (or
> subclasses, of course) rather than SQLException (in part so that when they
> get to the JDBC interface they can be reported at intended using
> SQLSyntaxErrorException .
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
