mackjoner

docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "DROP TABLE IF EXISTS adn_monitor.adn_stat_old_rp"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "DROP TABLE IF EXISTS adn_monitor.adn_stat_tk_old_rp"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "DROP TABLE IF EXISTS adx_monitor.adx_stat_old_rp"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "DROP TABLE IF EXISTS adx_monitor.adx_stat_tk_old_rp"

mackjoner

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 adx_monitor.adx_stat_tk_old TO adx_monitor.adx_stat_tk"

mackjoner

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/bi

mackjoner

docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat_tk ATTACH PARTITION 20191110 FROM adn_monitor.adn_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat_tk ATTACH PARTITION 20191111 FROM adn_monitor.adn_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat_tk ATTACH PARTITION 20191112 FROM adn_monitor.adn_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat_tk ATTACH PARTITION 20191113 FROM adn_monitor.adn_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat_tk ATTACH PARTITION 20191114 FROM adn_monitor.adn_stat_tk_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat_tk ATTACH PARTITION 20191115 FROM adn_monitor.adn_stat_tk_old"
docker exec moni

mackjoner

docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat ATTACH PARTITION 20191110 FROM adn_monitor.adn_stat_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat ATTACH PARTITION 20191111 FROM adn_monitor.adn_stat_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat ATTACH PARTITION 20191112 FROM adn_monitor.adn_stat_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat ATTACH PARTITION 20191113 FROM adn_monitor.adn_stat_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat ATTACH PARTITION 20191114 FROM adn_monitor.adn_stat_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "ALTER TABLE adn_monitor.adn_stat ATTACH PARTITION 20191115 FROM adn_monitor.adn_stat_old"
docker exec monitor-clickhouse-server-v4 /usr/bin/cl

mackjoner

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 moni

mackjoner

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/cl

mackjoner

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/cl

mackjoner

docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adn_monitor.adn_stat TO adn_monitor.adn_stat_old"

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"

docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "RENAME TABLE adx_monitor.adx_stat TO adx_monitor.adx_stat_old"

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"

docker exec monitor-clickhouse-server-v4 /usr/bin/clickhouse-client -q "CREATE TABLE IF NOT EXISTS adn_monitor.adn_stat (yyyymmdd Int32, hh Int8, mm Int8, timestamp DateTime, publisherId Int64, appId Int64, unitId Int64, sdkVersion String, scenario String, algorithm String, adType String, countryCode String, requestType Int8, platform String, advertiserId Int64, campaignId Int64, advUserId Int64, advOfferId Int64, thirdParty String, creativeId Int64, advCreativeId

mackjoner

{    
    // go configure
    // "go.toolsEnvVars": {
    //     "GO111MODULE": "on"
    // },
    "go.lintTool": "golangci-lint",
    // "go.lintFlags": [
    //     "--fast",
    //     "-D", "errcheck",
    //     "-E", "golint",