[
https://issues.apache.org/jira/browse/NIFI-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16011031#comment-16011031
]
ASF subversion and git services commented on NIFI-2624:
-------------------------------------------------------
Commit 1811ba568152d0586c29861899e7ceb2c6b06d24 in nifi's branch
refs/heads/master from [~ijokarumawak]
[ https://git-wip-us.apache.org/repos/asf?p=nifi.git;h=1811ba5 ]
NIFI-2624: Avro logical types for ExecuteSQL and QueryDatabaseTable
- Added Logical type support for DECIMAL/NUMBER, DATE, TIME and TIMESTAMP
column types.
- Added Logical type 'decimal' to AvroReader so that Avro records with logical
types written by ExecuteSQL and QueryDatabaseTable can be consumed by
AvroReader.
- Added JdbcCommon.AvroConversionOptions to consolidate conversion options.
- Added 'Use Avro Logical Types' property to ExecuteSQL and QueryDatabaseTable
to toggle whether to use Logical types.
- Added 'mime.type' FlowFile attribute as 'application/avro-binary' so that
output FlowFiles can be displayed by content viewer.
Signed-off-by: Matt Burgess <[email protected]>
This closes #1798
> JDBC-to-Avro processors handle BigDecimals as Strings
> -----------------------------------------------------
>
> Key: NIFI-2624
> URL: https://issues.apache.org/jira/browse/NIFI-2624
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Reporter: Matt Burgess
> Assignee: Koji Kawamura
>
> The original SQL processors implemented BigDecimal values as Strings for
> Avro, as the version of Avro it used (1.7.6) did not support DECIMAL type.
> As of Avro 1.7.7 (AVRO-1402), this type is supported and so the SQL/HiveQL
> processors should be updated to handle BigDecimals correctly if possible.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
