[HIVE-7695] hive stats issue when insert query is appending data into table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0, 0.13.1
• Fix Version/s: 0.14.0
• Component/s: Logical Optimizer, Statistics
• Assignee: Ashutosh Chauhan
• Reporter: Thejas Nair
• Created: 12/Aug/14 20:06
• Updated: 13/Nov/14 19:43
• Resolved: 02/Oct/14 14:12

Description

When 'insert' is used to append (not overrite), the stats don't seem to get updated.

set hive.compute.query.using.stats=true;
 set hive.stats.autogather=true;         
//insert 4 rows
insert into table t2 select * from t1;
select count(*) from t2;
4
//insert 4 again (appending instead of overrite)
insert into table t2 select * from t1;
select count(*) from t2;
4
select * from t2;    
1
2
3
4
1
2
3
4