[jira] [Commented] (HIVE-13282) GroupBy and select operator encounter ArrayIndexOutOfBoundsException

["Matt McCline (JIRA)" <ji...@apache.org>]

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

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

[~vikram.dixit] I have attached a Q where I attempt to repro the problem but I can't seem to coax the Optimizer to do an Sorted Merge Bucket Map Join Operator....

> 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
>         Attachments: 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)