[
https://issues.apache.org/jira/browse/HIVE-26144?focusedWorklogId=778641&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-778641
]
ASF GitHub Bot logged work on HIVE-26144:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 06/Jun/22 14:23
Start Date: 06/Jun/22 14:23
Worklog Time Spent: 10m
Work Description: deniskuzZ commented on code in PR #3214:
URL: https://github.com/apache/hive/pull/3214#discussion_r890202337
##########
standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0-alpha-2.derby.sql:
##########
@@ -558,7 +558,8 @@ CREATE TABLE TXN_COMPONENTS (
TC_TABLE varchar(256),
TC_PARTITION varchar(767),
TC_OPERATION_TYPE char(1) NOT NULL,
- TC_WRITEID bigint
+ TC_WRITEID bigint,
+ TC_ID bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
Review Comment:
TC_ID can't be a PRIMARY KEY as it's not unique. TXN_COMPONENTS might have a
bunch of partitions updated/inserted in the same txn.
Issue Time Tracking
-------------------
Worklog Id: (was: 778641)
Time Spent: 50m (was: 40m)
> Add keys/indexes to support highly concurrent workload
> ------------------------------------------------------
>
> Key: HIVE-26144
> URL: https://issues.apache.org/jira/browse/HIVE-26144
> Project: Hive
> Issue Type: Sub-task
> Components: Database/Schema
> Reporter: Janos Kovacs
> Assignee: Janos Kovacs
> Priority: Major
> Labels: pull-request-available
> Time Spent: 50m
> Remaining Estimate: 0h
>
> The following indexes are added to avoid full table-scan in backend rdbms:
> - primary key for COMPLETED_TXN_COMPONENTS
> - primary key for TXN_COMPONENTS
> - index for TXN_WRITE_NOTIFICATION_LOG
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
