Skip to content

Instantly share code, notes, and snippets.

@mackjoner
Created December 20, 2019 14:44
Show Gist options
  • Save mackjoner/cf2a88a973649bef84443540ee9a6cc4 to your computer and use it in GitHub Desktop.
Save mackjoner/cf2a88a973649bef84443540ee9a6cc4 to your computer and use it in GitHub Desktop.
recover-monitor
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adn_monitor.adn_stat TO adn_monitor.adn_stat_old_rp"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adn_monitor.adn_stat_tk TO adn_monitor.adn_stat_tk_old_rp"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adx_monitor.adx_stat TO adx_monitor.adx_stat_old_rp"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adx_monitor.adx_stat_tk TO adx_monitor.adx_stat_tk_old_rp"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adn_monitor.adn_stat_old TO adn_monitor.adn_stat"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adn_monitor.adn_stat_tk_old TO adn_monitor.adn_stat_tk"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adx_monitor.adx_stat_old TO adx_monitor.adx_stat"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adx_monitor.adx_stat_tk_old_rp TO adx_monitor.adx_stat_tk"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment