How to stop certain work while executing queries on Hive on Hadoop?

Scenario:

When I run enter the query on Hive CLI, I get the errors as below:

Query:

**$ bin/hive -e "insert overwrite table pokes select a.* from invites a where a.ds='2008-08-15';"** 

The error looks like this:

Total jobs MapReduce = 1 Start job 1 of 1 The number of job cuts is set to 0 because there is no job cut job Run Job = job_201111291547_0013, tracking URL = http: // localhost: 50030 / jobdetails.jsp? Jobid = job_201111291547_0013     Kill Command = C: \ cygwin \ home \ Bhavesh.Shah \ hadoop-0.20.2 / bin / hadoop job -Dmapred.job.tracker = localhost: 9101 -kill job_201111291547_0013 2011-12-01 14: 00: 52 380 Stage-1 card = 0% , decrease = 0% 2011-12-01 14: 01:19 518 Stage-1 card = 100%, decrease = 100% Job completed = job_201111291547_0013 with errors FAILED: Runtime error, return code 2 from org.apache.hadoop.hive .ql.exec.MapRedTask

Question:

, , ? : job_201111291547_0013 Pls , . .

+5
4

, hadoop job -kill <job_id>.

+12

hadoop job -kill . mapred job -kill.

+3

, . , . , hadoop job -kill .

mapred job -kill
+1

- WebHCat API , , Curl. WebHCat API

, ,

The task is not immediately deleted, so the returned information may not reflect the deletion, as in our example. Use the GET /: jobid jobs to monitor the job and confirm that it is ultimately deleted.

0
source

All Articles