You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by GitBox <gi...@apache.org> on 2021/07/15 12:06:40 UTC

[GitHub] [drill] sowo opened a new issue #2274: Elasticsearch and RDBMS (Oracle) JOIN of fails with ClassCastException

sowo opened a new issue #2274:
URL: https://github.com/apache/drill/issues/2274


   **Describe the bug**
    I am trying to join data from Elasticsearch with data from an Oracle RDBMS. My query looks like this:
   
   `SELECT o.a, o.b, o.c, e.d, e.f FROM oracle.schema.table o JOIN elastic.index e ON o.a=e.a`
   
   My problem is that this query produces a ClassCastException:
   
   ` Caused by: java.lang.ClassCastException: org.apache.calcite.plan.Convention$Impl cannot be cast to org.apache.drill.exec.store.jdbc.DrillJdbcConvention
   	at org.apache.drill.exec.store.jdbc.JdbcPrel.<init>(JdbcPrel.java:55)
   	at org.apache.drill.exec.store.jdbc.JdbcIntermediatePrel.finalizeRel(JdbcIntermediatePrel.java:65)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:322)
   	at org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:55)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:69)
   	at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:131)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:324)
   	at org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:55)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:69)
   	at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:131)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:324)
   	at org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:55)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:69)
   	at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:131)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:324)
   	at org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:55)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:69)
   	at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:131)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:324)
   	at org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:55)
   	at org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:69)
   	at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:131)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:324)
   	at org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToPrel(DefaultSqlHandler.java:437)
   	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
   	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283)
   	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163)
   	at org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:140)
   	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93)
   	at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:592)
   	at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:273)
   	... 1 common frames omitted` 
   
   I've also tried joing through the WHERE clause but with the same result. 
   
   
   
   **To Reproduce**
   Steps to reproduce the behavior:
   1. Configure Elasticsearch and Oracle storage
   2. Run query similiar to the one in the description
   3. See error
   
   **Expected behavior**
   A dataset is built consisting of columns retrieved from Elasticsearch and from Oracle joined on the common property
   
   **Screenshots**
   N/A
   
   **Desktop (please complete the following information):**
    - Docker container built from commit 512ac6c
    - Chrome
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [drill] luocooong closed issue #2274: Elasticsearch and RDBMS (Oracle) JOIN fails with ClassCastException

Posted by GitBox <gi...@apache.org>.
luocooong closed issue #2274:
URL: https://github.com/apache/drill/issues/2274


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org