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