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/ShellPlans" by udanax
Date Mon, 13 Aug 2007 08:10:51 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/ShellPlans

------------------------------------------------------------------------------
  ||Group ||<99%>'''Group''' tuples by value of an attribute and apply aggregate function
independently to each group of tuples.[[BR]]'''Aggregate Functions''' : ~-''AVG( attribute
), SUM( attribute ), COUNT( attribute ), MIN( attribute ), MAX( attribute )''-~[[BR]][[BR]]~-''A
= Table('movieLog_table);[[BR]]B = A.Group('studioName', MIN('year')); '''//γ,,studioName.MIN(
year ),,(A)''' ''-~ ||
  ||Sort ||<99%>'''Sort''' of tuples(rows) of R, ordered according to columnfamilies
on columnfamily-list.[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = Sort A by ('length');
'''//τ,,length,,(A)''' ''-~ ||
  
- '''(ex. 1) '''Search the subject and the year of the movies which were produced by 'Fox'
company and where running time is more than 100 minutes.
+ '''(ex. 1)''' Search the subject and the year of the movies which were produced by 'Fox'
company and where running time is more than 100 minutes.
  [[BR]]~-''π ,,title.year,, (σ ,,length > 100,, (movieLog_table)∩σ ,,studioName =
'Fox',, (movieLog_table))''-~
  
  {{{
  Hbase.altools > A = Table('movieLog_table'); 
  Hbase.altools > B = A.Selection(length > 100 AND studioName = 'Fox'); 
  Hbase.altools > C = B.Projection('year'); 
+ 
+ Hbase.altools > store C to table('result_table'); 
+ }}}
+ 
+ '''(ex. 2)''' Theta Join : ▷◁,,C,,
+ [[BR]]~-''movieStars_table▷◁,,actor < year,,movieLog_table''-~
+ 
+ {{{
+ Hbase.altools > A = Table('movieLog_table'); 
+ Hbase.altools > B = Table('movieStars_table');
+ Hbase.altools > C = A.thetaJoin(B);
  }}}
  
  ==== Matrix Arithmetic Operators ====

Mime
View raw message