Found a problem in self join on a Oracle table as source, dremio “connector” send erroneous table name to Oracle (PROVIDER0 is not a table in Oracle, it’s only an alias name in the query for PROVIDER table “join_PROVIDER.PROVIDER AS PROVIDER0” ) see logs attached :
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at com.dremio.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:195) [dremio-extra-plugin-jdbc-3.1.3-201902130614340856-5cd4808.jar:3.1.3-201902130614340856-5cd4808]
... 25 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00904: “PROVIDER0”.“DISPLAY_NAME” : identificateur non valide
Seems to be Oracle specific as i tested self join in PostgreSql and it’s ok.
dremiologs.zip (3,6 Ko)
