Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to kill a connect on hiveserver2 which does not submit to yarn ?

avatar
Explorer

As an admin of a CDH cluster , 

some query has submitted  to the hiveserver2 ,  but the query still  in the hiveserver make the explain stage , which does not submit to the yarn cluster and has no application id on yarn . And the query make the hiveserver2 wrong  which  has a too long query such as 

select * from aaa where code in ('xxx','xxx1','xxx3',.......'xxx2000000') ;

A sql has more than milion row  may make the hiveserver2 corrupt . 

 

The 10002 web page  seems does not have some action button like yarn web the deal with the query .

 

The cdh version is 6.3.2 . hive version 2.1.1 .

When this situation occur , I have to restart the hiveserver2 .

I want to know if there is some way to kill a query through hive queryid or hive sessionid o instead of yarn applicationid .

 

It is also usefull when someone query the metastore which multithread such as "use hadoop " sql with 30 or more active connect  ,  The adminastritor has the ability to kill them forcely . 

 

1 ACCEPTED SOLUTION

avatar
Master Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
2 REPLIES 2

avatar
Master Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Explorer

Much Thanks .