Select op.offer_id from dict_offer_pack AS `pdop` join dict_offer_pack AS `dop`

Question

Select op.offer_id from dict_offer_pack AS `pdop` join dict_offer_pack AS `dop`

on
dop.tree = pdop.tree
and dop.lft >= pdop.lft
and dop.rgt <= pdop.rgt
join offer_pack op on
op.pack_id = dop.id
where
pdop.id IN ('519', '521', '523', '789', '905', '1233', '1359', '1367', '1427', '1351') Всем привет. Запрос вылетает с ошибкой: Unsupported JOIN ON conditions. Unexpected '(dop.lft AS --dop.lft) >= (lft AS --pdop.lft)' Кликхаус не умеет в такие условия join?

#backend #clickhouse #database #devops #programming #russian

0

20.06.2022

2 ответов

31 просмотр

Алексей Горячев Автор вопроса

Владислав Lazycat
NOTE If a condition refers columns from different ...

Спасибо

0

20.06.2022

Владислав Lazycat · Accepted Answer

Владислав Lazycat

NOTE If a condition refers columns from different tables, then only the equality operator (=) is supported so far. https://clickhouse.com/docs/en/sql-reference/statements/select/join/

0

20.06.2022

184 похожих чатов

Select op.offer_id from dict_offer_pack AS `pdop` join dict_offer_pack AS `dop`

2 ответов

Похожие вопросы