[
https://issues.apache.org/jira/browse/HIVE-11831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14746639#comment-14746639
]
Sergey Shelukhin commented on HIVE-11831:
-----------------------------------------
Interesting...
{noformat}
$ f *.sql | grep -v target | grep schema |xargs grep -i HIVE_LOCK | sed -E
"s/^([^:]+).*$/\1/" | uniq
./metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql
./metastore/scripts/upgrade/derby/hive-schema-0.14.0.derby.sql
./metastore/scripts/upgrade/derby/hive-txn-schema-0.13.0.derby.sql
./metastore/scripts/upgrade/derby/hive-txn-schema-0.14.0.derby.sql
./metastore/scripts/upgrade/mssql/hive-schema-0.13.0.mssql.sql
./metastore/scripts/upgrade/mssql/hive-schema-0.14.0.mssql.sql
./metastore/scripts/upgrade/mssql/hive-schema-1.1.0.mssql.sql
./metastore/scripts/upgrade/mssql/hive-schema-1.2.0.mssql.sql
./metastore/scripts/upgrade/mssql/hive-schema-1.3.0.mssql.sql
./metastore/scripts/upgrade/mssql/hive-schema-2.0.0.mssql.sql
./metastore/scripts/upgrade/mssql/hive-txn-schema-0.13.0.mssql.sql
./metastore/scripts/upgrade/mssql/hive-txn-schema-0.14.0.mssql.sql
./metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
./metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql
./metastore/scripts/upgrade/mysql/hive-txn-schema-0.13.0.mysql.sql
./metastore/scripts/upgrade/mysql/hive-txn-schema-0.14.0.mysql.sql
./metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql
./metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql
./metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql
./metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql
./metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
./metastore/scripts/upgrade/postgres/hive-schema-0.14.0.postgres.sql
./metastore/scripts/upgrade/postgres/hive-txn-schema-0.13.0.postgres.sql
./metastore/scripts/upgrade/postgres/hive-txn-schema-0.14.0.postgres.sql
{noformat}
Should there be a separate JIRA for this? the tables are missing from all the
schemas other than mssql.
> 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.01.patch, HIVE-11831.patch
>
>
> These frequently-updated tables may otherwise suffer from spurious deadlocks.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
