Column with datatype int coming in binary

Kafka Connect
1

Hi

I have table with coulmn below

 Field             | Type               | Null | Key | Default | Extra          |
+-------------------+--------------------+------+-----+---------+----------------+
| order_id          | mediumint unsigned | NO   | PRI | NULL    | auto_increment |
| is_parent_order   | char(1)            | NO   |     | N       |                |
| parent_order_id   | mediumint unsigned | NO   |     | 0       |                |
| company_id        | int unsigned       | NO   | MUL | 0       |                |
| issuer_id         | mediumint unsigned | YES  |     | NULL    |                |
| user_id           | mediumint unsigned | NO   | MUL | 0       |                |

In debezium connector , I am using below config and all data of datatype mediumint coming in binary format, please suggest what I need to do or where I am doing wrong

  "decimal.handling.mode": "string",
        "bigint.unsigned.handling.mode": "long",
        "time.precision.mode": "connect",
        "binary.handling.mode": "base64",
         "key.converter.schemas.enable": "true",
        "value.converter.schemas.enable": "true",
        "transforms": "Cast",
        "transforms.Cast.type": "org.apache.kafka.connect.transforms.Cast$Value",
        "transforms.Cast.spec": "order_id:int32, user_id:int32"
2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.