Re: Apache Phoenix Tracing

2015-11-03 Thread Nanda
Hi All, I am trying to enable the tracing app as mentioned in the wiki: https://phoenix.apache.org/tracing.html I followed all the steps but was not able to find the "traceserver.py" file in my phoenix/bin directory. I am using 4.4.x version of phoneix. TIA. Nanda

Phoenix-spark : NoClassDefFoundError: HBaseConfiguration

2015-11-03 Thread vishnu prasad
I'm using phoenix-spark to load data from phoenix-hbase *spark-version* : 1.5.1 *Hbase Version* : 1.1.2 *Phoenix Version* : phoenix-4.6.0-HBase-1.1 I'm running spark-shell in standalone mode with the following jars added - phoenix-spark-4.6.0-HBase-1.1.jar - phoenix-4.6.0-HBase-1.1-client.

Re: Any Second Level Cache framework for Phoenix?

2015-11-03 Thread Nanda
Hi All, I am new to using Phoenix and interested to know if there is any Query Cache / second-level cache integration framework that i can use in my application. Thanks, Nanda

Error installing Phoenix

2015-11-03 Thread Michael Mior
I have a working HBase installation, but when I drop the Phoenix server JAR on my master and region server, I get the error message below. I'm using the Cloudera 5.4.8 packages of HBase 1.0.0. Currently I only have a two node installation with the YARN ResourceManager, the HDFS NameNode, ZooKeeper

Upserting values causes slow select queries

2015-11-03 Thread Naor David
Hello, I am using Phoenix 4.3.0 on CDH5.4 Cluster. I have a daily batch process that upserts values to an entire Pheonix table (there are no new records in each run, only updated values to all columns on each row). We have noticed that after 10-20 full runs, SELECT queries that contains WHERE clau

Re: Error installing Phoenix

2015-11-03 Thread Andrew Purtell
Try building Phoenix from https://github.com/chiastic-security/phoenix-for-cloudera and install the resulting server jar. CDH includes some local changes to HBase which cause binary compatibility issues. > On Nov 3, 2015, at 7:09 AM, Michael Mior wrote: > > I have a working HBase installati

Re: Error installing Phoenix

2015-11-03 Thread Michael Mior
Thanks for the quick response! That seems to be working perfectly. It would be nice if this were included in the documentation since Cloudera installs are relatively common. Cheers, -- Michael Mior michael.m...@gmail.com 2015-11-03 10:39 GMT-05:00 Andrew Purtell : > Try building Phoenix from > ht

Announcing phoenix-for-cloudera 4.6.0

2015-11-03 Thread Andrew Purtell
Today I pushed a new branch '4.6-HBase-1.0-cdh5' and the tag 'v4.6.0-cdh5.4.5' (58fcfa6) to https://github.com/chiastic-security/phoenix-for-cloudera. This is the Phoenix 4.6.0 release, modified to build against CDH 5.4.5 and possibly (but not tested) subsequent CDH releases. If you want release t

Re: Announcing phoenix-for-cloudera 4.6.0

2015-11-03 Thread James Heather
Bravo, Sir! Thanks for doing that. On 03/11/15 17:10, Andrew Purtell wrote: Today I pushed a new branch '4.6-HBase-1.0-cdh5' and the tag 'v4.6.0-cdh5.4.5' (58fcfa6) to https://github.com/chiastic-security/phoenix-for-cloudera. This is the Phoenix 4.6.0 release, modified to build against CDH 5

RE: Announcing phoenix-for-cloudera 4.6.0

2015-11-03 Thread Kevin Verhoeven
Fantastic! Thank you! Kevin From: James Heather [mailto:james.heat...@mendeley.com] Sent: Tuesday, November 3, 2015 9:13 AM To: user@phoenix.apache.org Subject: Re: Announcing phoenix-for-cloudera 4.6.0 Bravo, Sir! Thanks for doing that. On 03/11/15 17:10, Andrew Purtell wrote: Today I pushed a

Re: Apache Phoenix Tracing

2015-11-03 Thread Mujtaba Chohan
traceserver.py is in Phoenix 4.6.0. On Tue, Nov 3, 2015 at 12:42 AM, Nanda wrote: > > Hi All, > > I am trying to enable the tracing app as m

Help with salting

2015-11-03 Thread Vijay Vangapandu
Hi, I integrated one of the online services in my company with hbase using apache phoenix, after loading few millions of records I noticed that we have hotspot problem. All the records are going to one region as the keys are generated using sequence. Usecase is: each user has 1000’s of records

Re: Help with salting

2015-11-03 Thread James Taylor
Hi Vijay, Have you considered generating your IDs in a way that prevents hotspotting? One way might be to reverse the bits you get back from the sequence generator. You could write a simple UDF that does that: https://phoenix.apache.org/udf.html See inline for answers to your questions. Thanks, J