phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dhaval Modi <dhavalmod...@gmail.com>
Subject ROW_TIMESTAMP weird behaviour
Date Tue, 07 Feb 2017 04:58:32 GMT
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
dhavalmodi24@gmail.com

Mime
View raw message