[ 
https://issues.apache.org/jira/browse/HIVE-17346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16130705#comment-16130705
 ] 

Hive QA commented on HIVE-17346:
--------------------------------



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

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 10977 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[orc_merge7] 
(batchId=162)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_dynamic_partition_pruning_mapjoin_only]
 (batchId=170)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_vectorized_dynamic_partition_pruning]
 (batchId=169)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] 
(batchId=235)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] 
(batchId=235)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema
 (batchId=180)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema
 (batchId=180)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation 
(batchId=180)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/6437/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/6437/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-6437/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 8 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12882359 - PreCommit-HIVE-Build

> TestMiniSparkOnYarnCliDriver[spark_dynamic_partition_pruning] is failing 
> every time
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-17346
>                 URL: https://issues.apache.org/jira/browse/HIVE-17346
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Test
>    Affects Versions: 3.0.0
>            Reporter: Peter Vary
>            Assignee: Peter Vary
>         Attachments: HIVE-17346.patch
>
>
> The TestMiniSparkOnYarnCliDriver.testCliDriver - 
> spark_dynamic_partition_pruning is failing with this diff:
> {code}
> Client Execution succeeded but contained differences (error code = 1) after 
> executing spark_dynamic_partition_pruning.q 
> 714c714
> <                   filterExpr: ((date = '2008-04-08') and abs(((- 
> UDFToLong(concat(UDFToString(day(ds)), '0'))) + 10)) is not null) (type: 
> boolean)
> ---
> >                   filterExpr: ((date = '2008-04-08') and ds is not null) 
> > (type: boolean)
> 717c717
> <                     predicate: ((date = '2008-04-08') and abs(((- 
> UDFToLong(concat(UDFToString(day(ds)), '0'))) + 10)) is not null) (type: 
> boolean)
> ---
> >                     predicate: ((date = '2008-04-08') and ds is not null) 
> > (type: boolean)
> 749c749
> <                   filterExpr: abs(((- 
> UDFToLong(concat(UDFToString(day(ds)), '0'))) + 10)) is not null (type: 
> boolean)
> ---
> >                   filterExpr: ds is not null (type: boolean)
> 751,752c751,753
> <                   Filter Operator
> <                     predicate: abs(((- 
> UDFToLong(concat(UDFToString(day(ds)), '0'))) + 10)) is not null (type: 
> boolean)
> ---
> >                   Select Operator
> >                     expressions: ds (type: string)
> >                     outputColumnNames: _col0
> 754,756c755,758
> <                     Select Operator
> <                       expressions: ds (type: string)
> <                       outputColumnNames: _col0
> ---
> >                     Reduce Output Operator
> >                       key expressions: abs(((- 
> > UDFToLong(concat(UDFToString(day(_col0)), '0'))) + 10)) (type: bigint)
> >                       sort order: +
> >                       Map-reduce partition columns: abs(((- 
> > UDFToLong(concat(UDFToString(day(_col0)), '0'))) + 10)) (type: bigint)
> 758,762d759
> <                       Reduce Output Operator
> <                         key expressions: abs(((- 
> UDFToLong(concat(UDFToString(day(_col0)), '0'))) + 10)) (type: bigint)
> <                         sort order: +
> <                         Map-reduce partition columns: abs(((- 
> UDFToLong(concat(UDFToString(day(_col0)), '0'))) + 10)) (type: bigint)
> <                         Statistics: Num rows: 2000 Data size: 21248 Basic 
> stats: COMPLETE Column stats: NONE
> 767c764
> <          
> Output was too long and had to be truncated...
> {code}
> I think it is caused by:
> HIVE-17148 - Incorrect result for Hive join query with COALESCE in WHERE 
> condition
> [~allgoodok]: Am I right? Is it an intended change and only the golden file 
> regeneration is needed?
> Thanks,
> Peter



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to