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

Incorrect documentation for message.key.columns

XMLWordPrintable

      E.g. here for MySQL, but it's the same for other connectors. The docs say that the regular expression is used to identify the key columns, but actually, the regular expression is used to match the table(s), whereas the corresponding key column(s) are given with their name.

      See here for the actual semantics. Here's some valid examples:

      # use column "pk1" as message key for table inventory.customer
      inventory.customers:pk1
      
      # use columns "pk1 and pk2" as message key for table inventory.customer
      inventory.customers:pk1,pk2
      
      # use columns "pk1 and pk2" as message key for table inventory.customer, "pk3" and "pk4" for tables "purchaseorders" in any schema
      inventory.customers:pk1,pk2;(.*).purchaseorders:pk3,pk4
      

              broldan@redhat.com Robert Roldan
              gunnar.morling Gunnar Morling
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: