[HIVE-13050] The row count is not correct after changing partition location to point to another partition location

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1.0
• Component/s: Query Processor
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 12/Feb/16 18:47
• Updated: 26/Mar/16 15:15

Description

CREATE  TABLE test  (s STRING) PARTITIONED BY (p SMALLINT) location 'data/test';
INSERT INTO test PARTITION (`p`=1) VALUES ("v1");
INSERT INTO test PARTITION (`p`=2) VALUES ("v2");
ALTER TABLE test PARTITION (`p`=2) SET LOCATION '/data/test/p=1';

select * from test; shows 2 rows while SELECT count FROM test; shows 1.

That is inconsistent.

Issue Links

• is related to: HIVE-10807 Invalidate basic stats for insert queries if autogather=false