clickhouse のバージョンアップを行ったのでここにメモしておきます。
環境
旧環境
$ clickhouse-client ClickHouse client version 18.16.1. Connecting to localhost:9000. Connected to ClickHouse server version 18.16.1 revision 54412.
新環境
$ clickhouse-client ClickHouse client version 22.3.3.44 (official build). Connecting to localhost:9000 as user default. Connected to ClickHouse server version 22.3.3 revision 54455.
作業
インストール
以下のコマンドでインストールを行います。
$ sudo apt-get install -y apt-transport-https ca-certificates dirmngr
$ sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 8919F6BD2B48D754
$ echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee \
/etc/apt/sources.list.d/clickhouse.list
$ sudo apt-get update
$ sudo apt-get install -y clickhouse-server clickhouse-client
$ sudo service clickhouse-server start
$ clickhouse-client # or "clickhouse-client --password" if you've set up a password.
接続確認
password incorrect エラー
ClickHouse client version 22.3.3.44 (official build). Connecting to localhost:9000 as user default. If you have installed ClickHouse and forgot password you can reset it in the configuration file. The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml and deleting this file will reset the password. See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed. Code: 516. DB::Exception: Received from localhost:9000. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name. (AUTHENTICATION_FAILED)
default-password.xml を移動させて暫定対応
$ sudo mv /etc/clickhouse-server/users.d/default-password.xml /etc/clickhouse-server/users.d/default-password.xml.org
