Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-293 Add a JDBC Processor for executing arbitrary SQL queries
  3. NIFI-626

ExecuteSQL processor for executing arbitrary SQL queries

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.2.0
    • 0.2.0
    • None
    • Patch

    Description

      For example query can be:
      SELECT * FROM orders WHERE orderId = '${order.id}'

      where ${order.id} is FlowFile attribute.
      Result will serialized using Avro.
      Avro gives as possibility to have query Resultset metadata (column name and types) included in FlowFile.
      Also Avro should allow streaming.

      Attachments

        1. NIFI-626_25may2015.patch
          37 kB
          Toivo Adams
        2. NIFI-626_26may2015.patch
          53 kB
          Toivo Adams
        3. NIFI-626_31may2015.patch
          60 kB
          Toivo Adams
        4. 0001-NIFI-626-Code-cleanup-to-adhere-to-NiFi-coding-style.patch
          38 kB
          Mark Payne

        Issue Links

          Activity

            People

              Toivo Adams Toivo Adams
              Toivo Adams Toivo Adams
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: