Hi James, I apologize for getting confused between 2 things not I realized after looking at email they are not connected, but I tried the work arounds still I was not able to have success on loading timestamp. If you have a sample of how it can be achieved please kindly share a example.
It would be great help. Thanks Deepak Gattala -----Original Message----- From: James Taylor [mailto:[email protected]] Sent: Saturday, December 13, 2014 12:25 PM To: user Subject: Re: How do I read all timestamp values with Phoenix Hi Deepak & Noam, The issue to which you're referring, PHOENIX-1127, is specific to the CSV bulk loader and is not directly related to Mark's original question. Let's discuss that on the JIRA. Please let me know there if you've tried the workarounds I've mentioned. Also, if you could comment on Gabriel's idea for a fix, that'd be great too. Thanks, James On Sat, Dec 13, 2014 at 10:16 AM, <[email protected]> wrote: > 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:[email protected]] > Sent: Saturday, December 13, 2014 11:50 AM > To: [email protected] > > > 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: [email protected] [mailto:[email protected]] > Sent: Saturday, December 13, 2014 1:53 AM > To: [email protected]; [email protected] > 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: [email protected]; [email protected] > 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:[email protected]] > Sent: Friday, December 12, 2014 4:41 PM > To: [email protected] > 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.
