No problem, Deepak. I'll comment on the JIRA.
On Sat, Dec 13, 2014 at 10:27 AM, <[email protected]> wrote: > 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.
