[
https://issues.apache.org/jira/browse/HIVE-17900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16270453#comment-16270453
]
Hive QA commented on HIVE-17900:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12899719/HIVE-17900.01.patch
{color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 9 failed/errored test(s), 11414 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestHBaseNegativeCliDriver.testCliDriver[generatehfiles_require_family_path]
(batchId=242)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[hybridgrace_hashjoin_2]
(batchId=154)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata]
(batchId=162)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[resourceplan]
(batchId=160)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb]
(batchId=157)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConstraints
(batchId=224)
org.apache.hive.jdbc.TestSSL.testConnectionMismatch (batchId=230)
org.apache.hive.jdbc.TestSSL.testConnectionWrongCertCN (batchId=230)
org.apache.hive.jdbc.TestSSL.testMetastoreConnectionWrongCertCN (batchId=230)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/8039/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/8039/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-8039/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 9 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12899719 - PreCommit-HIVE-Build
> analyze stats on columns triggered by Compactor generates malformed SQL with
> > 1 partition column
> -------------------------------------------------------------------------------------------------
>
> Key: HIVE-17900
> URL: https://issues.apache.org/jira/browse/HIVE-17900
> Project: Hive
> Issue Type: Bug
> Components: Transactions
> Affects Versions: 1.0.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
> Attachments: HIVE-17900.01.patch
>
>
> {noformat}
> 2017-10-16 09:01:51,255 ERROR [haddl0007.mycenterpointenergy.com-51]:
> ql.Driver (SessionState.java:printError(993)) - FAILED: ParseException line
> 1:70 mismatched input 'dates' expecting ) near ''201608'' in analyze statement
> org.apache.hadoop.hive.ql.parse.ParseException: line 1:70 mismatched input
> 'dates' expecting ) near ''201608'' in analyze statement
> at
> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:205)
> at
> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:438)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:321)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1221)
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1262)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1158)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1148)
> at
> org.apache.hadoop.hive.ql.txn.compactor.Worker$StatsUpdater.gatherStats(Worker.java:294)
> at
> org.apache.hadoop.hive.ql.txn.compactor.CompactorMR.run(CompactorMR.java:265)
> at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:168)
> 2017-10-16 09:01:51,255 INFO [haddl0007.mycenterpointenergy.com-51]:
> log.PerfLogger (PerfLogger.java:PerfLogEnd(177)) - </PERFLOG method=compile
> start=1508162511253 end=1508162511255 duration=2
> from=org.apache.hadoop.hive.ql.Driver>
> 2017-10-16 09:01:51,255 INFO [haddl0007.mycenterpointenergy.com-51]:
> ql.Driver (Driver.java:compile(559)) - We are resetting the hadoop caller
> context to
> 2017-10-16 09:01:51,255 INFO [haddl0007.mycenterpointenergy.com-51]:
> log.PerfLogger (PerfLogger.java:PerfLogBegin(149)) - <PERFLOG
> method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
> 2017-10-16 09:01:51,255 INFO [haddl0007.mycenterpointenergy.com-51]:
> log.PerfLogger (PerfLogger.java:PerfLogEnd(177)) - </PERFLOG
> method=releaseLocks start=1508162511255 end=1508162511255 duration=0
> from=org.apache.hadoop.hive.ql.Driver>
> 2017-10-16 09:01:51,256 INFO [haddl0007.mycenterpointenergy.com-51]:
> tez.TezSessionPoolManager (TezSessionPoolManager.java:close(183)) - Closing
> tez session default? false
> 2017-10-16 09:01:51,256 INFO [haddl0007.mycenterpointenergy.com-51]:
> tez.TezSessionState (TezSessionState.java:close(294)) - Closing Tez Session
> 2017-10-16 09:01:51,256 INFO [haddl0007.mycenterpointenergy.com-51]:
> client.TezClient (TezClient.java:stop(518)) - Shutting down Tez Session,
> sessionName=HIVE-ae652f03-72c7-4ca8-a2d8-05dcc7392f4f,
> applicationId=application_1507779664083_0159
> 2017-10-16 09:01:51,279 ERROR [haddl0007.mycenterpointenergy.com-51]:
> compactor.Worker (Worker.java:run(191)) - Caught exception while trying to
> compact
> id:3723,dbname:mobiusad,tableName:zces_img_data_small_pt,partName:month=201608/dates=9,state:^@,type:MAJOR,properties:null,runAs:null,tooManyAborts:false,highestTxnId:0.
> Marking failed to avoid repeated failures, java.io.IOException: Could not
> update stats for table mobiusad.zces_img_data_small_pt/month=201608/dates=9
> due to: (40000,FAILED: ParseException line 1:70 mismatched input 'dates'
> expecting ) near ''201608'' in analyze statement,42000line 1:70 mismatched
> input 'dates' expecting ) near ''201608'' in analyze statement)
> at
> org.apache.hadoop.hive.ql.txn.compactor.Worker$StatsUpdater.gatherStats(Worker.java:296)
> at
> org.apache.hadoop.hive.ql.txn.compactor.CompactorMR.run(CompactorMR.java:265)
> at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:168)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
