You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by mu...@apache.org on 2015/02/20 01:10:00 UTC
svn commit: r1661036 [2/2] - in /phoenix/site: publish/
publish/images/using/ publish/language/ source/src/site/
source/src/site/markdown/ source/src/site/resources/images/using/
Modified: phoenix/site/source/src/site/markdown/download.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/download.md?rev=1661036&r1=1661035&r2=1661036&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/download.md (original)
+++ phoenix/site/source/src/site/markdown/download.md Fri Feb 20 00:09:59 2015
@@ -11,64 +11,5 @@
* Phoenix 2.x - HBase 0.94.x
* Phoenix 3.x - HBase 0.94.x
* Phoenix 4.x - HBase 0.98.1+
-
-### Installation ###
-To install a pre-built phoenix, use these directions:
-
-* Download and expand the latest phoenix-[version]-bin.tar. Use either hadoop1 and hadoop2 artifacts which match your HBase installation.
-* Add the phoenix-[version]-server.jar to the classpath of every HBase region server and remove any previous version. An easy way to do this is to copy it into the HBase lib directory (use phoenix-core-[version].jar for Phoenix 3.x)
-* Restart all region servers.
-* Add the phoenix-[version]-client.jar to the classpath of any Phoenix client.
-
-### Getting Started ###
-Wanted to get started quickly? Take a look at our [FAQs](faq.html) and take our quick start guide [here](Phoenix-in-15-minutes-or-less.html).
-
-<h4>Command Line</h4>
-
-A terminal interface to execute SQL from the command line is now bundled with Phoenix. To start it, execute the following from the bin directory:
-
- $ sqlline.py localhost
-
-To execute SQL scripts from the command line, you can include a SQL file argument like this:
-
- $ sqlline.py localhost ../examples/stock_symbol.sql
-
-
-
-For more information, see the [manual](http://www.hydromatic.net/sqlline/manual.html).
-
-<h5>Loading Data</h5>
-
-In addition, you can use the bin/psql.py to load CSV data or execute SQL scripts. For example:
-
- $ psql.py localhost ../examples/web_stat.sql ../examples/web_stat.csv ../examples/web_stat_queries.sql
-
-Other alternatives include:
-
-* Using our [map-reduce based CSV loader](bulk_dataload.html) for bigger data sets
-* [Mapping an existing HBase table to a Phoenix table](index.html#Mapping-to-an-Existing-HBase-Table) and using the [UPSERT SELECT](language/index.html#upsert_select) command to populate a new table.
-* Populating the table through our [UPSERT VALUES](language/index.html#upsert_values) command.
-
-<h4>SQL Client</h4>
-
-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
-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.
-
-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).
-
-
-
-### Samples ###
-The best place to see samples are in our unit tests under src/test/java. The ones in the endToEnd package are tests demonstrating how to use all aspects of the Phoenix JDBC driver. We also have some examples in the examples directory.
-
-[](http://githalytics.com/forcedotcom/phoenix.git)
+<hr/>
+See also: [Installation Instructions](installation.html)
Added: phoenix/site/source/src/site/markdown/installation.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/installation.md?rev=1661036&view=auto
==============================================================================
--- phoenix/site/source/src/site/markdown/installation.md (added)
+++ phoenix/site/source/src/site/markdown/installation.md Fri Feb 20 00:09:59 2015
@@ -0,0 +1,60 @@
+## Installation
+To install a pre-built phoenix, use these directions:
+
+* Download and expand the latest phoenix-[version]-bin.tar.
+* Add the phoenix-[version]-server.jar to the classpath of all HBase region server and master and remove any previous version. An easy way to do this is to copy it into the HBase lib directory (use phoenix-core-[version].jar for Phoenix 3.x)
+* Restart HBase.
+* Add the phoenix-[version]-client.jar to the classpath of any Phoenix client.
+
+### Getting Started ###
+Wanted to get started quickly? Take a look at our [FAQs](faq.html) and take our quick start guide [here](Phoenix-in-15-minutes-or-less.html).
+
+<h4>Command Line</h4>
+
+A terminal interface to execute SQL from the command line is now bundled with Phoenix. To start it, execute the following from the bin directory:
+
+ $ sqlline.py localhost
+
+To execute SQL scripts from the command line, you can include a SQL file argument like this:
+
+ $ sqlline.py localhost ../examples/stock_symbol.sql
+
+
+
+For more information, see the [manual](http://www.hydromatic.net/sqlline/manual.html).
+
+<h5>Loading Data</h5>
+
+In addition, you can use the bin/psql.py to load CSV data or execute SQL scripts. For example:
+
+ $ psql.py localhost ../examples/web_stat.sql ../examples/web_stat.csv ../examples/web_stat_queries.sql
+
+Other alternatives include:
+
+* Using our [map-reduce based CSV loader](bulk_dataload.html) for bigger data sets
+* [Mapping an existing HBase table to a Phoenix table](index.html#Mapping-to-an-Existing-HBase-Table) and using the [UPSERT SELECT](language/index.html#upsert_select) command to populate a new table.
+* Populating the table through our [UPSERT VALUES](language/index.html#upsert_values) command.
+
+<h4>SQL Client</h4>
+
+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
+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.
+
+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).
+
+
+
+### Samples ###
+The best place to see samples are in our unit tests under src/test/java. The ones in the endToEnd package are tests demonstrating how to use all aspects of the Phoenix JDBC driver. We also have some examples in the examples directory.
+
+[](http://githalytics.com/forcedotcom/phoenix.git)
Modified: phoenix/site/source/src/site/resources/images/using/all.jpeg
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/resources/images/using/all.jpeg?rev=1661036&r1=1661035&r2=1661036&view=diff
==============================================================================
Binary files - no diff available.
Modified: phoenix/site/source/src/site/site.xml
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/site.xml?rev=1661036&r1=1661035&r2=1661036&view=diff
==============================================================================
--- phoenix/site/source/src/site/site.xml (original)
+++ phoenix/site/source/src/site/site.xml Fri Feb 20 00:09:59 2015
@@ -64,6 +64,7 @@
<item href="source.html" name="Source Repository"/>
<item href="issues.html" name="Issue Tracking"/>
<item href="download.html" name="Download" />
+ <item href="installation.html" name="Installation" />
<item href="http:divider" name=""/>
<item href="who_is_using.html" name="Who is Using"/>
<item href="contributing.html" name="How to Contribute"/>