[
https://issues.apache.org/jira/browse/DRILL-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chun Chang closed DRILL-4744.
-----------------------------
verified fix.
[root@perfnode166 ~]# curl -X POST -H "Content-Type: application/json" -d
'{"queryType":"SQL", "query": "select * from mysql.mysql.t1 limit 2"}'
http://localhost:8047/query.json
{
"columns" : [ "c1", "c2" ],
"rows" : [ {
"c1" : "1",
"c2" : "1"
}, {
"c1" : "2",
"c2" : "2"
} ]
> Fully Qualified JDBC Plugin Tables return Table not Found via Rest API
> ----------------------------------------------------------------------
>
> Key: DRILL-4744
> URL: https://issues.apache.org/jira/browse/DRILL-4744
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JDBC
> Affects Versions: 1.6.0
> Reporter: John Omernik
> Assignee: Roman Lozovyk
> Priority: Minor
> Fix For: 1.7.0
>
>
> When trying to query a JDBC table via authenticated Rest API, using a fully
> qualified table name returns table not found. This does not occur in
> sqlline, and a workaround is to "use pluginname.mysqldatabase" prior to the
> query. (Then the fully qualified table name will work)
> Plugin Name: mysql
> Mysql Database: events
> Mysql Table: curevents
> Via Rest:
> select * from mysql.events.curevents limit 10;
> Fail with "VALIDATION ERROR "Table 'mysql.events.curevents' not found
> Via Rest:
> use mysql.events;
> select * from mysql.events.curevents limit 10;
> - Success.
> Via SQL line, authenticating with the same username, you can connect, and run
> select * from mysql.events.curevents limit 10;
> without issue. (and without the use mysql.events)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
