HBase篇---Shell命令行和Rest API

create ‘表名’, ‘列族名1’, ‘列族名2’, ‘列族名N’；

删除列族：alter ‘表名’, {NAME=> ‘列族名’, METHOD=> ‘delete’}

describe ‘表名’

desc ‘表名’

curl -vi -X GET 

-H "Accept:text/xml"

 "http://IP:port/users/schema"

curl -vi -X POST \

  -H "Accept: text/xml" \

  -H "Content-Type: text/xml" \

  -d '<?xml version="1.0" encoding="UTF-8"?><TableSchema name="users"><ColumnSchema name="cf" /></TableSchema>' \

  "http://IP:port/users/schema"

curl -vi -X PUT \

  -H "Accept: text/xml" \

  -H "Content-Type: text/xml" \

  -d '<?xml version="1.0" encoding="UTF-8"?><TableSchema name="users"><ColumnSchema name="cf" KEEP_DELETED_CELLS="true" /></TableSchema>' \

  "http://IP:port/users/schema"

curl -vi -X DELETE \

  -H "Accept: text/xml" \

  "http://IP:port/users/schema"

curl -vi -X GET \
  -H "Accept: text/xml" \
  "http://IP:port/users/regions

Get all columns of a single row. Values are Base-64 encoded. This requires the "Accept" request header with a type that can hold multiple columns (like xml, json or protobuf).

curl -vi -X GET \
  -H "Accept: text/xml" \
  "http://IP:port/users/row1"

curl -vi -X GET \
  -H "Accept: text/xml" \
  "http://IP:port/users/row1/cf:a/klle18"

curl -vi -X GET \

  -H "Accept: text/xml" \

  "http://IP:port/users/row1/cf:a"

curl -vi -X GET \

  -H "Accept: text/xml" \

   "http://IP:port/users/row1/cf:a/"

curl -vi -X GET \
  -H "Accept: text/xml" \
  "http://example.com:8000/users/row1/cf:a?v=2"

Write a row to a table. The row, column qualifier, and value must each be Base-64 encoded. To encode a string, use the base64 command-line utility. To decode the string, use base64 -d. The payload is in the --dataargument, and the /users/fakerow value is a placeholder. Insert multiple rows by adding them to the <CellSet> element. You can also save the data to be inserted to a file and pass it to the -dparameter with syntax like -d @filename.txt.

curl -vi -X PUT \

  -H "Accept: text/xml" \

  -H "Content-Type: text/xml" \

  -d '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><CellSet><Row key="cm93NQo="><Cell column="Y2Y6ZQo=">dmFsdWU1Cg==</Cell></Row></CellSet>' \

  "http://IP:port/users/fakerow"

Get a Scanner object. Required by all other Scan operations. Adjust the batch parameter to the number of rows the scan should return in a batch. See the next example for adding filters to your scanner. The scanner endpoint URL is returned as the Location in the HTTP response. The other examples in this table assume that the scanner endpoint

curl -vi -X PUT \

  -H "Accept: text/xml" \

  -H "Content-Type: text/xml" \

  -d '<Scanner batch="1"/>' \

  "http://IP:port/users/scanner/"

To supply filters to the Scanner object or configure the Scanner in any other way, you can create a text file and add your filter to the file. For example, to return only rows for which keys start with <codeph>u123</codeph> and use a batch size of 100, the filter file would look like this:

[source,xml] ---- <Scanner batch="100"> <filter> { "type": "PrefixFilter", "value": "u123" } </filter> </Scanner> ----

Pass the file to the -d argument of the curl request.

curl -vi -X PUT \
  -H "Accept: text/xml" \
  -H "Content-Type:text/xml" \
  -d @filter.txt \
  "http://IP:port/users/scanner/"

curl -vi -X GET \
  -H "Accept: text/xml" \
  "http://IP:port/users/scanner/ScannerID"

curl -vi -X DELETE \
  -H "Accept: text/xml" \
  "http://IP:port/users/scanner/ScannerID"