[
https://issues.apache.org/jira/browse/NIFI-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Koji Kawamura updated NIFI-2624:
--------------------------------
Description:
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.
UPDATED: This JIRA improved only ExecuteSQL and QueryDatabaseTable processors.
SelectHiveQL is removed from target. Hive tables can be queried by
ExecuteSQL/QueryDatabaseTable once NIFI-3093 is resolved (and logical types
will also be supported with those processors).
was:
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.
UPDATED: SelectHiveQL is removed from this JIRA scope, Hive tables can be
queried by ExecuteSQL/QueryDatabaseTable once NIFI-3093 is resolved.
> 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
> Fix For: 1.3.0
>
>
> 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.
> UPDATED: This JIRA improved only ExecuteSQL and QueryDatabaseTable
> processors. SelectHiveQL is removed from target. Hive tables can be queried
> by ExecuteSQL/QueryDatabaseTable once NIFI-3093 is resolved (and logical
> types will also be supported with those processors).
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
