Skip to content

Instantly share code, notes, and snippets.

@donghaic

donghaic/clickhouse-err.txt

Last active July 13, 2020 04:01
Show Gist options
  • Save donghaic/a838ebf361ebcbfb4001d6532708d274 to your computer and use it in GitHub Desktop.
Save donghaic/a838ebf361ebcbfb4001d6532708d274 to your computer and use it in GitHub Desktop.
Download ZIP
clickhouse query err
Raw
clickhouse-err.txt
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for query) exceeded: would use 9.32 GiB (attempt to allocate chunk of 4320768 bytes), maximum: 9.31 GiB: (while reading column total_video_click): (while reading from part /data/clickhouse-db/data/data/ssp/app_report_raw_local_v2/20200712_82666_83775_5/ from mark 12079 with max_rows_to_read = 8192)
set config for the query works
set max_bytes_before_external_group_by=10000000000;
set max_memory_usage=20000000000;
set distributed_aggregation_memory_efficient=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment