Skip to content

Instantly share code, notes, and snippets.

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