Failed to submit the map reduce job using hive cli?

[#1]

Hi,

I have installed below Hadoop services and all services are running fine

services.png

The problem is that when i am executing below query from Hive cli I am getting the exception in terminal as.

Query : select count(*) from mytables;

Exception:

short exception description:

Job Submission failed with exception 'java.io.FileNotFoundException(File does not exist: hdfs://<nanodeHostIp>:8020/hdp/apps/2.2.9.0-3393/mapreduce/mapreduce.tar.gz)

please find attached exception file

exception.txt

and I have also checked path on HDFS "/hdp" which is not completely present on file system so my question is, As have done fresh hadoop installation through Apache ambari then why ambari did not created files or directories under "/hdp" directory automatically.

What is the solution for above problem?

Thanks in advance.

[#2 · Accepted solution]

@Manoj Dhake

Try to copy mapreduce tar file to hdfs and try hive query again.

#su - hdfs
#hdfs dfs -mkdir -p /hdp/apps/2.2.9.0-3393/mapreduce/
#hdfs dfs -put /usr/hdp/<version>/hadoop/mapreduce.tar.gz /hdp/apps/2.2.9.0-3393/mapreduce/mapreduce.tar.gz

[#3]

Thank you Rguruvannagari.

This solution really worked for me.