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
