Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id DF007200BC2 for ; Thu, 3 Nov 2016 05:30:26 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id DDB77160B0A; Thu, 3 Nov 2016 04:30:26 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 27C8A160AFB for ; Thu, 3 Nov 2016 05:30:26 +0100 (CET) Received: (qmail 79189 invoked by uid 500); 3 Nov 2016 04:30:24 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 79180 invoked by uid 99); 3 Nov 2016 04:30:24 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Nov 2016 04:30:24 +0000 Received: from [192.168.2.108] (adsl-71-145-210-73.dsl.austtx.sbcglobal.net [71.145.210.73]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 3E4E11A018B for ; Thu, 3 Nov 2016 04:30:23 +0000 (UTC) User-Agent: Microsoft-MacOutlook/f.19.0.160817 Date: Wed, 02 Nov 2016 21:30:22 -0700 Subject: Re: a GROUP BY that is not fully grouping From: Gopal Vijayaraghavan Sender: Gopal Vijayaraghavan To: "user@hive.apache.org" Message-ID: <553885C5-C25A-4AF9-9781-0A3FD6D58E34@hortonworks.com> Thread-Topic: a GROUP BY that is not fully grouping References: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="UTF-8" Content-transfer-encoding: 7bit archived-at: Thu, 03 Nov 2016 04:30:27 -0000 > Attached (assuming attachments actually work on this list) are three explains: .. > TungstenAggregate(key=[artid#5,artorsec#0,page#11,geo#12, The explain plan shows you are not using Hive-on-Spark, but SparkSQL. > If you'd like any other info, or if you'd like me to test with other versions of Spark or whatever, please let me know. This bug needs to be reported on the Spark lists or JIRA (Spark calls its SQL part HiveContext, but it is not related to this list). You can also check their existing bugs before reporting it - https://issues.apache.org/jira/browse/SPARK Cheers, Gopal