hive 报错：FAILED: SemanticException Cartesian products are disabled for safety reasons.

FAILED: SemanticException Cartesian products are disabled for safety reasons. If you know what you are doing, please sethive.strict.checks.cartesian.product to false and that hive.mapred.mode is not set to 'strict' to proceed. Note that if you may get errors or incorrect results if you make a mistake while using some of the unsafe features.

遇到错误信息 "FAILED: SemanticException Cartesian products are disabled for safety reasons..." 时，意味着Hive默认禁用了笛卡尔积（Cartesian products），以防止大数据集之间的非全等连接（如非inner join）导致数据量急剧膨胀，从而影响大数据集群的稳定性。如果您确定需要执行这样的操作，可以通过设置Hive的配置参数来允许笛卡尔积操作。

以下是解决这个问题的步骤：

1. 设置hive.strict.checks.cartesian.product为false：

   SET hive.strict.checks.cartesian.product = false;

   这个设置允许笛卡尔积操作，但请注意，这可能会带来数据量急剧增加的风险，导致性能问题或错误结果。