[NIFI-4684] Add attribute prefix property to ConvertJSONToSQL

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 09/Dec/17 01:56
• Updated: 19/Dec/17 09:33
• Resolved: 19/Dec/17 09:33

Description

Some users have tried to use ConvertJSONToSQL to generate SQL to put into Hive (possibly having to convert to HiveQL via ReplaceText). I'm not sure if NIFI-4071 still applies, but even so, when generating/accepting prepared statements, PutHiveQL expects attributes of the form "hiveql.args.N.type/value", where ConvertJSONToSQL generates attributes of the form "sql.args.N.type/value".

To accommodate both use cases, we could add a property to ConvertJSONToSQL specifying the attribute prefix to use. It would default to "sql" to maintain existing behavior but allow the user to change to something like "hiveql" if they desire.

Issue Links

• links to: GitHub Pull Request #2333