How to select the Key of a Record in a Select statement

Question

I created this record:

new ProducerRecord(topic = "petstore-msg-topic", key = msg.username, value = s"${msg.route},${msg.time}")

I want now to do something like this:

CREATE STREAM petstorePages (KEY, route VARCHAR, time VARCHAR) \
                  WITH (KAFKA_TOPIC='petstore-msg-topic', VALUE_FORMAT='DELIMITED');

Is there a possibility to access the key in the Stream creation or do I have to include the key also in the value?

score 3 · Accepted Answer · answered Aug 20 '18 at 13:13

3

It's added automatically and called ROWKEY

KSQL adds the implicit columns ROWTIME and ROWKEY to every stream and table, which represent the corresponding Kafka message timestamp and message key

https://docs.confluent.io/current/ksql/docs/syntax-reference.html#id16

answered Aug 20 '18 at 13:13

OneCricketeer

179,855
19
132
245

1

BTW, if you use the Schema Registry with Avro data, then you wouldn't need to specify the Stream schema – OneCricketeer Aug 20 '18 at 13:15

How to select the Key of a Record in a Select statement

1 Answers1