Hive Query is not running in cloudera HUE

[#1]

Hi,

when we ran the "select *from tablename"  query in Cloudera Hive in HUE it is working fine ,but when i try to run the "select count(*) from tablename" or some other query the job is not running and it is throwing an error :

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

what is the problem here ? Normal select query is working and the query which requires map reduce is not working .

could anyone help us in resolving the issue.

[#2]

@Nekkanti ,

You need to locate the failed YARN application job and its associated logs to understand why it is failing. Find the application ID and run:

If kerberized:
yarn logs -applicationId {application_id} -appOwner {username}

If unsecured:
sudo -u yarn yarn logs -applicationId {application_id}

Cheers
Eric

[#3]

Hi Eric,

Thanks for your response.

when i ran the below command:

sudo -u yarn yarn logs -applicationId {application_1578980062850_0002}

it is also throwing error:

Invalid ApplicationId specified

please suggest me what i need to do.

[#4]

@Nekkanti,

The whole {application_id} is the placeholder, so you should run below instead:

sudo -u yarn yarn logs -applicationId application_1578980062850_0002