[ https://issues.apache.org/jira/browse/DRILL-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15028635#comment-15028635 ]
Filip Grabowski commented on DRILL-3970: ---------------------------------------- It works in 1.3 > 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 (v6.3.4#6332)