velox
velox copied to clipboard
Add support for LEFT, RIGHT and FULL OUTER joins with no equi-clauses
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