[ https://issues.apache.org/jira/browse/NIFI-293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ricky Saltzer resolved NIFI-293. -------------------------------- Resolution: Duplicate > 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 > Attachments: AvroWriter.java > > > 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)