How To Integrate SQuirreL With Apache Phoenix

It's only fair to share...Share on Facebook0Share on Google+2Tweet about this on Twitter0Share on LinkedIn0Pin on Pinterest0Digg thisShare on StumbleUpon0

 

If you’re looking to use a client GUI, or graphical user interface, to interact with Phoenix, you might want to give SQuirreL a try. SQuirreL is a graphical java program that lets you see the structure of a database, browse the data in tables, and perform SQL queries.

Installing SQuirrel

Download Squirrel from http://squirrel-sql.sourceforge.net/#installation and run the installer. Once the installer dialog pops up, follow the instructions to install SQuirreL onto the system. You can choose to select optional installs if you like. For now, you can chose base and standard install:

Configuring SQuirrelSQL for Phoenix:

Step 1 – Move Phoenix client jar to SQuirreL lib directory

Download the phoenix client jar file from HDP (In My HDP location is /usr/hdp/2.3.0.0-2557/phoenix/phoenix-4.4.0.2.3.0.0-2557-client.jar) to your local machine and move this to squirrel lib directory (SQUIRREL_INSTALLATION_DIRECTORY/lib).

Step 2 – Host Entry

Put the master and slave IP entry into host file.
192.168.56.101 hortonworks.hbase.vm

(If you are using Virtual Machine then Switch your VM’s network adapter to Host-only )

Step 3 – Add Phoenix driver to SQuirreL

Open up SQuirrel, click the Drivers tab on the left side of the window, and click the plus button to create a new driver. Enter this information into the driver creation window:

  • Name: Phoenix
  • Example URL: jdbc:phoenix:MASTER_IP:2181:/hbase-unsecure
  • Website URL: [Blank. Do not write anything here]
  • Class Name: org.apache.phoenix.jdbc.PhoenixDriver

It should look like this:

Click OK. You should get a message which reads “Driver class org.apache.phoenix.jdbc.PhoenixDriver successfully registered for driver definition: Phoenix”

Step 4 – Create an Alias

Switch to the Aliases tab and click the plus button to create a new alias. Enter this information in the alias creation window:

  • Name – Alias name (ex: hortonworksSandbox, whatever you want)
  • Driver – Phoenix
  • URL – This should be auto-populated when you select your driver with jdbc:phoenix: MASTER_IP:2181:/hbase-unsecure
  • User Name – Whatever you like (ex: admin)
  • Password – Whatever you like (ex: admin)

It should look like this:

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">