Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
1.7.1
-
None
-
None
-
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
Description
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 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.