Skip to content

Instantly share code, notes, and snippets.

@MikeRzhevsky
Created March 6, 2022 09:24
Show Gist options
  • Save MikeRzhevsky/33ed1beddf365975c9540e050b0d49a4 to your computer and use it in GitHub Desktop.
Save MikeRzhevsky/33ed1beddf365975c9540e050b0d49a4 to your computer and use it in GitHub Desktop.
#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
@MikeRzhevsky
Copy link
Author

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ущественныхтоваров")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment