[ https://issues.apache.org/jira/browse/HIVE-15445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-15445 started by Jesus Camacho Rodriguez. ------------------------------------------------------ > Subquery failing with ClassCastException > ---------------------------------------- > > Key: HIVE-15445 > URL: https://issues.apache.org/jira/browse/HIVE-15445 > Project: Hive > Issue Type: Bug > Affects Versions: 2.2.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > > To reproduce: > {code:sql} > CREATE TABLE table_7 (int_col INT); > SELECT > (t1.int_col) * (t1.int_col) AS int_col > FROM ( > SELECT > MIN(NULL) OVER () AS int_col > FROM table_7 > ) t1 > WHERE > (False) NOT IN (SELECT > False AS boolean_col > FROM ( > SELECT > MIN(NULL) OVER () AS int_col > FROM table_7 > ) tt1 > WHERE > (t1.int_col) = (tt1.int_col)); > {code} > The problem seems to be in the method that tries to resolve the subquery > column _MIN(NULL)_. It checks the column inspector and ends up returning a > constant descriptor instead of a column descriptor for _min(null)_. -- This message was sent by Atlassian JIRA (v6.3.4#6332)