hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukas Waldmann (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17332) NullPointer exception when processing query
Date Mon, 21 Aug 2017 11:53:00 GMT

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

Lukas Waldmann commented on HIVE-17332:
---------------------------------------

Hi Zoltan,
snapshot is indeed partitioning column in my DB and is of type DATE.
Your sample fails on my DB with the same error. However in my db there is no null value in
snapshot column.
So I actually tried your sample with only 'asd' row.
And guess what, query fails with the same error

we are using hive 1.2.1 and I don't think we will move to latest version anytime soon :(



> NullPointer exception when processing query
> -------------------------------------------
>
>                 Key: HIVE-17332
>                 URL: https://issues.apache.org/jira/browse/HIVE-17332
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.2.1
>            Reporter: Lukas Waldmann
>
> Hive query:
> {code}
> select count(*) from (select * from EXM_BASE_DATA, (select max(snapshot) max_snapshot
from EXM_BASE_DATA) s0 where snapshot == max_snapshot) t;
> {code}
> finish with NullPointer exception
> while 
> {code}
> select * from EXM_BASE_DATA, (select max(snapshot) max_snapshot from EXM_BASE_DATA) s0
where snapshot == max_snapshot
> {code}
> is executed without error



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message