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] [Comment Edited] (HIVE-15445) Subquery failing with ClassCastException
Date Fri, 16 Dec 2016 16:57: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 edited comment on HIVE-15445 at 12/16/16 4:57 PM:
--------------------------------------------------------------------------

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 that check. If other methods take care of that indeed,
then we should not see ptest failures...


was (Author: jcamachorodriguez):
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
>         Attachments: HIVE-15445.patch
>
>
> 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 expression instead of a column
expression for _min(null)_.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message