TPC-DS - Query Stream

Tpc Ds Data Flow

About

A query stream is defined as the sequential execution of a permutation of queries submitted by a single emulated user.

Ie this is a file containing multiple queries. See creation

Management

Creation

with TPC-DS - dsqgen

  • Linux
dsqgen –scale <sf> -dir <path to query templates> -streams <n> -input <templates.lsf>
  • Windows: Example
	
dsqgen ^
    /scale 1000 ^
    /dir D:\code\tpcds-xp\query_templates ^
    /streams 5 ^
    /input D:\code\tpcds-xp\query_templates\templates.lst ^
    /distributions D:\code\tpcds-xp\build\tpcds.idx

where:

  • the stream options defines the number of file generated (containing multiple queries).
  • distributions defines the location of tpcds.idx
  • input is a file containing list of query templates separated by an end of line

The output will show 5 files containing multiples query:

query_0.sql  query_1.sql  query_2.sql  query_3.sql  query_4.sql





Discover More
Tpc Ds Data Flow
Substitution Parameter

The is a query property that describes the substitution values needed to generate the executable query text within Each query has one or more substitution parameters. Dsqgen must be used to generate...
Tpc Ds Data Flow
TPC-DS - Power Test

A Power Test consists of exactly one query session running a single query stream.
Tpc Ds Data Flow
TPC-DS - Throughput Test

A Throughput Test consists of Sq query sessions each running a single query stream.
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...



Share this page:
Follow us:
Task Runner