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