question Re: Phoenix timestamp dropping digits in Archives of Support Questions (Read Only)

Phoenix timestamp dropping digits

sunile_manjee — Mon, 14 Mar 2016 22:05:30 GMT

I have timestamp : 2011-08-28 20:03:01.554797

The last 3 digit fall off when I use timestamp or timestamp (26). I only see the value in whole when I use char(26) but that does not help me. Here are my results:

timestamp --> 2011-08-28 20:03:01.554

timestamp (26) --> 2011-08-28 20:03:01.554

char(26) --> 2011-08-28 20:03:01.554797

Re: Phoenix timestamp dropping digits

nsabharwal — Tue, 15 Mar 2016 00:57:50 GMT

@Sunile Manjee

See this http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0-Win/bk_HDP_RelNotes_Win/content/known-issues-230.html

Hortonworks Bug ID

BUG-37042

Re: Phoenix timestamp dropping digits

sunile_manjee — Tue, 15 Mar 2016 01:14:31 GMT

@Neeraj Sabharwal The bug is for hive. I am experiencing this issue with phoenix.

Re: Phoenix timestamp dropping digits

nsabharwal — Tue, 15 Mar 2016 01:42:35 GMT

@Sunile Manjee

It may be related to client time zone

TIMESTAMP

The timestamp data type. The format is yyyy-MM-dd hh:mm:ss[.nnnnnnnnn]. Mapped to java.sql.Timestamp with an internal representation of the number of nanos from the epoch. The binary representation is 12 bytes: an 8 byte long for the epoch time plus a 4 byte integer for the nanos. Note that the internal representation is based on a number of milliseconds since the epoch (which is based on a time in GMT), while java.sql.Timestamp will format timestamps based on the client's local time zone.

Example:

TIMESTAMP

Re: Phoenix timestamp dropping digits

sunile_manjee — Tue, 15 Mar 2016 01:51:05 GMT

@Neeraj Sabharwal I am not sure I completely follow. The sql is being run from phoenix command line. Being so isn't the client should it use epoch? If not how to validate?