Re: sql-api: multiconditional joins into binary join

2025-03-21 Thread Kaustubh Beedkar
Hi Mads, Currently, the sql-api, converts logical plans by calcite to wayang (relational) plans as-is. For what you want to achieve, you will have to extend the WayangJoinVisitor.java class. Particularly, https://github.com/apache/incubator-wayang/blob/24d8eec742f21fd5adfbd089e93f96271c6f5a63/waya

sql-api: multiconditional joins into binary join

2025-03-14 Thread Mads Sejer Pedersen
Hi people, I am doing some benchmarking with Calcite for the sql-api in Apache Wayang that requires typically multiconditional joins to be split into "binary" joins ala: LogicalJoin(condition=[AND(=($0, $27), =($10, $28), =($34, $2))], joinType=[inner]): rowcount = 118.65234375, cumulative cost