[
https://issues.apache.org/jira/browse/HIVE-26144?focusedWorklogId=757613&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-757613
]
ASF GitHub Bot logged work on HIVE-26144:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 16/Apr/22 17:37
Start Date: 16/Apr/22 17:37
Worklog Time Spent: 10m
Work Description: kovjanos commented on PR #3214:
URL: https://github.com/apache/hive/pull/3214#issuecomment-1100716224
> Also, I am wondering if you tested the upgrade scripts with tables having
data. What happens to existing rows when you alter the table to introduce the
new PK column? Are they populated automatically?
mysql part (on MariaDB) was tested in production environment. Let me add the
other tests and results here...
Issue Time Tracking
-------------------
Worklog Id: (was: 757613)
Time Spent: 20m (was: 10m)
> 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: 20m
> 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.1#820001)
