[jira] [Resolved] (DRILL-4744) Fully Qualified JDBC Plugin Tables return Table not Found via Rest API

["Roman Lozovyk (JIRA)" <ji...@apache.org>]

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