Hive Session Warning

Lab Support
#1

Hi,

While using hive, on every query execution I am getting below warning. Could you please check and do the needful.

20/05/19 08:42:43 [main]: WARN thrift.ThriftCLIService: Error fetching results:
org.apache.hive.service.cli.HiveSQLException: Couldn’t find log associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIde
ntifier()=7023d269-15b1-4158-bee5-b5864c1988bc]
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.execute(Commands.java:891)
at org.apache.hive.beeline.Commands.sql(Commands.java:729)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1000)
at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:835)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:793)
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:493)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:476)
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.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)

#2

Hi,

Could you please share your query also? Also this error is coming after running the hive query or while launching hive

#3

Hi,
Its throwing the warning after executing queries (even simple ones). PFB the same.

0: jdbc:hive2://> select * from sd_db_stg.explode_example_2;
OK
20/05/20 10:50:06 [Thread-15]: 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()=f9c1aad6-5d57-4fd3-a68a-a9b3bfab1c56]
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)
±----------------------±----------------------±-+
| explode_example_2.c1 | explode_example_2.c2 |
±----------------------±----------------------±-+
| 1 | {10:“a”} |
| 2 | {20:“b”} |
| 3 | {30:“c”} |
| 3 | {30:“d”} |
| 4 | {40:“e”} |
±----------------------±----------------------±-+
5 rows selected (0.124 seconds)
20/05/20 10:50:06 [main]: WARN thrift.ThriftCLIService: Error fetching results:
org.apache.hive.service.cli.HiveSQLException: Couldn’t find log associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIde
ntifier()=f9c1aad6-5d57-4fd3-a68a-a9b3bfab1c56]
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.execute(Commands.java:891)
at org.apache.hive.beeline.Commands.sql(Commands.java:729)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1000)
at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:835)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:793)
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:493)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:476)
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.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
0: jdbc:hive2://>