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

[B Anil Kumar (JIRA)]

    [ 
https://issues.apache.org/jira/browse/DRILL-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041767#comment-14041767
 ] 

B Anil Kumar commented on DRILL-1056:
-------------------------------------

Thanks Jacques.

Better if we update the same on  
https://cwiki.apache.org/confluence/display/DRILL/Connecting+Apache+Drill+to+Data+Sources
  as

SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE
FROM INFORMATION_SCHEMA.`TABLES`
ORDER BY TABLE_NAME DESC;

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