nifi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (NIFI-626) ExecuteSQL processor for executing arbitrary SQL queries
Date Wed, 17 Jun 2015 17:42:02 GMT

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

ASF subversion and git services commented on NIFI-626:
------------------------------------------------------

Commit ec02e58d3c0a8162a32fb5c51651accf1d961d1b in incubator-nifi's branch refs/heads/develop
from [~markap14]
[ https://git-wip-us.apache.org/repos/asf?p=incubator-nifi.git;h=ec02e58 ]

NIFI-626: SQL timestamps were being added to Avro schema as string but value was being added
as java.sql.Date object, which caused exceptions to be thrown. Now call toString() on the
Date object to put to the record.


> ExecuteSQL processor for executing arbitrary SQL queries
> --------------------------------------------------------
>
>                 Key: NIFI-626
>                 URL: https://issues.apache.org/jira/browse/NIFI-626
>             Project: Apache NiFi
>          Issue Type: Sub-task
>    Affects Versions: 0.2.0
>            Reporter: Toivo Adams
>            Assignee: Toivo Adams
>              Labels: patch
>             Fix For: 0.2.0
>
>         Attachments: 0001-NIFI-626-Code-cleanup-to-adhere-to-NiFi-coding-style.patch,
NIFI-626_25may2015.patch, NIFI-626_26may2015.patch, NIFI-626_31may2015.patch
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message