drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1196) Does not support query of the form SELECT `schema`.`table`.* FROM `schema`.table`
Date Sun, 04 Jan 2015 21:26:38 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-1196.
-----------------------------------
    Resolution: Duplicate

> 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
>             Fix For: Future
>
>
> 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.3.4#6332)

Mime
View raw message