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 Wed, 19 Sep 2007 06:04:06 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

The comment on the change is:
Deleting comment. See the "ShellPlans" page.

------------------------------------------------------------------------------
  = Comments =
  
  Please add comments related to the project below.
- ----
- Commented by [:udanax: Edward yoon] 2007/09/18
  
- '''Case 1 : My initial style'''
- 
- {{{
-  Hbase > A = table('movieLog_table');
-  Hbase > B = A.Group('length', 'vote');
-  Hbase > Store B to table('m_table');
- }}}
- 
- '''Case 2 : SQL style'''
- 
- {{{
-  Hbase > CREATE TABLE m_table ('vote');
-  Hbase > INSERT INTO m_table ('vote')
-      --> SELECT * FROM  
-      --> (SELECT 
-      --> length, vote
-      --> FROM movieLog_table
-      --> GROUP BY length)
-      --> ORDER BY 1;
- }}}
- 
- In either case, return the same results. (It's a simple example.)
- 
- '''m_table : '''
- 
- {{{
-     Row                  Columnfamilies
- ------------    ----------------------------------  
-    length               vote                ...
- ------------     -------------------   ----------
-     0112          vote:user2      1       ...
-                   vote:user4      5
-     0124          vote:user3      3
-     0125          vote:user3      1
-     0131          vote:user1      2
-                   vote:user4      4
-                   ...
- }}}
- 
- 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
- ---------- ---------- ---------- ---------- ----------
-    0112                        1                     5
-    0124                                   3 
-    0125                                   1 
-    0131             2                                4
- }}}
- 
- Now, you want the analysis to find an unknown pattern between length and user? 
- 
- {{{
- Hbase > we can just use the matrix operations.
- }}}
- 
- '''So, Here's my questions.'''
- 
-  * What is a better syntax for Multi-dimensional Algebraic Operations commands?
-  * I don't think Sub-Shell(Separated Altools) is good. How think about it?
-  * Should i attempt to imitate SQL? I think it may be more difficult than we expected.
- 
- Any comments are welcomed.
- [[BR]]Thank you.
- 

Mime
View raw message