Hi All,   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  where id_num<>0 group by id_num having count(*)>1   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.   Thank you in Advance ... View more

I have the following json file : “a”:{     “after”:{         “a123”:{                  “ip”:”1.0.0.0”,                  “p_id”:”4500”                    }            }, “before”:{         “a123”:{             “ip”:”1.0.0.0”,             “p_id”:”4500                   }             } }   I'm trying to create a lookuprecord Processor in NiFi to match with the p_id. If matched then route to something and if unmatched then route to something else. The lookuprecord processor I have is a MongoDBLookUpService. The user expression I've written for the lookuprecord processor is : key : /a/after/*['p_id'] Note: [*] because that bit in json keeps changing with every json file. I've even tried /a/after/*/p_id and nothing seems to work.   They all seem to route to unmatched. Please help me figure out if I'm doing something wrong in the expression. ... View more