Skip to content
Kitbay
Skill

create-test-datasets

Apache-2.0Updated on Nov 11, 202650,877GitHub stars

A contributor skill in the ClickHouse repository that loads the standard test datasets used in its tests: hits and visits by default, plus TPC-DS and TPC-H on request.

What the skill teaches

A contributor skill in the ClickHouse repository that loads the standard test datasets used in its tests: hits and visits by default, plus TPC-DS and TPC-H on request. The agent first checks that a ClickHouse server answers a simple query and stops, without starting one, if it does not. It then checks for existing tables and stops on any conflict, telling the user to drop them by hand, because it never drops or overwrites tables. Hits and visits are created from the matching statements in the repository's test SQL file, and the TPC sets from its shell scripts. It finishes by reporting row counts for each dataset.

Capabilities

  • Check that a ClickHouse server is running
  • Create hits, visits, TPC-DS and TPC-H test tables
  • Stop on conflicts without dropping tables
  • Report row counts