-
Type:
Improvement
-
Status: Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.3.0
-
Component/s: Extensions
-
Labels:None
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).
- depends upon
-
AVRO-1497 Add LogicalType support to Java
-
- Closed
-
-
AVRO-1402 Support for DECIMAL type
-
- Closed
-
- duplicates
-
NIFI-2048 ExecuteSQL converts BigDecimal to strings in Avro
-
- Resolved
-
- is related to
-
NIFI-2531 SQL-to-Avro processors do not convert BIGINT correctly
-
- Resolved
-
-
NIFI-3093 HIVE Support for ExecuteSQL/QueryDatabaseTable/GenerateTableFetch
-
- Resolved
-
- links to