Ksqldb join tables

ksqlDB
1

Hi,
I want to join 2 tables with composite key, it’s possible?
Something on clause
select *
from TBL_TAT t
left join TBL_FIS f
on t.TIP_PERS = f.TIP_PERS AND
t.COD_PERS = f.COD_PERS

Thanks

2

Joining on composite keys is not supported yet.

Currently, the join expression must be a single column equal comparison. Non-equi joins, or joins on multiple columns are not supported.

Cf. Join Event Streams - ksqlDB Documentation

3

ok @mjsax , thank you.

4

This topic was automatically closed after 30 days. New replies are no longer allowed.