We have more than one cluster. One is using Phoenix 3 and one is using Phoenix 4. Here is what we have found: the latest DB Visualizer works with the official Phoenix 4.0 release from April even. But the problem is you cannot have both a Phoenix 3 connection and a Phoenix 4+ connection going on at the same time. If the Phoenix 3 connection happens first, DB Visualizer will erroneously use the Phoenix 3 driver to attempt the Phoenix 4+ connection. That is why people were seeing the infamous "Not a host:port pair: PBUF" exception.
Mike ________________________________________ From: Mike Friedman <mike.fried...@ds-iq.com> Sent: Friday, August 01, 2014 1:09 PM To: dev@phoenix.apache.org Subject: RE: Phoenix and CDH 5.1 success Here's where I got it from: Let me know if there is a better place to get the Phoenix 4 source: http://www.trieuvan.com/apache/incubator/phoenix/phoenix-4.0.0-incubating/ -----Original Message----- From: Gabriel Reid [mailto:gabriel.r...@gmail.com] Sent: Friday, August 01, 2014 12:41 PM To: dev@phoenix.apache.org Subject: Re: Phoenix and CDH 5.1 success Thanks for the follow-up Mike. Just to clarify, did you build 4.0 from the 4.0 release tag, or the current head of the 4.0 branch? The reason I ask is because PHOENIX-966 [1] fixed some issues with Phoenix being used as a "normal" JDBC driver in terms of classpath issues. As part of that ticket, Phoenix was also successfully tested with DbVisualizer. PHOENIX-966 isn't in the 4.0 release, but it is available in the head of the 4.0 branch, and will be present in the 4.1 release. Could you give a bit more info on the kind of issue (errors or stack traces) you're currently getting when trying to connection with DbVisualizer? Thanks, Gabriel 1. https://issues.apache.org/jira/browse/PHOENIX-966 On Fri, Aug 1, 2014 at 8:00 PM, Mike Friedman <mike.fried...@ds-iq.com> wrote: > I would also like to report that we now have Phoenix working with Java JDBC > as well, by following the steps that the sqlline source code uses to connect. > I have filed a support request to DB Visualizer to look into why their > product has a problem connecting to the driver. > > > Mike > > -----Original Message----- > From: Mike Friedman [mailto:mike.fried...@ds-iq.com] > Sent: Thursday, July 31, 2014 4:56 PM > To: dev@phoenix.apache.org; d...@phoenix.incubator.apache.org > Subject: Phoenix and CDH 5.1 success > > I would like to report that we got Phoenix and CDH 5.1 working. In the end, > we built 4.0 from the sources, specifying Hadoop profile 2. We did not have > to do any kludgy thing. Sqlline and Squirrel work fine. Pig works fine. > However, DB Visualizer does not work. We will file a bug with them. Also, we > found Java applications using JDBC are not working right now. However, since > sqlline is open source, my plan is to study the sqlline source code and > change the way we do the database connection to mimic what sqlline does, and > that will get those Java applications going again. > > I want to thank members of the Phoenix community for their reports of success > and for specific suggestions they provided. > > > > Mike