[jira] [Resolved] (PHOENIX-1604) Phoenix View table changes the underline numerical Data in Hbase

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

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

James Taylor resolved PHOENIX-1604.
-----------------------------------
    Resolution: Not a Problem

Best to ask questions on the mailing list.

> Phoenix View table changes the underline  numerical Data in Hbase
> -----------------------------------------------------------------
>
>                 Key: PHOENIX-1604
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1604
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.2
>         Environment: Hbase 0.98.0.1
> Phoenix 4.2.2
>            Reporter: Abhishek Tripathi
>
> Hi,
> I have created Hbase table EMP which has column family f1 and and ID as rowkey and NAME as another field.
> When I create Phoenix View on top of this Hbase table as
> CREATE view EMP(ID INTEGER NOT NULL PRIMARY KEY, NAME VARCHAR(40)); and run selelect state, Phoenix view shows Negative values for ID column.
> Actual value in Hbase is  like
> 101,102,103...
> but when I run "select id from EMP" in Phoenix, i get values as
> -101
> -102
> -103
> I tried to change data type for ID from Integer to Unassigned_Int which completely change the actual value of ID.
> it comes  as 
> 32423
> 23429
> 12432
> Can you please advise on how to define Primary Key in Phoenix as numerical value, not varchar as  i will perform Sum(id) on it and Sum() wont work on Varchar.
> I also tried to use Cast function in Phoenix, but that function is not able cast Varchar to Integer. 
> Thanks,
> Abhishek



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