Support Questions

Find answers, ask questions, and share your expertise

QuerRecord not working for a long time

avatar
Explorer

The log not error, but QueryRecord not work when big data from,   QueryRecor work when little data from.    not work such as :

 

zhangliang_0-1644561427906.png

the before has three queue, every queue has 56M size data.  how could solve the quertion, thanks!

2 REPLIES 2

avatar
Super Guru

Can you share the configuration of your QueryRecord processor and a sample of your data?

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
Explorer

The QueryRecord config like this:

zhangliang_0-1644802675341.png

I add a new route relationship:  select 907 fileds from the merge flowfile.

the configuation of nifi like this in bootstrap.conf

zhangliang_1-1644803013008.png

 

the select like this:

select 

     907 fileds 

FROM ( SELECT * FROM FLOWFILE WHERE d = 'devicedata' ) devicedata LEFT JOIN ( SELECT * FROM FLOWFILE WHERE d = 'deviceinfo' ) deviceinfo ON devicedata.manufacturer_oui = deviceinfo.manufacturer_oui AND devicedata.serial_number = deviceinfo.serial_number