You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2023/02/16 20:31:00 UTC

[jira] [Commented] (HIVE-26659) TPC-DS query 16, 69, 94 return wrong results.

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

Steve Carlin commented on HIVE-26659:
-------------------------------------

First cut, I was unable to produce this in my environment, though I am using a branch of Hive with the anti.join patch cherry-picked on.

A couple of questions (and I think you may have mentioned this in other related Jiras)

- What size is the TPCDS dataset (1TB?)
- I assume you ran with hive.auto.convert.anti.join= false and it worked?
- Did you run ANALYZE STATS?  Does it make a difference?
- Can you attach the explain plans (regular, CBO, and extended)?  
- I assume this was a wrong result error as opposed to a compilation error?

Thanks!

> TPC-DS query 16, 69, 94 return wrong results.
> ---------------------------------------------
>
>                 Key: HIVE-26659
>                 URL: https://issues.apache.org/jira/browse/HIVE-26659
>             Project: Hive
>          Issue Type: Sub-task
>    Affects Versions: 4.0.0-alpha-2
>            Reporter: Sungwoo Park
>            Priority: Major
>
> TPC-DS query 16, 69, 94 return wrong results when hive.auto.convert.anti.join is set to true.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)