Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-4684

Add attribute prefix property to ConvertJSONToSQL

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: Extensions
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mattyb149 Matt Burgess
                Reporter:
                mattyb149 Matt Burgess
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: