Wanted to set different ttl for different tables i...
# troubleshooting
a
Wanted to set different ttl for different tables in same table environment. Is there anyway to achieve this? If not, any suggestion for similar usecase?
d
table.exec.state.ttl
is a global (cluster) setting. AFAIK there's no way to set this on a per-table basis.
I can't think of any way to achieve what you're after.
a
On a different but slightly related usecase,
Is there a way we can do a stream to dynamic table join?
as in.. my dynamic table is slow changing table that I'd like to keep in state forever. And my main stream would like to join on that dynamic table. I do not want to create a dynamic table on streamA as well, since then it will increase my state indefinitely.
So is there a way I can directly join streamA with the dynamic table without creating dynamic table for streamA itself?
Or any other way to facilitate this kind of lookup join where my lookup table is limited in size but changing?
Any suggestions @David Anderson
d
You could stream in the table updates using a changelog format, such as debezium.
a
Thanks @David Anderson. I'm interested in working of the Table API. Can you guide me to the entry point in the code where states/etc is managed for dynamic tables?