Details
-
Feature Request
-
Resolution: Done
-
Major
-
0.9.0.Beta2
-
0
-
0%
Description
Zebezium does not support many array types even in case of one-dimensional array.
Array types completely disappeared from event message
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[]
Example Warning message
[l.TableSchemaBuilder] No converter found for column common_0.tbl_2.c_arr_uuid of type _uuid. The column will not be part of change events for that table.
Array types converted to null
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[]
Example Warning message
[stgresValueConverter] Unexpected JDBC BINARY value for field c_arr_bit_1 with schema Schema{BOOLEAN}: class=class java.util.Arrays$ArrayList, value=[true]
Request
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).
Attachments
Issue Links
- is related to
-
DBZ-1071 Support Postgresql arbitrary-dimensional array
- Closed