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

Update TPC-DS kit with version 2.2.0 of the official kit

Open rcecil opened this issue 9 years ago • 2 comments

  1. Updated the templates with the templates from the Offical 2.2.0 release
  2. Added an MQM folder to hold query rewrites that are allowed per official TPC-DS spec ( MQM = Minor Query Modifications )

rcecil avatar Sep 07 '16 15:09 rcecil

Thanks for putting this together. For the MQM rewrites, are for a specific system? Asking because I was thinking about creating another repo of just TPC-DS query templates for different DBMSs that could be maintained separately from the datagen kit.

gregrahn avatar Sep 08 '16 04:09 gregrahn

Greg, you are very welcome. The MQM rewrites are specific to spark ( I have tested 1.5/1.6 and 2.0  ) . All queries compile only on 2.0 ...     Kind Regards,---Roy CecilSr. Big SQL Performance Engineer,Analytics Platform Performance (BigInsights/Big SQL/DB2)Phone : +353- (0)1 815-5557TL/ITN : 7-515557 / 37515557Email : [email protected] : +353-(0) 1 815 - 3388/2298/2324     ----- Original message -----From: Greg Rahn [email protected]: gregrahn/tpcds-kit [email protected]: Roy Cecil/Ireland/IBM@IBMIE, Author [email protected]: Re: [gregrahn/tpcds-kit] Update TPC-DS kit with version 2.2.0 of the official kit (#19)Date: Thu, Sep 8, 2016 12:45 PM  Thanks for putting this together. For the MQM rewrites, are for a specific system? Asking because I was thinking about creating another repo of just TPC-DS query templates for different DBMSs that could be maintained separately from the datagen kit. —You are receiving this because you authored the thread.Reply to this email directly, view it on GitHub, or mute the thread.

 

rcecil avatar Sep 08 '16 12:09 rcecil