Hi All,
I am facing abnormal scenarios with ROW_TIMESTAMP.
I created table in Phoenix as below:
CREATE TABLE DUMMY(XXX_TS TIMESTAMP NOT NULL CONSTRAINT pk PRIMARY KEY
(XXX_TS ROW_TIMESTAMP))
where "XXX_TS" is used as ROW_TIMESTAMP.
Now, I am trying to add data:
upsert into DUMMY values('2017-07-02T15:02:21.050');
upsert into DUMMY values('2017-01-02T15:02:21.050');
I am only seeing one entry.
*======================================================*
*0: jdbc:phoenix:> select * from DUMMY;*
*+--------------------------+*
*| XXX_TS |*
*+--------------------------+*
*| 2017-01-02 15:02:21.050 |*
*+--------------------------+*
*1 row selected (0.039 seconds)*
*======================================================*
Additional info:
System date of HBase & Phoenix: mar feb 7 05:57:37 CET 2017
Regards,
Dhaval Modi
[email protected]
