FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(me

解决Hive Sentry配置错误：MetaException

最新推荐文章于 2023-07-12 23:17:49 发布

原创最新推荐文章于 2023-07-12 23:17:49 发布 · 346 阅读

0 ·

CC 4.0 BY-SA版权

hive 专栏收录该内容

7 篇文章

订阅专栏

当Sentry在无Kerberos环境下运行时，可能会出现Execution Error，返回代码1。解决办法是在测试模式下配置Sentry，通过设置sentry.hive.testing.mode属性并与Hadoop管理员确认配置。如果需要，可以在HiveServer2和Hive metastore的sentry-site.xml中添加此属性，并重启服务。

Cause
This error indicates an error in the configuration of the Cluster.

This would typically happen in a cluster that has Sentry enabled, but currently has Kerberos disabled.
Solution
If Sentry is used in an environment where Kerberos is disabled, Sentry needs to be configured in testing mode.

Once Sentry is configured in non-testing mode, it mandates Kerberos to be configured as well.

The property that controls the Sentry Testing mode is: sentry.hive.testing.mode - review this with your Hadoop Administrator.

https://kb.informatica.com/solution/23/pages/56/432006.aspx

If you don’t find the configuration by default you can use “Advanced Configuration Snippet” as follows

Also the document says “Add the following property to the HiveServer2 and Hive metastore’s sentry-site.xml”. So you can set your property in below locations and make sure to restart the services

CM -> Hive -> Configuration -> Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml
CM -> Sentry -> Configuration -> Sentry Service Advanced Configuration Snippet (Safety Valve) for sentry-site.xml