drill-issues 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

View raw message