You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/07/25 20:15:38 UTC
[jira] [Commented] (DRILL-1196) Does not support query of the form
SELECT `schema`.`table`.* FROM `schema`.table`
[ https://issues.apache.org/jira/browse/DRILL-1196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14074713#comment-14074713 ]
Julian Hyde commented on DRILL-1196:
------------------------------------
Probably root cause is in Optiq. Logged https://issues.apache.org/jira/browse/OPTIQ-356.
> Does not support query of the form SELECT `schema`.`table`.* FROM `schema`.table`
> ---------------------------------------------------------------------------------
>
> Key: DRILL-1196
> URL: https://issues.apache.org/jira/browse/DRILL-1196
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Environment: LINUX UBUNTU, WINDOWS 7
> Reporter: Alexander Zarei
> Priority: Minor
>
> Query of the form Select `schema`.`table`.* from `schema`.table` returns an error from the parser. This affects loading data to TIBCO Spotfire BI tool.
> sqlline query and returned error:
> 0: jdbc:drill:schema=hbase> SELECT `hive43.default`.`bella_table`.* FROM `hive43.default`.`bella_table`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "186471ae-6271-4b74-91d5-fbe80e6675d2"
> endpoint {
> address: "192.168.39.43"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < SqlParseException:[ Encountered ". *" at line 1, column 39.
> Was expecting one of:
> "FROM" ...
> "," ...
> "AS" ...
> <IDENTIFIER> ...
> <QUOTED_IDENTIFIER> ...
> <BACK_QUOTED_IDENTIFIER> ...
> <BRACKET_QUOTED_IDENTIFIER> ...
> <UNICODE_QUOTED_IDENTIFIER> ...
> "NOT" ...
> "IN" ...
> "BETWEEN" ...
> "LIKE" ...
> "SIMILAR" ...
> "=" ...
> ">" ...
> "<" ...
> "<=" ...
> ">=" ...
> "<>" ...
> "+" ...
> "-" ...
> "*" ...
> "/" ...
> "||" ...
> "AND" ...
> "OR" ...
> "IS" ...
> "MEMBER" ...
> "SUBMULTISET" ...
> "MULTISET" ...
> "[" ...
> "." <IDENTIFIER> ...
> "." <QUOTED_IDENTIFIER> ...
> "." <BACK_QUOTED_IDENTIFIER> ...
> "." <BRACKET_QUOTED_IDENTIFIER> ...
> "." <UNICODE_QUOTED_IDENTIFIER> ...
> "(" ...
> ]"
> ]
> Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)