Karthik, PutSQL will handle both styles, and for multiple tables, without issue.
Internally it creates a separate SQL Batch for each distinct SQL statement in the queue and then executes these batches separately. Feel free to mix as many Inserts/Updates as you wish for as many tables as you wish. Thanks, Peter From: Karthik Ramakrishnan [mailto:[email protected]] Sent: Tuesday, September 20, 2016 9:57 PM To: [email protected] Subject: Does NiFi support multiple queries Hello - I was wondering if NiFi can support multiple queries in the same PutSQL processor. For example, if an attribute is set to 'update' - will PutSQL run the defined update query and next time when it is an 'insert' - it runs the insert query. Or should we go ahead and add two separate processors and make a decision on the RouteAttributes processor? Any thoughts would be welcome!! TIA!! -- Thanks, Karthik Ramakrishnan Data Services Intern Copart Inc. Contact : +1 (469) 951-8854
