I'm trying to write a WHERE clause that returns rows from a CSV file where the value of the date column is greater or less than a comparison value (e.g., where columns[2] > '2010-01-01').
It looks like Drill cannot automatically infer date values in CSV files, and that one must manually/explicitly tell Drill that both the value in the date column and the comparison value in the where clause predicate are dates, so that it can correctly compare values. OTOH, select <fields> from <plugin> WHERE to_date(<column>, <format>) < to_date(<value>, <format>) seems to work, although it's verbose. Do I have this right, and is there a less verbose way to handle this? Thanks
