starrocks
starrocks copied to clipboard
How do you implement a non-equal hash join?
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?