[
https://issues.apache.org/jira/browse/HIVE-6967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-6967:
-----------------------------------
Resolution: Fixed
Fix Version/s: 0.14.0
Status: Resolved (was: Patch Available)
Committed to trunk. Thanks, Alan!
> 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
> Fix For: 0.14.0
>
> 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)
