drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mahmoud Baalbaki (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4138) "Show tables" for oracle data storage list only subset of truely available objects
Date Tue, 05 Jan 2016 02:25:39 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15082242#comment-15082242
] 

Mahmoud Baalbaki commented on DRILL-4138:
-----------------------------------------

same problem with Sql Server.

> "Show tables" for oracle data storage list only subset of truely available objects
> ----------------------------------------------------------------------------------
>
>                 Key: DRILL-4138
>                 URL: https://issues.apache.org/jira/browse/DRILL-4138
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.3.0
>         Environment: Oracle 11.2 
> jdbc 7
> centos 6.5
>            Reporter: Filip Grabowski
>
> After a successful creation of oracle storage only a subset of tables can be queried.
The problem seems to be in the way drill retrieves object list from the database. I think
at the moment it gets only synonyms. I could not find any place where to configure how the
list of objects is retrieved from the database.
> In my opinion this is should be configurable per database engine type (Oracle, Teradata,
DB2, MySQL ...) in the storage definition as every database has different internal metadata
structure...
> For Oracle at the moment there are only synonyms retrieved it would be good to have also
tables and views...



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message