TPC-H dataset #

The TPC-H dataset provides a set of schemas to support the TPC Benchmark™ H (TPC-H). TPC-H is a database benchmark used to measure the performance of highly-complex decision support databases.

The dataset includes numerous schemas that only vary in the amount of data. This allows you to develop and test SQL queries with a small number of records, and then run the same query against a larger dataset.

The benchmark also includes numerous queries that can be used as examples for learning and improving SQL.

All data is generated when requested from the catalog. You can use it as a data source and use CREATE TABLE AS SELECT statements to copy the data into other catalogs, and subsequently run queries against those catalog for various purposes, including testing and benchmarks as desired.

Configure a catalog #

To create a catalog with the TPC-H dataset, select Catalogs in the main navigation, and click Configure a catalog. Click on the TPC-H button in the Select a dataset section.

Define catalog name and description #

The Name of the catalog is visible in Query editor and other clients. It is used to identify the catalog when writing SQL or showing the catalog and nested schemas and tables in client applications.

The name is displayed in Query editor, and when running a SHOW CATALOGS. It is used to fully qualify the name of any table in SQL queries following the catalogname.schemaname.tablename syntax. For example, you can run the following query in the demo cluster without setting any context of catalog or schema.

SELECT * FROM tpch.sf1.nation;

The Description is a short, optional paragraph that provides more details about the catalog than the name alone. It appears in the user interface and can help other users to determine what data can be accessed with the catalog.

Save the catalog #

Click the Save catalog button, and proceed to add the catalog to a cluster. Then proceed to use SQL queries to analyze and work with the data source with SQL.