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

["Marcus Rehm (JIRA)" <ji...@apache.org>]

Marcus Rehm created DRILL-4818:
----------------------------------

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


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)