[
https://issues.apache.org/jira/browse/DRILL-4138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Filip Grabowski updated DRILL-4138:
-----------------------------------
Description:
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...
was:
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 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...
> "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
> Components: Storage - Other
> 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)
