ClickHouse / ClickHouse/pg_stat_ch

Schema file for ClickHouse not available

Open Beginner friendly
#125 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Perl
Stars
123
Forks
5
Avg merge
56m
Merged PRs (30d)
3

Description

On page https://github.com/ClickHouse/pg_stat_ch/blob/main/docs/guides/clickhouse.md we provide a schema to apply to ClickHouse to use the pg_stat_ch extension:

For production, apply the schema directly to your ClickHouse instance:

clickhouse-client < docker/init/00-schema.sql
The schema file ([docker/init/00-schema.sql](https://github.com/ClickHouse/pg_stat_ch/blob/main/docker/init/00-schema.sql)) is the single source of truth. It creates:

The pg_stat_ch database
The events_raw table with all columns
Four materialized views for common analytics

However the schema file cannot be found, it returns 404.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with docs/guides/clickhouse.md and verify the linked docker/init/00-schema.sql path in the repository. Check whether the schema file is missing or the documentation link is wrong, then confirm that the documented clickhouse-client command points to an available schema file.

Written by the indexing model from the issue text.

Assessment

Tech stack
clickhouse, postgresql
Domain
databases, documentation
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
75/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.