starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

How do you implement a non-equal hash join?

Open JackTan25 opened this issue 3 years ago • 0 comments

General Question

I mean the sql statement like this: Select t1.a,t2.b from t1 join t2 on t1.c = t2.d and t1.e > t2.f; how to use hash join to do this and speed up the query?

JackTan25 avatar Aug 10 '22 03:08 JackTan25