Support Questions
Find answers, ask questions, and share your expertise

Unable to fetch table : Hive MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

Highlighted

Unable to fetch table : Hive MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

Contributor

HDP: 2.3.4 ambari- 2.2.0

I had enabled hiverserver2 HA.

I have all my hive services(hive server2, hive metastore, webhat server) in one node.Hive metastore is Mysql and it is in another node.I have properly configured the connection using mysql-connector-java.jar.

I am getting an error when i try executing hive commands and jobs through beeline . I connect HA enabled hiverserver2 via beeline using

!connect jdbc:hive2://<zookeeper ips>:2181/; serviceDiscoveryMode=zooKeeper; zooKeeperNamespace=hiveserver2;principal=hive/_HOST@<realm>

Please find the error logs:-

Caused
 by: org.apache.hive.service.cli.HiveSQLException: Error while compiling
 statement: FAILED: SemanticException Unable to fetch table machines. 
For direct MetaStore DB connections, we don't support retries at the 
client level.
	at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:315)
	at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:112)
	at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:181)
	at org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)
	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:410)
	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:397)
	at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:274)
	at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)
	at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)
	at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
	at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
	at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor.process(HadoopThriftAuthBridge.java:692)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused
 by: org.apache.hadoop.hive.ql.parse.SemanticException: Unable to fetch 
table machines. For direct MetaStore DB connections, we don't support 
retries at the client level.
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1850)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1531)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:10064)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10115)
	at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:211)
	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:227)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:454)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:314)
	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1164)
	at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1158)
	at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)
	... 15 more

Please provide a fix for this.

4 REPLIES 4
Highlighted

Re: Unable to fetch table : Hive MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

Super Guru
@Vandana K R

What happens when you try to connect to single hiveserver2? does it work?

Re: Unable to fetch table : Hive MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

Contributor

Yes. it is working when i try connecting using single hiverserver2.It is throwing error while enabling hiverserver2 HA

Highlighted

Re: Unable to fetch table : Hive MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

Explorer
@Vandana K R

does this issue with hiveserver2 HA has any solutions?

Highlighted

Re: Unable to fetch table : Hive MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

Explorer

@Artem Ervits hi, Artem, can you help to solve this problem?thx