hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Lucene-hadoop Wiki] Trivial Update of "Hbase/HbaseShell" by udanax
Date Tue, 18 Sep 2007 23:31:48 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Lucene-hadoop Wiki" for change notification.

The following page has been changed by udanax:
http://wiki.apache.org/lucene-hadoop/Hbase/HbaseShell

------------------------------------------------------------------------------
  ||hbaseshell.jline.bell.enabled ||<99%>If true, enable audible keyboard bells if an
alert is required.||
  
  = Hbase Shell Commands =
- '''Note''' that Data should be located by their row, column, and timestamp.
+ 
+ '''Note''' that attribute values are quoted with either single or double quotes.
+ 
- == Hbase Shell Global Commands ==
+ == Hbase Shell Basic Commands ==
  ||<bgcolor="#ececec">'''Command''' ||<bgcolor="#ececec">'''Explanation''' ||
  ||Help ||<99%>'''Help''' command provides information about the use of shell script.[[BR]][[BR]]~-''HELP
[function_name];''-~ ||
  ||Show ||<99%>'''Show''' command lists tables.[[BR]][[BR]]~-''SHOW tables;''-~ ||
@@ -44, +46 @@

  ||Clear ||<99%>'''Clear''' the screen.[[BR]][[BR]]~-''CLEAR;''-~ ||
  ||Exit ||<99%>'''Exit''' from the current shell script.[[BR]][[BR]]~-''EXIT;''-~ ||
  
+ and, Definition commands to define data tables. 
- == HQL(Hbase Query Language) Commands ==
- 
- HQL is an SQL-like query language for Hbase. You can use it to query and modify tables in
Hbase. 
- [[BR]]'''Note''' that attribute values are quoted with either single or double quotes.
  
  ||<bgcolor="#ececec">'''Command''' ||<bgcolor="#ececec">'''Explanation''' ||
- ||Create ||'''Create''' command creates a new table.[[BR]][[BR]]~-''CREATE TABLE table_name
([[BR]]{{{    }}}column_family_spec[[BR]]{{{    }}}[, column_family_spec][[BR]]{{{    }}}...[[BR]])[[BR]][[BR]]''-~'''colum_family_spec:'''~-''[[BR]]column_family_name[[BR]]{{{
 }}}[MAX_VERSIONS=n][[BR]]{{{    }}}[MAX_LENGTH=n][[BR]]{{{    }}}[COMPRESSION=NONE|BLOCK|RECORD][[BR]]{{{
   }}}[IN_MEMORY][[BR]]{{{    }}}[BLOOMFILTER=NONE|BLOOM|COUNTING|RETOUCHED VECTOR_SIZE=n
NUM_HASH=n]''-~ ||
+ ||Create ||<99%>'''Create''' command creates a new table.[[BR]][[BR]]~-''CREATE TABLE
table_name ([[BR]]{{{    }}}column_family_spec[[BR]]{{{    }}}[, column_family_spec][[BR]]{{{
   }}}...[[BR]])[[BR]][[BR]]''-~'''colum_family_spec:'''~-''[[BR]]column_family_name[[BR]]{{{
 }}}[MAX_VERSIONS=n][[BR]]{{{    }}}[MAX_LENGTH=n][[BR]]{{{    }}}[COMPRESSION=NONE|BLOCK|RECORD][[BR]]{{{
   }}}[IN_MEMORY][[BR]]{{{    }}}[BLOOMFILTER=NONE|BLOOM|COUNTING|RETOUCHED VECTOR_SIZE=n
NUM_HASH=n]''-~ ||
- ||Alter ||'''Alter''' command changes the structure of the specified table.[[BR]][[BR]]~-''ALTER
TABLE table_name[[BR]]{{{    }}}alter_spec [, alter_spec] ...[[BR]][[BR]]''-~'''alter_spec:'''~-''[[BR]]{{{
    }}}ADD column_family_spec[[BR]]{{{    }}}| ADD (column_family_spec, ...)[[BR]]{{{    }}}|
DROP column_family_name[[BR]]{{{    }}}| CHANGE column_family_name column_family_spec''-~||
+ ||Alter ||<99%>'''Alter''' command changes the structure of the specified table.[[BR]][[BR]]~-''ALTER
TABLE table_name[[BR]]{{{    }}}alter_spec [, alter_spec] ...[[BR]][[BR]]''-~'''alter_spec:'''~-''[[BR]]{{{
    }}}ADD column_family_spec[[BR]]{{{    }}}| ADD (column_family_spec, ...)[[BR]]{{{    }}}|
DROP column_family_name[[BR]]{{{    }}}| CHANGE column_family_name column_family_spec''-~||
  ||Drop ||'''Drop''' command drops columnfamilies in a table or tables.[[BR]][[BR]]~-''DROP
table_name1[, table_name2, ...];''-~ ||
+ 
+ And, Commands to manually manipulate data on more detailed parts. 
+ 
+ ||<bgcolor="#ececec">'''Command''' ||<bgcolor="#ececec">'''Explanation''' ||
  ||Insert ||<99%>'''Insert''' command inserts one row into the table with a value for
specified column in the table.[[BR]][[BR]]~-''INSERT INTO table_name (colmn_name, ...)[[BR]]{{{
   }}}VALUES ('value', ...)[[BR]]{{{    }}}WHERE row = 'row-key'[[BR]]{{{    }}}[TIMESTAMP
'timestamp'];''-~ ||
  ||Delete ||'''Delete''' command deletes specified rows in table. [[BR]][[BR]]~-''DELETE
{ column_name, [, column_name] ... | *}[[BR]]{{{    }}}FROM table_name[[BR]]{{{    }}}WHERE
row = 'row-key';''-~ ||
  ||Select ||<99%>'''Select''' command retrieves rows from a table.[[BR]][[BR]]~-''SELECT
{ column_name [, column_name] ... | * }[[BR]]{{{    }}}FROM table_name[[BR]]{{{    }}}[WHERE
row = 'row-key' | STARTING FROM 'row-key'][[BR]]{{{    }}}[NUM_VERSIONS = version_count][[BR]]{{{
   }}}[TIMESTAMP 'timestamp'][[BR]]{{{    }}}[LIMIT = row_count][[BR]]{{{    }}}[INTO FILE
'file_name'][[BR]][[BR]]''-~'''column_name:'''~-''[[BR]]{{{     }}}column_family_name[[BR]]{{{
   }}}| column_family_name:column_label_name''-~ ||
  
  ----
  = Example =
- == Example Of HQL Use ==
+ == Example Of basic command Uses ==
  === Create the table in a Hbase ===
  
  {{{

Mime
View raw message