[NIFI-293] Add a JDBC Processor for executing arbitrary SQL queries

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Ricky Saltzer
• Created: 22/Jan/15 19:26
• Updated: 21/Aug/15 16:56
• Resolved: 10/Jul/15 18:58

Description

This could be very useful for a variety of tasks, such as updating a value in a PostgreSQL table, or adding a new partition to Hive.

Ideally, SQL commands could be generated using the NiFi expression language using FlowFile attributes.

The processor should as generic as possible so that any of the popular JDBC drivers can be used (e.g. PostgreSQL, Hive, Impala).

I'm still new to how processors are architected, but it seems that using a pre-defined service in the services.xml file (like the distributed map cache) would be the most efficient way to share a connection pool across multiple JDBC processors.

Issue Links

• duplicates: NIFI-626 ExecuteSQL processor for executing arbitrary SQL queries
• is blocked by: NIFI-852 Mock Framework does not re-queue FlowFiles that are transferred to Relationship.SELF
• is related to: NIFI-322 New Database Connection Pooling Controller Service
• relates to: NIFI-853 Create Processors to put JSON data to a Relational Database

Sub-Tasks

• ExecuteSQL processor for executing arbitrary SQL queries: Resolved