Assertion error and Failure finding function

1

I have the below queries, where am I am getting assertion error:

  1. SELECT TRUNC(ABC_DATE, ‘MI’) FROM TABLE_1;
  2. SELECT CAST(TRUNC(ABC_DATE, ‘MI’)AS TIMESTAMP) FROM TABLE_1;

And I am getting Failure finding function: trunc(timestamp) for the below query:
3. select TRUNC(ABC_DATE) FROM TABLE_1;

Can anyone help me around to see if this is a known issue or I am doing some mistake? As the same query is working fine on the oracle DB.

2

@lyashninan

If you logon to the Dremio coordinator , under the log folder, you should see “hive.deprecated.function.warning.log”, can you see if you see trunc in that. Can you please use one of Dremio’s supported functions for date functions