tpcds-kit icon indicating copy to clipboard operation
tpcds-kit copied to clipboard
verified publisher icon gregrahn

customer table: c_last_review_date vs c_last_review_date_sk

Open gregrahn opened this issue 8 years ago • 2 comments

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 DDL looks incorrect. This column change also impacts query30.tpl

gregrahn avatar Mar 23 '17 04:03 gregrahn

Fixed in v2.6.0 in query30, but DDL (tpcds.sql) not updated to match in official release. I've made both the column name and type change in tpcds.sql

gregrahn avatar Oct 14 '17 06:10 gregrahn

https://tpcorg.fogbugz.com/default.asp?3037_lq3je9v9

gregrahn avatar May 19 '20 13:05 gregrahn