[
https://issues.apache.org/jira/browse/HIVE-6967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alan Gates updated HIVE-6967:
-----------------------------
Attachment: HIVE-6967.patch
A patch that changes the transaction manager to use serializable isolation
instead of select for update. Each operation is allowed to select whether it
wants serializable (which ones that used to use select for update use) or read
committed (for other operations).
> Hive transaction manager fails when SQLServer is used as an RDBMS
> -----------------------------------------------------------------
>
> Key: HIVE-6967
> URL: https://issues.apache.org/jira/browse/HIVE-6967
> Project: Hive
> Issue Type: Bug
> Components: Locking
> Affects Versions: 0.13.0
> Reporter: Alan Gates
> Assignee: Alan Gates
> Attachments: HIVE-6967.patch
>
>
> When using SQLServer as an RDBMS for the metastore, any transaction or
> DbLockMgr operations fail with:
> {code}
> MetaException(message:Unable to select from transaction database
> com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE clause
> allowed only for DECLARE CURSOR.
> {code}
> The issue is that SQLServer does not support the FOR UPDATE clause in SELECT.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
