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

Performance consequence of leftOuterJoinLateral

2020-12-01 Thread Rex Fenley
Hello, I'm curious if there's any performance consequence of using a TableFunction + leftOuterJoinLateral to create some new columns vs creating each column individually? I'm hoping that lookup for a row with leftOuterJoinLateral is essentially O(1), so as soon as the TableFunction is done it jus