phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ankit beohar <ankitbeoha...@gmail.com>
Subject Phoenix and HBase data type serialization issue
Date Wed, 24 Aug 2016 07:40:56 GMT
HI All,

I have table in HBase and putting data into it then create phoenix view
with date, bigint etc data types but when I query from phoenix its giving
me wrong values I tried unassigned data types also but not working below
are stack:-

==========Hbase===========
hbase(main):057:0> create 'CEHCK_DT','0'
0 row(s) in 2.2650 seconds

=> Hbase::Table - CEHCK_DT
hbase(main):058:0> put 'CEHCK_DT','row1','0:dates','2016-08-11'
0 row(s) in 0.0080 seconds

hbase(main):059:0> scan 'CEHCK_DT'
ROW                                                          COLUMN+CELL
 row1
 column=0:dates, timestamp=1471930977145, value=2016-08-11
1 row(s) in 0.0100 seconds


=========Phoenix=============
0: jdbc:phoenix:localhost:2181> create table "CEHCK_DT"(pk varchar primary
key,"0"."dates" date,"0"."SALARY" bigint);
No rows affected (0.347 seconds)
0: jdbc:phoenix:localhost:2181> select "0"."dates" from "CEHCK_DT";
+-------------------------------+
|             dates             |
+-------------------------------+
| 177670840-04-13 05:44:22.317  |
| 177670840-04-13 05:44:22.317  |
| 177670840-04-13 05:44:22.317  |
+-------------------------------+



Best Regards,
ANKIT BEOHAR

Mime
View raw message