Hi Gabriel, Thank you for the information, I think I'll wait for the patch since I don't seem to get this to work with DbVizualizer. ------------------------------------ Cosmin Catalin SANDA Software Systems Engineer Phone: +45.27.30.60.35
On Fri, Jul 18, 2014 at 1:49 PM, Gabriel Reid <[email protected]> wrote: > Hi Cosmin, > > The underlying problem has to do with the way that jar files and hbase > configuration files are loaded on the client side, so there shouldn't > be any need to update anything on the cluster nodes themselves. If you > can add the hbase-client jar (and possible hbase-site.xml) to the list > of driver search paths in DBVisualizer (similar to what is discussed > here: http://www.dbvis.com/doc/8.0/doc/ug/installDriver/installDriver.html), > it might resolve this issue for now. > > The good news is that this is resolved in PHOENIX-966 [1], and so it > will be in the next release of Phoenix (hopefully in the next couple > of weeks). I previously did some testing with DBVisualizer as part of > the work on PHOENIX-966, and with that patch everything works > properly. > > - Gabriel > > 1. https://issues.apache.org/jira/browse/PHOENIX-966 > > On Fri, Jul 18, 2014 at 11:47 AM, Cosmin Cătălin Sanda > <[email protected]> wrote: >> Hi >> >> I am trying to use Phoenix with DbVizualizer, and I seem to stumble on >> a problem that has appeared before, but which I cannot fix. I have two >> test scenarios: >> >> Without an HBase cluster I follow these steps: >> >> - Configure the JDBC driver in DBVizualizer by using >> phoenix-4.0.0-incubating-client.jar and everything seems correct. >> - Connect to a nonexisting HBase cluster just for the heck of it. >> - I get the infamous: >> >> hbase-default.xml file seems to be for and old version of HBase >> (null), this version is 0.98.1-hadoop2 >> >> With an HBase cluster up and running: >> >> - Use ./sqlline.py to connect to the cluster, Connection is made >> successful and I am able to work with HBase to the full. >> - Use DbVizualizer to connect to the same cluster: >> - I get the infamous: >> >> hbase-default.xml file seems to be for and old version of HBase >> (null), this version is 0.98.1-hadoop2 >> >> I have added >> >> <property> >> <name>hbase.defaults.for.version.skip</name> >> <value>true</value> >> </property> >> >> to all the hbase-site.xml files on all nodes of the cluster that had >> HBase installed, both to the actual HBase conf/hbase-site.xml >> configuration and to the Phoenix configuration in bin/hbase-site.xml >> >> Is there anything else I'm missing? >> >> ------------------------------------ >> Cosmin Catalin SANDA >> Software Systems Engineer >> Phone: +45.27.30.60.35
