You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@knox.apache.org by km...@apache.org on 2013/10/09 03:24:17 UTC
svn commit: r1530477 - in /incubator/knox:
site/books/knox-incubating-0-3-0/knox-incubating-0-3-0.html
trunk/books/0.3.0/book_getting-started.md trunk/books/0.3.0/service_hbase.md
Author: kminder
Date: Wed Oct 9 01:24:17 2013
New Revision: 1530477
URL: http://svn.apache.org/r1530477
Log:
Updates to service coverage and hbase tweaks.
Modified:
incubator/knox/site/books/knox-incubating-0-3-0/knox-incubating-0-3-0.html
incubator/knox/trunk/books/0.3.0/book_getting-started.md
incubator/knox/trunk/books/0.3.0/service_hbase.md
Modified: incubator/knox/site/books/knox-incubating-0-3-0/knox-incubating-0-3-0.html
URL: http://svn.apache.org/viewvc/incubator/knox/site/books/knox-incubating-0-3-0/knox-incubating-0-3-0.html?rev=1530477&r1=1530476&r2=1530477&view=diff
==============================================================================
--- incubator/knox/site/books/knox-incubating-0-3-0/knox-incubating-0-3-0.html (original)
+++ incubator/knox/site/books/knox-incubating-0-3-0/knox-incubating-0-3-0.html Wed Oct 9 01:24:17 2013
@@ -146,10 +146,6 @@
<td>Enumerates the changes between releases. </td>
</tr>
<tr>
- <td>INSTALL </td>
- <td>Provides simple installation instructions. </td>
- </tr>
- <tr>
<td>LICENSE </td>
<td>Documents the license under which this software is provided. </td>
</tr>
@@ -201,13 +197,13 @@
<td>Hive (via WebHCat) </td>
<td>0.11.0 </td>
<td><img src="check.png" alt="y"/> </td>
- <td><img src="check.png" alt="y"/> </td>
+ <td><img src="error.png" alt="n"/> </td>
</tr>
<tr>
<td> </td>
<td>0.12.0 </td>
<td><img src="check.png" alt="y"/> </td>
- <td><img src="check.png" alt="y"/> </td>
+ <td><img src="question.png" alt="?"/> </td>
</tr>
<tr>
<td>Hive (via JDBC) </td>
@@ -218,11 +214,17 @@
<tr>
<td> </td>
<td>0.12.0 </td>
- <td><img src="question.png" alt="?"/><img src="check.png" alt="y"/> </td>
+ <td><img src="question.png" alt="?"/> </td>
<td><img src="question.png" alt="?"/> </td>
</tr>
<tr>
<td>Hive (via ODBC) </td>
+ <td>0.11.0 </td>
+ <td><img src="error.png" alt="n"/> </td>
+ <td><img src="error.png" alt="n"/> </td>
+ </tr>
+ <tr>
+ <td>Hive </td>
<td>0.12.0 </td>
<td><img src="question.png" alt="?"/> </td>
<td><img src="question.png" alt="?"/> </td>
@@ -1517,7 +1519,7 @@ curl -i -k -u guest:guest-password -X DE
</ul></li>
</ul><h3><a id="HBase"></a>HBase</h3><p>TODO</p><h4><a id="HBase+URL+Mapping"></a>HBase URL Mapping</h4><p>TODO</p><h4><a id="HBase+Examples"></a>HBase Examples</h4><p>TODO</p><p>The examples below illustrate the set of basic operations with HBase instance using Stargate REST API. Use following link to get more more details about HBase/Stargate API: <a href="http://wiki.apache.org/hadoop/Hbase/Stargate">http://wiki.apache.org/hadoop/Hbase/Stargate</a>.</p><h3><a id="HBase+Stargate+Setup"></a>HBase Stargate Setup</h3><h4><a id="Launch+Stargate"></a>Launch Stargate</h4><p>The command below launches the Stargate daemon on port 60080</p>
<pre><code>sudo /usr/lib/hbase/bin/hbase-daemon.sh start rest -p 60080
-</code></pre><p>60080 post is used because it was specified in sample Hadoop cluster deployment <code>{GATEWAY_HOME}/deployments/sandbox.xml</code>.</p><h4><a id="Configure+Sandbox+port+mapping+for+VirtualBox"></a>Configure Sandbox port mapping for VirtualBox</h4>
+</code></pre><p>Port 60080 is used because it was specified in sample Hadoop cluster deployment <code>{GATEWAY_HOME}/deployments/sandbox.xml</code>.</p><h4><a id="Configure+Sandbox+port+mapping+for+VirtualBox"></a>Configure Sandbox port mapping for VirtualBox</h4>
<ol>
<li>Select the VM</li>
<li>Select menu Machine>Settings…</li>
@@ -1527,7 +1529,15 @@ curl -i -k -u guest:guest-password -X DE
<li>Press Plus button to insert new rule: Name=Stargate, Host Port=60080, Guest Port=60080</li>
<li>Press OK to close the rule window</li>
<li>Press OK to Network window save the changes</li>
-</ol><p>60080 post is used because it was specified in sample Hadoop cluster deployment <code>{GATEWAY_HOME}/deployments/sandbox.xml</code>.</p><h3><a id="HBase/Stargate+client+DSL"></a>HBase/Stargate client DSL</h3><h4><a id="Usage"></a>Usage</h4><p>For more details about client DSL usage please follow this [page|https://cwiki.apache.org/confluence/display/KNOX/Client+Usage].</p><h5><a id="systemVersion()+-+Query+Software+Version."></a>systemVersion() - Query Software Version.</h5>
+</ol><p>60080 pot is used because it was specified in sample Hadoop cluster deployment <code>{GATEWAY_HOME}/deployments/sandbox.xml</code>.</p><h4><a id="HBase+Restart"></a>HBase Restart</h4><p>If it becomes necessary to restart HBase you can log into the hosts running HBase and use these steps.</p>
+<pre><code>sudo /usr/lib/hbase/bin/hbase-daemon.sh stop rest
+sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh stop regionserver
+sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh stop master
+
+sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh start regionserver
+sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh start master
+sudo /usr/lib/hbase/bin/hbase-daemon.sh start rest -p 60080
+</code></pre><h3><a id="HBase/Stargate+client+DSL"></a>HBase/Stargate client DSL</h3><p>For more details about client DSL usage please follow this [page|https://cwiki.apache.org/confluence/display/KNOX/Client+Usage].</p><h4><a id="systemVersion()+-+Query+Software+Version."></a>systemVersion() - Query Software Version.</h4>
<ul>
<li>Request
<ul>
@@ -1541,7 +1551,7 @@ curl -i -k -u guest:guest-password -X DE
<ul>
<li><code>HBase.session(session).systemVersion().now().string</code></li>
</ul></li>
-</ul><h5><a id="clusterVersion()+-+Query+Storage+Cluster+Version."></a>clusterVersion() - Query Storage Cluster Version.</h5>
+</ul><h4><a id="clusterVersion()+-+Query+Storage+Cluster+Version."></a>clusterVersion() - Query Storage Cluster Version.</h4>
<ul>
<li>Request
<ul>
@@ -1555,7 +1565,7 @@ curl -i -k -u guest:guest-password -X DE
<ul>
<li><code>HBase.session(session).clusterVersion().now().string</code></li>
</ul></li>
-</ul><h5><a id="status()+-+Query+Storage+Cluster+Status."></a>status() - Query Storage Cluster Status.</h5>
+</ul><h4><a id="status()+-+Query+Storage+Cluster+Status."></a>status() - Query Storage Cluster Status.</h4>
<ul>
<li>Request
<ul>
@@ -1569,7 +1579,7 @@ curl -i -k -u guest:guest-password -X DE
<ul>
<li><code>HBase.session(session).status().now().string</code></li>
</ul></li>
-</ul><h5><a id="table().list()+-+Query+Table+List."></a>table().list() - Query Table List.</h5>
+</ul><h4><a id="table().list()+-+Query+Table+List."></a>table().list() - Query Table List.</h4>
<ul>
<li>Request
<ul>
@@ -1581,7 +1591,7 @@ curl -i -k -u guest:guest-password -X DE
</ul></li>
<li>Example</li>
<li><code>HBase.session(session).table().list().now().string</code></li>
-</ul><h5><a id="table(String+tableName).schema()+-+Query+Table+Schema."></a>table(String tableName).schema() - Query Table Schema.</h5>
+</ul><h4><a id="table(String+tableName).schema()+-+Query+Table+Schema."></a>table(String tableName).schema() - Query Table Schema.</h4>
<ul>
<li>Request
<ul>
@@ -1595,7 +1605,7 @@ curl -i -k -u guest:guest-password -X DE
<ul>
<li><code>HBase.session(session).table().schema().now().string</code></li>
</ul></li>
-</ul><h5><a id="table(String+tableName).create()+-+Create+Table+Schema."></a>table(String tableName).create() - Create Table Schema.</h5>
+</ul><h4><a id="table(String+tableName).create()+-+Create+Table+Schema."></a>table(String tableName).create() - Create Table Schema.</h4>
<ul>
<li>Request
<ul>
@@ -1622,7 +1632,7 @@ curl -i -k -u guest:guest-password -X DE
.endFamilyDef()
.attribute("tb_attr3", "value5")
.now()
-</code></pre><h5><a id="table(String+tableName).update()+-+Update+Table+Schema."></a>table(String tableName).update() - Update Table Schema.</h5>
+</code></pre><h4><a id="table(String+tableName).update()+-+Update+Table+Schema."></a>table(String tableName).update() - Update Table Schema.</h4>
<ul>
<li>Request
<ul>
@@ -1644,7 +1654,7 @@ curl -i -k -u guest:guest-password -X DE
.attribute("fm_attr3", "value6")
.endFamilyDef()
.now()```
-</code></pre><h5><a id="table(String+tableName).regions()+-+Query+Table+Metadata."></a>table(String tableName).regions() - Query Table Metadata.</h5>
+</code></pre><h4><a id="table(String+tableName).regions()+-+Query+Table+Metadata."></a>table(String tableName).regions() - Query Table Metadata.</h4>
<ul>
<li>Request
<ul>
@@ -1658,7 +1668,7 @@ curl -i -k -u guest:guest-password -X DE
<ul>
<li><code>HBase.session(session).table(tableName).regions().now().string</code></li>
</ul></li>
-</ul><h5><a id="table(String+tableName).delete()+-+Delete+Table."></a>table(String tableName).delete() - Delete Table.</h5>
+</ul><h4><a id="table(String+tableName).delete()+-+Delete+Table."></a>table(String tableName).delete() - Delete Table.</h4>
<ul>
<li>Request
<ul>
@@ -1672,7 +1682,7 @@ curl -i -k -u guest:guest-password -X DE
<ul>
<li><code>HBase.session(session).table(tableName).delete().now()</code></li>
</ul></li>
-</ul><h5><a id="table(String+tableName).row(String+rowId).store()+-+Cell+Store."></a>table(String tableName).row(String rowId).store() - Cell Store.</h5>
+</ul><h4><a id="table(String+tableName).row(String+rowId).store()+-+Cell+Store."></a>table(String tableName).row(String rowId).store() - Cell Store.</h4>
<ul>
<li>Request
<ul>
@@ -1694,7 +1704,7 @@ curl -i -k -u guest:guest-password -X DE
HBase.session(session).table(tableName).row("row_id_2").store()
.column("family1", "row2_col1", "row2_col_value1")
.now()
-</code></pre><h5><a id="table(String+tableName).row(String+rowId).query()+-+Cell+or+Row+Query."></a>table(String tableName).row(String rowId).query() - Cell or Row Query.</h5>
+</code></pre><h4><a id="table(String+tableName).row(String+rowId).query()+-+Cell+or+Row+Query."></a>table(String tableName).row(String rowId).query() - Cell or Row Query.</h4>
<ul>
<li>rowId is optional. Querying with null or empty rowId will select all rows.</li>
<li>Request
@@ -1725,7 +1735,7 @@ HBase.session(session).table(tableName).
.times(0, Long.MAX_VALUE)
.numVersions(1)
.now().string
-</code></pre><h5><a id="table(String+tableName).row(String+rowId).delete()+-+Row,+Column,+or+Cell+Delete."></a>table(String tableName).row(String rowId).delete() - Row, Column, or Cell Delete.</h5>
+</code></pre><h4><a id="table(String+tableName).row(String+rowId).delete()+-+Row,+Column,+or+Cell+Delete."></a>table(String tableName).row(String rowId).delete() - Row, Column, or Cell Delete.</h4>
<ul>
<li>Request
<ul>
@@ -1749,7 +1759,7 @@ HBase.session(session).table(tableName).
.column("family2")
.time(Long.MAX_VALUE)
.now()```
-</code></pre><h5><a id="table(String+tableName).scanner().create()+-+Scanner+Creation."></a>table(String tableName).scanner().create() - Scanner Creation.</h5>
+</code></pre><h4><a id="table(String+tableName).scanner().create()+-+Scanner+Creation."></a>table(String tableName).scanner().create() - Scanner Creation.</h4>
<ul>
<li>Request
<ul>
@@ -1781,7 +1791,7 @@ HBase.session(session).table(tableName).
.filter("")
.maxVersions(100)
.now()```
-</code></pre><h5><a id="table(String+tableName).scanner(String+scannerId).getNext()+-+Scanner+Get+Next."></a>table(String tableName).scanner(String scannerId).getNext() - Scanner Get Next.</h5>
+</code></pre><h4><a id="table(String+tableName).scanner(String+scannerId).getNext()+-+Scanner+Get+Next."></a>table(String tableName).scanner(String scannerId).getNext() - Scanner Get Next.</h4>
<ul>
<li>Request
<ul>
@@ -1795,7 +1805,7 @@ HBase.session(session).table(tableName).
<ul>
<li><code>HBase.session(session).table(tableName).scanner(scannerId).getNext().now().string</code></li>
</ul></li>
-</ul><h5><a id="table(String+tableName).scanner(String+scannerId).delete()+-+Scanner+Deletion."></a>table(String tableName).scanner(String scannerId).delete() - Scanner Deletion.</h5>
+</ul><h4><a id="table(String+tableName).scanner(String+scannerId).delete()+-+Scanner+Deletion."></a>table(String tableName).scanner(String scannerId).delete() - Scanner Deletion.</h4>
<ul>
<li>Request
<ul>
@@ -1809,7 +1819,7 @@ HBase.session(session).table(tableName).
<ul>
<li><code>HBase.session(session).table(tableName).scanner(scannerId).delete().now()</code></li>
</ul></li>
-</ul><h4><a id="Examples"></a>Examples</h4><p>This example illustrates sequence of all basic HBase operations: 1. get system version 2. get cluster version 3. get cluster status 4. create the table 5. get list of tables 6. get table schema 7. update table schema 8. insert single row into table 9. query row by id 10. query all rows 11. delete cell from row 12. delete entire column family from row 13. get table regions 14. create scanner 15. fetch values using scanner 16. drop scanner 17. drop the table</p><p>There are several ways to do this depending upon your preference.</p><p>You can use the Groovy interpreter provided with the distribution.</p>
+</ul><h3><a id="HBase/Stargate+via+Client+DSL"></a>HBase/Stargate via Client DSL</h3><p>This example illustrates sequence of all basic HBase operations: 1. get system version 2. get cluster version 3. get cluster status 4. create the table 5. get list of tables 6. get table schema 7. update table schema 8. insert single row into table 9. query row by id 10. query all rows 11. delete cell from row 12. delete entire column family from row 13. get table regions 14. create scanner 15. fetch values using scanner 16. drop scanner 17. drop the table</p><p>There are several ways to do this depending upon your preference.</p><p>You can use the Groovy interpreter provided with the distribution.</p>
<pre><code>java -jar bin/shell.jar samples/ExampleHBase.groovy
</code></pre><p>You can manually type in the KnoxShell DSL script into the interactive Groovy interpreter provided with the distribution.</p>
<pre><code>java -jar bin/shell.jar
@@ -1996,74 +2006,74 @@ session.shutdown(10, SECONDS)
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/version/cluster'
</code></pre><h4><a id="Get+detailed+status+on+the+HBase+cluster+backing+the+Stargate+instance."></a>Get detailed status on the HBase cluster backing the Stargate instance.</h4><p>Set Accept Header to “text/plain”, “text/xml”, “application/json” or “application/x-protobuf”</p>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/status/cluster'
</code></pre><h4><a id="Get+the+list+of+available+tables."></a>Get the list of available tables.</h4><p>Set Accept Header to “text/plain”, “text/xml”, “application/json” or “application/x-protobuf”</p>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase'
</code></pre><h4><a id="Create+table+with+two+column+families+using+xml+input"></a>Create table with two column families using xml input</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml" -H "Content-Type: text/xml"\
-d '<?xml version="1.0" encoding="UTF-8"?><TableSchema name="table1"><ColumnSchema name="family1"/><ColumnSchema name="family2"/></TableSchema>'\
-X PUT 'https://localhost:8443/gateway/sandbox/hbase/table1/schema'
</code></pre><h4><a id="Create+table+with+two+column+families+using+JSON+input"></a>Create table with two column families using JSON input</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: application/json" -H "Content-Type: application/json"\
-d '{"name":"table2","ColumnSchema":[{"name":"family3"},{"name":"family4"}]}'\
-X PUT 'https://localhost:8443/gateway/sandbox/hbase/table2/schema'
</code></pre><h4><a id="Get+table+metadata"></a>Get table metadata</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/regions'
</code></pre><h4><a id="Insert+single+row+table"></a>Insert single row table</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Content-Type: text/xml"\
-H "Accept: text/xml"\
-d '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><CellSet><Row key="cm93MQ=="><Cell column="ZmFtaWx5MTpjb2wx" >dGVzdA==</Cell></Row></CellSet>'\
-X POST 'https://localhost:8443/gateway/sandbox/hbase/table1/row1'
</code></pre><h4><a id="Insert+multiple+rows+into+table"></a>Insert multiple rows into table</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Content-Type: text/xml"\
-H "Accept: text/xml"\
-d '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><CellSet><Row key="cm93MA=="><Cell column=" ZmFtaWx5Mzpjb2x1bW4x" >dGVzdA==</Cell></Row><Row key="cm93MQ=="><Cell column=" ZmFtaWx5NDpjb2x1bW4x" >dGVzdA==</Cell></Row></CellSet>'\
-X POST 'https://localhost:8443/gateway/sandbox/hbase/table2/false-row-key'
</code></pre><h4><a id="Get+all+data+from+table"></a>Get all data from table</h4><p>Set Accept Header to “text/plain”, “text/xml”, “application/json” or “application/x-protobuf”</p>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/*'
</code></pre><h4><a id="Execute+cell+or+row+query"></a>Execute cell or row query</h4><p>Set Accept Header to “text/plain”, “text/xml”, “application/json” or “application/x-protobuf”</p>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/row1/family1:col1'
</code></pre><h4><a id="Delete+entire+row+from+table"></a>Delete entire row from table</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table2/row0'
</code></pre><h4><a id="Delete+column+family+from+row"></a>Delete column family from row</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table2/row0/family3'
</code></pre><h4><a id="Delete+specific+column+from+row"></a>Delete specific column from row</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table2/row0/family3'
</code></pre><h4><a id="Create+scanner"></a>Create scanner</h4><p>Scanner URL will be in Location response header</p>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Content-Type: text/xml"\
-d '<Scanner batch="1"/>'\
-X PUT 'https://localhost:8443/gateway/sandbox/hbase/table1/scanner'
</code></pre><h4><a id="Get+the+values+of+the+next+cells+found+by+the+scanner"></a>Get the values of the next cells found by the scanner</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: application/json"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/scanner/13705290446328cff5ed'
</code></pre><h4><a id="Delete+scanner"></a>Delete scanner</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table1/scanner/13705290446328cff5ed'
</code></pre><h4><a id="Delete+table"></a>Delete table</h4>
-<pre><code>% curl -ik -u guest:guest-password\
+<pre><code>curl -ik -u guest:guest-password\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table1/schema'
</code></pre><h3><a id="Hive"></a>Hive</h3><p>TODO</p><h4><a id="Hive+URL+Mapping"></a>Hive URL Mapping</h4><p>TODO</p><h4><a id="Hive+Examples"></a>Hive Examples</h4><p>This guide provides detailed examples for how to to some basic interactions with Hive via the Apache Knox Gateway.</p><h5><a id="Hive+Setup"></a>Hive Setup</h5>
<ol>
Modified: incubator/knox/trunk/books/0.3.0/book_getting-started.md
URL: http://svn.apache.org/viewvc/incubator/knox/trunk/books/0.3.0/book_getting-started.md?rev=1530477&r1=1530476&r2=1530477&view=diff
==============================================================================
--- incubator/knox/trunk/books/0.3.0/book_getting-started.md (original)
+++ incubator/knox/trunk/books/0.3.0/book_getting-started.md Wed Oct 9 01:24:17 2013
@@ -158,7 +158,6 @@ The table below provides a brief explana
| README | Provides basic information about the Apache Knox Gateway. |
| ISSUES | Describes significant know issues. |
| CHANGES | Enumerates the changes between releases. |
-| INSTALL | Provides simple installation instructions. |
| LICENSE | Documents the license under which this software is provided. |
| NOTICE | Documents required attribution notices for included dependencies. |
| DISCLAIMER | Documents that this release is from a project undergoing incubation at Apache. |
@@ -175,11 +174,12 @@ Only more recent versions of some Hadoop
| WebHCat/Templeton | 0.11.0 | ![y] | ![y] |
| Ozzie | 4.0.0 | ![y] | ![y] |
| HBase/Stargate | 0.95.2 | ![y] | ![?] |
-| Hive (via WebHCat) | 0.11.0 | ![y] | ![y] |
-| | 0.12.0 | ![y] | ![y] |
+| Hive (via WebHCat) | 0.11.0 | ![y] | ![n] |
+| | 0.12.0 | ![y] | ![?] |
| Hive (via JDBC) | 0.11.0 | ![n] | ![n] |
-| | 0.12.0 | ![?]![y] | ![?] |
-| Hive (via ODBC) | 0.12.0 | ![?] | ![?] |
+| | 0.12.0 | ![?] | ![?] |
+| Hive (via ODBC) | 0.11.0 | ![n] | ![n] |
+| Hive | 0.12.0 | ![?] | ![?] |
### Sandbox Configuration ###
Modified: incubator/knox/trunk/books/0.3.0/service_hbase.md
URL: http://svn.apache.org/viewvc/incubator/knox/trunk/books/0.3.0/service_hbase.md?rev=1530477&r1=1530476&r2=1530477&view=diff
==============================================================================
--- incubator/knox/trunk/books/0.3.0/service_hbase.md (original)
+++ incubator/knox/trunk/books/0.3.0/service_hbase.md Wed Oct 9 01:24:17 2013
@@ -38,9 +38,9 @@ The command below launches the Stargate
sudo /usr/lib/hbase/bin/hbase-daemon.sh start rest -p 60080
-60080 post is used because it was specified in sample Hadoop cluster deployment `{GATEWAY_HOME}/deployments/sandbox.xml`.
+Port 60080 is used because it was specified in sample Hadoop cluster deployment `{GATEWAY_HOME}/deployments/sandbox.xml`.
-#### Configure Sandbox port mapping for VirtualBox
+#### Configure Sandbox port mapping for VirtualBox ####
1. Select the VM
2. Select menu Machine>Settings...
@@ -51,15 +51,25 @@ The command below launches the Stargate
7. Press OK to close the rule window
8. Press OK to Network window save the changes
-60080 post is used because it was specified in sample Hadoop cluster deployment `{GATEWAY_HOME}/deployments/sandbox.xml`.
+60080 pot is used because it was specified in sample Hadoop cluster deployment `{GATEWAY_HOME}/deployments/sandbox.xml`.
-### HBase/Stargate client DSL
+#### HBase Restart ####
-#### Usage
+If it becomes necessary to restart HBase you can log into the hosts running HBase and use these steps.
+
+ sudo /usr/lib/hbase/bin/hbase-daemon.sh stop rest
+ sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh stop regionserver
+ sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh stop master
+
+ sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh start regionserver
+ sudo -u hbase /usr/lib/hbase/bin/hbase-daemon.sh start master
+ sudo /usr/lib/hbase/bin/hbase-daemon.sh start rest -p 60080
+
+### HBase/Stargate client DSL ###
For more details about client DSL usage please follow this [page|https://cwiki.apache.org/confluence/display/KNOX/Client+Usage].
-##### systemVersion() - Query Software Version.
+#### systemVersion() - Query Software Version.
* Request
* No request parameters.
@@ -68,7 +78,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).systemVersion().now().string`
-##### clusterVersion() - Query Storage Cluster Version.
+#### clusterVersion() - Query Storage Cluster Version.
* Request
* No request parameters.
@@ -77,7 +87,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).clusterVersion().now().string`
-##### status() - Query Storage Cluster Status.
+#### status() - Query Storage Cluster Status.
* Request
* No request parameters.
@@ -86,7 +96,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).status().now().string`
-##### table().list() - Query Table List.
+#### table().list() - Query Table List.
* Request
* No request parameters.
@@ -95,7 +105,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).table().list().now().string`
-##### table(String tableName).schema() - Query Table Schema.
+#### table(String tableName).schema() - Query Table Schema.
* Request
* No request parameters.
@@ -104,7 +114,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).table().schema().now().string`
-##### table(String tableName).create() - Create Table Schema.
+#### table(String tableName).create() - Create Table Schema.
* Request
* attribute(String name, Object value) - the table's attribute.
@@ -129,7 +139,7 @@ For more details about client DSL usage
.attribute("tb_attr3", "value5")
.now()
-##### table(String tableName).update() - Update Table Schema.
+#### table(String tableName).update() - Update Table Schema.
* Request
* family(String name) - starts family definition. Has sub requests:
@@ -149,7 +159,7 @@ For more details about client DSL usage
.endFamilyDef()
.now()```
-##### table(String tableName).regions() - Query Table Metadata.
+#### table(String tableName).regions() - Query Table Metadata.
* Request
* No request parameters.
@@ -158,7 +168,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).table(tableName).regions().now().string`
-##### table(String tableName).delete() - Delete Table.
+#### table(String tableName).delete() - Delete Table.
* Request
* No request parameters.
@@ -167,7 +177,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).table(tableName).delete().now()`
-##### table(String tableName).row(String rowId).store() - Cell Store.
+#### table(String tableName).row(String rowId).store() - Cell Store.
* Request
* column(String family, String qualifier, Object value, Long time) - the data to store; "qualifier" may be "null"; "time" is optional.
@@ -187,7 +197,7 @@ For more details about client DSL usage
.column("family1", "row2_col1", "row2_col_value1")
.now()
-##### table(String tableName).row(String rowId).query() - Cell or Row Query.
+#### table(String tableName).row(String rowId).query() - Cell or Row Query.
* rowId is optional. Querying with null or empty rowId will select all rows.
* Request
@@ -216,7 +226,7 @@ For more details about client DSL usage
.numVersions(1)
.now().string
-##### table(String tableName).row(String rowId).delete() - Row, Column, or Cell Delete.
+#### table(String tableName).row(String rowId).delete() - Row, Column, or Cell Delete.
* Request
* column(String family, String qualifier) - the column to delete; "qualifier" is optional.
@@ -238,7 +248,7 @@ For more details about client DSL usage
.time(Long.MAX_VALUE)
.now()```
-##### table(String tableName).scanner().create() - Scanner Creation.
+#### table(String tableName).scanner().create() - Scanner Creation.
* Request
* startRow(String) - the lower bound for filtration by row id.
@@ -268,7 +278,7 @@ For more details about client DSL usage
.maxVersions(100)
.now()```
-##### table(String tableName).scanner(String scannerId).getNext() - Scanner Get Next.
+#### table(String tableName).scanner(String scannerId).getNext() - Scanner Get Next.
* Request
* No request parameters.
@@ -277,7 +287,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).table(tableName).scanner(scannerId).getNext().now().string`
-##### table(String tableName).scanner(String scannerId).delete() - Scanner Deletion.
+#### table(String tableName).scanner(String scannerId).delete() - Scanner Deletion.
* Request
* No request parameters.
@@ -286,7 +296,7 @@ For more details about client DSL usage
* Example
* `HBase.session(session).table(tableName).scanner(scannerId).delete().now()`
-#### Examples
+### HBase/Stargate via Client DSL ###
This example illustrates sequence of all basic HBase operations:
1. get system version
@@ -515,7 +525,7 @@ Set Accept Header to "text/plain", "text
Set Accept Header to "text/plain", "text/xml", "application/json" or "application/x-protobuf"
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/status/cluster'
@@ -523,33 +533,33 @@ Set Accept Header to "text/plain", "text
Set Accept Header to "text/plain", "text/xml", "application/json" or "application/x-protobuf"
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase'
#### Create table with two column families using xml input
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml" -H "Content-Type: text/xml"\
-d '<?xml version="1.0" encoding="UTF-8"?><TableSchema name="table1"><ColumnSchema name="family1"/><ColumnSchema name="family2"/></TableSchema>'\
-X PUT 'https://localhost:8443/gateway/sandbox/hbase/table1/schema'
#### Create table with two column families using JSON input
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: application/json" -H "Content-Type: application/json"\
-d '{"name":"table2","ColumnSchema":[{"name":"family3"},{"name":"family4"}]}'\
-X PUT 'https://localhost:8443/gateway/sandbox/hbase/table2/schema'
#### Get table metadata
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/regions'
#### Insert single row table
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Content-Type: text/xml"\
-H "Accept: text/xml"\
-d '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><CellSet><Row key="cm93MQ=="><Cell column="ZmFtaWx5MTpjb2wx" >dGVzdA==</Cell></Row></CellSet>'\
@@ -557,7 +567,7 @@ Set Accept Header to "text/plain", "text
#### Insert multiple rows into table
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Content-Type: text/xml"\
-H "Accept: text/xml"\
-d '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><CellSet><Row key="cm93MA=="><Cell column=" ZmFtaWx5Mzpjb2x1bW4x" >dGVzdA==</Cell></Row><Row key="cm93MQ=="><Cell column=" ZmFtaWx5NDpjb2x1bW4x" >dGVzdA==</Cell></Row></CellSet>'\
@@ -567,7 +577,7 @@ Set Accept Header to "text/plain", "text
Set Accept Header to "text/plain", "text/xml", "application/json" or "application/x-protobuf"
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/*'
@@ -575,25 +585,25 @@ Set Accept Header to "text/plain", "text
Set Accept Header to "text/plain", "text/xml", "application/json" or "application/x-protobuf"
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/row1/family1:col1'
#### Delete entire row from table
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table2/row0'
#### Delete column family from row
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table2/row0/family3'
#### Delete specific column from row
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table2/row0/family3'
@@ -601,24 +611,24 @@ Set Accept Header to "text/plain", "text
Scanner URL will be in Location response header
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Content-Type: text/xml"\
-d '<Scanner batch="1"/>'\
-X PUT 'https://localhost:8443/gateway/sandbox/hbase/table1/scanner'
#### Get the values of the next cells found by the scanner
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: application/json"\
-X GET 'https://localhost:8443/gateway/sandbox/hbase/table1/scanner/13705290446328cff5ed'
#### Delete scanner
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-H "Accept: text/xml"\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table1/scanner/13705290446328cff5ed'
#### Delete table
- % curl -ik -u guest:guest-password\
+ curl -ik -u guest:guest-password\
-X DELETE 'https://localhost:8443/gateway/sandbox/hbase/table1/schema'