How do I Install ClickHouse on Windows 10?

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

How to install and test ClickHouse on Microsoft Windows

When ClickHouse installing on Windows 10 you may receive errors when inserting data, for example:

On Windows 10, WSL needs to be upgraded to WSL 2.

• Open Powershell by right-clicking on the PowerShell icon and selecting "run as administrator".

• Follow the instructions from Microsoft to upgrade to WSL 2, here: https://learn.microsoft.com/en-us/windows/wsl/install

• Once it is upgraded, open WSL from PowerShell.

• For testing follow these instructions, you should have similar output: Since this is for testing, I logged in as root to avoid permissions issues:

• Create a ClickHouse directory:

• From the new directory, download clickhouse:

• Start the clickhouse server:

• In another WSL window, start the client:

• Create the database and table:

• Insert sample rows:

• View the rows:

Apr 24, 2023 · 3 min read