Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Fri, 20 Jan 2017 20:58:27 +0000 (UTC)
From: "Matt McCline (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12950070.1457991280000.66415.1484945907355@Atlassian.JIRA>
In-Reply-To: <JIRA.12950070.1457991280000@Atlassian.JIRA>
References: <JIRA.12950070.1457991280000@Atlassian.JIRA> <JIRA.12950070.1457991280851@jira-lw-us.apache.org>
Subject: [jira] [Commented] (HIVE-13282) GroupBy and select operator
 encounter ArrayIndexOutOfBoundsException
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 20 Jan 2017 20:58:37 -0000


    [ https://issues.apache.org/jira/browse/HIVE-13282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15832388#comment-15832388 ] 

Matt McCline commented on HIVE-13282:
-------------------------------------

Vikram had worked on it.  I took over.  There were 2 issues I recall.  One was the index out of bounds but when that was fixed another issue wrong results appeared.  It had to do with handling of operator close when there are multiple parents.  I wasn't able to work that one very well.

> GroupBy and select operator encounter ArrayIndexOutOfBoundsException
> --------------------------------------------------------------------
>
>                 Key: HIVE-13282
>                 URL: https://issues.apache.org/jira/browse/HIVE-13282
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 1.2.1, 2.0.0, 2.1.0
>            Reporter: Vikram Dixit K
>            Assignee: Matt McCline
>            Priority: Blocker
>         Attachments: HIVE-13282.01.patch, smb_fail_issue.patch, smb_groupby.q, smb_groupby.q.out
>
>
> The group by and select operators run into the ArrayIndexOutOfBoundsException when they incorrectly initialize themselves with tag 0 but the incoming tag id is different.
> {code}
> select count(*) from
> (select rt1.id from
> (select t1.key as id, t1.value as od from tab t1 group by key, value) rt1) vt1
> join
> (select rt2.id from
> (select t2.key as id, t2.value as od from tab_part t2 group by key, value) rt2) vt2
> where vt1.id=vt2.id;
> {code}


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