TPCDS Connector

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

This connector can also be used to test the capabilities and query syntax of openLooKeng without configuring access to an external data source. When you query a TPCDS schema, the connector generates the data on the fly using a deterministic algorithm.

Configuration

To configure the TPCDS connector, create a catalog properties file etc/catalog/tpcds.properties with the following contents:

  1. connector.name=tpcds

TPCDS Schemas

The TPCDS connector supplies several schemas:

  1. SHOW SCHEMAS FROM tpcds;
  1. Schema
  2. --------------------
  3. information_schema
  4. sf1
  5. sf10
  6. sf100
  7. sf1000
  8. sf10000
  9. sf100000
  10. sf300
  11. sf3000
  12. sf30000
  13. tiny
  14. (11 rows)

Ignore the standard schema information_schema which exists in every catalog and is not directly provided by the TPCDS connector.

Every TPCDS schema provides the same set of tables. Some tables are identical in all schemas. The scale factor of the tables in a particular schema is determined from the schema name. For example, the schema sf1 corresponds to scale factor 1 and the schema sf300 corresponds to scale factor 300. Every unit in the scale factor corresponds to a gigabyte of data. For example, for scale factor 300, a total of 300 gigabytes will be generated. The tiny schema is an alias for scale factor 0.01, which is a very small data set useful for testing.