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)
