You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "B Anil Kumar (JIRA)" <ji...@apache.org> on 2014/06/24 08:38:24 UTC
[jira] [Commented] (DRILL-1056) Any query on
INFORMATION_SCHEMA.TABLES is failing
[ 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)