CODEWITHSUNDEEP
apache-kafkaksqldb
Janice
Janice

Reputation: 176

Can I change KSQL table from AVRO to JSON format?

I am trying to have a JSON format table for my python script to access it and doesn't want to change the original topic format as it is currently in AVRO format.

So my question is, it is possible to change from an AVRO format to JSON format? Either from stream to table, or from table to table.

Upvotes: 0

Views: 994

Answers (1)

Robin Moffatt
Robin Moffatt

Reputation: 32090

Yes, you can specify the alternative VALUE_FORMAT and create a derived stream/table:

CREATE STREAM foo_json WITH (VALUE_FORMAT='JSON') AS SELECT * FROM foo_avro;

Upvotes: 2

Related Questions