question Re: How to give dynamic query in queryrecord processor in Nifi ? in Archives of Support Questions (Read Only)

How to give dynamic query in queryrecord processor in Nifi ?

nishantgupta101 — Thu, 07 Dec 2017 21:07:46 GMT

Hi,

I want to do something like this

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

Need Help. Thanks

Re: How to give dynamic query in queryrecord processor in Nifi ?

nishantgupta101 — Thu, 07 Dec 2017 21:09:52 GMT

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

Re: How to give dynamic query in queryrecord processor in Nifi ?

bbende — Fri, 08 Dec 2017 04:38:07 GMT

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.

Re: How to give dynamic query in queryrecord processor in Nifi ?

nishantgupta101 — Tue, 12 Dec 2017 16:37:36 GMT

Thnks Bryan