Created
March 6, 2022 09:24
-
-
Save MikeRzhevsky/33ed1beddf365975c9540e050b0d49a4 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=false | |
| query.max-memory=32GB | |
| discovery.uri=http://localhost:8080 | |
| Ошибка | |
| SQL Error [131072]: Query failed (#20220306_091843_00000_ipaur): Insufficient active worker nodes. Waited 5.00m for at least 1 workers, but only 0 workers are active |
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ущественныхтоваров")