Repository: calcite Updated Branches: refs/heads/master 20ade9d26 -> 3e587afb0
[CALCITE-2052] Remove SQL code style from MV documentation Project: http://git-wip-us.apache.org/repos/asf/calcite/repo Commit: http://git-wip-us.apache.org/repos/asf/calcite/commit/3e587afb Tree: http://git-wip-us.apache.org/repos/asf/calcite/tree/3e587afb Diff: http://git-wip-us.apache.org/repos/asf/calcite/diff/3e587afb Branch: refs/heads/master Commit: 3e587afb0d689e42b432c5024d37916ef8b2ccd4 Parents: 20ade9d Author: Jesus Camacho Rodriguez <[email protected]> Authored: Tue Nov 14 16:38:34 2017 -0800 Committer: Jesus Camacho Rodriguez <[email protected]> Committed: Tue Nov 14 16:38:34 2017 -0800 ---------------------------------------------------------------------- site/_docs/materialized_views.md | 44 +++++++++++++++++------------------ 1 file changed, 22 insertions(+), 22 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/calcite/blob/3e587afb/site/_docs/materialized_views.md ---------------------------------------------------------------------- diff --git a/site/_docs/materialized_views.md b/site/_docs/materialized_views.md index 8cb57cd..a407b12 100644 --- a/site/_docs/materialized_views.md +++ b/site/_docs/materialized_views.md @@ -77,7 +77,7 @@ To produce a larger number of rewritings, the rule relies on information exposed Let us illustrate with some examples the coverage of the view rewriting algorithm implemented in `AbstractMaterializedViewRule`. The examples are based on the following database schema. -```SQL +``` CREATE TABLE depts( deptno INT NOT NULL, deptname VARCHAR(20), @@ -106,7 +106,7 @@ The rewriting can handle different join orders in the query and the view definit * Query: -```SQL +``` SELECT empid FROM depts JOIN ( @@ -118,7 +118,7 @@ ON (depts.deptno = subq.deptno) * Materialized view definition: -```SQL +``` SELECT empid FROM emps JOIN depts USING (deptno) @@ -126,7 +126,7 @@ JOIN depts USING (deptno) * Rewriting: -```SQL +``` SELECT empid FROM mv WHERE empid = 1 @@ -137,7 +137,7 @@ WHERE empid = 1 * Query: -```SQL +``` SELECT deptno FROM emps WHERE deptno > 10 @@ -146,7 +146,7 @@ GROUP BY deptno * Materialized view definition: -```SQL +``` SELECT empid, deptno FROM emps WHERE deptno > 5 @@ -155,7 +155,7 @@ GROUP BY empid, deptno * Rewriting: -```SQL +``` SELECT deptno FROM mv WHERE deptno > 10 @@ -167,7 +167,7 @@ GROUP BY deptno * Query: -```SQL +``` SELECT deptno, COUNT(*) AS c, SUM(salary) AS s FROM emps GROUP BY deptno @@ -175,7 +175,7 @@ GROUP BY deptno * Materialized view definition: -```SQL +``` SELECT empid, deptno, COUNT(*) AS c, SUM(salary) AS s FROM emps GROUP BY empid, deptno @@ -183,7 +183,7 @@ GROUP BY empid, deptno * Rewriting: -```SQL +``` SELECT deptno, SUM(c), SUM(s) FROM mv GROUP BY deptno @@ -196,7 +196,7 @@ Through the declared constraints, the rule can detect joins that only append col * Query: -```SQL +``` SELECT deptno, COUNT(*) FROM emps GROUP BY deptno @@ -204,7 +204,7 @@ GROUP BY deptno * Materialized view definition: -```SQL +``` SELECT empid, depts.deptno, COUNT(*) AS c, SUM(salary) AS s FROM emps JOIN depts USING (deptno) @@ -213,7 +213,7 @@ GROUP BY empid, depts.deptno * Rewriting: -```SQL +``` SELECT deptno, SUM(c) FROM mv GROUP BY deptno @@ -224,7 +224,7 @@ GROUP BY deptno * Query: -```SQL +``` SELECT deptname, state, SUM(salary) AS s FROM emps JOIN depts ON (emps.deptno = depts.deptno) @@ -234,7 +234,7 @@ GROUP BY deptname, state * Materialized view definition: -```SQL +``` SELECT empid, deptno, state, SUM(salary) AS s FROM emps JOIN locations ON (emps.locationid = locations.locationid) @@ -243,7 +243,7 @@ GROUP BY empid, deptno, state * Rewriting: -```SQL +``` SELECT deptname, state, SUM(s) FROM mv JOIN depts ON (mv.deptno = depts.deptno) @@ -255,7 +255,7 @@ GROUP BY deptname, state * Query: -```SQL +``` SELECT empid, deptname FROM emps JOIN depts ON (emps.deptno = depts.deptno) @@ -264,7 +264,7 @@ WHERE salary > 10000 * Materialized view definition: -```SQL +``` SELECT empid, deptname FROM emps JOIN depts ON (emps.deptno = depts.deptno) @@ -273,7 +273,7 @@ WHERE salary > 12000 * Rewriting: -```SQL +``` SELECT empid, deptname FROM mv UNION ALL @@ -288,7 +288,7 @@ WHERE salary > 10000 AND salary <= 12000 * Query: -```SQL +``` SELECT empid, deptname, SUM(salary) AS s FROM emps JOIN depts ON (emps.deptno = depts.deptno) @@ -298,7 +298,7 @@ GROUP BY empid, deptname * Materialized view definition: -```SQL +``` SELECT empid, deptname, SUM(salary) AS s FROM emps JOIN depts ON (emps.deptno = depts.deptno) @@ -308,7 +308,7 @@ GROUP BY empid, deptname * Rewriting: -```SQL +``` SELECT empid, deptname, SUM(s) FROM ( SELECT empid, deptname, s
