A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

How to kill a Hive query that does not have a YARN application_ID?

ometimes, when running CREATE and SELECT queries, YARN application ID is not created. These queries may have to be killed manually. To achieve this, do the following: 

  1. Take the query ID from the Beeline / Hive CLI console:
    hive> select * from firsttable;
    Query ID = mapr_20170523134547_2c04d119-5495-401e-b7b7-2ad87f0f5627
    Total jobs = 1
    Launching Job 1 out of 1
  2. Use “kill query” command, which is available from HDP 2.6.3:
    KILL QUERY "<queryid1>" "<queryid2>"

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>