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
