[jira] [Updated] (HIVE-3343) Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result
[ https://issues.apache.org/jira/browse/HIVE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3343: - Resolution: Fixed Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committed. Thanks Tim Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result -- Key: HIVE-3343 URL: https://issues.apache.org/jira/browse/HIVE-3343 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Gang Tim Liu Assignee: Gang Tim Liu Attachments: hive-3343.patch 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
[jira] [Updated] (HIVE-3343) Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result
[ https://issues.apache.org/jira/browse/HIVE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gang Tim Liu updated HIVE-3343: --- Attachment: hive-3343.patch Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result -- Key: HIVE-3343 URL: https://issues.apache.org/jira/browse/HIVE-3343 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Gang Tim Liu Assignee: Gang Tim Liu Attachments: hive-3343.patch 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
[jira] [Updated] (HIVE-3343) Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result
[ https://issues.apache.org/jira/browse/HIVE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gang Tim Liu updated HIVE-3343: --- Status: Patch Available (was: Open) patch is submitted. Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result -- Key: HIVE-3343 URL: https://issues.apache.org/jira/browse/HIVE-3343 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Gang Tim Liu Assignee: Gang Tim Liu Attachments: hive-3343.patch 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
