Archive

### 2023[​](#2023 "Direct link to 2023")

- [January 14 - Comparing metrics between queries in decibels](/docs/knowledgebase/comparing-metrics-between-queries)- [March 1 - Capturing server logs of queries at the client](/docs/knowledgebase/send_logs_level)- [March 1 - How to Ignore Incorrect Settings in ClickHouse](/docs/knowledgebase/ignoring-incorrect-settings)- [March 1 - How to Increase the Number of Threads in ClickHouse](/docs/knowledgebase/how-to-increase-thread-pool-size)- [March 1 - Using Filtered Aggregates in ClickHouse](/docs/knowledgebase/filtered-aggregates)- [March 1 - Execute SYSTEM Statements on All Nodes in ClickHouse Cloud](/docs/knowledgebase/execute-system-queries-in-cloud)- [March 1 - How to Configure Settings for a User in ClickHouse](/docs/knowledgebase/configure-a-user-setting)- [March 1 - Synchronous data reading](/docs/knowledgebase/async_vs_optimize_read_in_order)- [March 1 - Are Materialized Views inserted synchronously?](/docs/knowledgebase/are_materialized_views_inserted_asynchronously)- [March 14 - Let's calculate pi using SQL](/docs/knowledgebase/calculate-pi-using-sql)- [March 17 - Useful queries for troubleshooting](/docs/knowledgebase/useful-queries-for-troubleshooting)- [March 20 - How to import JSON into ClickHouse?](/docs/knowledgebase/json-import)- [March 20 - Resolving "Too Many Parts" Error in ClickHouse](/docs/knowledgebase/exception-too-many-parts)- [March 20 - Resolving Timeout Errors with `remote` and `remoteSecure` Table Functions](/docs/knowledgebase/connection_timeout_remote_remoteSecure)- [March 21 - How do I export MySQL Data to Parquet, CSV, or JSON Using ClickHouse](/docs/knowledgebase/mysql-to-parquet-csv-json)- [March 22 - How do I export PostgreSQL data to Parquet, CSV or JSON?](/docs/knowledgebase/postgresql-to-parquet-csv-json)- [March 22 - How do I convert Files from Parquet to CSV or JSON?](/docs/knowledgebase/parquet-to-csv-json)- [March 22 - How to ingest Parquet files from an S3 bucket](/docs/knowledgebase/ingest-parquet-files-in-s3)- [March 22 - How to Export Data from ClickHouse to a File](/docs/knowledgebase/file-export)- [March 24 - How to check what code is currently running on a server?](/docs/knowledgebase/which-processes-are-currently-running)- [March 24 - How can I do partitioned writes by year and month on S3?](/docs/knowledgebase/s3_export_data_year_month_folders)- [March 24 - How to quickly recreate a small table across different terminals](/docs/knowledgebase/recreate_table_across_terminals)- [March 24 - Importing and Querying JSON Array Objects in ClickHouse](/docs/knowledgebase/importing_and_working_with_JSON_array_objects)- [March 24 - How to Identify Queries Using Materialized Views in ClickHouse](/docs/knowledgebase/how_to_display_queries_using_MV)- [March 25 - Resolving "Cannot Append Data in Parquet Format" Error in ClickHouse](/docs/knowledgebase/cannot-append-data-to-parquet-format)- [March 26 - How to Identify the Most Expensive Queries in ClickHouse](/docs/knowledgebase/find-expensive-queries)- [April 24 - How do I Install ClickHouse on Windows 10?](/docs/knowledgebase/install-clickhouse-windows10)- [May 2 - When are TTL rules applied, and do we have control over it?](/docs/knowledgebase/when_is_ttl_applied)- [May 2 - DB::Exception: Part XXXXX intersects previous part YYYYY. It is a bug or a result of manual intervention in the ZooKeeper data.](/docs/knowledgebase/part_intersects_previous_part)- [May 2 - Resolving SSL Certificate Verify Error in ClickHouse](/docs/knowledgebase/certificate_verify_failed_error)- [May 4 - How to Validate if Two Queries Return the Same Result-sets](/docs/knowledgebase/compare_resultsets)- [May 8 - A Python client working example for connecting to ClickHouse Cloud Service](/docs/knowledgebase/python-clickhouse-connect-example)- [May 10 - Using ClickHouse for Log Analytics](/docs/knowledgebase/use-clickhouse-for-log-analytics)- [May 18 - How to calculate the ratio of empty/zero values in every column in a table](/docs/knowledgebase/calculate_ratio_of_zero_sparse_serialization)- [June 7 - Why is ClickHouse Keeper recommended over ZooKeeper?](/docs/knowledgebase/why_recommend_clickhouse_keeper_over_zookeeper)- [June 7 - How do I view the number of active or queued mutations?](/docs/knowledgebase/view_number_of_active_mutations)- [June 7 - Schema migration tools for ClickHouse](/docs/knowledgebase/schema_migration_tools)- [June 7 - Identifying Expensive Queries by Memory Usage in ClickHouse](/docs/knowledgebase/finding_expensive_queries_by_memory_usage)- [June 7 - Configuring CAP\_IPC\_LOCK and CAP\_SYS\_NICE Capabilities in Docker](/docs/knowledgebase/configure_cap_ipc_lock_and_cap_sys_nice_in_docker)- [June 7 - Managing ClickHouse Cloud Service with API and cURL](/docs/knowledgebase/clickhouse_cloud_api_usage)- [June 7 - How to Measure Query Processing Time Without Returning Rows](/docs/knowledgebase/check_query_processing_time_only)- [June 7 - How to Verify Query Cache Usage in ClickHouse](/docs/knowledgebase/check-query-cache-in-use)- [June 26 - Differences Between Official and 3rd-Party ClickHouse Builds](/docs/knowledgebase/difference_between_official_builds_and_3rd_party)- [July 10 - How to Create a ClickHouse Dictionary with String Keys and Values](/docs/knowledgebase/dictionary_using_strings)- [July 21 - How do I solve TOO MANY PARTS error during an INSERT...SELECT?](/docs/knowledgebase/Insert_select_settings_tuning)- [August 1 - How to Use Parameterized Views in ClickHouse](/docs/knowledgebase/how_to_use_parametrised_views)- [August 13 - Does ClickHouse support row-level and column-level security?](/docs/knowledgebase/row-column-policy)- [August 26 - Alter User Settings Exception](/docs/knowledgebase/alter-user-settings-exception)- [September 7 - How to Check Users Assigned to Roles and Vice Versa](/docs/knowledgebase/check_users_roles)- [September 8 - How do I change my Billing Contact in ClickHouse Cloud?](/docs/knowledgebase/change-billing-email)- [September 28 - Common RBAC queries](/docs/knowledgebase/common-rbac-queries)- [October 25 - About Quotas and Query complexity](/docs/knowledgebase/about-quotas-and-query-complexity)- [October 26 - Can you use ClickHouse for vector search?](/docs/knowledgebase/vector-search)- [November 16 - How to Check Your ClickHouse Cloud Service State](/docs/knowledgebase/how-to-check-my-clickhouse-cloud-sevice-state)- [November 16 - Change the prompt in clickhouse-client](/docs/knowledgebase/change-the-prompt-in-clickhouse-client)- [November 22 - How do I use NodeJS with @clickhouse/client](/docs/knowledgebase/node-js-example)

### 2022[​](#2022 "Direct link to 2022")

- [April 22 - What if I have a problem with encodings when using Oracle via ODBC?](/docs/knowledgebase/oracle-odbc)- [April 22 - Does ClickHouse support multi-region replication?](/docs/knowledgebase/multi-region-replication)- [July 10 - Setting a limit on query execution time](/docs/knowledgebase/query_max_execution_time)- [July 10 - Python quick example using HTTP requests module](/docs/knowledgebase/python_http_requests)- [July 10 - How to confirm if a Projection is used by the query?](/docs/knowledgebase/projection_example)- [October 19 - Is it possible to delete old records from a ClickHouse table?](/docs/knowledgebase/delete-old-data)- [October 30 - Improving Map Lookup Performance in ClickHouse](/docs/knowledgebase/improve-map-performance)- [November 17 - How do I resolve Ingest Failures After ClickHouse 23.9 Release?](/docs/knowledgebase/ingest-failures-23-9-release)

### 2021[​](#2021 "Direct link to 2021")