[ https://issues.apache.org/jira/browse/HIVE-12738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070278#comment-15070278 ]
Matt McCline commented on HIVE-12738: ------------------------------------- Vectorized vertices (Map and Reduce) can by mixed -- that is the root and some number of children are vectorized but if there is a GroupBy with AVG that generated STRUCT output (count,sum) then by the old design we have VectorGroupBy generate rows and all down stream operators are non-vectorized... > subquery with NOT IN failing due to ClassCastException > ------------------------------------------------------ > > Key: HIVE-12738 > URL: https://issues.apache.org/jira/browse/HIVE-12738 > Project: Hive > Issue Type: Bug > Components: Hive > Reporter: Matt McCline > Assignee: Matt McCline > Priority: Critical > Attachments: HIVE-12738.01.patch > > > {code} > create table student( > name string, > age int, > gpa double) > create table voter( > name string, > age int, > registration string, > contributions float) > select * > from student > where not student.age in > (select age from voter) > order by age; > {code} > Fails in Tez -- Vectorized Reduce. -- This message was sent by Atlassian JIRA (v6.3.4#6332)