Skip to content

Instantly share code, notes, and snippets.

@mackjoner
Created December 20, 2019 11:34
Show Gist options
  • Save mackjoner/4fe55c44a6fca30b832ef366f756af55 to your computer and use it in GitHub Desktop.
Save mackjoner/4fe55c44a6fca30b832ef366f756af55 to your computer and use it in GitHub Desktop.
adx-stat-tk
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191110 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191111 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191112 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191113 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191114 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191115 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191116 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191117 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191118 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191119 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191120 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191121 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191122 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191123 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191124 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191125 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191126 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191127 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191128 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191129 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191130 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191201 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191202 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191203 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191204 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191205 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191206 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191207 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191208 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191209 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191210 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191211 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191212 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191213 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191214 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191215 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191216 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191217 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191218 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191219 FROM adx_monitor.adx_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adx_monitor.adx_stat_tk ATTACH PARTITION 20191220 FROM adx_monitor.adx_stat_tk_old"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment