The QueryRecord config like this:
I add a new route relationship: select 907 fileds from the merge flowfile.
the configuation of nifi like this in bootstrap.conf
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