You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2015/03/19 03:31:38 UTC
[jira] [Commented] (HIVE-9675) Support START
TRANSACTION/COMMIT/ROLLBACK commands
[ https://issues.apache.org/jira/browse/HIVE-9675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14368390#comment-14368390 ]
Hive QA commented on HIVE-9675:
-------------------------------
{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/12705465/HIVE-9675.6.patch
{color:red}ERROR:{color} -1 due to 70 failed/errored test(s), 7816 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_authorization_update
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_authorization_update_own_table
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_exchange_partition
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_exchange_partition2
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_exchange_partition3
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_update_all_types
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_update_tmp_table
org.apache.hadoop.hive.cli.TestCliDriverMethods.testProcessSelectDatabase
org.apache.hadoop.hive.cli.TestCliDriverMethods.testprocessInitFiles
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_update_all_types
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_update_tmp_table
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_authorization_update_noupdatepriv
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_clusterbyorderby
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_column_rename3
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_cte_with_in_subquery
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_invalid_create_tbl2
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_invalid_select_expression
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_invalid_tbl_name
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_join_alt_syntax_comma_on
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_lateral_view_join
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_DistributeByOrderBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_PartitionBySortBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_window_boundaries
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_window_boundaries2
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_select_charliteral
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_select_star_suffix
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_show_columns2
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_show_tables_bad1
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_show_tables_bad2
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_unionClusterBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_unionDistributeBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_unionLimit
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_unionOrderBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_unionSortBy
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_uniquejoin3
org.apache.hadoop.hive.metastore.txn.TestCompactionTxnHandler.testLockNoWait
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testCheckLockAcquireAfterWaiting
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockDbLocksTable
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockEESR
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockEESW
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockESRE
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockESRSR
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockESRSW
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockSRE
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockSWSWSR
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockSWSWSW
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockSameDB
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockSamePartition
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockSameTable
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockTableLocksPartition
org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testMultipleLockWait
org.apache.hadoop.hive.ql.security.authorization.plugin.TestHiveAuthorizerCheckInvocation.testUpdateSomeColumnsUsed
org.apache.hadoop.hive.ql.security.authorization.plugin.TestHiveAuthorizerCheckInvocation.testUpdateSomeColumnsUsedExprInSet
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.majorCompactAfterAbort
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.majorCompactWhileStreaming
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.minorCompactAfterAbort
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.minorCompactWhileStreaming
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.testStatsAfterCompactionPartTbl
org.apache.hive.hcatalog.cli.TestSemanticAnalysis.testCTAS
org.apache.hive.hcatalog.cli.TestSemanticAnalysis.testInvalidateNonStringPartition
org.apache.hive.hcatalog.streaming.TestStreaming.testConcurrentTransactionBatchCommits
org.apache.hive.hcatalog.streaming.TestStreaming.testInterleavedTransactionBatchCommits
org.apache.hive.hcatalog.streaming.TestStreaming.testMultipleTransactionBatchCommits
org.apache.hive.hcatalog.streaming.TestStreaming.testRemainingTransactions
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchAbort
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchAbortAndCommit
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Delimited
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Json
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyAbort
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyCommit
{noformat}
Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3075/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3075/console
Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3075/
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: 70 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12705465 - PreCommit-HIVE-TRUNK-Build
> Support START TRANSACTION/COMMIT/ROLLBACK commands
> --------------------------------------------------
>
> Key: HIVE-9675
> URL: https://issues.apache.org/jira/browse/HIVE-9675
> Project: Hive
> Issue Type: Bug
> Components: SQL, Transactions
> Affects Versions: 0.14.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
> Attachments: HIVE-9675.6.patch
>
>
> Hive 0.14 added support for insert/update/delete statements with ACID semantics. Hive 0.14 only supports auto-commit mode. We need to add support for START TRANSACTION/COMMIT/ROLLBACK commands so that the user can demarcate transaction boundaries.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)