phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Deepak_Gatt...@Dell.com>
Subject RE: How do I read all timestamp values with Phoenix
Date Sat, 13 Dec 2014 18:16:07 GMT
It’s the same problem I am facing it can store only one digit in milli seconds so it wont
work, The workaournd was do  EPOCH but that is not what I am looking at, I want to store it
in the same format I am getting and don’t want to make it a string.

Thanks
Deepak Gattala

From: Bulvik, Noam [mailto:Noam.Bulvik@teoco.com]
Sent: Saturday, December 13, 2014 11:50 AM
To: user@phoenix.apache.org
Subject: RE: How do I read all timestamp values with Phoenix

What about timestamp(3)

I am using the CSV  bulk loader tool and it seems like the milliseconds are been truncated
when data is inserted to the DB

From: Deepak_Gattala@Dell.com<mailto:Deepak_Gattala@Dell.com> [mailto:Deepak_Gattala@Dell.com]
Sent: Saturday, December 13, 2014 1:53 AM
To: user@phoenix.apache.org<mailto:user@phoenix.apache.org>; user@phoenix.incubator.apache.org<mailto:user@phoenix.incubator.apache.org>
Subject: RE: How do I read all timestamp values with Phoenix

“Cannot load Timestamp(6) from oracle  Example: 10/7/2010 3:28:58.117127 PM. the only
option currently is to load it as string and cannot apply andy date manupulations on that
column.“


Thanks
Deepak Gattala

From: Gattala, Deepak
Sent: Friday, December 12, 2014 5:50 PM
To: user@phoenix.apache.org<mailto:user@phoenix.apache.org>; user@phoenix.incubator.apache.org<mailto:user@phoenix.incubator.apache.org>
Subject: RE: How do I read all timestamp values with Phoenix

I have the same problem I have no idea how to get loaded a time stamp columns

Can you please help me because currently the date column si getting truncated when I am loading
into it

Mm/dd/yyyy HH:MM:SS 115622

Thanks
Deepak Gattala

From: Mark Kerzner [mailto:mark@elephantscale.com]
Sent: Friday, December 12, 2014 4:41 PM
To: user@phoenix.incubator.apache.org<mailto:user@phoenix.incubator.apache.org>
Subject: How do I read all timestamp values with Phoenix

Hi,

let's say I have 20 values in one column with different timestamps, can I get them all?

Thank you,
Mark
Information in this e-mail and its attachments is confidential and privileged under the TEOCO
confidentiality terms that can be reviewed here<http://www.teoco.com/email-disclaimer>.
Mime
View raw message