[
https://issues.apache.org/jira/browse/NIFI-5802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Koji Kawamura updated NIFI-5802:
--------------------------------
Description:
WIth Avro schema, a field can be defined as nullable by a union type. For
example:
{code:java}
"type": [ "null", "boolean" ]
{code}
QueryRecord generates relational data types from the record schema. But it
currently doesn't utilize the nullable information. And it leads to a
NullPointerException when the incoming FlowFile has null values for the
nullable fields.
A simple 'select * from FLOWFILE' can fail, if the AvroRecordSetWriter is used.
This issue was reported to nifi user ML. See the message for detail.
[https://mail-archives.apache.org/mod_mbox/nifi-users/201811.mbox/%3CCAB10SGVgW2NR76UR1pYJvEZYTO3J1T7t_0q%2BUsQANp%3DcHxS-kw%40mail.gmail.com%3E]
was:
WIth Avro schema, a field can be defined as nullable by a union type. For
example:
{code}
"type": [ "null", "boolean" ]
{code}
QueryRecord generates relational data types from the record schema. But it
currently doesn't utilize the nullable information. And it leads to a
NullPointerException when the incoming FlowFile has null values for the
nullable fields.
A simple 'select * from FLOWFILE' can fail.
This issue was reported to nifi user ML. See the message for detail.
https://mail-archives.apache.org/mod_mbox/nifi-users/201811.mbox/%3CCAB10SGVgW2NR76UR1pYJvEZYTO3J1T7t_0q%2BUsQANp%3DcHxS-kw%40mail.gmail.com%3E
> QueryRecord ignores field nullability and causes NPE with null input value
> --------------------------------------------------------------------------
>
> Key: NIFI-5802
> URL: https://issues.apache.org/jira/browse/NIFI-5802
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 1.2.0
> Reporter: Koji Kawamura
> Assignee: Koji Kawamura
> Priority: Major
>
> WIth Avro schema, a field can be defined as nullable by a union type. For
> example:
> {code:java}
> "type": [ "null", "boolean" ]
> {code}
> QueryRecord generates relational data types from the record schema. But it
> currently doesn't utilize the nullable information. And it leads to a
> NullPointerException when the incoming FlowFile has null values for the
> nullable fields.
> A simple 'select * from FLOWFILE' can fail, if the AvroRecordSetWriter is
> used.
> This issue was reported to nifi user ML. See the message for detail.
>
> [https://mail-archives.apache.org/mod_mbox/nifi-users/201811.mbox/%3CCAB10SGVgW2NR76UR1pYJvEZYTO3J1T7t_0q%2BUsQANp%3DcHxS-kw%40mail.gmail.com%3E]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
