uwescience/tpch-myrial

Name: tpch-myrial

Owner: UW eScience Institute

Description: An implementation of TPC-H in the MyriaL language

Created: 2015-07-01 18:06:37.0

Updated: 2017-04-02 04:20:02.0

Pushed: 2016-06-07 20:35:53.0

Homepage: http://myria.cs.washington.edu/docs/myrial.html

Size: 37

Language: Python

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

tpch-myrial

This is an implementation of TPC-H in the MyriaL language. You can use it to generate TPC-H query plans for any back end of the Raco relational algebra compiler.

Setup

tpch-myrial requires TPC-H qgen to generate SQL queries and Raco to generate the query plans.

• Download qgen
• Install Raco by following its README.md and then make sure to set RACO_HOME to the directory of your Raco

Generate the queries

The queries are expressed as TPC-H qgen template files. The following command will run qgen on all the templates using the test parameters from the TPC-H specification.

on gen_validation.py

See the plan of a query

O_HOME/scripts/myrial [flag] q1.myl

Run $RACO_HOME/scripts/myrial -h for documentation about the different kinds of output.

Compile the queries to Grappa (Radish) programs

on do_all_queries_py.sh COMPILER_FLAGS

Caveats

• The queries are currently modified to omit sorting (ORDER BY) because MyriaL does not yet support ORDER BY.
• If you want qgen to work in general (e.g., to use the templates for the traditional ad-hoc TPC-H benchmark), then you need to fix the date ranges. See query 4 for an example. MyriaL doesn't have date intervals, but qgen expects them. The easiest fix is to extend Raco with a built-in function.