In a CSV file, every field is a VARCHAR. On Thu, Feb 12, 2015 at 12:47 PM, Minnow Noir <[email protected]> wrote:
> 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 >
