Contributor
Posts: 26
Registered: ‎04-09-2016
Accepted Solution
Unable to execute add jar command as mentioned in Exercise 2
[ Edited ]

I did finished cloudera exercise 1 successfully on CDH 5 and now I am trying to replicate below same scenario in cloudera url on CDH 5:-


http://www.cloudera.com/developers/get-started-with-hadoop-tutorial/exercise-2.html

 

Exact command cloudera gave is ADD JAR {{lib_dir}}/hive/lib/hive-contrib.jar;

 

Problem is when i issue below command in HIVE query editor:-

 

ADD JAR /home/cloudera/lib/hive-contrib.jar;

 

Hive query editor says:-

Your query has the following error(s):

Error while processing statement: /home/cloudera/lib/hive-contrib.jar does not exist

 

There are 2 issues for which i need solution:-

1)I am unable to find hive/lib directory on CDH 5
2)How to import these jar on on Hive/lib directory

 

My main intention is to get output of below query after invalidate metadata command from Impala 

select count(*),url from tokenized_access_logs
where url like '%\/product\/%'
group by url order by count(*) desc;

 But though i see tokenized_access_logs created at left hand side of HUE but i see no results of above query so i doubt that reason is that add jar command was not executed successfully above hence i am not getting output,can someone suggest how do i successfully execute Add jar command 

 

I have added the screenshot of my VM which shows tokenized_access_logs created but no data when i run 

select count(*),url from tokenized_access_logs
where url like '%\/product\/%'
group by url order by count(*) desc;no results.JPG

 

 

Also added is the error when i ran jar add jar no results.JPG 

Who Me Too'd this topic