Created
March 6, 2022 09:32
-
-
Save MikeRzhevsky/19605c163843e619da5d49b6c7a00d61 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #single node install config | |
| coordinator=true | |
| http-server.http.port=8080 | |
| #JVM -Xmx20g | |
| node-scheduler.include-coordinator=true | |
| #query.max-memory-per-node=5GB # jvm*0.25 #Invalid value | |
| #memory.heap-headroom-per-node=5GB #jvm*0.2 #Invalid value | |
| #query.max-total-memory-per-node=5GB # jvm*0.4 #can not be configured | |
| query.max-memory=32GB | |
| discovery.uri=http://localhost:8080 | |
| Ошибка | |
| SQL Error [131079]: Query failed (#20220306_092734_00000_6sdk9): Query exceeded per-node memory limit of 307.20MB [Allocated: 303.82MB, Delta: 9.61MB, Top Consumers: {HashAggregationOperator=238.87MB, LazyOutputBuffer=32.47MB, ExchangeOperator=32.47MB}] |
Author
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
select indi.customer_id
from clickhouse.cifra.ct_privilege_cards__calculated_indicators indi
WHERE NOT EXISTS
--EXCEPT
(SELECT dbt_statuses."покупатель"
from cifratest.dbt_stage."dm_stage_регистрсведений_статусыкартprivilege" as dbt_statuses
where indi.customer_id = dbt_statuses."покупатель"
and indi.redeem_percentage = dbt_statuses."процентвыкупа"
and indi.redeem_amount = dbt_statuses."суммавыкупа"
and indi.cancelled_orders_amount = dbt_statuses."суммаотказов"
and indi.ordered_basic_goods_qty = dbt_statuses."заказаноcущественныхтоваров")