Important

You are viewing documentation for an older version of Confluent Platform. For the latest, click here.

ValueToKey

The following provides usage information for the Apache Kafka® SMT org.apache.kafka.connect.transforms.ValueToKey.

Description

Replace the record key with a new key formed from a subset of fields in the record value.

Examples

These examples show how to use ValueToKey by itself and in conjunction with a second SMT.

Transform Fields to Message Key

This configuration snippet shows how to use ValueToKey to transform the UserId, city, and state fields into a message key.

"transforms": "ValueToKey",
"transforms.ExtractField.type":"org.apache.kafka.connect.transforms.ValueToKey$Key",
"transforms.ExtractField.fields":"userId,city,state"

Before: {"userId": 12, "address": "1942 Wilhelm Boulevard", "city": "Topeka", "state": "KS", "country": "US"}

After: {"userId": 12, "city": "Topeka", "state": "KS"}

Chained Transformation

You can use SMTs together to perform a more complex transformation.

The following examples show how the ValueToKey and ExtractField SMTs are chained together to set the key for data coming from a JDBC Source Connector. During the transform, ValueToKey copies the message c1 field into the message key and then ExtractField extracts just the integer portion of that field.

"transforms":"createKey,extractInt",
"transforms.createKey.type":"org.apache.kafka.connect.transforms.ValueToKey",
"transforms.createKey.fields":"c1",
"transforms.extractInt.type":"org.apache.kafka.connect.transforms.ExtractField$Key",
"transforms.extractInt.field":"c1"

The following shows what the message looked like before the transform.

"./bin/kafka-avro-console-consumer \
                              --bootstrap-server localhost:9092 \
                              --property schema.registry.url=http://localhost:8081 \
                              --property print.key=true \
                              --from-beginning \
                              --topic mysql-foobar

null {"c1":{"int":1},"c2":{"string":"foo"},"create_ts":1501796305000,"update_ts":1501796305000}
null {"c1":{"int":2},"c2":{"string":"foo"},"create_ts":1501796665000,"update_ts":1501796665000}

After the connector configuration is applied, new rows are inserted (piped) into the MySQL table:

"echo "insert into foobar (c1,c2) values (100,'bar');"|mysql --user=username --password=pw demo

The following is displayed in the Avro console consumer. Note that the key (the first value on the line) matches the value of c1, which was defined with the transforms.

100 {"c1":{"int":100},"c2":{"string":"bar"},"create_ts":1501799535000,"update_ts":1501799535000}

Properties

Name Description Type Default Valid Values Importance
fields Field names on the record value to extract as the record key. list   non-empty list high