Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-178

Add TPC-DS schema and query set (but not data) for testing

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              github-import GitHub Import
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: