flink sql 连接kafka avro序列化异常 Failed to deserialize Avro record ArrayIndexOutOfBoundsException

在使用flinksql 解析复杂avro格式时候，遇到ArrayIndexOutOfBoundsException报错。问题的原因是所有非空字段都需要显示 not null,注意是每个层级的字段。

2022-07-05 15:44:54,474 [Source: TableSourceScan(table=[[vvp, default, Ammeter]], fields=[header, ammeter ... with job vertex id 717c7b8afebbfb7137f6f0f99beb2a94 (1/1)#4] WARN  org.apache.flink.runtime.taskmanager.Task                    [] - Source: TableSourceScan(table=[[vvp, default, Ammeter]], fields=[header, ammeter ... with job vertex id 717c7b8afebbfb7137f6f0f99beb2a94 (1/1)#4 (217ad89a0aed0fae8b9b454c25b940f7) switched from RUNNING to FAILED with failure cause: java.io.IOException: Failed to deserialize Avro record.
	at org.apache.flink.formats.avro.AvroRowDataDeserializationSchema.deserialize(AvroRowDataDeserializationSchema.java:120)
	at org.apache.flink.formats.avro.AvroRowDataDeserializationSchema.deserialize(AvroRowDataDeserializationSchema.java:47)
	at org.apache.flink.api.common.serialization.DeserializationSchema.deserialize(DeserializationSchema.java:82)
	at org.apache.flink.streaming.connectors.kafka.table.DynamicKafkaDeserializationSchema.deserialize(DynamicKafkaDeserializationSchema.java:113)
	at org.apache.flink