# Hive故障排除
本章节汇总了使用Hive时遇到的常见故障及故障处理方法。
- **Hive日志类型及不同故障日志定位介绍**
  [Hive常见日志说明](https://support.huaweicloud.com/trouble-mrs/mrs_03_0147.html)
  
- **Hive服务异常**
  - [Hive服务启动失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0148.html)
  
  - [Hive服务状态为故障如何处理](https://support.huaweicloud.com/trouble-mrs/mrs_03_0167.html)
  
  - [Hive服务健康状态和Hive实例健康状态的区别](https://support.huaweicloud.com/trouble-mrs/mrs_03_0169.html)
  
  - [Hive服务状态为Unknown](https://support.huaweicloud.com/trouble-mrs/mrs_03_0175.html)
  
  - [HiveServer或者MetaStore实例的健康状态为unknown](https://support.huaweicloud.com/trouble-mrs/mrs_03_0176.html)
  
  - [HiveServer或者MetaStore实例的健康状态为Concerning](https://support.huaweicloud.com/trouble-mrs/mrs_03_0177.html)
  
  - [修改hostname后导致WebHCat启动失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0184.html)
  
  - [DBService超过最大连接数后导致Hive MetaStore异常](https://support.huaweicloud.com/trouble-mrs/mrs_03_0186.html)
  
  - [HiveServer和HiveHCat进程故障](https://support.huaweicloud.com/trouble-mrs/mrs_03_0215.html)
  
  - [重启Hive服务失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0260.html)
  
  - [WebHCat健康状态异常导致启动失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0727.html)
  
  - [mapred-default.xml文件解析异常导致WebHCat启动失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0728.html)
   
- **Hive客户端任务运行异常**
  - [执行set命令的时候报错"Cannot modify xxx at runtime"](https://support.huaweicloud.com/trouble-mrs/mrs_03_0149.html)
  
  - [提交Hive任务时如何指定队列](https://support.huaweicloud.com/trouble-mrs/mrs_03_0151.html)
  
  - [怎么通过客户端设置Map/Reduce内存](https://support.huaweicloud.com/trouble-mrs/mrs_03_0152.html)
  
  - [如何在导入Hive表时指定输出的文件压缩格式](https://support.huaweicloud.com/trouble-mrs/mrs_03_0153.html)
  
  - [Hive表desc描述过长导致无法完整显示](https://support.huaweicloud.com/trouble-mrs/mrs_03_0154.html)
  
  - [Hive表中增加分区列后再插入数据显示为NULL](https://support.huaweicloud.com/trouble-mrs/mrs_03_0155.html)
  
  - [访问Hive客户端提示访问ZooKeeper失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0172.html)
  
  - [使用UDF函数时提示"Invalid function"](https://support.huaweicloud.com/trouble-mrs/mrs_03_0173.html)
  
  - [TEXTFILE类型文件使用ARC4压缩时查询结果乱码](https://support.huaweicloud.com/trouble-mrs/mrs_03_0178.html)
  
  - [Hive任务运行过程中失败，重试成功](https://support.huaweicloud.com/trouble-mrs/mrs_03_0180.html)
  
  - [执行select语句时报错"Execution Error return code 2"](https://support.huaweicloud.com/trouble-mrs/mrs_03_0181.html)
  
  - [有大量分区时执行drop partition操作失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0182.html)
  
  - [执行join操作时localtask启动失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0183.html)
  
  - [beeline客户端报错"Failed to execute session hooks: over max connections"](https://support.huaweicloud.com/trouble-mrs/mrs_03_0187.html)
  
  - [beeline客户端查询大量数据报错"OutOfMemoryError"](https://support.huaweicloud.com/trouble-mrs/mrs_03_0188.html)
  
  - [输入文件数超出设置限制导致任务执行失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0189.html)
  
  - [Hive任务执行中报栈内存溢出导致任务执行失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0190.html)
  
  - [对同一张表或分区并发写数据导致任务失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0191.html)
  
  - [Load数据到Hive表失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0193.html)
  
  - [Hive执行insert into语句报错](https://support.huaweicloud.com/trouble-mrs/mrs_03_0228.html)
  
  - [增加Hive表字段超时](https://support.huaweicloud.com/trouble-mrs/mrs_03_0236.html)
  
  - [Hive分区数过多导致删除表失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0268.html)
  
  - [Hive执行msck repair table命令时报错](https://support.huaweicloud.com/trouble-mrs/mrs_03_0282.html)
  
  - [在Hive中drop表后如何完全释放磁盘空间](https://support.huaweicloud.com/trouble-mrs/mrs_03_0719.html)
  
  - [JSON表中有破损数据导致Hive查询异常](https://support.huaweicloud.com/trouble-mrs/mrs_03_0722.html)
  
  - [Hive客户端执行SQL报错连接超时](https://support.huaweicloud.com/trouble-mrs/mrs_03_0725.html)
  
  - [Hive元数据使用RDS时创建视图表中文乱码](https://support.huaweicloud.com/trouble-mrs/mrs_03_0816.html)
  
  - [MetaStore动态分区数超出阈值导致SQL报错](https://support.huaweicloud.com/trouble-mrs/mrs_03_0822.html)
   
- **Hive用户权限问题**
  - [集群中创建的新用户执行查询Hive操作时无权限](https://support.huaweicloud.com/trouble-mrs/mrs_03_0156.html)
  
  - [执行SQL提交任务到指定队列时报错权限不足](https://support.huaweicloud.com/trouble-mrs/mrs_03_0160.html)
  
  - [执行load data inpath命令报错用户权限不足或目录格式不正确](https://support.huaweicloud.com/trouble-mrs/mrs_03_0161.html)
  
  - [执行load data local inpath命令报错用户权限不足或目录不存在](https://support.huaweicloud.com/trouble-mrs/mrs_03_0162.html)
  
  - [执行create external table命令报错用户权限不足](https://support.huaweicloud.com/trouble-mrs/mrs_03_0163.html)
  
  - [在beeline客户端执行dfs -put命令报错用户权限不足](https://support.huaweicloud.com/trouble-mrs/mrs_03_0164.html)
  
  - [执行set role admin命令报错用户无权限](https://support.huaweicloud.com/trouble-mrs/mrs_03_0165.html)
  
  - [在beeline客户端创建UDF时报错用户无权限](https://support.huaweicloud.com/trouble-mrs/mrs_03_0166.html)
  
  - [Shell客户端连接提示"authentication failed"](https://support.huaweicloud.com/trouble-mrs/mrs_03_0171.html)
  
  - [Hive任务失败，报没有HDFS目录的权限](https://support.huaweicloud.com/trouble-mrs/mrs_03_0192.html)
  
  - [Hive执行insert into命令报用户权限不足](https://support.huaweicloud.com/trouble-mrs/mrs_03_0717.html)
   
- **Hive样例程序运行失败**
  - [集群修改域名后Hive样例程序运行报错](https://support.huaweicloud.com/trouble-mrs/mrs_03_0185.html)
  
  - [Hive JDBC代码用例未配置Kerberos认证导致开发的业务应用运行失败](https://support.huaweicloud.com/trouble-mrs/mrs_03_0194.html)
  
  - [MRS Hive连接ZooKeeper时报错"ConnectionLoss for hiveserver2"](https://support.huaweicloud.com/trouble-mrs/mrs_03_0216.html)