Hi Rahul, while you are working on that, might I tempt to you also look at date_add() and date_sub()? They behave the same way as the interval issue with the JDBC plugin - the issue might be similar between the two.
Thanks, Chris On Thu, Feb 22, 2018 at 6:12 AM, Rahul Raj <rahul....@option3consulting.com> wrote: > I am working on a fix for DRILL-5578 which is due to CALCITE-2188. > > Query fails when there is a DATE/INTERVAL arithmetic on the where part - > select * from actor where last_update - INTERVAL '20' SECOND > TIMESTAMP > '2005-10-17 00:00:00" > > I have made the changes for ANSI and MySql dialect of calcite. For the rest > of the dialects, calcite will default to ANSI syntax. Since INTERVAL syntax > differs between DBs, I want to know what all filters are pushed down to the > DB by Drill JDBC plugin. > > Could you point me to the location in Jdbc plugin? > > Thanks, > Rahul > > -- > **** This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom it is > addressed. If you are not the named addressee then you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately and delete this e-mail from your system.**** >