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, 30 Jul 2007 13:45:15 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'));''-~||
  ||Sort ||<99%>'''Sort''' of tuples(rows) of R, ordered according to columnfamilies
on columnfamily-list[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Sort('length',
'vote');''-~||
  
+ 
+ '''~+^π^+~'''~-title-~,~-year-~,~-length-~'''~+^(movieLog_table)^+~'''
+ 
+ A = table('movieLog_table');
+ [[BR]]B = A.projection('year','length');
+ 
+ ||<rowbgcolor="#ececec">title ||year ||length ||
+ ||Star Wars ||1977 ||124 ||
+ ||Mighty Ducks ||1991 ||104 ||
+ ||Wayne's World ||1992 ||95 ||
+ 
+ '''~+^σ^+~'''~-length>100-~'''~+^(movieLog_table)^+~'''
+ 
+ A = Table('movieLog_table');
+ [[BR]]B = A.Selection(length > 100);
+ 
+ ||<rowbgcolor="#ececec">title ||year ||length ||inColor ||studioName ||producer ||
+ ||Star Wars ||1977 ||124 ||true ||Fox ||12345 ||
+ ||Mighty Ducks ||1991 ||104 ||true ||Disney ||67890 ||
+ 
+ 
+ '''~+^π^+~'''~-title-~,~-year-~'''~+^(σ^+~'''~-length>100-~'''~+^(movieLog_table)∩σ^+~'''~-studioName='Fox'-~'''~+^(movieLog_table))^+~'''
+ 
+ A = Table('movieLog_table');
+ [[BR]]B = A.Projection('year');
+ [[BR]]C = B.Selection(length > 100 AND studioName = 'Fox');
+ 
+ ||<rowbgcolor="#ececec">title ||year ||
+ ||Star Wars ||1977 ||
+ 
  == Matrix Operators ==
  
  
@@ -83, +113 @@

  ||subtraction ||<99%>... ||
  ||multiplication ||<99%>... ||
  ||division ||<99%>... ||
- ||transpose ||<99%>interchanging rows and columns ||
+ ||transpose ||<99%>... ||
  ||permutation ||<99%>... ||
  ||norms ||<99%>... ||
  
@@ -94, +124 @@

  ||QR ||<99%>... ||
  ||Cholesky ||<99%>... ||
  ||SVD ||<99%>... ||
- ||Inverse ||<99%>interchanging rows and columns ||
+ ||Inverse ||<99%>... ||
  ||Pseudoinverse ||<99%>... ||
  ||Condition ||<99%>... ||
  ||Determinant ||<99%>... ||

Mime
View raw message