[
https://issues.apache.org/jira/browse/HIVE-11831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746629#comment-14746629
]
Sergey Shelukhin commented on HIVE-11831:
-----------------------------------------
Which ones? Actually now that I look there are 4 but they are for 2 versions.
Should I update main schema, txn-schema, or both? :)
What is executed e.g. for 1.2?
{noformat}
$ find . -name '*oracle.sql' | grep -v target |xargs grep -i HIVE_LOCK
./metastore/scripts/upgrade/oracle/019-HIVE-7118.oracle.sql:ALTER TABLE
HIVE_LOCKS MODIFY (
./metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql:CREATE TABLE
HIVE_LOCKS (
./metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql:CREATE INDEX
HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID);
./metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql:CREATE TABLE
HIVE_LOCKS (
./metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql:CREATE INDEX
HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID);
./metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql:CREATE
TABLE HIVE_LOCKS (
./metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql:CREATE
INDEX HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID);
./metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql:CREATE
TABLE HIVE_LOCKS (
./metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql:CREATE
INDEX HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID);
{noformat}
> TXN tables in Oracle should be created with ROWDEPENDENCIES
> -----------------------------------------------------------
>
> Key: HIVE-11831
> URL: https://issues.apache.org/jira/browse/HIVE-11831
> Project: Hive
> Issue Type: Bug
> Reporter: Sergey Shelukhin
> Assignee: Sergey Shelukhin
> Attachments: HIVE-11831.patch
>
>
> These frequently-updated tables may otherwise suffer from spurious deadlocks.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
