You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@nifi.apache.org by ch...@post.ch on 2018/09/13 10:41:18 UTC

ExecuteSQL Avro schema: all fields are nullable

Hello

Is there a reason why JdbcCommon#createSchema creates an Avro schema with nullable types for all fields?
Why not check with java.sql.ResultSetMetaData#isNullable ?

https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.7.1/org.apache.nifi.processors.standard.ExecuteSQL/index.html

https://github.com/apache/nifi/blob/rel/nifi-1.7.1/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/util/JdbcCommon.java#L500

Regards,
Chris

Re: ExecuteSQL Avro schema: all fields are nullable

Posted by Otto Fowler <ot...@gmail.com>.

You should send this to the dev@ list


On September 13, 2018 at 06:41:29, christophe.monnet@post.ch (
christophe.monnet@post.ch) wrote:

Hello

Is there a reason why JdbcCommon#createSchema creates an Avro schema with
nullable types for all fields?
Why not check with java.sql.ResultSetMetaData#isNullable ?

https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.7.1/org.apache.nifi.processors.standard.ExecuteSQL/index.html

https://github.com/apache/nifi/blob/rel/nifi-1.7.1/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/util/JdbcCommon.java#L500

Regards,
Chris