Hi all: Maybe i meet a hive bug. i used hive version is 0.14. when i insert data to a lzo compress table,the dest table hava no data.
the hql is: insert into table meimiao_user_register_log select * from default.meimiao_user_register_log where dt<'2015-12-16'; and the run log is: Starting Job = job_201511091957_966116, Tracking URL = http://jxq-job-01:50030/jobdetails.jsp?jobid=job_201511091957_966116 Kill Command = /hadoop/hadoop-1.2.1/libexec/../bin/hadoop job -kill job_201511091957_966116 Hadoop job information for Stage-1: number of mappers: 1984; number of reducers: 0 2015-12-16 17:39:55,453 Stage-1 map = 0%, reduce = 0% 2015-12-16 17:40:55,805 Stage-1 map = 0%, reduce = 0% 2015-12-16 17:41:05,339 Stage-1 map = 1%, reduce = 0%, Cumulative CPU 127.88 sec 2015-12-16 17:41:06,498 Stage-1 map = 6%, reduce = 0%, Cumulative CPU 525.91 sec 2015-12-16 17:41:07,657 Stage-1 map = 10%, reduce = 0%, Cumulative CPU 1065.7 sec 2015-12-16 17:41:08,831 Stage-1 map = 17%, reduce = 0%, Cumulative CPU 1742.89 sec 2015-12-16 17:41:10,169 Stage-1 map = 27%, reduce = 0%, Cumulative CPU 2883.05 sec 2015-12-16 17:41:11,292 Stage-1 map = 40%, reduce = 0%, Cumulative CPU 3996.41 sec 2015-12-16 17:41:12,483 Stage-1 map = 50%, reduce = 0%, Cumulative CPU 4923.69 sec 2015-12-16 17:41:13,624 Stage-1 map = 60%, reduce = 0%, Cumulative CPU 6044.36 sec 2015-12-16 17:41:14,828 Stage-1 map = 73%, reduce = 0%, Cumulative CPU 7219.26 sec 2015-12-16 17:41:16,019 Stage-1 map = 79%, reduce = 0%, Cumulative CPU 7822.3 sec 2015-12-16 17:41:17,169 Stage-1 map = 86%, reduce = 0%, Cumulative CPU 8495.27 sec 2015-12-16 17:41:18,340 Stage-1 map = 92%, reduce = 0%, Cumulative CPU 9083.37 sec 2015-12-16 17:41:19,463 Stage-1 map = 95%, reduce = 0%, Cumulative CPU 9341.79 sec 2015-12-16 17:41:21,781 Stage-1 map = 98%, reduce = 0%, Cumulative CPU 9733.53 sec 2015-12-16 17:41:22,923 Stage-1 map = 99%, reduce = 0%, Cumulative CPU 9785.7 sec 2015-12-16 17:41:30,965 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 9922.45 sec 2015-12-16 17:41:32,021 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 9922.45 sec MapReduce Total cumulative CPU time: 0 days 2 hours 45 minutes 22 seconds 450 msec Ended Job = job_201511091957_966116 Stage-4 is filtered out by condition resolver. Stage-3 is selected by condition resolver. Stage-5 is filtered out by condition resolver. Launching Job 3 out of 3 Number of reduce tasks is set to 0 since there's no reduce operator Starting Job = job_201511091957_966142, Tracking URL = http://jxq-job-01:50030/jobdetails.jsp?jobid=job_201511091957_966142 Kill Command = /hadoop/hadoop-1.2.1/libexec/../bin/hadoop job -kill job_201511091957_966142 Hadoop job information for Stage-3: number of mappers: 0; number of reducers: 0 2015-12-16 17:41:44,324 Stage-3 map = 0%, reduce = 0% 2015-12-16 17:41:46,763 Stage-3 map = 100%, reduce = 100% Ended Job = job_201511091957_966142 Loading data to table tmp.meimiao_user_register_log Table tmp.meimiao_user_register_log stats: [numFiles=0, numRows=14340, totalSize=0, rawDataSize=2382546] MapReduce Jobs Launched: Stage-Stage-1: Map: 1984 Cumulative CPU: 9922.45 sec HDFS Read: 1353990 HDFS Write: 721305 SUCCESS Stage-Stage-3: HDFS Read: 0 HDFS Write: 0 SUCCESS but the select result is real have data. and when i change the dest table stored type(like text and orc type).The results were with expectations [email protected]
