Support Questions

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

Failed to submit the map reduce job using hive cli?

avatar
Super Collaborator

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.

1 ACCEPTED SOLUTION

avatar
Super Collaborator
@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

View solution in original post

2 REPLIES 2

avatar
Super Collaborator
@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

avatar
Super Collaborator

Thank you Rguruvannagari.

This solution really worked for me.