John Omernik created DRILL-4744:
-----------------------------------
Summary: 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
Priority: Minor
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)
