tpcds-kit
tpcds-kit copied to clipboard
gregrahn
TPC-DS benchmark kit with some modifications/fixes
hi, It is amply clear that the current tpcds tools codebase supports few discrete workloads until 100T. But, for a test case, i need 250T dataset - even though i...
`$lsb_release -a` No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 21.04 Release: 21.04 Codename: hirsute `$pwd` ~/tpcds-kit/tools `$make OS=LINUX` gcc -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -DYYDEBUG -DLINUX -g -Wall -o dsdgen...
When I attempt to generate TPC-DS data at scale factor < 1, I get the following: [arunm2@vm-arunm2 tools]$ ./dsdgen -DIR ~/tpcds -SCALE 0.01 dsdgen Population Generator (Version 2.10.0) Copyright Transaction...
The definition of `customer` in `tpcds.sql` lists the last column as `c_last_review_date char(10)` however the TPC-DS spec v2.4 list the last column as `c_last_review_date_sk identifier` with FK to `d_date_sk` The...
As of v2.4 the `results` CTE has a `group by` that appears to be a mistake. There is no aggregate and when removing the `group by` query22a returns the same...
When using dsdgen with -ABREVIATION 1k (which admittedly I don't know if that's use as intended) it seems to seg fault.
A change introduced in v2.9 modified query77a.tpl to fix the incorrect inline view `cr` (lines 75-84) is missing a comma after the first column (L76).
At some point the dialect definitions lost the following two lines and `dsqgen` will error if not present. ``` define _BEGIN = "-- start query " + [_QUERY] + "...
The business question for query91 states: > Display total returns of catalog sales by call center and manager in a particular month for male customers of unknown education or female...