5.22. TPCH Connector

The TPCH connector provides a set of schemas to support the TPCBenchmark™ H (TPC-H). TPC-H is a database benchmark used to measure theperformance of highly-complex decision support databases.

This connector can also be used to test the capabilities and querysyntax of Presto without configuring access to an external datasource. When you query a TPCH schema, the connector generates thedata on the fly using a deterministic algorithm.

Configuration

To configure the TPCH connector, create a catalog properties fileetc/catalog/tpch.properties with the following contents:

  1. connector.name=tpch

TPCH Schemas

The TPCH connector supplies several schemas:

  1. SHOW SCHEMAS FROM tpch;

  1.        Schema

information_schema sf1 sf100 sf1000 sf10000 sf100000 sf300 sf3000 sf30000 tiny(11 rows)

Ignore the standard schema information_schema which exists in everycatalog and is not directly provided by the TPCH connector.

Every TPCH schema provides the same set of tables. Some tables areidentical in all schemas. Other tables vary based on the _scale factor_which is determined based on the schema name. For example, the schemasf1 corresponds to scale factor 1 and the schema sf300corresponds to scale factor 300. The TPCH connector provides aninfinite number of schemas for any scale factor, not just the few commonones listed by SHOW SCHEMAS. The tiny schema is an alias for scalefactor 0.01, which is a very small data set useful for testing.