Re: How do How do the operation Tephra

how about using HBase ?? whether it can use HBase directly? 2015-12-04 2:37 GMT+07:00 Thomas D'Silva : > If you checkout the latest 4.x or master branch (depending on which > HBase version you use), you can test using transactions in Phoenix. > Tephra is used for

Re: Phoenix Query Server Placement

You mean https://phoenix.apache.org/server.html? I am not sure it's really heavy, so I would suggest to run it closest from HBase server. 2015-12-04 15:59 GMT+01:00 Andreas Fritzler : > Hi, > > What is the best place to install the Phoenix Query Server within an HDP

Re: Help tuning for bursts of high traffic?

Hi Zack, Did you consider avoiding hitting hbase for every single row by doing that step in an offline mode? I was thinking if you could have some kind of daily export of hbase table and then use pig to perform join (co-group perhaps) to do the same. Obviously this would work only when your hbase

RE: Help tuning for bursts of high traffic?

Thanks Satish, To clarify: I’m not looking up single rows. I’m looking up the history of each widget, which returns hundreds-to-thousands of results per widget (per query). Each query is a range scan, it’s just that I’m performing thousands of them. From: Satish Iyengar

Re: Help tuning for bursts of high traffic?

Zack, Thanks for reporting this and for the detailed description. Here's a bunch of questions and some things you can try in addition to what Andrew suggested: 1) Is this reproducible in a test environment (perhaps through Pherf: https://phoenix.apache.org/pherf.html) so you can experiment more?

Re: Row timestamp support in 4.6

Pierre, Thanks for reporting this. Do you mind filing a JIRA? Also, as a workaround, can you check if changing the data type from UNSIGNED_LONG to BIGINT resolves the issue? -Samarth On Friday, December 4, 2015, pierre lacave wrote: > > Hi, > > I am trying to use the

Re: Help tuning for bursts of high traffic?

Any chance of stack dumps from the debug servlet? Impossible to get anywhere with 'pegged the CPU' otherwise. Thanks. > On Dec 4, 2015, at 12:20 PM, Riesland, Zack wrote: > > James, > > 2 quick followups, for whatever they’re worth: > > 1 – There is nothing

RE: Help tuning for bursts of high traffic?

James, 2 quick followups, for whatever they're worth: 1 - There is nothing phoenix-related in /tmp 2 - I added a ton of logging, and played with the properties a bit, and I think I see a pattern: Watching the logging and the system profiler side-by-side, I see that, periodically - maybe

Re: Help tuning for bursts of high traffic?

Just realized that it wasnt to the user group. I sent you the dump. We face the exact same issues. Working on getting tracing (CDH distro doesnt include tracing, so we need to build our own) Secondly we had certain things what James had suggested(guide post, batch commit, join queries, major

Re: Row timestamp support in 4.6

Thanks Samarth, It does work with BIGINT, which is fine for my use case. I raised https://issues.apache.org/jira/browse/PHOENIX-2493 for the UNSIGNED_LONG issue *Pierre Lacave* 171 Skellig House, Custom House, Lower Mayor street, Dublin 1, Ireland Phone : +353879128708 On Fri, Dec 4,