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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.0

Environment

Oracle 11.2
jdbc 7
centos 6.5

• Assignee: Unassigned
• Reporter: Filip Grabowski
• Created: 26/Nov/15 12:10
• Updated: 05/Jan/16 02:25

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