куска? Например, так: SELECT sum(cityHash64(oc39)) FROM db.logs_local WHERE _part='20170205_20170205_301560_301572_1'
SELECT sum(cityHash64(oc39)) FROM db.logs_local WHERE _part = '20170205_20170205_301560_301572_1' Received exception from server: Code: 241. DB::Exception: Received from localhost:9000, 127.0.0.1. DB::Exception: Memory limit (for query) exceeded: would use 512.01 GiB (attempt to allocate chunk of 549755813888 bytes), maximum: 18.63 GiB: (while reading column oc39): (while reading from part /local/clickhouse//data/db/logs_local/20170205_20170205_301560_301572_1/ from mark 0 to 8).
Обсуждают сегодня