大数据在hive与HBASE联合使用时，hive insert into 出现异常错误

weixin_41509192

于 2020-07-02 20:21:50 发布

阅读量741

点赞数 1

文章标签： hive 大数据

本文链接：https://blog.youkuaiyun.com/weixin_41509192/article/details/107092174

版权

在尝试将Hive与HBase整合时遇到问题，当使用`insert into`语句向与HBase关联的Hive表添加数据时，出现类型不匹配的异常错误。错误的根本原因是查询导入的表中存在不兼容的数据类型字段。为解决此问题，需要检查并修正或删除这些不匹配的字段，确保所有字段类型与HBase和Hive表定义一致，之后重新执行插入操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在练习HBASE与hive联合使用时 hive无法向与hbase关联的表中添加数据。

报出错误如下：

hive (default)> insert into table hive_hbase_emp_table select * from emp;
Query ID = hadoop_20200703024258_990646f2-d56d-4915-9d4b-b18712baad15
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1593714898131_0001, Tracking URL = http://hrbu30:8088/proxy/application_1593714898131_0001/
Kill Command = /opt/ha/hadoop/bin/hadoop job  -kill job_1593714898131_0001
Hadoop job information for Stage-0: number of mappers: 1; number of reducers: 0
2020-07-03 02:43:14,108 Stage-0 map = 0%,  reduce = 0%
2020-07-03 02:43:46,558 Stage-0 map = 100%,  reduce = 0%
Ended Job = job_1593714898131_0001 with errors
Error during job, obtaining debugging information...
Examining task ID: task_1593714898131_0001_m_000000 (and more) from job job_1593714898131_000