Hi All, This is an issue related to Apache Drill and need some help to debug the problem.
Drill supports a feature to query a database directly. When querying a database directly, Drill throws an exception while manipulating a date field inside the 'where' clause as shown in the query below: select * from config_1.APP.EXECUTIONSTEP where DATE_ADD(CAST(STARTED_AT as DATE),interval '1' second) < CAST(CURRENT_DATE as DATE) I could see a calcite exception in the trace: Caused by: java.lang.AssertionError: 1000: INTERVAL_DAY_TIME at org.apache.calcite.adapter.jdbc.JdbcImplementor$Context.toSql(JdbcImplementor.java:179) ~[calcite-core-1.4.0-drill-r19.jar:1.4.0-drill-r19] I have raised the issue and details at https://issues.apache.org/jira/browse/DRILL-5578. The issue does not happen when querying parquet files. Regards, Rahul
