执行hive语句时报ALLOW_UNQUOTED_CONTROL_CHARS

最新推荐文章于 2023-08-30 23:44:59 发布

duxianghe

最新推荐文章于 2023-08-30 23:44:59 发布

阅读量2.7k

点赞数

分类专栏： hadoop

本文链接：https://blog.csdn.net/duxianghe/article/details/9248639

版权

在执行Hive的LIKE查询时遇到错误，问题根源是不同节点上的Jackson库版本不一致。尽管已尝试将Hadoop和Hive的Jackson库统一为1.8.8版本，但在slave节点上仍发现版本不匹配。通过替换所有slave节点上的jackson-core-asl-1.8.8.jar，并进一步替换jackson-mapper-asl-1.8.8.jar后，重启Hadoop服务，问题得到解决。

摘要由CSDN通过智能技术生成

在hive中执行普通查询没有问题。

hive> select * from weblog w where w.accdate='2013-06-15' limit 20;

但执行like时，就报错，

select * from weblog w where w.csuristem like '%aspx' limit 20;                                                                   
Total MapReduce 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_201307050845_0002, Tracking URL = http://Master.Hadoop:50030/jobdetails.jsp?jobid=job_201307050845_0002
Kill Command = /usr/hadoop/libexec/../bin/hadoop job  -kill job_201307050845_0002
Hadoop job information for Stage-1: number of mappers: 3; number of reducers: 0
2013-07-05 08:51:14,582 Stage-1 map = 0%,  reduce = 0%
2013-07-05 08:51:58,150 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201307050845_0002 with errors
Error during job, obtaining debugging information...
Job Tracking URL: http://Master.Hadoop:50030/jobdetails.jsp?jobid=job_201307050845_0002
Examining task ID: task_201307050845_0002_m_000004 (and more) from job job_201307050845_0002
Examining task ID: task_201307050845_0002_m_000000 (and more) from job job_201307050845_0002

Task with the most failures(4): 
-----
Task ID:
  task_201307050845_0002_m_000001

URL:
  http://Master.Hadoop:50030