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 - - }}} -