AnsweredAssumed Answered

Column name is not passed to RDBMSin Apache Drill

Question asked by nishith on Mar 20, 2017
Latest reply on Mar 20, 2017 by kli

Hi,

While trying to run SQL query for RDBMS source like Oracle, instead of the column names from the table referred it it pushing down * to the respective database.
Ex: Select empName from Employee
Passed to Oracle is 
select * from Employee
For large scale application, it is fetching all the unnecessary columns from the referred table.
Even i was trying to understand the physical query plan for the query. After getting the whole result set through jdbc scan, it is trying to get the column by projection.
Ideally it should push down the desired column name to database.
I am really stuck with this issue for my application.
Any suggestion or help is appreciated.

Outcomes