[
https://issues.apache.org/jira/browse/HIVE-6967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alan Gates updated HIVE-6967:
-----------------------------
Status: Patch Available (was: Open)
> 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)
