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