clickhouse双分布式子查询被拒绝: select * from chuz_ods.ods_mes_sfc_all where toDate(partition_date) = yesterda

最新推荐文章于 2024-05-30 18:12:07 发布

天有不测阳光

最新推荐文章于 2024-05-30 18:12:07 发布

阅读量722

点赞数 6

文章标签： clickhouse 分布式

本文链接：https://blog.youkuaiyun.com/Master_Yiran/article/details/135250245

版权

文章讨论了在ClickHouse中遇到的关于双分布子查询的限制，指出不支持直接使用IN/JOIN子查询。作者提供了使用GLOBAL关键字的解决方案，允许在子查询中执行全局查询以避免错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select * from chuz_ods.ods_mes_sfc_all 
where toDate(partition_date) = yesterday() 
or partition_date in 
(select partition_date from chuz_ods.ods_mes_sfc_all 
where toDate(modified_date_time) = yesterday());

但是clickhouse是不是不支持这样的子查询呀? 会报以下错误:
SQL 错误 [288] [07000]: Code: 288. DB::Exception: Double-distributed IN/JOIN subqueries is denied (distributed_product_mode = ‘deny’). You may rewrite query to use local tables in subqueries, or use GLOBAL keyword, or set distributed_product_mode to suitable value.: While processing chuz_ods.ods_mes_sfc_all: While processing partition_date IN (SELECT partition_date FROM chuz_ods.ods_mes_sfc_all WHERE toDate(modified_date_time) = yesterday()).

select * from chuz_ods.ods_mes_sfc_all 
where toDate(partition_date) = yesterday() 
or toDate(partition_date) GLOBAL in 
(select toDate(partition_date) 
from chuz_ods.ods_mes_sfc_all 
where toDate(modified_date_time) = yesterday());