TPC-DS - Query Template

Tpc Ds Data Flow


A query template is translated by dsqgen into fully functional SQL, which is known as executable query text (EQT).

The query templates are primarily phrased in compliance with SQL1999 core (with OLAP amendments).


A template includes the following, non-standard additions:

  • They are annotated, where necessary, to specify the number of rows to be returned
  • They include substitution tags that, in conjunction with dsqgen, allow a single template to generate a large number of syntactically distinct queries, which are functionally equivalent


See tpcds_home\query_templates/*.tpl

Discover More
Tpc Ds Data Flow
TPC-DS - Query

A query is an ordered set of one or more valid SQL statements resulting from applying the required parameter substitutions to a given query template. The order of the SQL statements is defined in the...
Tpc Ds Data Flow
TPC-DS - Result

Result measures: query response time in single user mode, query throughput in multi user mode and data maintenance performance for: a given hardware, operating system, and data processing...
Tpc Ds Data Flow
TPC-DS - dsqgen

dsqgen translates the query templates into fully functional SQL, which is known as executable query text (EQT). dsqgen can create: one executable query text (EQT). See or multiple executable query...
Tpc Ds Data Flow
TPC-DS - executable query text (EQT)

An executable query text (EQT) is a query that: is created with the dsqgen tool from a query template file can be executed against a database

Share this page:
Follow us:
Task Runner