Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1076

Postgresql ARRAY support

XMLWordPrintable

      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).

              Unassigned Unassigned
              takaomag_jira Takao Magoori (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: