foodmart-queries

SQL queries issued by Mondrian against the FoodMart data set, in JSON format

It was generated by the test suite of the Pentaho Mondrian OLAP engine, but serves as a challenging benchmark for any SQL engine.

Download and build

Java version 8 or higher.

$ git clone git://github.com/julianhyde/foodmart-queries.git
$ cd foodmart-queries
$ ./mvnw install

On Windows, the last line is

> mvnw install

See also

Similar data sets:

• chinook-data-hsqldb
• foodmart-data-hsqldb
• foodmart-data-json
• foodmart-data-mysql
• scott-data-hsqldb
• scott-data-hsqldb
• steelwheels-data-hsqldb

More information

• License: Apache License, Version 2.0
• Author: Julian Hyde
• Blog: http://julianhyde.blogspot.com
• Project page: http://www.hydromatic.net/foodmart-queries
• Source code: http://github.com/julianhyde/foodmart-queries
• Developers list: dev at calcite.incubator.apache.org (archive, subscribe)
• Issues: https://github.com/julianhyde/foodmart-queries/issues
• Release notes and history