Hi, We are considering using Calcite to perform cost-based query optimization in our project.
Specifically, we can already generate some SQL queries expressed in some relational algebra expression through our API, and we want to optimize the generated expressions using Calcite. We have a cost model based on cardinality estimation. We want to use it to convert e.g., a union of conjunctive queries (UCQ) into a a join of UCQs. We would like to understand how much efforts are needed to realize our idea using Calcite. Do you have suggestions about this? Thanks in advance. Best regards, Guohui & Davide -- Guohui Xiao, PhD Assistant Professor with a fixed-term contract KRDB - Faculty of Computer Science Free University of Bozen-Bolzano Piazza Domenicani, 3 I-39100 Bolzano, Italy http://www.ghxiao.org