Re: UniqueKey constraint is lost with multiple sources join in SQL

2021-04-08 Thread Kai Fu
As identified with the community, it's bug and more information in issue https://issues.apache.org/jira/browse/FLINK-22113 On Sat, Apr 3, 2021 at 8:43 PM Kai Fu wrote: > Hi team, > > We have a use case to join multiple data sources to generate a > continuous updated view. We defined primary key

UniqueKey constraint is lost with multiple sources join in SQL

2021-04-03 Thread Kai Fu
Hi team, We have a use case to join multiple data sources to generate a continuous updated view. We defined primary key constraint on all the input sources and all the keys are the subsets in the join condition. All joins are left join. In our case, the first two inputs can produce *JoinKeyContai