[NIFI-5780] Add pre and post statements to ExecuteSQL and ExecuteSQLRecord

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.9.0
• Assignee: Deon Huang
• Reporter: Deon Huang
• Created: 01/Nov/18 12:39
• Updated: 30/Jan/19 20:55
• Resolved: 30/Jan/19 20:55

Description

Sometimes we might need to set up session relate configuration before or after query.

For example:
Pre query can be used for session relate setting like our use case Teradata Query Banding.

Same feature (pre query and post query) is added to SelectHiveQL in https://issues.apache.org/jira/browse/NIFI-5044
Planning to add this feature to ExecuteSQL and ExecuteSQLRecord processors.
If pre or post statement fail, will not produce resultset flowfile.

Issue Links

• links to: GitHub Pull Request #3156