Dear all, I am using a postgres datasource and I want to use the volcano planner of calcite (mainly for materialized view rewriting) and I was wondering which convention I should be using for the volcano planner. At this moment I am using the enumerable convention but since I am using a jdbc source I can also understand that the JdbcConvention would work better.
If the convention preference results in a favour towards the JdbcConvention then I would like to ask some help in setting this up. To create an instance of this convention I need a dialect, name and an Expression instance. Now dialect and name is pose no problem, but I am confused in how to create the expression instance. Am I supposed to use a default expression for a simple select statement for instance? And if so, what class should I give to this constructor? I have tried looking online and in the documentations but it is still a bit unclear. With kind regards, Mark