[DRILL-4818] Drill not pushing down joins to RDBS Storages

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.7.0
• Component/s: Storage - JDBC

Environment

Windows 7 and Linux Red Hat 6.1 server

• Assignee: Unassigned
• Reporter: Marcus Rehm
• Created: 01/Aug/16 19:09
• Updated: 27/Mar/17 12:02

Description

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.