Skip to Content

Vora 1.4 vora tools connection error

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 27, 2017 at 10:29 PM

    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

    Add comment
    10|10000 characters needed 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)
  • avatar image
    Former Member
    Jun 28, 2017 at 06:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 29, 2017 at 09:29 PM

    see the comment on the first answer.

    I can imagine, that there is a problem with authentication

    Add comment
    10|10000 characters needed characters exceeded

    • 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'