[jira] [Created] (HIVE-6967) Hive transaction manager fails when SQLServer is used as an RDBMS

["Alan Gates (JIRA)" <ji...@apache.org>]

Alan Gates created HIVE-6967:
--------------------------------

             Summary: 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


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)