drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roman Lozovyk (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (DRILL-4744) Fully Qualified JDBC Plugin Tables return Table not Found via Rest API
Date Thu, 21 Jul 2016 11:07:20 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Roman Lozovyk reassigned DRILL-4744:
------------------------------------

    Assignee: Roman Lozovyk

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

Mime
View raw message