Re: Performance consequence of leftOuterJoinLateral

2020-12-02 Thread Rex Fenley
Yes, exactly. Thanks! On Tue, Dec 1, 2020 at 6:11 PM Danny Chan wrote: > Hi, Rex ~ > > For "leftOuterJoinLateral" do you mean join a table function through > lateral table ? > If it is, yes, the complexity is O(1) for each probe key of LHS. The table > function evaluate the extra columns and app

Re: Performance consequence of leftOuterJoinLateral

2020-12-01 Thread Danny Chan
Hi, Rex ~ For "leftOuterJoinLateral" do you mean join a table function through lateral table ? If it is, yes, the complexity is O(1) for each probe key of LHS. The table function evaluate the extra columns and append it to the left columns. Rex Fenley 于2020年12月2日周三 上午7:54写道: > Hello, > > I'm cu