[
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)
