Re:Re: bulk update data in phoenix

2014-12-12 Thread 乔凯
ok,i saw it in blew page。 which hbase version it fit? in addition,where is the api doc ? I can not find it。 At 2014-12-12 15:00:19, Ravi Kiran maghamraviki...@gmail.com wrote: Hi Apparently, the support for MR jobs was submitted few days ago as part of

Re: Re: bulk update data in phoenix

2014-12-12 Thread Ravi Kiran
Hi , Absolutely my bad. There is no documentation at this point. For the time being, an example MR job using the InputFormat/OutputFormat classes is available at https://gist.github.com/mravi/a340200bfef66192bf52. The code is available at 3.3.0-SNAPSHOT , 4.3.0-SNAPSHOT and the master

Re: Query performance question

2014-12-12 Thread Maryann Xue
Hi Ralph, Thanks for the question! According to the explain result you got, the optimization worked exactly as expected with this query: DYNAMIC SERVER FILTER BY FILE_ID IN (SS.FILE_ID) means a skip-scan instead of a full-scan over BULK_TABLE will be executed at runtime based on the values of

Re: Phoenix loading via psql.py - specifying tab separator

2014-12-12 Thread Gabriel Reid
On Fri, Dec 12, 2014 at 1:48 AM, James Taylor jamestay...@apache.org wrote: Thanks for that somewhat tricky workaround, Gabriel. Might be worth filing a JIRA to see if we could support specifying \t for tab if it's easy/feasible? Sounds good, I've filed PHOENIX-1523 to improve setting a tab

Re: Phoenix loading via psql.py - specifying tab separator

2014-12-12 Thread Perko, Ralph J
I have encountered the same issue with the CsvBulkLoadTool and used the same workaround On 12/12/14, 11:53 AM, Gabriel Reid gabriel.r...@gmail.com wrote: On Fri, Dec 12, 2014 at 1:48 AM, James Taylor jamestay...@apache.org wrote: Thanks for that somewhat tricky workaround, Gabriel. Might be

How do I read all timestamp values with Phoenix

2014-12-12 Thread Mark Kerzner
Hi, let's say I have 20 values in one column with different timestamps, can I get them all? Thank you, Mark

RE: How do I read all timestamp values with Phoenix

2014-12-12 Thread Deepak_Gattala
“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: