/*
 * 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'
        } ]
      } ]
    } ]
  } ]
}

Add a model that has lattices and works against HSQLDB.
Add a model that has lattices and works against HSQLDB.
