Hello,

from time to time I am running into a strange problem.

When I issue a command in the hive shell I get the error

hive> show databases;
FAILED: Error in metadata: MetaException(message:Got exception: org.apache.hadoop.hive.metastore.api.MetaException javax.jdo.JDOUserException: Object with id "" is managed by a different Object Manager
NestedThrowables:
org.datanucleus.exceptions.NucleusUserException: Object with id "" is managed by a different Object Manager)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

I do not know what user this message is refering to.

I started the hive shell as a different user but got the same result.

The only way to get rid of this error is to retart the complete cloudera cluster.

Is there any other way to get rid of this error or - even better - prevent it?

I must add that I am accessing the databas ewith both hive and impala - could that be a problem?