Type: Feature Request
Status: Closed (View Workflow)
Affects Version/s: 0.9.0.Beta2
Fix Version/s: 0.9.5.Final
- Debezium 0.9.0Beta2
- wal2json commit d4c0e814696695bbf853c48b38b7479e0f83f6c7
- Postgresql 11.1
- confluent platform 5.1
- zookeeper 3.4.13
Zebezium does not support many array types even in case of one-dimensional array.
Debezium has no converter for the following array types even in case of one-dimensional array. That is, Avro schema has no fieild for these column types. Result message has no field for these column types.
BYTEA, TIMESTAMP, TIMESTAMPTZ, TIME, TIMETZ, INTERVAL, POINT, VARBIT, UUID, XML, JSON, JSONB
Debezium can not parse the following array type values and set *null*s as results even in case of one-dimensional array and "include.unknown.datatypes=true".
BIT, ENUM, LINE, LSEG, BOX, PATH, POLYGON, CIRCLE, CIDR, INET, MACADDR, MACADDR8, INT4RANGE, INT8RANGE, NUMRANGE, TSRANGE, TSTZRANGE, DATERANGE
If "include.unknown.datatypes" is enabled, raw binary representation of a column should be set as the result when Debezium can not parse it.
In conclusion, Debezium should support these array types (at least, array of currently supported types).