clickhouse-operator icon indicating copy to clipboard operation
clickhouse-operator copied to clipboard

Published 20 hours ago • verified publisher icon Altinity

Can not add dictionary external csv to /var/lib/clickhouse/user_files/ path

Open hueiyuan opened this issue 1 year ago • 1 comments

We want to mount csv file to /var/lib/clickhouse/user_files/ path for dictionary can source from local. But is result in clickhouse pod can not start successfully. Does have any suggestion?

And if we volume mount to another path will have Code: 481. DB::Exception: Received from localhost:9000. DB::Exception: File path /opt/clickhouse-dict/xxxx is not inside /var/lib/clickhouse/user_files/: While processing dictGet Error

hueiyuan avatar Mar 08 '24 08:03 hueiyuan

could you provide your current kind: ClickHouseInstallation manifest without sensitive data?

Slach avatar Mar 08 '24 16:03 Slach

@hueiyuan , the error message clearly says that you misconfugured the path.

Also note, that paths with persistent data should be inside /var/lib/clickhouse.

alex-zaitsev avatar Mar 27 '24 08:03 alex-zaitsev