SELECT
    any(device) AS device,
    any(line_item_id) AS line_item_id,
    any(tactic) AS tactic,
    any(target) AS target,
    any(line_item_name) AS line_item_name,
    any(line_item_name_2) AS line_item_name_2,
    any(outside_target_dma) AS outside_target_dma,
    any(creative) AS creative,
    date AS date,
    any(inside_target_dma) AS inside_target_dma,
    toFloat64(sum(impression * __sign)) AS impression,
    any(channel) AS channel,
    __account_id AS account_id
FROM impressions_4930
GROUP BY
    date,
    __account_id,
    __row_hash,
    __row_id
HAVING sum(__sign) > 0

Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for query) exceeded: would use 46.57 GiB (attempt to allocate chunk of 4216924 bytes), maximum: 46.57 GiB: While executing AggregatingTransform.