hive问题

olivee 3年前 ⋅ 1103 阅读

1. hive客户端报错Couldn't find log associated with operation handle: OperationHandle

2021-09-22 11:40:20,053 WARN  [HiveServer2-Handler-Pool: Thread-36]: thrift.ThriftCLIService (ThriftCLIService.java:FetchResults(681)) - Error fetching results:
org.apache.hive.service.cli.HiveSQLException: Couldn't find log associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=0db6766b-9546-4820-9da5-6462566a5310]
        at org.apache.hive.service.cli.operation.OperationManager.getOperationLogRowSet(OperationManager.java:229)
        at org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:687)
        at sun.reflect.GeneratedMethodAccessor10.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:1657)
        at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
        at com.sun.proxy.$Proxy20.fetchResults(Unknown Source)
  • 配置hive-site.xml
<property>
    <name>hive.server2.logging.operation.enabled</name>
    <value>true</value>
</property>
  • hive client执行
set hive.server2.logging.operation.log.location;
# 查看指向目录
+-----------------------------------------------------------------------+--+
|                                  set                                  |
+-----------------------------------------------------------------------+--+
| hive.server2.logging.operation.log.location=/tmp/root/operation_logs  |
+-----------------------------------------------------------------------+--+
  • 创建对应目录 修改用户权限
# 注意目录位置
mkdir -p /tmp/root/operation_logs
chmod -R 777 /tmp/root/operation_logs
  • 还不行就重启hive