I am running a single node cluster on Ubuntu 16.04. Hadoop version is 2.7.2 and Hive 1.2.1.
When I run hive queries which involve map-reduce job like partitioning or bucketing etc. It shows progress for sometime and then process get stop and comes out of command line. All the daemons get stop automatically and even my hadoop user (hduser) closes down and command line comes to default user.
Here is my log when I run query of copying data from one table to other.
hive> insert into table A1 select id,age,symptoms_pertaining_illness,sex from allcities;
Query ID = hduser_20160723195334_b34925b4-d6b7-46f2-a5ef-2e9e6b7c5293
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1469283576772_0001, Tracking URL = http://gaurav-HP-Notebook:8088/proxy/application_1469283576772_0001/
Kill Command = /usr/local/hadoop/bin/hadoop job -kill job_1469283576772_0001
Hadoop job information for Stage-1: number of mappers: 3; number of reducers: 0
2016-07-23 19:53:43,738 Stage-1 map = 0%, reduce = 0%
2016-07-23 19:53:58,136 Stage-1 map = 33%, reduce = 0%, Cumulative CPU 18.15 sec
killing job with: job_1469283576772_0001
gaurav@gaurav-HP-Notebook:~$
I tried setting up no. of mappers and reducers but it didn't work.
The problem is coming with smaller as well as larger datasets.
Copyright Notice:Content Author:「Gaurav」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/38543011/hive-query-stops-in-between-when-running-mapreduce-job