calcite-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jh...@apache.org
Subject [1/2] incubator-calcite git commit: Add a model that has lattices and works against HSQLDB.
Date Wed, 10 Dec 2014 00:44:44 GMT
Repository: incubator-calcite
Updated Branches:
  refs/heads/master 94752a606 -> f2a67050b


Add a model that has lattices and works against HSQLDB.


Project: http://git-wip-us.apache.org/repos/asf/incubator-calcite/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/42bbaad9
Tree: http://git-wip-us.apache.org/repos/asf/incubator-calcite/tree/42bbaad9
Diff: http://git-wip-us.apache.org/repos/asf/incubator-calcite/diff/42bbaad9

Branch: refs/heads/master
Commit: 42bbaad997b3be659b91fd9d94d2982372605b30
Parents: 94752a6
Author: Julian Hyde <jhyde@apache.org>
Authored: Fri Dec 5 16:16:38 2014 -0800
Committer: Julian Hyde <jhyde@apache.org>
Committed: Tue Dec 9 12:02:51 2014 -0800

----------------------------------------------------------------------
 .../hsqldb-foodmart-lattice-model.json          | 59 ++++++++++++++++++++
 1 file changed, 59 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-calcite/blob/42bbaad9/core/src/test/resources/hsqldb-foodmart-lattice-model.json
----------------------------------------------------------------------
diff --git a/core/src/test/resources/hsqldb-foodmart-lattice-model.json b/core/src/test/resources/hsqldb-foodmart-lattice-model.json
new file mode 100644
index 0000000..bf2543e
--- /dev/null
+++ b/core/src/test/resources/hsqldb-foodmart-lattice-model.json
@@ -0,0 +1,59 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to you under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+{
+  version: '1.0',
+  defaultSchema: 'foodmart',
+  schemas: [ {
+    type: 'jdbc',
+    name: 'foodmart',
+    jdbcUser: 'FOODMART',
+    jdbcPassword: 'FOODMART',
+    jdbcUrl: 'jdbc:hsqldb:res:foodmart',
+    /* jdbcCatalog: 'foodmart', */
+    jdbcSchema: 'foodmart'
+  },
+  {
+    name: 'adhoc',
+    lattices: [ {
+      name: 'star',
+      sql: [
+        'select 1 from "foodmart"."sales_fact_1997" as "s"',
+        'join "foodmart"."product" as "p" using ("product_id")',
+        'join "foodmart"."time_by_day" as "t" using ("time_id")',
+        'join "foodmart"."product_class" as "pc" on "p"."product_class_id" = "pc"."product_class_id"'
+      ],
+      auto: true,
+      algorithm: false,
+      rowCountEstimate: 86837,
+      defaultMeasures: [ {
+        agg: 'count'
+      } ],
+      tiles: [ {
+        dimensions: [ 'the_year', ['t', 'quarter'] ],
+        measures: [ {
+          agg: 'sum',
+          args: 'unit_sales'
+        }, {
+          agg: 'sum',
+          args: 'store_sales'
+        }, {
+          agg: 'count'
+        } ]
+      } ]
+    } ]
+  } ]
+}


Mime
View raw message