Author: tdsilva
Date: Sat May 16 00:09:10 2015
New Revision: 1679665
URL: http://svn.apache.org/r1679665
Log:
Update Squirrel instructions to work with version 3.6
Modified:
phoenix/site/publish/installation.html
phoenix/site/source/src/site/markdown/installation.md
Modified: phoenix/site/publish/installation.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/installation.html?rev=1679665&r1=1679664&r2=1679665&view=diff
==============================================================================
--- phoenix/site/publish/installation.html (original)
+++ phoenix/site/publish/installation.html Sat May 16 00:09:10 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-05-04
+ Generated by Apache Maven Doxia at 2015-05-15
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -184,11 +184,10 @@
<h4 id="SQL_Client">SQL Client</h4>
<p>If youâd rather use a client GUI to interact with Phoenix, download
and install <a class="externalLink"
href="http://squirrel-sql.sourceforge.net/";>SQuirrel</a>. Since Phoenix is a
JDBC driver, integration with tools such as this are seamless. Here are the
setup steps necessary:</p>
<ol style="list-style-type: decimal">
- <li>Remove prior phoenix-[version]-client.jar from the lib directory of
SQuirrel</li>
+ <li>Remove prior phoenix-[<i>oldversion</i>]-client.jar from the lib
directory of SQuirrel, copy phoenix-[<i>newversion</i>]-client.jar to the lib
directory (<i>newversion</i> should be compatible with the version of the
phoenix server jar used with your HBase installation)</li>
<li>Start SQuirrel and add new driver to SQuirrel (Drivers -> New
Driver)</li>
- <li>In the âExtra Class Pathâ tab, add the path to the
phoenix-[version-client.jar.</li>
<li>In Add Driver dialog box, set Name to Phoenix, and set the Example URL
to jdbc:phoenix:localhost.</li>
- <li>Press List Drivers button and org.apache.phoenix.jdbc.PhoenixDriver
should be automatically populated in the Class Name textbox. Press OK to close
this dialog.</li>
+ <li>Type âorg.apache.phoenix.jdbc.PhoenixDriverâ into the Class Name
textbox and click OK to close this dialog.</li>
<li>Switch to Alias tab and create the new Alias (Aliases -> New
Aliases)</li>
<li>In the dialog box, Name: <i>any name</i>, Driver: Phoenix, User Name:
<i>anything</i>, Password: <i>anything</i></li>
<li>Construct URL as follows: jdbc:phoenix: <i>zookeeper quorum
server</i>. For example, to connect to a local HBase use:
jdbc:phoenix:localhost</li>
Modified: phoenix/site/source/src/site/markdown/installation.md
URL:
http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/installation.md?rev=1679665&r1=1679664&r2=1679665&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/installation.md (original)
+++ phoenix/site/source/src/site/markdown/installation.md Sat May 16 00:09:10
2015
@@ -39,16 +39,15 @@ Other alternatives include:
If you'd rather use a client GUI to interact with Phoenix, download and
install [SQuirrel](http://squirrel-sql.sourceforge.net/). Since Phoenix is a
JDBC driver, integration with tools such as this are seamless. Here are the
setup steps necessary:
-1. Remove prior phoenix-[version]-client.jar from the lib directory of SQuirrel
+1. Remove prior phoenix-[_oldversion_]-client.jar from the lib directory of
SQuirrel, copy phoenix-[_newversion_]-client.jar to the lib directory
(_newversion_ should be compatible with the version of the phoenix server jar
used with your HBase installation)
2. Start SQuirrel and add new driver to SQuirrel (Drivers -> New Driver)
-3. In the "Extra Class Path" tab, add the path to the
phoenix-[version-client.jar.
-4. In Add Driver dialog box, set Name to Phoenix, and set the Example URL to
jdbc:phoenix:localhost.
-5. Press List Drivers button and org.apache.phoenix.jdbc.PhoenixDriver should
be automatically populated in the Class Name textbox. Press OK to close this
dialog.
-6. Switch to Alias tab and create the new Alias (Aliases -> New Aliases)
-7. In the dialog box, Name: _any name_, Driver: Phoenix, User Name:
_anything_, Password: _anything_
-8. Construct URL as follows: jdbc:phoenix: _zookeeper quorum server_. For
example, to connect to a local HBase use: jdbc:phoenix:localhost
-9. Press Test (which should succeed if everything is setup correctly) and
press OK to close.
-10. Now double click on your newly created Phoenix alias and click Connect.
Now you are ready to run SQL queries against Phoenix.
+3. In Add Driver dialog box, set Name to Phoenix, and set the Example URL to
jdbc:phoenix:localhost.
+4. Type "org.apache.phoenix.jdbc.PhoenixDriver" into the Class Name textbox
and click OK to close this dialog.
+5. Switch to Alias tab and create the new Alias (Aliases -> New Aliases)
+6. In the dialog box, Name: _any name_, Driver: Phoenix, User Name:
_anything_, Password: _anything_
+7. Construct URL as follows: jdbc:phoenix: _zookeeper quorum server_. For
example, to connect to a local HBase use: jdbc:phoenix:localhost
+8. Press Test (which should succeed if everything is setup correctly) and
press OK to close.
+9. Now double click on your newly created Phoenix alias and click Connect. Now
you are ready to run SQL queries against Phoenix.
Through SQuirrel, you can issue SQL statements in the SQL tab (create tables,
insert data, run queries), and inspect table metadata in the Object tab (i.e.
list tables, their columns, primary keys, and types).
