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. Want to know more about what has changed? Check out the Community News blog.

Issue With Hive

Issue With Hive

Explorer

Hi All,

 

Could any body help ...

 

We are facing issues in hive.  lastday hive was very slow. And since we are   getting these errors.In CM there are no errors appearing 


Error: Error while compiling statement: FAILED: SemanticException Unable to determine if hdfs://lxxx.xx.com:8020/user/hive/warehouse/difaults.db/TX_CSC_FINANCIAL is read only: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.ipc.StandbyException): Operation category READ is not supported in state standby
at org.apache.hadoop.hdfs.server.namenode.ha.StandbyState.checkOperation(StandbyState.java:87)
at org.apache.hadoop.hdfs.server.namenode.NameNode$NameNodeHAContext.checkOperation(NameNode.java:1713)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkOperation(FSNamesystem.java:1321)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getFileInfo(FSNamesystem.java:3973)
at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getFileInfo(NameNodeRpcServer.java:812)
at org.apache.hadoop.hdfs.server.namenode.AuthorizationProviderProxyClientProtocol.getFileInfo(AuthorizationProviderProxyClientProtocol.java:502)
at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getFileInfo(ClientNamenodeProtocolServerSideTranslatorPB.java:815)
at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java)
at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:587)
at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:1026)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2013)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2009)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1642)
at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2007) (state=42000,code=40000)

5 REPLIES 5
Highlighted

Re: Issue With Hive

New Contributor

Hi,

 

We faceing the same issue. Were you able to solve this?

 

 

 

Re: Issue With Hive

Contributor
Is HDFS in a good shape? Looks like HDFS HA is on. Hive talks to the
standby NN instead of the active one.

Re: Issue With Hive

Explorer

Yes  the Name node was on standby we fixed it.

 

Thanks 

Re: Issue With Hive

Explorer

yes we solved it .Check your name node state Active or Standby


@Michael.Br wrote:

Hi,

 

We faceing the same issue. Were you able to solve this?

 

 

 



@Michael.Br wrote:

Hi,

 

We faceing the same issue. Were you able to solve this?

 

 

 




Re: Issue With Hive

New Contributor

No more errros

 

Thank you