[HIVE-21460] ACID: Load data followed by a select * query results in incorrect results

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 3.1.1, 4.0.0
• Fix Version/s: 3.1.1, 4.0.0-alpha-1
• Component/s: Transactions
• Assignee: Vaibhav Gumashta
• Reporter: Brian Goerlitz
• Created: 16/Mar/19 07:08
• Updated: 17/Nov/22 08:50
• Resolved: 20/Mar/19 23:03

Description

This affects current master as well. Created an orc file such that it spans multiple stripes and ran a simple select *, and got incorrect row counts (when comparing with select count. The problem seems to be that after split generation and creating min/max rowId for each row (note that since the loaded file is not written by Hive ACID, it does not have ROW_ID in the file; but the ROWID is applied on read by discovering min/max bounds which are used for calculating ROW_ID.rowId for each row of a split), Hive is only reading the last split.