git404hub

what is tpcds-kit fr?

starrocks/tpcds-kit — explained in plain English

Analysis updated 2026-07-19 · repo last pushed 2025-01-02

1CAudience · ops devopsComplexity · 4/5StaleSetup · hard

tl;dr

A toolkit for generating massive fake retail datasets and 99 standard business queries to benchmark database performance. This version is tweaked specifically for the StarRocks database.

vibe map

mindmap
  root((repo))
    What it does
      Generates fake retail data
      Creates 99 business queries
      Simulates TPC-DS benchmark
    Tech stack
      C source code
      SQL queries
      StarRocks database
    Use cases
      Stress-test databases
      Measure query response times
      Validate analytics platforms
    Audience
      Database engineers
      Performance testers
    Setup
      Compile on Linux or macOS
      Generates data at massive scale

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

what do people make with this?

VIBE 1

Generate a simulated 10-terabyte retail dataset to stress-test your database.

VIBE 2

Run 99 standardized business queries against your data to measure response times.

VIBE 3

Benchmark an analytics platform to prove it can handle heavy real-world workloads.

what's the stack?

CSQLStarRocks

how it stacks up fr

starrocks/tpcds-kitabrown/aomadroxz1122/injected-host-enumeration
Stars111
LanguageCCC
Last pushed2025-01-022020-03-11
MaintenanceStaleDormant
Setup difficultyhardhardmoderate
Complexity4/55/53/5
Audienceops devopsdeveloperdeveloper

Figures from each repo's GitHub metadata at analysis time.

how do i run it?

Difficulty · hard time til it works · 1h+

Requires compiling C source code on Linux or macOS, and generating data at massive scale can require significant disk space and processing time.

This is a modified fork of the open-source TPC-DS benchmark toolkit, the license terms of the original toolkit apply.

in plain english

The tpcds-kit is a toolkit for generating large sets of fake retail sales data and the complex questions (queries) you would ask about that data. It is based on an industry standard benchmark called TPC-DS, which simulates a realistic retail business with sales, customers, stores, and websites. The project lets teams create test data at a massive scale, for example, 10 terabytes, and then generate 99 different business questions to run against that data to see how fast their system can answer them. This particular fork of the toolkit was adapted specifically for StarRocks, a database system. The original benchmark tools generate queries using standard SQL, but every database has its own quirks and preferred syntax. The project's creators modified the query templates so they work correctly with StarRocks, fixing things like date calculations and adding required naming aliases. The tools themselves are written in C and need to be compiled on your machine, with the README providing instructions for Linux and macOS. Database engineers and performance testers are the main users of this project. If a company is building an analytics platform and wants to prove it can handle heavy workloads, they would use this toolkit to generate a simulated 10-terabyte retail dataset, load it into their database, and then run the 99 generated queries to measure response times. It provides a standardized way to answer the question: "Can our database handle real-world scale?" The project itself is a modified version of an open-source benchmarking kit, with specific adjustments to make the generated SQL compatible with StarRocks' dialect. Beyond the StarRocks-specific changes, the fork also includes fixes from other community contributors that make the toolkit compile on macOS and correct bugs in some of the original query templates.

prompts (copy fr)

prompt 1
Compile the tpcds-kit on macOS using the instructions in the README, then generate a 1GB scale factor dataset and load it into StarRocks to verify the toolkit works.
prompt 2
Generate the 99 TPC-DS benchmark queries using this kit and run them against my StarRocks database to measure query response times. Which queries are the slowest?
prompt 3
Scale up the tpcds-kit to generate a 10-terabyte retail dataset, then load the output files into StarRocks tables so I can run a full performance benchmark.

Frequently asked questions

what is tpcds-kit fr?

A toolkit for generating massive fake retail datasets and 99 standard business queries to benchmark database performance. This version is tweaked specifically for the StarRocks database.

What language is tpcds-kit written in?

Mainly C. The stack also includes C, SQL, StarRocks.

Is tpcds-kit actively maintained?

Stale — no commits in 1-2 years (last push 2025-01-02).

What license does tpcds-kit use?

This is a modified fork of the open-source TPC-DS benchmark toolkit, the license terms of the original toolkit apply.

How hard is tpcds-kit to set up?

Setup difficulty is rated hard, with roughly 1h+ to a first successful run.

Who is tpcds-kit for?

Mainly ops devops.

peek the repo → explain another one

This repo across BitVibe Labs

double-check against the repo, no cap.