Timetype in oracle

Hello,
I am querying Oracle from Dremio with where clause, the query is something like this:
Select *
from oracledb.table
where date_col > ‘2018-01-01’
I also tried using to_date and other date functions but the query that I found Dremio generates to oracle is using cast to timestamp (and the date_col type is date).
Is there any way to avoid it?

How about something like CAST(date_col as DATE)> '2018-01-01' ?

Ok, it helped, but because of oracle needs to cast the date it can’t use the partition range scan.
There is no option just to send date type without cast?

Hi @liord

Can you please send me the profile for this job?

Share a query Profile

Thanks
@balaji.ramaswamy