[GH-ISSUE #207] Import the SQL file into ClickHouse failed #124

Open
opened 2026-10-26 09:45:35 +00:00 by bsakaguchi · 1 comment
Owner

Originally created by @Hansyangxingxiang on GitHub (Mar 25, 2025).
Original GitHub issue: https://github.com/deepseek-ai/3FS/issues/207

ClickHouse version:
apt list --installed | grep clickhouse

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

clickhouse-client/now 18.16.1+ds-7ubuntu0.1 amd64 [installed,local]
clickhouse-common/now 18.16.1+ds-7ubuntu0.1 amd64 [installed,local]
clickhouse-server/now 18.16.1+ds-7ubuntu0.1 amd64 [installed,local]

OS version:
cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04.1 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.1 LTS"
VERSION_ID="20.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=focal
UBUNTU_CODENAME=focal

Import the SQL file into ClickHouse failed:
clickhouse-client -n < /3fs/3fs-monitor.sql
Code: 62. DB::Exception: Syntax error: failed at position 31 (line 1, col 31): 3fs;

CREATE TABLE IF NOT EXISTS 3fs.counters (
TIMESTAMP DateTime CODEC(DoubleDelta),
metricName LowCardinality(String) CODEC(ZSTD(1)),
host LowCar. Wrong number

Are there specific version requirements for ClickHouse?

Originally created by @Hansyangxingxiang on GitHub (Mar 25, 2025). Original GitHub issue: https://github.com/deepseek-ai/3FS/issues/207 ClickHouse version: apt list --installed | grep clickhouse WARNING: apt does not have a stable CLI interface. Use with caution in scripts. clickhouse-client/now 18.16.1+ds-7ubuntu0.1 amd64 [installed,local] clickhouse-common/now 18.16.1+ds-7ubuntu0.1 amd64 [installed,local] clickhouse-server/now 18.16.1+ds-7ubuntu0.1 amd64 [installed,local] OS version: cat /etc/os-release NAME="Ubuntu" VERSION="20.04.1 LTS (Focal Fossa)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 20.04.1 LTS" VERSION_ID="20.04" HOME_URL="https://www.ubuntu.com/" SUPPORT_URL="https://help.ubuntu.com/" BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/" PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy" VERSION_CODENAME=focal UBUNTU_CODENAME=focal Import the SQL file into ClickHouse failed: clickhouse-client -n < /3fs/3fs-monitor.sql Code: 62. DB::Exception: Syntax error: failed at position 31 (line 1, col 31): 3fs; CREATE TABLE IF NOT EXISTS 3fs.counters ( `TIMESTAMP` DateTime CODEC(DoubleDelta), `metricName` LowCardinality(String) CODEC(ZSTD(1)), `host` LowCar. Wrong number Are there specific version requirements for ClickHouse?
Author
Owner

@iamazy commented on GitHub (Mar 25, 2025):

my clickhouse version is 23.3.13.6 and works well

<!-- gh-comment-id:2750747308 --> @iamazy commented on GitHub (Mar 25, 2025): my clickhouse version is 23.3.13.6 and works well
Sign in to join this conversation.
No labels
pull-request
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
deepseek-ai/3FS#124
No description provided.