Re: Issue with QueryRecord failing when data is missing

2021-02-25 Thread Jens M. Kofoed
Hi Matt Many thanks for you replay. Yes I use the default which is the infer-schema. And it makes sense that the infer-schema can't guess what type the fields are if there are no data. So if I search for a boolean value and the infer-schema set it to text, it makes sense it produce errors. And

Re: Issue with QueryRecord failing when data is missing

2021-02-25 Thread Matt Burgess
Jens, What is the Schema Access Strategy set to in your CSVReader? If "Infer Schema" or "Use String Fields From Header", the setting of "Treat First Line As Header" should be ignored as those two options require a header be present anyway. If you know the schema ahead of time you could set it in

Issue with QueryRecord failing when data is missing

2021-02-24 Thread Jens M. Kofoed
Hi all I have a issue with using the QueryRecord query csv files. currently i'm running NiFi version 1.12.1 but I also tested this in version 1.13.0 If my incoming csv file only have a header line and no data it fails My querying statement looks like this: SELECT colA FROM FLOWFILE WHERE colC =