[IndexTool NOT working] mapreduce.LoadIncrementalHFiles: Split occured while grouping HFiles

2017-05-25 Thread anil gupta
Hi, We are using HDP2.3.2(Phoenix 4.4 and HBase 1.1), we created a secondary index on an already existing table. We paused all writes to Primary table. Then we invoked IndexTool to populate secondary index table. We have tried same steps many times but we keep on getting following error(we have

Re: Log from inside UDF

2017-05-25 Thread Cheyenne Forbes
I have everything running inside a single docker container https://github.com/CheyenneForbes/docker-apache-phoenix/blob/master/Dockerfile could you look at my dockerfile and tell me what steps are missing to get the logging? Regards, Cheyenne O. Forbes On Thu, May 25, 2017 at 3:05 PM, Josh

Re: Log from inside UDF

2017-05-25 Thread Josh Elser
The log4j.properties which you have configured to be on the HBase RegionServer classpath. I don't know how you configured your system. On 5/25/17 2:02 PM, Cheyenne Forbes wrote: Which one of the files? I found 4 //usr/local/hbase-1.2.5/conf/log4j.properties

Re: Log from inside UDF

2017-05-25 Thread Cheyenne Forbes
Which one of the files? I found 4

Re: Phoenix driver query rejection - note change in config?

2017-05-25 Thread Josh Elser
Hi Megan, Did you happen to restart Squirrel and/or re-connect to Phoenix after making the change? The steps you took (Squirrel, notwithstanding) should have sufficiently fixed the issue you described. Another sanity check would be to make sure your didn't have any mis-typing of the

Requests in for loop vs joins

2017-05-25 Thread Cheyenne Forbes
Which is more efficient in heavy usage platform? 1. Join 8 tables with billions of rows 2. Select the "primary row" from a table then run multiple select queries on the other tables using each primary key returned from the first table in a for loop on the client side Regards,

What is hardware used for the official performance page ?

2017-05-25 Thread cmbendre
Hi, There performance reports on Phoenix website - http://phoenix-bin.github.io/client/performance/latest.htm What is the cluster capacity used (RAM, Cores, CPU, Number of RegionServers) for testing these ? Sorry if this is indeed mentioned on the website and i missed it. Thanks Chaitanya

Re: Speeding Up Group By Queries

2017-05-25 Thread cmbendre
Hi, I am observing a similar behavior.I am doing POC of Phoenix since our query workloads are a mix of point lookups and aggregations. As i can see, Phoenix performs well on point lookups based on either PK or secondary index. But when it comes to aggregations, it has to do a full scan and its

Re: checking-in on hbase 1.3.1 support

2017-05-25 Thread Ankit Singhal
Next release of Phoenix(v4.11.0) will be supporting HBase 1.3.1(see PHOENIX-3603) and there is no timeline yet decided for the release. But you may expect some updates in next 1-2 months. On Thu, May 25, 2017 at 3:32 AM, Anirudha Jadhav wrote: > hi, > > just checking in, any