drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kyle Marek-Spartz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3970) Oracle JDBC configuration filters necessary Calcite parameter
Date Fri, 23 Oct 2015 14:48:28 GMT
Kyle Marek-Spartz created DRILL-3970:

             Summary: 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:

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]

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}}:


This message was sent by Atlassian JIRA

View raw message