Clickhouse執行報錯（Double-distributed IN/JOIN subqueries is denied (distributed_product_mode = ‘deny‘)）

在執行SQL語句時報如下錯誤：

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))      

主要就是不支援分布式子查詢而報錯。

解決方案：