nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Burgess (JIRA)" <j...@apache.org>
Subject [jira] [Created] (NIFI-6370) Allow PutDatabaseRecord to execute multiple SQL statements if using SQL field
Date Mon, 10 Jun 2019 15:40:00 GMT
Matt Burgess created NIFI-6370:
----------------------------------

             Summary: Allow PutDatabaseRecord to execute multiple SQL statements if using
SQL field
                 Key: NIFI-6370
                 URL: https://issues.apache.org/jira/browse/NIFI-6370
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Extensions
            Reporter: Matt Burgess
            Assignee: Matt Burgess


PutDatabaseRecord can be configured to point at a field in a record that contains a SQL statement,
and execute the statement rather than a generated INSERT/UPDATE/DELETE statement from the
fields in the record.  It would be helpful if the SQL field could contain multiple SQL statements
(delimited by semicolons) and each of the statements be executed, rolling back the whole thing
if any errors occur.

To maintain current behavior, I propose adding a boolean property to "Allow Multiple SQL Statements"
that is only used when the statement type is SQL. This is also necessary because we can't
fully parse the SQL statements; instead we can just split the SQL field by semicolons (like
PutHiveQL does).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message