Skip to Content
0

Vora 1.4 vora tools connection error

Jun 24, 2017 at 09:21 PM

146

avatar image

I'm using Vora 1.4 on an Cloudera test-cluster on AWS and getting the following error while connecting to Vora tools:

Error while compiling statement: FAILED: SemanticException Table not found 'SYS_TABLES' with error code 10001, status ERROR_STATUS

All services are up, also the thriftserver is running and I tried several ports without success.

Kindly advise.

10 |10000 characters needed characters left characters exceeded
0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jason Hinsperger
Jun 27, 2017 at 10:29 PM
0

Are you using VPC in AWS? If not, and your ip addresses change for the nodes in your cluster, you will run into strange problems.

If IP addresses have changed since you installed Vora, the Vora troubleshooting guide explains how you can fix the problem:

https://help.sap.com/http.svc/rc/347253ce050e484eb3277a46d290fb92/1.4/en-US/SAP_Vora_Troubleshooting_Guide_1.4_en.pdf

--Jason

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

as expected, I followed the steps without any impact on the error message:

In vora manager all services are started:

Vora tools, the error message still persists:

Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:70 Table not found 'SYS_TABLES' with error code 10001, status ERROR_STATUS

vora-manager.png (87.9 kB)
vora-tools.png (32.7 kB)
0
avatar image
Former Member Jun 28, 2017 at 06:59 PM
0

Hi,

I'm using AWS behind a proxy, so although, that the public IP addresses changes, the private one does not. I do not have problems to access Vora Manager, Cloudera Manager, Cloudera Director, HUE, ....

Even I can connect to the Vora Tools, however, the connection status shows the error message posted.

I'm sure, that the problem lies somewhere else. What I do not understand is: Which table is tried to be accessed in which database?

Table not found 'SYS_TABLES' with error code 10001, status ERROR_STATUS

Cheers

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 29, 2017 at 09:29 PM
0

see the comment on the first answer.

I can imagine, that there is a problem with authentication

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Are you running CDH 5.11? If so, you could be running into a known issue that was introduced with the Spark version that comes with CDH5.11. This should be fixed in Vora 1.4 Patch 2.

As a workaround you will have to download Spark 1.6.2 from Apache Spark's website (http://spark.apache.org/downloads.html), extract the package on the host where Vora Thriftserver is running (you can check this in Vora Manager UI) and set the Spark home directory in the Vora Thriftserver settings to point the 1.6.2 installation.

0
Former Member

yes, I'm on CDH 5.11.1 the Spark version is 1.6.0+cdh5.11.1+506.

I will test your suggestion.

0
Former Member

I'm still testing.

However I found in the vora thriftserver logs, that before the error is thrown there is a warning potentially giving a hint on the root-cause. The error including this warning is (check the first line with WARN):

17/07/07 10:27:09 WARN security.UserGroupInformation: PriviledgedActionException as:vora (auth:SIMPLE) cause:org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:23 Table not found 'SYS_SESSION_CONTEXT'
17/07/07 10:27:09 WARN thrift.ThriftCLIService: Error executing statement: 
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:23 Table not found 'SYS_SESSION_CONTEXT'
	at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:400)
	at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:188)
	at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:267)
	at org.apache.hive.service.cli.operation.Operation.run(Operation.java:337)
	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:439)
	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:405)
	at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
	at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
	at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1920)
	at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
	at com.sun.proxy.$Proxy40.executeStatement(Unknown Source)
	at org.apache.hive.service.cli.CLIService.executeStatement(CLIService.java:257)
	at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:501)
	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.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:23 Table not found 'SYS_SESSION_CONTEXT'



0