Implement a filter rule that adds a predicate

2023-05-27 Thread Soumyadeep Mukhopadhyay
Hello all, *I was trying to implement a filter rule which can add an extra predicate*, for example: *look for GROUP BY clause in a query, check if HAVING is present, if not add HAVING COUNT(*)>120.* *I was trying to do the following: *

Re: Template SQL

2023-05-27 Thread Soumyadeep Mukhopadhyay
Hello Askar, Thank you again for the replies! Hope all is well! :) To answer your questions: Question: Wanting to use Calcite (Calcite-server in particular) as a "proxy DB" to change incoming queries to have HAVING before passing the query to an underlying database? Answer: Yes. Question: Just

[DISCUSS] Towards Calcite 1.35.0

2023-05-27 Thread Benchao Li
It's been a bit more than 2 months since our last release [1] and there are currently 80+ new commits in master. As usual, according to our Jira dashboard [2] and Github [3], there are many pending issues that could / should be part of the release. I'd propose to make a collective effort to try