You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2007/12/29 09:46:49 UTC

[Lucene-hadoop Wiki] Update of "Hbase/HbaseShell/ShellPlans" 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/ShellPlans

The comment on the change is:
I have no permission

------------------------------------------------------------------------------
- [[TableOfContents(4)]]
+ deleted
  
-  * https://issues.apache.org/jira/browse/HADOOP-2329 Built-in Data Types.
-  * https://issues.apache.org/jira/browse/HADOOP-2265 LIKE operator for a select-condition.
- 
- = Hbase Shell Commands Plans =
- 
- ||<bgcolor="#E5E5E5">'''Command''' ||<bgcolor="#E5E5E5">'''Explanation''' ||
- ||Matrix ||<99%>'''Matrix''' command constructs the configuration of the logic matrix.[[BR]]'''Options''' : features not yet. [[BR]][[BR]]~-''Matrix(table_name, columnfamily_name[, option]);''-~ ||
- 
- 
- === Sparse Linear Algebra ===
-  * Proof of concept implementation for hbase-based Matrix Computing
-   * https://issues.apache.org/jira/browse/HADOOP-1655 (Click the "Vote it" button!!)
- 
-  * Load Matrix 
- {{{
- //Set up the matrix M from mapped matrix in hbase.
- Hbase > M = Matrix('m_table','cf_1'); 
- 
- M ([1, 2],
-    [3, 4])
- }}}
- 
- 
- 
-  * Matrix Addition
-  * ~-'''''C = A + B = (a,,ij,, + b,,ij,,)'''''-~
- 
- {{{
- //Set up the matrix A, B from mapped matrix in hbase.
- 
- Hbase > A = Matrix('m_table','cf_1');
- Hbase > B = Matrix('m_table','cf_2');
- Hbase > C = A + B;
- }}}
- 
- 
- 
-  * The product C of two matrices A and B
-  * ~-'''''C,,ij,, = ΣA,,ik,,B,,kj,, (1 ≤ i ≤ m , 1 ≤ j ≤n)'''''-~
- 
- {{{
- //Set up the matrix A, B from mapped matrix in hbase.
- 
- Hbase > A = Matrix('m_table','cf_1');
- Hbase > B = Matrix('m_table','cf_2');
- Hbase > C = A * B;
- }}}
- 
-  * To find the Singular Value decomposition in Altools, do the following:
-  * ~-'''''M = UΣV*'''''-~
- 
- {{{
- Hbase > A = M.SVDdecomposition();
- Hbase > U = A.getU();
- Hbase > S = A.getS();
- Hbase > V = A.getV();
- 
- U ([[-0.40455358, -0.9145143 ],
-     [-0.9145143 ,  0.40455358]])
- 
- S ([ 5.4649857 ,  0.36596619])
- 
- V ([[-0.57604844, -0.81741556],
-     [ 0.81741556, -0.57604844]])
- }}}
- 
-  * To find the QR decomposition in Altools, do the following:
-  * ~-'''''M = QR'''''-~
- 
- {{{
- Hbase > A = M.QRDecomposition();
- Hbase > U = A.getQ();
- Hbase > U = A.getR();
- 
- Q ([[-0.31622777, -0.9486833 ],
-     [-0.9486833 ,  0.31622777]])
- 
- R ([[-3.16227766, -4.42718872],
-     [ 0.        , -0.63245553]])
- }}}
- 
- 
- ----
- = Some Ideas Note =
- 
- {{{
- select column_qualifier1, column_qualifier2 from 2d_table(table_name, columnfamily_name) where row='row key';
- }}}
- 
-  * User Defined Function (UDF)
- 
- {{{
- create function isValidUrl(address) returning boolean ??
- 
- insert into webtable (anchor) values("http://www.google.com");
- insert into webtable (anchor) values("http://www.naver.com");
- 
- select * from webtable where row = 'http://blog.udanax.org' and isValidUrl(anchor);
- }}}
- 
-  * Find the theaters in the radius 2km from specified center.
- 
- {{{
- 2D geographic data table :
- 
-               restaurant,                        theater,                        d-store
-               restaurant:y_position | firm_name  theater:y_position | firm_name  d-store:y_position | firm_name
- x_position    ...                                ...                             ...
- ...
- 
- }}}
- 
-  * Find the relation between the Picture and the Keyword
- 
- {{{
- webTable :
- 
- title  content  anchor                                           image
- ..     ..       anchor:http://..doc1  main page                  image:type         PNG
-                 anchor:http://..doc2  http://upload/..svg.png    image:address      http://upload/..svg.png
-                                                                  image:dimensions   500 * 500
-                                                                  image:size         44125 bytes
- 
- }}}
-