You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Suresh Ollala (JIRA)" <ji...@apache.org> on 2016/07/25 20:55:20 UTC
[jira] [Updated] (DRILL-4744) Fully Qualified JDBC Plugin Tables
return Table not Found via Rest API
[ https://issues.apache.org/jira/browse/DRILL-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Ollala updated DRILL-4744:
---------------------------------
Reviewer: Chun Chang
> 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)