[
https://issues.apache.org/jira/browse/DRILL-4818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Rehm updated DRILL-4818:
-------------------------------
Attachment: Physical Plan.txt
Json Profile.txt
drill pushdown rdbms.sql
Here are the files I spoke about in the issue description.
> 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 and linux red hat
> Reporter: Marcus Rehm
> Priority: Blocker
> Attachments: Json Profile.txt, Physical Plan.txt, drill pushdown
> rdbms.sql
>
>
> 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.4#6332)
