[
https://issues.apache.org/jira/browse/HIVE-6967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14037842#comment-14037842
]
Alan Gates commented on HIVE-6967:
----------------------------------
Failed tests pass when run locally, except for root_dir_external_table which
fails against trunk, so I don't think any of these failures relate to this
patch.
> 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)
