Hi, Beam currently doesn't support Join of Unbounded PCollections of different WindowFns ( https://beam.apache.org/documentation/programming-guide/#groupbykey-and-unbounded-pcollections ).
BeamSql performs [Unbounded PCollection] JOIN [Bounded PCollection], by performing 'SideInputJoin' with Bounded PCollection as a SideInput. Can we support [Unbounded PCollection] JOIN [Unbounded PCollection], when one of the Unbounded PCollection has [GlobalWindows Applied with Non-Default Trigger(probably a slow-changing lookup cache https://beam.apache.org/documentation/patterns/side-input-patterns/#slowly-updating-global-window-side-inputs)] by performing 'SideInputJoin'? Regards, Rahul
