Hello everyone,
I'm new with Apache Nifi, i'm trying to filter on a date column with the format yyyy-mm-dd using the queryRecord processor. Data come from CSV file. What i want to do is to filter and keep all records that have the column date greater or equal than the current date, i tried:
select * from flowfile where date >= currentDate();
But that does not work
if it is not possible with the queryRecord processor, which one can achieve that ?
Does anyone have an idea ?
Thanks in advance