Reply
Highlighted
Explorer
Posts: 7
Registered: ‎03-09-2015

Issue With Hive

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)

New Contributor
Posts: 5
Registered: ‎08-18-2014

Re: Issue With Hive

Hi,

 

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

 

 

 

Cloudera Employee
Posts: 35
Registered: ‎09-04-2013

Re: Issue With Hive

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

Explorer
Posts: 7
Registered: ‎03-09-2015

Re: Issue With Hive

Yes  the Name node was on standby we fixed it.

 

Thanks 

Explorer
Posts: 7
Registered: ‎03-09-2015

Re: Issue With Hive

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?

 

 

 




New Contributor
Posts: 5
Registered: ‎08-18-2014

Re: Issue With Hive

No more errros

 

Thank you