hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-18201) Disable XPROD_EDGE for sq_count_check() created for scalar subqueries
Date Wed, 01 Aug 2018 03:50:00 GMT

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

Hive QA commented on HIVE-18201:
--------------------------------



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

{color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified.

{color:green}SUCCESS:{color} +1 due to 14838 tests passed

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

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
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12933841 - PreCommit-HIVE-Build

> Disable XPROD_EDGE for sq_count_check()  created for scalar subqueries
> ----------------------------------------------------------------------
>
>                 Key: HIVE-18201
>                 URL: https://issues.apache.org/jira/browse/HIVE-18201
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Nita Dembla
>            Assignee: Ashutosh Chauhan
>            Priority: Major
>         Attachments: HIVE-18201.1.patch, HIVE-18201.2.patch, HIVE-18201.3.patch, query6.explain2.out
>
>
> sq_count_check()  will either return an error at runtime or a single row. In case of
query6, the subquery has avg() function that should return a single row. Attaching the explain.

> This does not need an x-prod, because it is not useful to shuffle the big table side
for a cross-product against 1 row.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message