我们使用CDH 版HADOOP 的hive时，会有问题
hive
hive> select * from ismproinfo where ismcode='170620611106562';
Query ID = root_20171225133939_a1659f3d-1939-42d7-ab67-a50f776c4a6b
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_201712251306_0002, Tracking URL = http://test028.tf.corp:50030/jobdetails.jsp?jobid=job_201712251306_0002
Kill Command = /app/zpy/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hadoop/bin/hadoop job -kill job_201712251306_0002
Hadoop job information for Stage-1: number of mappers: 3; number of reducers: 0
2017-12-25 13:39:20,544 Stage-1 map = 100%, reduce = 100%
Ended Job = job_201712251306_0002 with errors
Error during job, obtaining debugging information...
Job Tracking URL: http://test028.tf.corp:50030/jobdetails.jsp?jobid=job_201712251306_0002
Examining task ID: task_201712251306_0002_m_000004 (and more) from job job_201712251306_0002
Examining task ID: task_201712251306_0002_r_000000 (and more) from job job_201712251306_0002
Task with the most failures(4):
-----
Task ID:
task_201712251306_0002_m_000003
URL:
http://test028.tf.corp:50030/taskdetails.jsp?jobid=job_201712251306_0002&tipid=task_201712251306_0002_m_000003
-----
Diagnostic Messages for this Task:
Error initializing attempt_201712251306_0002_m_000003_3:
org.apache.hadoop.security.AccessControlException: Permission denied: user=mapred, access=EXECUTE, inode="/tmp/mapred/system":hdfs:supergroup:drwx------
错误如下：
org.apache.hadoop.security.AccessControlException: Permission denied: user=mapred, access=EXECUTE, inode="/tmp/mapred/system":hdfs:supergroup:drwx------
如果按照普通情况下，我们应该修改HDFS 目录的权限，但是修改了很多次也不行，后来在网上搜
如下方法：
应该修改hdfs-site.xml文件
<property>
<name>dfs.permissions</name>
<value>false</value>
</property>
我们也可以通过web界面来实现,把这项的对勾去掉就行
图片.png
最后重启HDFS
hive> select * from ismproinfo where ismcode='170620611106562';
Query ID = root_20171225142626_9035da87-fe0d-4020-b371-a4fc8585e0ea
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_201712251425_0001, Tracking URL = http://test028.tf.corp:50030/jobdetails.jsp?jobid=job_201712251425_0001
Kill Command = /app/zpy/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hadoop/bin/hadoop job -kill job_201712251425_0001
Hadoop job information for Stage-1: number of mappers: 3; number of reducers: 0
2017-12-25 14:26:36,471 Stage-1 map = 0%, reduce = 0%
2017-12-25 14:26:40,500 Stage-1 map = 33%, reduce = 0%, Cumulative CPU 3.0 sec
2017-12-25 14:26:41,506 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 7.15 sec
2017-12-25 14:26:43,522 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 7.15 sec
MapReduce Total cumulative CPU time: 7 seconds 150 msec
Ended Job = job_201712251425_0001
MapReduce Jobs Launched:
Stage-Stage-1: Map: 3 Cumulative CPU: 7.15 sec HDFS Read: 27881899 HDFS Write: 366 SUCCESS
Total MapReduce CPU Time Spent: 7 seconds 150 msec
OK
8311596287391245555 14147,15063,16276,16669,420,607,18324,34829,2741,9541,10073,10860,169,5665,15628,1664 002611,002651,002685,002686,000756,000990,002728,002741,002036,002341,002389,002463,000421,002144,002667,600510 170620611106562 2017-10-27 2017-10-27 2017-10-27 2017-10-27 2017-10-27 2017-11-06 1.0E7 24991.0 1.23 0.8 15 2017-10-26 1 70.12883042 4 4 17 171026
Time taken: 15.236 seconds, Fetched: 1 row(s)
