@SAMSAL Hi Samsal, Problem solved by using regex to extract maprecord{[xxxxx]}, Thanks for your details explaination about the lookup service
... View more
Dear @SAMSAL , Thank you so much for helping, we tried different ways, and we decided to use the solution that you mention above by concatenating those columns.
... View more
Problem solve after reading: https://community.cloudera.com/t5/Support-Questions/NiFi-Trigger-a-Processor-once-after-the-Queue-gets-empty-for/td-p/381801
... View more
Hi Timothy, Thank you so much for helping. I also made some changes (adding index, change data types etc.,) for mysql database. Now, it ran much faster than before
... View more
