calcite_test.json
contains test cases of Apache Calcite, a query optimizer generator. The test cases are from https://github.com/apache/calcite/blob/master/core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java . Each element of has 3 fields:
name
: corresponding to the test name inRelOptRuleTest.java
.q1
: converted from query plan (not the input SQL) before optimizer's rewrite.q2
: converted from query plan after optimzier's rewrite.
The following preprocessing has been done in calcite_test.json
.
- Remove the multi-level catalog, e.g.
CATALOG.SALES.EMP
becomesEMP
. - Convert compound column to normal column. e.g.
F1.A0
becomesF1_A0
.