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 14:29:14 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

------------------------------------------------------------------------------
  
  {{{
   Hbase > A = table('movieLog_table');
-  Hbase > B = A.Group('RunningTime', SUM('vote'));
+  Hbase > B = A.Group('length', 'vote');
   Hbase > Store B to table('m_table');
  }}}
  
@@ -187, +187 @@

  {{{
   Hbase > CREATE TABLE m_table ('vote');
   Hbase > INSERT INTO m_table ('vote')
-      --> SELECT  * FROM  
+      --> SELECT * FROM  
       --> (SELECT 
+      --> length, vote
-      --> RunningTime,
-      --> sum('vote:user1') vote:user1, 
-      --> sum('vote:user2') vote:user2, 
-      --> sum('vote:user3') vote:user3, 
-      --> sum('vote:user4') vote:user4 
-          ...
-          ..
       --> FROM movieLog_table
-      --> GROUP BY RunningTime)
+      --> GROUP BY length)
-      --> ORDER BY 1; 
+      --> ORDER BY 1;
  }}}
  
- In either case, return the same results.
+ In either case, return the same results. (It's a simple example.)
  
  '''m_table : '''
  
  {{{
      Row                  Columnfamilies
  ------------    ----------------------------------  
-  RunningTime          vote                ...
+    length               vote                ...
  ------------     -------------------   ----------
-     112           vote:user2   1100       ...
+     0112          vote:user2      1       ...
-                   vote:user4   1500
+                   vote:user4      5
-     124           vote:user3   1600
+     0124          vote:user3      3
-     125           vote:user3   2850
+     0125          vote:user3      1
-     131           vote:user1   2450
+     0131          vote:user1      2
-                   vote:user4   3050
+                   vote:user4      4
                    ...
  }}}
  
- The expected matrix A of (Movie Running Time by User) would be as sampled below :
+ The expected matrix A of (length by User) would be as sampled below :
  [[BR]]Note : Cell data is an aggregate value of voting.
  
  {{{
             Vote:user1 vote:user2 vote:user3 vote:user4
  ---------- ---------- ---------- ---------- ----------
-    112                      1100                  1500
+    0112                        1                     5
-    124                                 1600 
+    0124                                   3 
-    125                                 2850 
+    0125                                   1 
-    131           2450                             3050
+    0131             2                                4
  }}}
  
- Now, you want the analysis to find a unknown relationship between User and Movie Running
Time? 
+ Now, you want the analysis to find an unknown pattern between length and user? 
  
  {{{
- Hbase > ok, you can find a unknown relationship using the algebraic operations.
+ Hbase > we can just use the matrix operations.
  }}}
  
  '''So, Here's my questions.'''

Mime
View raw message