I have been trying to using group by with having clause in the ExecuteSQL processor but it doesn't seem to be returning the count.
The SQL query looks like :
select id_num, count(*) from xyz
group by id_num
I put this in the SQL select query. I just get an empty array. How do I use group by and having in the select query in Nifi? A normal query without these clauses works perfectly but I need a count to check for duplicates in the database.