[DRILL-3970] Oracle JDBC configuration filters necessary Calcite parameter

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.0
• Component/s: Storage - JDBC

Environment

Mac OS X 10.10

• Assignee: Unassigned
• Reporter: Kyle Marek-Spartz
• Created: 23/Oct/15 14:48
• Updated: 31/May/18 21:37

Description

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:

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)

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