drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Hsuan-Yi Chu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2229) SQL syntax errors should use SQLSyntaxErrorException
Date Tue, 12 May 2015 01:37:59 GMT

    [ 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)

Mime
View raw message