apache phoenix queryserver on Mapr

Hello, I'm evaluating using Phoenix on mapr platform. I am able to get it working via sqlline or java, spark client but having issues with queryserver (exception below). [mapr@host bin]$ 17/09/09 01:14:18 INFO zookeeper.ClientCnxn: Opening socket connection to server

Re: Salt Number

HI James, We have a table where multiple customer could have rows. Some of them may be large and some very small in terms for number of rows. we have a row key based on customerid+type+orderid..if not salted all the rows of large customer will end up in some regions leading to hot

Re: Salt Number

Hi Pradheep, Would you be able to describe your use case and why you're salting? We really only recommend salting if you have write hotspotting. Otherwise, it increases the overall load on your cluster. Thanks, James On Fri, Sep 8, 2017 at 9:13 AM, Pradheep Shanmugam <

Re: How to speed up write performance

Here's another good tuning resource that covers HBase too: http://phoenix.apache.org/presentations/TuningForOLTP.pdf On Fri, Sep 8, 2017 at 8:30 AM, Josh Elser wrote: > Hef -- do your split points actually correspond with the distribution on > values of your `id` column? You

Re: How to speed up write performance

Hef -- do your split points actually correspond with the distribution on values of your `id` column? You can tell this pretty easily looking at the number of requests per region for your data table on the HBase UI. And yes, PQS will not increase the performance (as it is adding "more work" to

Re: How to speed up write performance

Hi James, I have read over the Tuning Guide, and tried some of your suggestions: #3, #5, #6. Since the date is mutable, and read/write frequently, I did not try #1, #2, #4. The schema is simple as such: *create table if not exists test_data (* * id VARCHAR(32),* * sid VARCHAR(32),* * uid