Missing Functionality for TPC-DS Benchmark

2 posts / 0 new
Last post
ep1
ep1's picture
Offline
Last seen: 6 months 6 days ago
Joined: Oct 10 2011
Junior Boarder

Posts: 1

Protalis LLC
Missing Functionality for TPC-DS Benchmark

I'm trying to run the TPC-DS benchmark to compare against Sybase-IQ and Teradata, both of which we currently use.  I am unable to proceed because the following features are unsupported:

 

1) PRIMARY KEY CONSTRAINTS

2) TIME DATA TYPE

 

djoshi
djoshi's picture
Offline
Last seen: 1 month 1 week ago
Joined: Jun 6 2012
Administrator

Posts: 28

Dipti Joshi
Functionality for TPCDS- benchmark

1) InfiniDB does not have concept of primary key, so you need to comment out or remove the "primary key" line for each table in tpcds.sql script

 

2) Instead of "time" use "datetime" type in the table creation script.