Query regarding Hive hanging while running a hive query

["Kandpal, Ritu " <ri...@citi.com>]

Hi,

I have a query regarding hive, I am running following simple hive queries on hive CLI, hive does not respond to "insert into table select .." statement:


*         create table test_temp ( year int, month int) ROW FORMAT delimited fields terminated by ',' STORED AS TEXTFILE;

*         load data local inpath '/var/opt/hive/test_temp.txt' into table test_temp;

*         create table test (year int, month int);

*         insert into table test select year, month from test_temp ;

Total MapReduce 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_1407754524966_0222, Tracking URL = http://vm-test:8088/proxy/application_1407754524966_0222/

Kill Command = /var/opt/hadoop/hadoop/bin/hadoop job  -kill job_1407754524966_0222




After running the last statement "insert into table test select year, month from test_temp " hive hangs at kill command,

Hive logs are also pasted below:



hive.log output :

2014-09-30 01:35:06,108 WARN  common.LogUtils (LogUtils.java:logConfigLocation(142)) - hive-site.xml not found on CLASSPATH
2014-09-30 01:35:06,425 WARN  util.NativeCodeLoader (NativeCodeLoader.java:<clinit>(62)) - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
2014-09-30 01:44:17,442 WARN  bonecp.BoneCPConfig (BoneCPConfig.java:sanitize(1537)) - Max Connections < 1. Setting to 20
2014-09-30 01:44:18,992 WARN  bonecp.BoneCPConfig (BoneCPConfig.java:sanitize(1537)) - Max Connections < 1. Setting to 20
2014-09-30 01:44:21,460 WARN  mapreduce.JobSubmitter (JobSubmitter.java:copyAndConfigureFiles(150)) - Hadoop command-line option parsing not performed. Implement the Tool interface and execute your application with ToolRunner to remedy this.


Can anyone please let me know whether it is a configuration issue, or some other issue which is causing hive to hang?



Thanks,
Ritu