[
https://issues.apache.org/jira/browse/DRILL-4818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15940527#comment-15940527
]
Muhammad Gelbana commented on DRILL-4818:
-----------------------------------------
[[email protected]], have you had any progress with this please ?
> Drill not pushing down joins to RDBS Storages
> ---------------------------------------------
>
> Key: DRILL-4818
> URL: https://issues.apache.org/jira/browse/DRILL-4818
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JDBC
> Affects Versions: 1.7.0
> Environment: Windows 7 and Linux Red Hat 6.1 server
> Reporter: Marcus Rehm
> Priority: Critical
> Attachments: drill pushdown rdbms.sql, Json Profile.txt, Physical
> Plan.txt
>
>
> I'm trying to map ours databases running on Oracle 11g. After try some
> queries I realized that the amount of time Drill takes to complete is bigger
> than a general sql client takes. Looking the execution plan I saw that Drill
> is doing the join of tables and is not pushing it down to the database.
> My storage configuration is as:
> {
> "type": "jdbc",
> "driver": "oracle.jdbc.OracleDriver",
> "url": "jdbc:oracle:thin:USER/PASS@server:1521/ORCL",
> "username": null,
> "password": null,
> "enabled": true
> }
> I'm not able to reproduce the case with example tables so i'm sending the
> query and the physical plan Drill is generating.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
