[ https://issues.apache.org/jira/browse/PHOENIX-1707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor resolved PHOENIX-1707. ----------------------------------- Resolution: Cannot Reproduce > 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)