drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcus Rehm (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4818) Drill not pushing down joins to RDBS Storages
Date Mon, 01 Aug 2016 19:10:20 GMT
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)

Mime
View raw message