Ricky Saltzer created NIFI-293:
----------------------------------
Summary: Add a JDBC Processor for executing arbitrary SQL queries
Key: NIFI-293
URL: https://issues.apache.org/jira/browse/NIFI-293
Project: Apache NiFi
Issue Type: New Feature
Reporter: Ricky Saltzer
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
