ClickHouse Catalog

Add a ClickHouse catalog to the cluster along with ClickHouse backend.

The module provisions a ClickHouse server with some preloaded data. The preloaded tables are stored in the minitrino ClickHouse database, which is exposed as the clickhouse.minitrino schema in the cluster’s clickhouse catalog.

Loading Data

Data is loaded via a shell script mounted to the ClickHouse container’s docker-entrypoint-initdb.d/ directory. The init script can be edited in the library to load different tables and/or additional data:

lib/modules/catalog/clickhouse/resources/clickhouse/init.sh

Usage

Module Uses Persistent Storage

This module uses named volumes to persist data. To delete these volumes, run:

minitrino remove --volumes --module ${module}

Provision the module:

minitrino provision -m clickhouse

Connect to the coordinator container’s Trino CLI:

minitrino exec -i 'trino-cli'

Confirm the tables are loaded:

SHOW TABLES IN clickhouse.minitrino;