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