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

Posted to dev@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2014/09/23 00:20:34 UTC

[jira] [Created] (HIVE-8225) CBO trunk merge: union11 test fails due to incorrect plan

Sergey Shelukhin created HIVE-8225:
--------------------------------------

             Summary: CBO trunk merge: union11 test fails due to incorrect plan
                 Key: HIVE-8225
                 URL: https://issues.apache.org/jira/browse/HIVE-8225
             Project: Hive
          Issue Type: Bug
            Reporter: Sergey Shelukhin
            Assignee: Sergey Shelukhin


The result changes to as if the union didn't have count() inside. The issue can be fixed by using srcunion.value outside the subquery in count (replace count(1) with count(srcunion.value)). Otherwise, it looks like count(1) node from union-ed queries is not present in AST at all, which might cause this result.

Interestingly, adding group by to each query in a union produces completely weird result (count(1) is 309 for each key, whereas it should be 1 and the "logical" incorrect value if internal count is lost is 500)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)