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

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

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

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