ClickHouse / ClickHouse/pg_stat_ch
Schema file for ClickHouse not available
- 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