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/ShellPlans

------------------------------------------------------------------------------
  Plan is to significantly expand the set of shell operators.  Basic data 
manipulation and data definition operators will be extended and evolved to be 
more SQL-like ([wiki:Hbase/HbaseShell/HQL HQL]).  More sophisticated 
manipulations to do relational and linear algebra, matrix additions, 
multiplications, etc., will be added to a HBase subshell to keep the two 
operator types -- SQL-like vs. non-SQL -- distinct.
  
   ''-- After POC(proof of concept) review, many things can change.''
+ 
+ This project is currently in the planning stage.  
[https://issues.apache.org/jira/browse/HADOOP-1608 HADOOP-1608] to add 
"Relational Algrebra Operators" is currently in process.
  
  ----
  
@@ -36, +38 @@

  
  ----
  
- === Suggested Hbase altools Syntax ===
+ == Suggested Hbase altools Syntax ==
  '''Note''' that Data should be located by their row, column, and timestamp.
  
- ==== Commands ====
+ === Commands ===
  ||<bgcolor="#E5E5E5">'''Command''' ||<bgcolor="#E5E5E5">'''Explanation''' ||
  ||Table ||<99%>'''Table''' command loads specified table. 
[[BR]][[BR]]~-''Table('movieLog_table');''-~ ||
  ||Matrix ||<99%>'''Matrix''' command constructs the configuration of the 
logic matrix.[[BR]]'''Options''' : features not yet. 
[[BR]][[BR]]~-''Matrix(table_name, columnfamily_name[, option]);''-~ ||
@@ -47, +49 @@

  ||IF...ELSE ||<99%>'''IF...ELSE''', Imposes conditions on the execution. 
[[BR]][[BR]]~-''IF ( boolean_expression )[[BR]]B = 
command_statements;[[BR]]ELSE[[BR]]B = command_statements;''-~||
  ||Store ||<99%>'''Store''' command will store results to specified table. 
[[BR]][[BR]]~-''A = Table('movieLog_table'); [[BR]]B = A.Selection(length > 
100); [[BR]]Store B TO table('tmp_table')[or file('backup.dat')];''-~ ||
  
- ==== Relational Operators ====
+ === Relational Operators ===
  ||<bgcolor="#E5E5E5">'''Operator''' ||<bgcolor="#E5E5E5">'''Explanation''' ||
  ||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'); 
'''//π,,year.length,,(A)''' ''-~ ||
  ||Selection ||<99%>'''Selection''' of a relation ~+R+~, It makes a new 
relation as the set of specified tuples(rows) of the relation 
~+R+~.[[BR]]'''Set Operations''' : ~-''OR, AND, NOT''-~[[BR]][[BR]]~-''A = 
Table('movieLog_table');[[BR]]B = A.Selection(length > 100 AND studioName = 
'Fox'); '''//σ,,length > 100.studioName='Fox',,(A)''' ''-~ ||
@@ -77, +79 @@

  Hbase.altools > store C to table('result_table'); 
  }}}
  
- ==== Matrix Arithmetic Operators ====
+ === Matrix Arithmetic Operators ===
  ||<bgcolor="#E5E5E5">'''Operator''' ||<bgcolor="#E5E5E5">'''Explanation''' ||
  ||Addition ||<99%>'''Adding''' entries with the same indices. 
[[BR]][[BR]]~-''A = Matrix('m_table','cf_1');[[BR]]B = 
Matrix('m_table','cf_2');[[BR]]C = A + B; '''// c,,ij,, = a,,ij,, + b,,ij,, (i 
: row key, j : column key)''' ''-~ ||
  ||Subtraction ||<99%>'''Subtracting''' entries with the same 
indices.[[BR]][[BR]]~-''A = Matrix('m_table','cf_1');[[BR]]B = 
Matrix('m_table','cf_2');[[BR]]C = A - B; '''// c,,ij,, = a,,ij,, - b,,ij,, (i 
: row key, j : column key)''' ''-~ ||
@@ -94, +96 @@

  Hbase.altools > C = A * B;  
  }}}
  
- ==== Factorizations and Decompositions ====
+ === Factorizations and Decompositions ===
  
  ||<bgcolor="#E5E5E5">'''Function''' ||<bgcolor="#E5E5E5">'''Explanation''' ||
  ||LU ||<99%>'''LU Decomposition'''[[BR]]A procedure for decomposing an N by N 
matrix A into a product of a lower triangular matrix L and an upper triangular 
matrix U, LU = A.[[BR]]'''Functions''' : ~-''getL(), getU(), isSingular(), 
getPivot()''-~ [[BR]][[BR]]~-''A = Matrix('m_table','cf_1');[[BR]]B = 
LUDecomposition(A);[[BR]]C = getU(B);[[BR]]D = getL(A);''-~||
@@ -134, +136 @@

  St.Ack
  }}}
  
- This project is currently in the planning stage.  
[https://issues.apache.org/jira/browse/HADOOP-1608 HADOOP-1608] to add 
"Relational Algrebra Operators" is currently in process.
- 
- ----
- = Example Of Hbase Shell Use =
- 
- See the HBase Shell Full Usage Page. 
-  * [:Hbase/HbaseShell/Examples]
- 

Reply via email to