[jira] [Created] (HIVE-15445) Subquery failing with ClassCastException

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

Jesus Camacho Rodriguez created HIVE-15445:
----------------------------------------------

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