[ https://issues.apache.org/jira/browse/HIVE-21460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16796113#comment-16796113 ]
Victor Corral commented on HIVE-21460: -------------------------------------- http://mail-archives.apache.org/mod_mbox/infra-issues/201903.mbox/raw/<jira.13222138.1552820633000.74797.1552877220...@atlassian.jira>.com] > ACID: Load data followed by a select * query results in incorrect results > ------------------------------------------------------------------------- > > Key: HIVE-21460 > URL: https://issues.apache.org/jira/browse/HIVE-21460 > Project: Hive > Issue Type: Bug > Components: Transactions > Affects Versions: 4.0.0, 3.1.1 > Reporter: Vaibhav Gumashta > Assignee: Vaibhav Gumashta > Priority: Blocker > Attachments: HIVE-21460.1.patch > > > 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 ROW__ID 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)