Hi Team,
Is there a way I can directly join stream...
# troubleshootinga
Aditya
02/24/2023, 5:00 AMHi Team,
Is there a way I can directly join streamA with the dynamic table without creating dynamic table for streamA itself?
π 1
m
Martijn Visser
02/24/2023, 1:49 PMI'm not sure I understand the question, Can you clarify what you're trying to do?
a
Aditya
02/24/2023, 2:13 PMI was looking for a way to join data of 1 stream to join with historical data for second stream.
Aditya
02/24/2023, 2:13 PM1 way to do that is create dynamic table for both streamA and streamB. Perform join on both.
Aditya
02/24/2023, 2:14 PMBut this way, data for both tables will be kept in state. I am not concerned with historical data of streamA.
However I need entire historical data of streamB in state.
Aditya
02/24/2023, 2:15 PMWould it be possible that somehow I only create a dynamic table for streamB.
And have a join between streamA and dynamic table?
Aditya
02/28/2023, 11:52 AMAny ideas @Martijn Visser
m
Martijn Visser
03/02/2023, 2:45 PMDynamic tables are a logical concept, as outlined on https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/concepts/dynamic_tables/
You should be able to achieve this with a normal join https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql/queries/joins/
2 Views