[jira] [Commented] (HIVE-19416) Create single version transactional table metastore statistics for aggregation queries

["Steve Yeom (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-19416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16498341#comment-16498341 ] 

Steve Yeom commented on HIVE-19416:
-----------------------------------

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)