I am trying to join messages from 2 different kafka topics which have different partition numbers with ksqlDB. When i create streams from each topics and trying to join them, ksqlDB does not allow bec. of different partition numbers in base topics.
When i do the below steps for each topic: ->create stream from root topic, ->create another stream from first stream with new topic with 1 partition (reduce 4 to 1) i cant' t see any data at the final stream which has 1 partition.
Is there any solution to join 2 topics with different partition numbers in ksqlDB?
I had same issue. Problem wasn't the number of partitions. Problem was that the join was on fields with different data type ( bigint and double ).