Hi, getting this error .please, advice!
CREATE TABLE nasty1.nasty2 (id int, name string);
OK
20/10/22 18:46:00 [Thread-25]: 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()=84752df6-8370-4b06-b0c1-22409f011bd2]
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.GeneratedMethodAccessor4.invoke(Unknown Source)
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)
No rows affected (0.223 seconds)
20/10/22 18:46:00 [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, getHandleIdentifier()=84752df6-8370-4b06-b0c1-22409f011bd2]
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.GeneratedMethodAccessor4.invoke(Unknown Source)
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:909)
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)
These are warnings that you can ignore.
It is already showing the table is created in line number 2
CREATE TABLE nasty1.nasty2 (id int, name string);
OK