Clickhouse执行报错(Double-distributed IN/JOIN subqueries is denied (distributed_product_mode = ‘deny‘))
错误示例:
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. (version 20.1.4.14 (official build))
主要就是不支持分布式子查询而报错。
解决方案:
1、将inner join 改成 global join
2、添加配置:set distributed_product_mode = 'global';
posted on 2022-09-07 15:23 RICH-ATONE 阅读(616) 评论(0) 编辑 收藏 举报