Mailing-List: contact hadoop-commits-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hadoop-dev@lucene.apache.org
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
From: Apache Wiki <wikidiffs@apache.org>
To: hadoop-commits@lucene.apache.org
Date: Mon, 02 Jul 2007 13:33:59 -0000
Message-ID: <20070702133359.26917.99013@eos.apache.org>
Subject: [Lucene-hadoop Wiki] Update of "Hbase/HbaseShell" by udanax

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

------------------------------------------------------------------------------
  ||DESC ||'''Desc''' command will provides information about the columnfamilies in a table.[[BR]][[BR]]~-''DESC table_name;''-~ ||
  ||CREATE ||'''Create''' command will create a new table.[[BR]][[BR]]~-''CREATE table_name[[BR]]COLUMNFAMILIES('columnfamily_name1'[, 'columnfamily_name2', ...])[[BR]][LIMIT=limitNumber_of_Version];''-~ ||
  ||DROP ||'''Drop''' command will droping columnfamilies in a table or tables.[[BR]][[BR]]~-''DROP table_name1[, table_name2, ...] or columnfamily_name1[, columnfamily_name2, ...];''-~ ||
- ||SUBSTITUTE[[BR]] || '''Substitute''' query to [A~Z][[BR]][[BR]]~-''X = Matrix(table_name, columnfamily_name);''-~||
+ ||SUBSTITUTE[[BR]] || '''Substitute''' expression to [A~Z][[BR]][[BR]]~-''X = Matrix(table_name, columnfamily_name);''-~||
  ||STORE ||'''STORE''' command will store results to specified table. [[BR]][[BR]]~-''A = Table('movieLog_table'); [[BR]]B = A.Selection('length' > 100); [[BR]]STORE B TO X run_style;''-~ ||
  ||EXIT ||<99%>'''Exit''' from the current shell script.[[BR]][[BR]]~-''EXIT;''-~ ||
  And, Commands to manually manipulate data on more detailed parts.
@@ -64, +64 @@

  ||DELETE ||'''Delete''' command will delete specified rows in table. [[BR]][[BR]]~-''DELETE table_name[[BR]]WHERE row='row_key'[[BR]][AND column='columnfamily_name:column_key'];''-~ ||
  ||SELECT ||<99%>'''Select''' command will retrieves rows from a table.[[BR]][[BR]]~-''SELECT table_name[[BR]][WHERE row='row_key'][[BR]][AND column='columnfamily_name:column_key'];[[BR]][AND time='Specified_Timestamp'];[[BR]][LIMIT=Number_of_Version];''-~ ||
  
- == Relational Operations ==
+ == Relational Operatiors ==
  
- ||<bgcolor="#ececec">'''Operators''' ||<bgcolor="#ececec">'''Explanation''' ||
+ ||<bgcolor="#ececec">'''Operator''' ||<bgcolor="#ececec">'''Explanation''' ||
- ||PROJECTION||<99%>is defined as the set that is obtained when all tuples in ~+R+~ are restricted to the set {a,,1,,,...,a,,n,,}.||
- ||SELECTION||<99%>...||
- ||PRODUCT||<99%>...||
- ||RENAME||<99%>'''Rename''' r to x||
- ||GROUP||<99%>...||
- ||SORT||<99%>...||
+ ||PROJECTION||<99%>'''Projection''' of a relation ~+R+~, It makes a new relation as the set that is obtained when all tuples(rows) in ~+R+~ are restricted to the set {columnfamily,,1,,,...,columnfamily,,n,,}.[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Projection('year','length');''-~||
+ ||SELECTION||<99%>'''Selection''' of a relation ~+R+~, It makes a new relation as the set of specified tuples(rows) of the relation ~+R+~[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Selection('length' > 100);''-~||
+ ||PRODUCT||<99%>'''Product''' of relations R and S, It makes a new relation as the set of all possible combinations of tuples of the two operation relations.[[BR]]'''NOTE''' that this is the most computationally expensive operator in the relational algebra.||
+ ||RENAME||<99%>'''Rename''' r to x, The columnfamily names in the columnfamily-list replace the columnfamily names of the relation.[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Rename('length' = 'movieLength');''-~||
+ ||GROUP||<99%>'''Group''' tuples by value of an attribute and apply aggregate function independently to each group of tuples.[[BR]]'''Aggregate Functions''' : ~-''AVG( attribute ), SUM( attribute ), COUNT( attribute ), MIN( attribute ), MAX( attribute )''-~[[BR]][[BR]]~-''A = Table('movieLog_table);[[BR]]B = A.Group('studioName', MIN('year'));''-~||
+ ||SORT||<99%>'''Sort''' of tuples(rows) of R, ordered according to columnfamilies on columnfamily-list[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Sort('length', 'vote');''-~||
  
- 
- ||<bgcolor="#ececec">'''Operators''' ||<bgcolor="#ececec">'''Explanation''' ||
+ ||<bgcolor="#ececec">'''Operator''' ||<bgcolor="#ececec">'''Explanation''' ||
- ||UNION ||<99%>'''Union''' A∪B contains all the elements of A and it contains all the elements of B.||
- ||INTERSECTION ||<99%>'''Intersection''' A∩B is a subset of A and it is a subset of B.||
- ||DIFFERENCE ||'''Difference''' of A and B (A-B).||
+ ||UNION ||<99%>'''Union''' R1∪R2 is a relation that includes all tuples(rows) that are either in R1 or R2 or in both without duplicate tuples.||
+ ||INTERSECTION ||<99%>'''Intersection''' R1∩R2 is a relation that includes only those tuples(rows) in R1 that also appear in R2.||
+ ||DIFFERENCE ||'''Difference''' of R1 and R2, R1 - R2 is a relation that includes all tuples that are in R1 and not in R2.||
  
- ||<bgcolor="#ececec">'''Functions''' ||<bgcolor="#ececec">'''Explanation''' ||
- ||AVG ||<99%>...||
- ||SUM ||<99%>...||
- ||COUNT ||<99%>...||
- ||MIN ||<99%>...||
- ||MAX ||<99%>...||
- 
- == Matrix Operations ==
+ == Matrix Operators ==
  
  ||<bgcolor="#ececec">'''Operation''' ||<bgcolor="#ececec">'''Explanation''' ||
  ||DOUBLEMATRIX||<99%>...||
@@ -153, +145 @@

  ||Star Wars ||1977 ||124 ||true ||Fox ||12345 ||
  ||Mighty Ducks ||1991 ||104 ||true ||Disney ||67890 ||
  
+ === Renaming ===
+ 
+ '''~+^ρS^+~'''~-columnfamily-list-~'''~+^(movieLog_table)^+~'''
+ 
+ === Groupping ===
+ 
+ '''~+^γ^+~'''~-columnfamily-list-~'''~+^(R)^+~'''
+ 
+ === Sorting ===
+ 
+ '''~+^τ^+~'''~-columnfamily-list-~'''~+^(R)^+~'''
  
  === Example ===