Hive中 ParseException解决方案

以下是错误信息
Error: Error while compiling statement: 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. (state=42000,code=4000

在这里插入图片描述
输入上面的sql语句会出现以上错误

解决方案就是在命令行中分别输入
在这里插入图片描述
以上就是解决方案,欢迎指正 谢谢大家


版权声明:本文为lsssss_原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。