Re: Using Calcite for query planning

2018-02-15 Thread Davide Lanti
Ok, thank you very much Julian, we'll try it out. Best regards, Davide and Guohui. On 14/02/18 19:42, Julian Hyde wrote: It sounds like a good fit. Parse the SQL, translate to relational algebra, apply some query transformation rules on the algebra. If you have a few simple transformations

Re: Using Calcite for query planning

2018-02-14 Thread Julian Hyde
It sounds like a good fit. Parse the SQL, translate to relational algebra, apply some query transformation rules on the algebra. If you have a few simple transformations in mind, you may be able to achieve it without a cost model. Or, as you propose, a simple model based on cardinality. To conv

Using Calcite for query planning

2018-02-14 Thread Guohui Xiao
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 mo