CODEWITHSUNDEEP
sqldatabaseoracle-databasebenchmarkingtpc
user3395654
user3395654

Reputation: 13

How to generate executable TPC-DS queries?

I have downloaded the DSGEN tool from the TPC-DS web site and already generated the tables and loaded the data into Oracle XE.

I am using the following command to generate the SQL statements :

dsqgen -input ..\query_templates\templates.lst -directory ..\query_templates -dialect oracle -scale 1

However, No matter how I adjust the command I always get this error message :

ERROR: A query template list must be supplied using the INPUT option

Can anybody help?

Upvotes: 1

Views: 3140

Answers (1)

Alex Poole
Alex Poole

Reputation: 191315

Apparently you need to use / rather than - for the flags for the Windows executable:

dsqgen /input ..\query_templates\templates.lst /directory ..\query_templates
    /dialect oracle /scale 1

Upvotes: 1

Related Questions