I have downloaded the DSGEN tool from the TPC-DS web site and already generated the tables and loaded the data into MS SQL server.
I am using the following command to generate the SQL statements(on windows):
dsqgen /input ../query_templates/templates.lst /directory ../query_templates /dialect sqlserver /scale 1
The command gives a single query_0.sql file as output and it has only 22 queries out of 99 queries. Also in the command prompt, an error is shown as given below:
RUNTIME ERROR: Distribution over-run/under-run
Check distribution definitions and usage for cities
index=-1, length=1000
Can anybody help?
Best Answer
Try the -VERBOSE option to see if there are additional information generated by dsqgen. Also, the version of templates downloaded from tpc.org are missing some DEFINES.