Getting error while reading from hive in Beeline

Hi team,

Please note i am running the below queries:

beeline -u jdbc:hive2://
and
show databases;

I am getting below error while running queries in beeline hive:

20/10/02 07:22:43 [Thread-16]: WARN thrift.ThriftCLIService: Error fetching results:
org.apache.hive.service.cli.HiveSQLException: Couldn’t find log associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=7bc3007c-
4e8c-4df3-a986-faf7eb6bda4a]
at org.apache.hive.service.cli.operation.OperationManager.getOperationLogRowSet(OperationManager.java:249)
at org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:786)
at org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:520)
at org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:709)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hive.jdbc.HiveConnection$SynchronizedHandler.invoke(HiveConnection.java:1374)
at com.sun.proxy.$Proxy17.FetchResults(Unknown Source)
at org.apache.hive.jdbc.HiveStatement.getQueryLog(HiveStatement.java:865)
at org.apache.hive.jdbc.HiveStatement.getQueryLog(HiveStatement.java:836)
at org.apache.hive.beeline.Commands.showRemainingLogsIfAny(Commands.java:973)
at org.apache.hive.beeline.Commands.access$100(Commands.java:62)
at org.apache.hive.beeline.Commands$1.run(Commands.java:951)
at java.lang.Thread.run(Thread.java:745)

Hi, @Sasmit_Bhitiria

You are able to connect Hive via beeline.

  1. Type beeline in terminal.

  2. !connect jdbc:hive2://

  3. You cloudxlab username and password for permissions.

  4. show databases;

You are good to go, It is just for practice purpose that there is a way you can connect to Hive,
For CRUD operations and beyond

you can use Hive terminal.


All the best!