forked from h2oai/db-benchmark
-
Notifications
You must be signed in to change notification settings - Fork 0
/
setup-clickhouse.sh
31 lines (22 loc) · 1.32 KB
/
setup-clickhouse.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
# install
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4
echo "deb https://repo.yandex.ru/clickhouse/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
# start server
sudo rm /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.log
sudo service clickhouse-server start
# stop server
#sudo service clickhouse-server stop
# let file table function access csv
grep '<user_files_path>/var/lib/clickhouse/user_files/</user_files_path>' /etc/clickhouse-server/config.xml
sudo sed -i -e "s|<user_files_path>/var/lib/clickhouse/user_files/</user_files_path>|<user_files_path>/home/jan/git/db-benchmark/</user_files_path>|" /etc/clickhouse-server/config.xml
grep 'user_files_path' /etc/clickhouse-server/config.xml
# server start/stop without sudo: use visudo to edit sudoers
#sudo cp /etc/sudoers etc_sudoers.bak
#sudo EDITOR=vim visudo
# add two lines for your user at the end of section: Members of the admin group may gain root privileges
#user ALL=NOPASSWD: /usr/sbin/service clickhouse-server start
#user ALL=NOPASSWD: /usr/sbin/service clickhouse-server stop
# interactive debugging
# copy exec.sh body and substitute $1 for groupby and $2 for G1_1e7_1e2_0_0, avoid exit calls