Knowledge Base

Learn how to install and test ClickHouse on Windows 10 using WSL 2. Includes setup, troubleshooting, and running a test environment.

Learn how to use the `query_log` table in ClickHouse to identify the most memory and CPU-intensive queries across distributed nodes.

Are you getting the error "Cannot append data in format Parquet to file" error in ClickHouse? Let's take a look at how to resolve it.

Learn how to query ClickHouse logs to identify all queries involving Materialized Views within a specified time range.

Learn how to import JSON array objects into ClickHouse and perform advanced queries using JSON functions and array operations.

Learn how to quickly recreate a small table and its data across different terminals using copy/paste for development environments.

Learn how to write partitioned data by year and month to an S3 bucket in ClickHouse, using a custom path structure for organizing the data.

ClickHouse provides introspection tools like `system.stack_trace` for inspecting what code is currently running on each server thread, helping with debugging and performance monitoring.

Learn various methods to export data from ClickHouse, including `INTO OUTFILE`, the File table engine, and command-line redirection.

Learn the basics of using the S3 table engine in ClickHouse to ingest and query Parquet files from an S3 bucket, including setup, access permissions, and data import examples.