You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Abhishek Sreenivasa (JIRA)" <ji...@apache.org> on 2015/04/14 23:55:58 UTC

[jira] [Assigned] (PHOENIX-1707) Compare (where) DATE<> UNSIGNED_DATE raise NPE

     [ https://issues.apache.org/jira/browse/PHOENIX-1707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Abhishek Sreenivasa reassigned PHOENIX-1707:
--------------------------------------------

    Assignee: Abhishek Sreenivasa

> Compare (where) DATE<> UNSIGNED_DATE raise NPE
> ----------------------------------------------
>
>                 Key: PHOENIX-1707
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1707
>             Project: Phoenix
>          Issue Type: Bug
>         Environment: Phoenix 4.3, hbase 0.98.6
>            Reporter: Lavrenty Eskin
>            Assignee: Abhishek Sreenivasa
>              Labels: Newbie
>
> select
>     FLOOR(REGDATE, 'DAY'),                                <<== UNSIGNED_DATE
>    TO_DATE('2015-03-06', 'yyyy-MM-dd')              <<== DATE
> from
>     "ALARMSHISTORY" as "ALARMSHISTORY"
> where
>  FLOOR(REGDATE, 'DAY') = TO_DATE('2015-03-06', 'yyyy-MM-dd'); <<== raise java.lang.NullPointerException
> (!) There are no NULLs in REGDATE
> Ways to resolve:
> a) Implement TO_UNSIGNED_DATE function
> b) Implement correct compare function DATE<> UNSIGNED_DATE



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