You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Kyle Marek-Spartz (JIRA)" <ji...@apache.org> on 2015/10/23 16:49:27 UTC
[jira] [Updated] (DRILL-3970) Oracle JDBC configuration filters
necessary Calcite parameter
[ https://issues.apache.org/jira/browse/DRILL-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kyle Marek-Spartz updated DRILL-3970:
-------------------------------------
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:
{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
was:
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 kmarekspartz-mb.stp01.office.gdi: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
> 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)