[jira] [Commented] (NIFI-293) Add a JDBC Processor for executing arbitrary SQL queries

["Ryan Blue (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14486161#comment-14486161 ] 

Ryan Blue commented on NIFI-293:
--------------------------------

I'm working in the upstream Avro community to define storage specifications for high-level types, like decimal, date, timestamp, etc. Avro is a great choice for the output of this, so let me know if you have questions about type representation or schema management.

> 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)