Hi Sudheesh and Zelaine, Thank you both for the reply.
Unfortunately I wasn't able to recreate the scenario with a small set of tables and dummy records, but I created the issue 4818 - https://issues.apache.org/jira/browse/DRILL-4818 on Jira and attached the query, the physical plan and the Json Profile related to the case. Again, thank you very much for the support. Best, Marcus 2016-07-15 17:48 GMT-03:00 Marcus Rehm <[email protected]>: > Hi all, > > I started to teste Drill and I'm very excited about the possibilities. > > By now 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 > (or understood) that Drill is doing the join of tables and is not pushing > it down to the database. > > Is there any configuration required to it? How can I tell Drill to send to > Oracle the task of doing the join? > > Thanks in Advance. > > Best regards, > Marcus Rehm >
