[CALCITE-178] Add TPC-DS schema and query set (but not data) for testing

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 08:27
• Updated: 18/Jun/14 08:27

Description

It will be helpful to have a rich schema and set of queries to test advanced planning rules. TPC-DS is a star schema with multiple fact tables and complex queries so would fit the bill.

I don't want the data set (or maybe just a scale 0.01 version, a couple of megabytes) but I do want to be able to mock up statistics such as number of distinct values of column x or the selectivity of the join between t1 and t2.

A convenient packaging would be a JAR file, stored in maven, containing an hsqldb database (similar format to http://conjars.org/pentaho/mondrian-data-foodmart-hsqldb) and a queries.json (similar to http://conjars.org/pentaho/mondrian-data-foodmart-queries).

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/178
Created by: julianhyde
Labels: performance,
Created at: Wed Mar 12 19:24:01 CET 2014
State: open