Marcio Sugar created NIFI-5971: ---------------------------------- Summary: ExecuteSQL Avro schema: all fields are nullable Key: NIFI-5971 URL: https://issues.apache.org/jira/browse/NIFI-5971 Project: Apache NiFi Issue Type: Improvement Components: Extensions Affects Versions: 1.7.1 Environment: Ubuntu 16.04 Apache NiFi 1.7.1 IBM DB2 for Linux, UNIX and Windows 10.5.0.7, 10.5.0.8 IBM Data Server Driver for JDBC and SQLJ, JDBC 4.0 Driver (db2jcc4.jar) 4.19.26 / v10.5 FP6, 4.19.72 / v10.5 FP9 Reporter: Marcio Sugar
JdbcCommon#createSchema creates an Avro schema with nullable types for all fields. It should check with java.sql.ResultSetMetaData#isNullable instead. It's the same issue discussed on dev list [here|https://lists.apache.org/list.html?d...@nifi.apache.org:2018-12] a few months ago. A workaround exists, but it's inconvenient when you have lots of tables to deal with. I like the solution proposed by Matt Burgess, the "Honor Non-Nullable Fields" property. -- This message was sent by Atlassian JIRA (v7.6.3#76005)