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)
