[jira] [Updated] (DRILL-4138) "Show tables" for oracle data storage list only subset of truely available objects

["Filip Grabowski (JIRA)" <ji...@apache.org>]

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

Filip Grabowski updated DRILL-4138:
-----------------------------------
    Component/s:     (was: Storage - Other)

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