search

gregrahn / tpcds-kit

TPC-DS benchmark kit with some modifications/fixes
317 stars 200 forks source link

Changing range of dates #46

Closed hancelpv closed 5 years ago

hancelpv commented 5 years ago

With the default setting, data is generated from 1998-01-02 to 2003-01-02. Is it possible to generate data for a different range of dates ? for instance 2015-01-01 to 2020-01-01..

gregrahn commented 5 years ago

You can:

1) load and do date math with SQL either in-line or via staging tables 2) change the range in constants.h and recompile

1 is sure to work, you will have to test 2. Do note this will likely make the queries return 0 rows as they are aligned to the default date window.

hancelpv commented 5 years ago

@gregrahn Thank you so much for your prompt reply ! I used method 2, changed the sysdate to a future date and obtained data for future dates as well. I have one more query regarding promotion data.

My date range is 2015-01-01 to 2019-04-16 in constants.h. When I generated data at scale 1, promotion.dat file has the latest record 27-03-2015. Is there anyway we can generate promotion records too for the future/current dates ?

gregrahn commented 5 years ago

There may be a way but I'm not familiar with how one might go about doing so. I'd recommend navigating around the .c and .h files.