Is there some documentation or best practice doc about how using both of
the two planners ?
I guess you have to pass a set of rules to the HepPlanner in order to
perform some simpler steps
and then pass other rules to VolcanoPlanner in order to create the physical
plan.
What is the RelNode to pass
Thanks Rui and Stamatis for the clarification. I was probably misled by the
documentation,
as it stated that there are 2 implementations for planner rules. Thus I
figured that this is configurable in some way.
Also, it was mentioned that the Heuristic approach carried by the
HepPlanner has less ove
I did a test locally and I found your example syntax is correct.
I used "select distinct deptno, empno from emp order by empno desc"
and Calcite generates this plan:
LogicalSort(sort0=[$1], dir0=[DESC])
LogicalAggregate(group=[{0, 1}])
LogicalProject(DEPTNO=[$7], EMPNO=[$0])
LogicalTa
Hi all,
I am trying to generate the following SQL query but I am facing some
difficulties in finding the right syntax to implement 'DISTINCT' and 'ORDER BY'
SELECT DISTINCT name_first, name_last FROM users ORDER BY name_last DESC
I would really appreciate it if you could guide me with the corr
Rui Wang created CALCITE-4153:
-
Summary: Implement EMIT AFTER WATERMARK
Key: CALCITE-4153
URL: https://issues.apache.org/jira/browse/CALCITE-4153
Project: Calcite
Issue Type: Sub-task
Hi Matt,
Since you end-up with SqlTypeName.OTHER I guess when you create the type
you use RelDataTypeFactory#createJavaType [1].
Have you tried using RelDataTypeFactory#createStructType [2]?
There are already use-cases using combinations of arrays with structs and
Avatica seems to handle them wit
Hi Meron,
The two planners are not equivalent so the comparison is not totally fair.
Even if you apply the same ruleset it does not mean that you are going
to obtain the same plan.
The two planners are complementary to each other and they are used in
different stages of the optimization process t
I didn’t see the derivation formula yet but I believe there is indeed some
promotion space for the Agg Join transpose cases, Alex, can you log an issue
there ?
Best,
Danny Chan
在 2020年7月31日 +0800 PM1:43，Alex Baden ，写道：
> Hi all,
>
> I have a query of the form:
>
> SELECT a.x, SUM(b.y), SUM(b.z)
Istvan Toth created CALCITE-4152:
Summary: Avoid SPNEGO re-negotiation for each request
Key: CALCITE-4152
URL: https://issues.apache.org/jira/browse/CALCITE-4152
Project: Calcite
Issue Type:
