[jira] [Commented] (DRILL-4818) Drill not pushing down joins to RDBS Storages

["Muhammad Gelbana (JIRA)" <ji...@apache.org>]

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

[~marcus.rehm@gmail.com], 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)