I would like to do a groupby followed by a join in structured streaming. I would read from from two delta table in snapshot mode i.e. latest snapshot.
My question is specifically about chaining the stateful operator.
groupby is update mode
chaning groupby and join, must be append mode overall.
But does it means that the groupby would behave as if it was append as well, or the groupby can be in update mode and the join in append mode ?
