You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Mahmoud Baalbaki (JIRA)" <ji...@apache.org> on 2016/01/05 03:25:39 UTC
[jira] [Commented] (DRILL-4138) "Show tables" for oracle data
storage list only subset of truely available objects
[ 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)