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

2014-06-20 Thread Ashutosh Chauhan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-6967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14038958#comment-14038958
 ] 

Ashutosh Chauhan commented on HIVE-6967:


+1

 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)

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

2014-06-19 Thread Alan Gates (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-6967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)

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

2014-05-24 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-6967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14008286#comment-14008286
 ] 

Hive QA commented on HIVE-6967:
---



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12646620/HIVE-6967.patch

{color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 5462 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_parquet_decimal1
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_root_dir_external_table
org.apache.hadoop.hive.metastore.TestMetastoreVersion.testDefaults
org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimal
org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimalX
org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimalXY
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/286/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/286/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-Build-286/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 6 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12646620

 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)