文章讲述了在Hive中执行多表自然连接查询时遇到的错误，原因是由于开启了严格的检查模式。解决方法是将`hive.strict.checks.cartesian.product`属性设置为`false`。
在Hive中进行多表自然连接查询时报如下错误：
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
原因为Hive中开启了严格模式，将其属性设置为false即可。
set hive.strict.checks.cartesian.product=false；
1962
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
