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
Articles Related
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