hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Yeom (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-19416) Create single version transactional table metastore statistics for aggregation queries
Date Thu, 31 May 2018 16:28:00 GMT

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

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

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)

Mime
View raw message