drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Filip Grabowski (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3970) Oracle JDBC configuration filters necessary Calcite parameter
Date Tue, 08 Dec 2015 16:18:11 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15047028#comment-15047028

Filip Grabowski commented on DRILL-3970:

It works is a bit of overstatment. I should write it works a little. Try to run 'use oracle'
and then 'show tables'. This will show you tables that Apache drill can query. In my case
I can not figure out how this list is created. 
I created DRILL-4138 for this problem...

> Oracle JDBC configuration filters necessary Calcite parameter
> -------------------------------------------------------------
>                 Key: DRILL-3970
>                 URL: https://issues.apache.org/jira/browse/DRILL-3970
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>         Environment: Mac OS X 10.10
>            Reporter: Kyle Marek-Spartz
> After getting around DRILL-3958, I created a JDBC storage connection to an Oracle database.
However, when I execute queries, I get errors of this sort:
> {code}
> 0: jdbc:drill:zk=local> show tables from oracle;
> Error: SYSTEM ERROR: IllegalArgumentException: duplicate key: WWV_FLOW_DUAL100
> Fragment 0:0
> [Error Id: f34cc14b-42ea-4caf-a849-205eb5570ba2 on .....:31010] (state=,code=0)
> {code}
> This seems similar to CALCITE-880, which was closed as a configuration issue, suggesting
adding {{"jdbcSchema": "ORACLE_SCHEMA_NAME"}} to the JSON configuration. Adding this to the
Drill storage configuration option gives a {{Invalid JSON mapping}} error, which likely is
due to a lack of {{jdbcSchema}} in {{JdbcStorageConfig.java}}:
> https://github.com/apache/drill/blob/d7eebec41a1636055be1b2c79b693d76c52d8932/contrib/storage-jdbc/src/main/java/org/apache/drill/exec/store/jdbc/JdbcStorageConfig.java#L38-L41

This message was sent by Atlassian JIRA

View raw message