RisingWave Community - How to store data into a table from a Kafka topic holding JSON data and can the values be stored in a columnar structure?

all-things-risingwave

I want to know how to store data into a table from a Kafka topic holding JSON data and if it's possible to store the values in a columnar structure.

Sereena Eldhose

Asked on Jul 04, 2023

Risingwave only supports row store, not columnar store.
When reading from Kafka, you can define the schema for the columns or use jsonb type to keep the data in JSON format.
Risingwave supports a range of jsonb related functions to process the data, similar to PostgreSQL.
Here are some helpful links:
- Create Source Kafka Examples
- PostgreSQL JSON Functions

Jul 04, 2023Edited by