Size: a a a
YV
WA
RN
ZM
watch -n1 'clickhouse-client -h localhost --password xxx -m --format PrettyNoEscapes --query "SELECT elapsed, formatReadableSize(memory_usage) as mem, initial_user, formatReadableSize(read_bytes) as bytes, substring(query, 1, 50) FROM system.processes"'
RN
watch -n1 'clickhouse-client -h localhost --password xxx -m --format PrettyNoEscapes --query "SELECT elapsed, formatReadableSize(memory_usage) as mem, initial_user, formatReadableSize(read_bytes) as bytes, substring(query, 1, 50) FROM system.processes"'
ПШ
DB::Exception: Unsupported type FixedString(16).DB::Exception: Unsupported type FixedString(16).DO
PV
AN
C
DC
DO
DC
DC
ENGINE = MergeTree(EventDate, (View, Click, Get, EventDate), 8192)? или какие есть другие варианты, очень желательно что бы без простоя?
ENGINE = AggregatingMergeTree(EventDate, (EventDate, AdvertiserId, CampaignId, TeaserId, AdTypeId, hour), 8192) AS
ENGINE = AggregatingMergeTree(EventDate, (EventDate, WebmasterId, SiteId, BlockId, AdTypeId), 8192) AS
ENGINE = MergeTree(EventDate, (uuid, EventDate), 8192)
ENGINE = AggregatingMergeTree(EventDate, (EventDate, AdvertiserId, CampaignId, TeaserId, AdTypeId, hour), 8192)
ENGINE = AggregatingMergeTree(EventDate, (EventDate, WebmasterId, SiteId, BlockId, AdTypeId), 8192)
АА
DC
АА
АА
АА
A
$ sudo apt-get update
$ sudo apt-get install clickhouse-client clickhouse-server
$ sudo service clickhouse-server restart
DETACH TABLE db.table_name
mv data new_data
create table
mv new_data data
ATTACH TABLE db.table_name
