In our current project, we only have one topic and we want to create two or more tables based on one topic and distribute columns between multiple tables. Is there a way to assign multiple tables to one topic?

A Table in Flink SQL is metadata that is decoupled from the storage used to hold the data. So you can define as many tables as you want, all backed by the same Kafka topic.

Hello @David Anderson. Thank you for your suggestion. It worked.