I’ve added a comment to the JIRA case. Its a Calcite issue and it shouldn’t be too hard to develop a fix.
> On Dec 7, 2017, at 11:11 PM, Rahul Raj <[email protected]> wrote: > > 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
