You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Alan Gates (JIRA)" <ji...@apache.org> on 2014/05/24 00:20:01 UTC
[jira] [Updated] (HIVE-6967) Hive transaction manager fails when
SQLServer is used as an RDBMS
[ 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)