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

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!