[
https://issues.apache.org/jira/browse/DRILL-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Lozovyk resolved DRILL-4744.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.7.0
This issue can be reproduced on drill 1.6.0, but starting from 1.7.0 issue has
been fixed.
> 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)
