You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Steve Yeom (JIRA)" <ji...@apache.org> on 2018/06/01 01:07:00 UTC

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

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

Steve Yeom edited comment on HIVE-19416 at 6/1/18 1:06 AM:
-----------------------------------------------------------

1. MetaStore Schema Changes for the patch 04 of HIVE-19417
1.1 New table UPD_TXNS
   A record is created per transaction write per table.

   UPDATE_ID: primary key column, generated by Datanucleus when 
      specified at "package.jdo" as datastore-identity . 
   TBL_ID: TBLS.TBL_ID referencing column. A foreign key is created for 
      this column referencing TBLS.TBL_ID.
   STATE: this is deleted for the next patch version.
   TXN_ID: Transaction id of the transaction to insert the row.
   WRITEID_LIST: valid writeIdList for the table of the transaction

1.2 Modification for TBLS and PARTITIONS tables

    A new column TXN_ID: transaction id of the UPD_TXNS.


was (Author: steveyeom2017):
1. MetaStore Schema Changes for the patch 04 of HIVE-19147
1.1 New table UPD_TXNS
   A record is created per transaction write per table.

   UPDATE_ID: primary key column, generated by Datanucleus when 
      specified at "package.jdo" as datastore-identity . 
   TBL_ID: TBLS.TBL_ID referencing column. A foreign key is created for 
      this column referencing TBLS.TBL_ID.
   STATE: this is deleted for the next patch version.
   TXN_ID: Transaction id of the transaction to insert the row.
   WRITEID_LIST: valid writeIdList for the table of the transaction

1.2 Modification for TBLS and PARTITIONS tables

    A new column TXN_ID: transaction id of the UPD_TXNS.

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