hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15445) Subquery failing with ClassCastException
Date Fri, 16 Dec 2016 16:55:58 GMT

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

Jesus Camacho Rodriguez commented on HIVE-15445:
------------------------------------------------

It seems it was introduced in HIVE-9195. I think the method used to create a ColumnExprDesc
from a ColumnInfo should not check the object inspectors for constants; there are other methods
in Hive that take care of that.

I am submitting a patch that disables the check of the object inspectors when we are creating
the ColumnExprDesc from the ColumnInfo. If other methods take care of that indeed, then we
should not see ptest failures...

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

Mime
View raw message