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