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.
From: Karthik Ramakrishnan [mailto:karthik.ramakrishna...@gmail.com]
Sent: Tuesday, September 20, 2016 9:57 PM
Subject: Does NiFi support multiple queries
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!!
Data Services Intern
Contact : +1 (469) 951-8854