[jira] [Resolved] (DRILL-1056) Any query on INFORMATION_SCHEMA.TABLES is failing

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

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

Jacques Nadeau resolved DRILL-1056.
-----------------------------------

    Resolution: Invalid

TABLES is a reserved word in Drill.  As such, you need to write the query as select * from INFORMATION_SCHEMA.`TABLES`



> Any query on INFORMATION_SCHEMA.TABLES is failing
> -------------------------------------------------
>
>                 Key: DRILL-1056
>                 URL: https://issues.apache.org/jira/browse/DRILL-1056
>             Project: Apache Drill
>          Issue Type: Bug
>         Environment: sqlline
>            Reporter: B Anil Kumar
>
> SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE
> FROM INFORMATION_SCHEMA.TABLES
> is giving below exception:
> 0: jdbc:drill:> SELECT * FROM INFORMATION_SCHEMA.TABLES;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "39f544e0-14e4-4f83-ba00-36715708db10"
> endpoint {
>   address: "172.28.208.98"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < SqlParseException:[ Encountered ". TABLES" at line 1, column 33.
> Was expecting one of:
>     <EOF> 
>     "ORDER" ...
> :



--
This message was sent by Atlassian JIRA
(v6.2#6252)