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
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?
**** 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.****