hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-6967) Hive transaction manager fails when SQLServer is used as an RDBMS
Date Fri, 23 May 2014 22:20:01 GMT

     [ 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)

Mime
View raw message