[jira] [Reopened] (PHOENIX-1076) to_unsigned_date() function missing in sql of Phoenix

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor reopened PHOENIX-1076:
-----------------------------------


Anil tried the following query:
select * from events where dummy_date=CAST(TO_DATE('2012-12-23',
'yyyy-MM-dd') AS UNSIGNED_DATE) and id='1234' limit 50;

But, got following error:
Error: ERROR 602 (42P00): Syntax error. Missing "LPAREN" at line 1, column
30. (state=42P00,code=602)


> to_unsigned_date() function missing in sql of Phoenix
> -----------------------------------------------------
>
>                 Key: PHOENIX-1076
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1076
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Anil Gupta
>
> Hi All,
> Phoenix has a DataType Unsigned_Date but now i am unable to use these columns for filtering. For using a date column in sql query i can use to_date(). I think similarly we need to have to_unsigned_date function. Can anyone guide me how to introduce this function in sql language of Phoenix?
> -- 
> ~Anil Gupta 



--
This message was sent by Atlassian JIRA
(v6.2#6252)