Clickhouse执行报错(Double-distributed IN/JOIN subqueries is denied (distributed_product_mode = ‘deny‘))

2022/9/7 23:23:06

本文主要是介绍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';



这篇关于Clickhouse执行报错(Double-distributed IN/JOIN subqueries is denied (distributed_product_mode = ‘deny‘))的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!


扫一扫关注最新编程教程