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.