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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.7.0
• Component/s: Storage - JDBC
• Assignee: Roman Lozovyk
• Reporter: John Omernik
• Reviewer: Chun Chang
• Created: 22/Jun/16 13:02
• Updated: 26/Aug/16 18:32
• Resolved: 21/Jul/16 11:08

Description

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)