How to give dynamic query in queryrecord processor in Nifi ?

[#1]

Hi,

I want to do something like this

SELECT * FROM FLOWFILE WHERE Gender = '${gender}'

Need Help. Thanks

[#2]

If I do -> SELECT * FROM FLOWFILE WHERE Gender = 'Male', It works

[#3 · Accepted solution]

You should be able to do exactly what you showed with ${gender} as long as your incoming flow files have an attribute called gender. You would have to create that attribute before QueryRecord by using UpdateAttribute or by using a processor that extracts something from the content of the flow into an attribute called gender.

[#4]

Thnks Bryan