Abhishek Tripathi created PHOENIX-1604:
------------------------------------------
Summary: 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)
