解决hive报错FAILED: SemanticException Cartesian products are disabled for safety的问题

1.先看问题：
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.
2解决办法：

set hive.strict.checks.cartesian.product; 
# 首先查看hive.strict.checks.cartesian.product
set hive.strict.checks.cartesian.product=false;  
# 设置hive.strict.checks.cartesian.product为false 

完成上述步骤即可。