[HIVE-22055] select count gives incorrect result after loading data from text file

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Hive
• Assignee: Attila Magyar
• Reporter: Attila Magyar
• Created: 26/Jul/19 11:51
• Updated: 27/Feb/24 22:23
• Resolved: 14/Sep/19 20:02

Description

Add one more load to mm_loaddata.q:

Load data 3 times (both kv1.txt and kv2.txt contains 500 records)

create table load0_mm (key string, value string) stored as textfile tblproperties("transactional"="true", "transactional_properties"="insert_only");
load data local inpath '../../data/files/kv1.txt' into table load0_mm;
select count(1) from load0_mm;
load data local inpath '../../data/files/kv2.txt' into table load0_mm;
select count(1) from load0_mm;
load data local inpath '../../data/files/kv2.txt' into table load0_mm;
select count(1) from load0_mm;

Expected output

PREHOOK: query: load data local inpath '../../data/files/kv2.txt' into table load0_mm
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@load0_mm
POSTHOOK: query: load data local inpath '../../data/files/kv2.txt' into table load0_mm
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@load0_mm
PREHOOK: query: select count(1) from load0_mm
PREHOOK: type: QUERY
PREHOOK: Input: default@load0_mm
#### A masked pattern was here ####
POSTHOOK: query: select count(1) from load0_mm
POSTHOOK: type: QUERY
POSTHOOK: Input: default@load0_mm
#### A masked pattern was here ####
1500

Got:

[ERROR]   TestMiniLlapLocalCliDriver.testCliDriver:59 Client Execution succeeded but contained differences (error code = 1) after executing mm_loaddata.q

63c63

< 1480

—

> 1500

 

Issue Links

• links to: review board