Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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).
Attachments
Issue Links
- links to