Support Questions

Find answers, ask questions, and share your expertise

HDP 3.0.1 Upgrade - hive preupgrade tool failed


2018-11-14T20:36:33,075 INFO [main] org.apache.hadoop.hive.upgrade.acid.PreUpgradeTool - Creating metastore client for PreUpgradeTool 2018-11-14T20:36:33,106 INFO [main] hive.metastore - Trying to connect to metastore with URI thrift:// 2018-11-14T20:36:33,328 INFO [main] hive.metastore - Opened a connection to metastore, current connections: 1 2018-11-14T20:36:33,329 INFO [main] hive.metastore - Connected to metastore. 2018-11-14T20:36:34,533 INFO [main] hive.metastore - Trying to connect to metastore with URI thrift:// 2018-11-14T20:36:34,548 INFO [main] hive.metastore - Opened a connection to metastore, current connections: 2 2018-11-14T20:36:34,549 INFO [main] hive.metastore - Connected to metastore. 2018-11-14T20:36:36,572

ERROR [main] org.apache.hadoop.hive.upgrade.acid.PreUpgradeTool - PreUpgradeTool failed org.apache.hadoop.hive.metastore.api.MetaException: 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( at org.apache.hadoop.hdfs.server.namenode.NameNode$NameNodeHAContext.checkOperation( at

org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkOperation( at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getFileInfo( at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getFileInfo( at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getFileInfo( at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod( at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ at org.apache.hadoop.ipc.RPC$ at org.apache.hadoop.ipc.Server$Handler$ at org.apache.hadoop.ipc.Server$Handler$ at Method) at at at org.apache.hadoop.ipc.Server$ at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_result$ ~[hive-metastore-] at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_result$ ~[hive-metastore-] at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$ ~[hive-metastore-] at org.apache.thrift.TServiceClient.receiveBase( ~[libthrift-0.9.3.jar:0.9.3] at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table( ~[hive-metastore-]


New Contributor

Encountered this error during our upgrade. 


User and third party tool had created external Hive tables with locations that referenced single namenodes rather than HA name. These had to be corrected. 





I would firstly advise you to start a new thread rather than updating a thread that's not being followed and please share the logs too.

New Contributor

My issue is resolved. Wanted to provide an update to the thread in case it is later discovered through a search. 

Community Manager

@DaveyDevOps , 


I'm happy to see you resolved your issue. Can you please mark the appropriate reply as the solution? As you mentioned, it will make it easier for others to find the answer in the future.


Vidya Sargur,
Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.