Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive error :Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level

Highlighted

Hive error :Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level

New Contributor

Hive version - 1.1..2

Hadoop Version - 2.7.2

I get the above given error when I try deleting and creating tables. Hive is not allowing to create or delete tables. Kindly help

1 REPLY 1

Re: Hive error :Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level

Hi @Basil Paul
Could you share your hive configs (that one related to DB)?
And this tool may help you :)
https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool
I saw some people having the same issue, and their solution was to initialize their Metastore using this tool.

Hope this helps!

Don't have an account?
Coming from Hortonworks? Activate your account here