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.

Regards,
Nishith Kumar Nayak

Reply via email to