velox icon indicating copy to clipboard operation
velox copied to clipboard

Add support for LEFT, RIGHT and FULL OUTER joins with no equi-clauses

Open mbasmanova opened this issue 2 years ago • 0 comments

Extends CrossJoinNode plan node and CrossJoinProbe operator to support LEFT, RIGHT and FULL OUTER joins without equi-clauses.

SELECT * FROM t LEFT JOIN u ON t.a < u.b;
SELECT * FROM t RIGHT JOIN u ON t.a < u.b;
SELECT * FROM t FULL OUTER JOIN u ON t.a < u.b;

Currently, these queries are not supported. Running these from Prestissimo gives errors like

VeloxRuntimeError: !leftKeys_.empty() JoinNode requires at least one join key

CC: @rui-mo @aditi-pandit @majetideepak @xiaoxmeng @Yuhta

mbasmanova avatar Oct 19 '22 14:10 mbasmanova