phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Friedman <Mike.Fried...@ds-iq.com>
Subject RE: Phoenix and CDH 5.1 success
Date Fri, 15 Aug 2014 15:46:59 GMT
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.Friedman@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.reid@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.Friedman@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.Friedman@ds-iq.com]
> Sent: Thursday, July 31, 2014 4:56 PM
> To: dev@phoenix.apache.org; dev@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

Mime
View raw message