[ https://issues.apache.org/jira/browse/HIVE-19416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16498341#comment-16498341 ]
Steve Yeom edited comment on HIVE-19416 at 6/1/18 7:05 PM: ----------------------------------------------------------- Based on the talk with Ashutosh Chauhan, Sergey Shelukhin, Eugene Koifman, and I. 1. I will check and implement concurrent insert case detection and resolution based on txn_id (first version shall make the CSA state false, the next version may make the case have the CSA state true). 2. Hive aborted transaction case should turn the CSA state false. 3. I will explore (and implement if it does not cause any issue) the possibility of using CSA state at TBLS/PARTITIONS instead of keeping UPD_TXNS, which will simplify implementation. The basis of this is the invariant item that Metastore TBLS/PARTITIONS keeps CSA updated for transactional stats in Metastore for both table and its columns. was (Author: steveyeom2017): Based on the talk with Ashutosh Chauhan, Sergey Shelukhin, Eugene Koifman, and I. 1. I will check and implement concurrent insert case detection and resolution based on txn_id (first version shall make the CSA state false, the next version may make the case have the CSA state true). 2. Hive aborted transaction case should turn the CSA state false. 3. I will explore (and implement if it does not cause any issue) the possibility of using CSA state at TBLS/PARTITIONS instead of keeping UPD_TXNS, which will simplify implementation. The basis of this is the invariant item that Metastore TBLS/PARTITIONS keeps CSA updated for committed stats for both transactional table and its columns. > Create single version transactional table metastore statistics for > aggregation queries > -------------------------------------------------------------------------------------- > > Key: HIVE-19416 > URL: https://issues.apache.org/jira/browse/HIVE-19416 > Project: Hive > Issue Type: Bug > Components: Transactions > Reporter: Steve Yeom > Assignee: Steve Yeom > Priority: Major > > The system should use only statistics for aggregation queries like count on > transactional tables. -- This message was sent by Atlassian JIRA (v7.6.3#76005)