[
https://issues.apache.org/jira/browse/HIVE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13807604#comment-13807604
]
Hive QA commented on HIVE-5626:
-------------------------------
{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/12610719/HIVE-5626.patch
{color:red}ERROR:{color} -1 due to 27 failed/errored test(s), 4512 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.hwi.TestHWISessionManager.testHiveDriver
org.apache.hadoop.hive.metastore.TestHiveMetaTool.testListFSRoot
org.apache.hadoop.hive.ql.history.TestHiveHistory.testQueryloglocParentDirNotExist
org.apache.hadoop.hive.ql.metadata.TestHive.testTable
org.apache.hadoop.hive.ql.metadata.TestHiveMetaStoreChecker.testTableCheck
org.apache.hadoop.hive.ql.metadata.TestHiveRemote.testTable
org.apache.hcatalog.api.TestHCatClient.testBasicDDLCommands
org.apache.hcatalog.cli.TestPermsGrp.testCustomPerms
org.apache.hcatalog.hbase.TestHBaseHCatStorageHandler.testTableCreateDrop
org.apache.hcatalog.hbase.TestHBaseHCatStorageHandler.testTableCreateDropDifferentCase
org.apache.hcatalog.hbase.TestHCatHBaseInputFormat.TestHBaseTableReadMR
org.apache.hcatalog.hbase.TestSnapshots.TestSnapshotConversion
org.apache.hcatalog.hbase.snapshot.TestZNodeSetUp.testBasicZNodeCreation
org.apache.hcatalog.mapreduce.TestHCatInputFormat.testBadRecordHandlingFails
org.apache.hcatalog.mapreduce.TestHCatNonPartitioned.testHCatNonPartitionedTable
org.apache.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema
org.apache.hcatalog.pig.TestHCatLoaderStorer.testSmallTinyInt
org.apache.hcatalog.security.TestHdfsAuthorizationProvider.testTableOps
org.apache.hive.hcatalog.hbase.TestHBaseInputFormat.TestHBaseTableReadMR
org.apache.hive.hcatalog.hbase.TestHiveHBaseStorageHandler.testTableCreateDrop
org.apache.hive.hcatalog.hbase.TestHiveHBaseStorageHandler.testTableCreateDropDifferentCase
org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.testPigPopulation
org.apache.hive.hcatalog.mapreduce.TestHCatExternalHCatNonPartitioned.testHCatNonPartitionedTable
org.apache.hive.hcatalog.pig.TestOrcHCatLoaderComplexSchema.testSyntheticComplexSchema
org.apache.hive.service.cli.TestEmbeddedThriftBinaryCLIService.testConfOverlay
org.apache.hive.service.cli.thrift.TestThriftBinaryCLIService.testExecuteStatement
org.apache.hive.service.cli.thrift.TestThriftHttpCLIService.testExecuteStatement
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/1274/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/1274/console
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests failed with: TestsFailedException: 27 tests failed
{noformat}
This message is automatically generated.
> enable metastore direct SQL for drop/similar queries
> ----------------------------------------------------
>
> Key: HIVE-5626
> URL: https://issues.apache.org/jira/browse/HIVE-5626
> Project: Hive
> Issue Type: Improvement
> Reporter: Sergey Shelukhin
> Priority: Minor
> Attachments: HIVE-5626.patch
>
>
> Metastore direct SQL is currently disabled for any queries running inside
> external transaction (i.e. all modification queries, like dropping stuff).
> This was done to keep the strictly performance-optimization behavior when
> using Postgres, which unlike other RDBMS-es fails the tx on any syntax error;
> so, if direct SQL is broken there's no way to fall back. So, it is disabled
> for these cases.
> It is not as important because drop commands are rare, but we might want to
> address that. Either by some config setting or by making it work on
> non-postgres DBs.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
