ClickHouse: clickhouse-local doesn't work under ubuntu wsl

I’ve been using the guide from here: https://clickhouse.com/docs/en/integrations/migration/clickhouse-local/ to install clickhouse-local (also mentioned here: https://clickhouse.com/blog/extracting-converting-querying-local-files-with-sql-clickhouse-local)

Running: curl https://clickhouse.com/ | sh

downloads a clickhouse binary file (shouldn’t it be clickhouse-local?)

but then if I try to do: xxx@DESKTOP-VNB3DU9:~$ ./clickhouse-local -bash: ./clickhouse-local: No such file or directory

and for install i get: sudo ./clickhouse install No target executable - decompression only was performed.

Environment: Ubuntu WSL 1 under Windows 11

About this issue

Original URL
State: closed
Created a year ago
Comments: 22 (13 by maintainers)

Most upvoted comments

The problem is due to inconsistency in WSL1 - inode reported by stat is 64bit number, while inode in /proc/self/maps is 32bit number and seems to be just a conversion with lost precision. Solution will be provided soon.

yakov-olkhovskiy on Jan 16, 2023

BTW which WSL? wsl or wsl2 ?

den-crane on Jan 16, 2023

seems completely normal… frankly, I have no idea what’s going on here… we wanted do make decompression seamless so we have no any printout unless some error occurs, and apparently it bites us back… let’s do next - I will add extensive diagnostic to decompressor enabled by some env flag, and then we probably will be able to find what’s going on…

yakov-olkhovskiy on Jan 16, 2023