phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "" <>
Subject Re: Re: Phoenix in production
Date Wed, 07 Jan 2015 08:15:38 GMT

Glad to share our experience of using Phoenix in Production. I believe that Siddharth had
sufficient tests and practices about Phoenix performance. Here are some tips about how we
are using
Phoenix for our projects:
1. We facilitate Phoenix to give convinience for both RD and QA engineers, as they are glad
to use 
standard sql to operate hbase with no much loss of query performance. 
2. In Production environment, we mainly integrate Apache Spark with Phoenix to optimize data
loading to
Phoenix tables with or withour secondary indexes. Glad that current performance of writing
had worked 
smoothly with both compared to previously used MySQL InfoBright and other sql schema. We both
had tested 
a lot for secondary indexes and query optimization for Phoenix before moving Phoenix to Production

environment. Now we can get most of the features worked for Phoenix in our job. 
3. Challenges had a lot too, such as bulkload performance with wal enabled, query optimization,
statistical data collection with Phoenix
full table scan, and so on. However, we believe Phoenix be a sufficient schema for sql query
over HBase and we are glad 
that even more our projects are considering using Phoenix.



From: Justin Workman
Date: 2015-01-07 15:54
Subject: Re: Phoenix in production
I am also using Phoenix in production and have been now for roughly 6 months. We adopted Phoenix
for most of the same reasons Anil mentions. 

We are connection to a secure cluster without issue. We have also implemented our own storm
persistence bolt, and a lookup bolt that are reading and writing to our Phoenix/Hbase cluster.

I have still had problems getting a secure connection from client tools for adhoc analysis
other than sqlline. Still fighting though connections from SquirrelSQL, although I haven't
dedicated a whole lot of time trying to figure it out. 


Sent from my iPhone

On Jan 7, 2015, at 12:26 AM, Siddharth Ubale <> wrote:

Hi Anil,
Thanks a lot for sharing ur thoughts.
Have you tried using Phoenix API along with Apache Storm?
There is a storm RDBMS connector implementation , but it was last updated in 2012 and I am
having problems with it.
Any thoughts on Storm-Phoenix integration?
Siddharth ubale
From: anil gupta [] 
Sent: Wednesday, January 07, 2015 12:49 PM
Cc: James Taylor
Subject: Re: Phoenix in production
Hi Siddharth,
I have used Phoenix in production for more than a year at Intuit.(i no longer work there.)
I was pretty happy with Phoenix because it provided us capability to use sql-like(JDBC compliant)
querying on a NoSql DB. With help of Phoenix, the adoption rate of HBase in my team was much
more faster and it makes it very easy to read data from HBase Table.(without Phoenix, i personally
used to write java programs for queries with complex filters.or non-string columns).
Following are the some of the challenges i faced while using Phoenix:
1. Connecting to secure HBase cluster.
2. Phoenix creating big files under /tmp folder when a "select *" type query is done.
3. Phoenix only used to work with SQuirreL(GUI based DB client)
I know for sure that #1 and #3 are addressed. There was jira for #2, i m not sure whats the
status of it right now.
Obviously,i haven't used all the features of Phoenix. So, i would suggest you to do your own
evaluation(POC) and take guidance from the Phoenix community if you are planning to use any
specific feature. This community is quite active. 
Hope This Helps,
Anil Gupta
On Thu, Jan 1, 2015 at 11:21 PM, Siddharth Ubale <> wrote:
Hi Guys,
We are seriously thinking of phoenix in Production environment , however, we have no much
data of how Phoenix is behaving in production.
Can anyone let us know if anyone is using Phoenix in Production and any challenges which they
have experienced.
Siddharth Ubale,
Synchronized Communications 
#43, Velankani Tech Park, Block No. II, 
3rd Floor, Electronic City Phase I,
Bangalore – 560 100
Tel : +91 80 3202 4060
we innovate, plan, execute, and transform the business​

Thanks & Regards,
Anil Gupta
View raw message