You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Gang Tim Liu (JIRA)" <ji...@apache.org> on 2012/08/08 02:01:36 UTC
[jira] [Created] (HIVE-3342) Hive: Query misaligned result for
Group by followed by Join with filter and skip a group-by result
Gang Tim Liu created HIVE-3342:
----------------------------------
Summary: Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result
Key: HIVE-3342
URL: https://issues.apache.org/jira/browse/HIVE-3342
Project: Hive
Issue Type: Bug
Components: Query Processor
Reporter: Gang Tim Liu
This simple Hive query would generate wrong result:
select a.key, b.k2, b.k3
from src a
join (
select key,
min(key) as k,
min(key)+1 as k1,
min(key)+2 as k2,
min(key)+3 as k3
from src
group by key
) b
on a.key=b.key and b.k1 < 5;
0 3.0 1.0
0 3.0 1.0
0 3.0 1.0
2 5.0 3.0
The right result is:
0 2.0 3.0
0 2.0 3.0
0 2.0 3.0
2 4.0 5.0
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira