错误示例:
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';
标签:product,subqueries,distributed,报错,mode,denied From: https://www.cnblogs.com/-courage/p/16665611.html