Update ksql stream with new topic schema

Question

I write avro messages into kafka topic using schema registry. Then created stream based on the topic. The scream created with current schema.

Then I add new field to the schema. The schema register updated, it's OK, but the stream stay with the first structure.

Can I update the stream with new schema?

It's problematic for me to drop and create the schema again because I have lot of other streams\tables that depend on it. The KSQL don't allow to drop stream with dependencies.

Can you just create a new stream now that you have the new schema in place? Once you have the new stream (based on the new schema) you can point your applications to this new stream. — davidseth, Sep 19 '18 at 00:52

score 0 · Answer 1 · answered Mar 12 '19 at 11:27

0

I think the best way is stop the streams and DROP STREAM MYSTREAM.

https://docs.confluent.io/current/ksql/docs/developer-guide/create-a-stream.html#delete-a-ksql-stream

answered Mar 12 '19 at 11:27

Calebe Elias Ribeiro Brim

81
7

Care to collaborate a little more why do you think it's the best solution? – wscourge Mar 12 '19 at 11:46
1

Drop stream is not option for me because I have lot of dependencies ( read the questions again). – Hersh Mar 13 '19 at 08:34

Update ksql stream with new topic schema

1 Answers1