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 Mon, 19 Nov 2007 02:13:49 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

------------------------------------------------------------------------------
  === Relational Join ===
   * The join of two relations R1(A,,1,, ,A,,2,, ,...,A,,n,,) and R2(B,,1,, ,B,,2,, ,...,B,,m,,)
is a relation with degree k=n+m and attributes (A,,1,, ,A,,2,, ,...,A,,n,, , B,,1,, ,B,,2,,
,...,B,,m,,) that satisfy the join condition
    * Result = R1 ▷◁ ,,θ join_condition,, R2
+ {{{
+ R1
+ +----------------------------------------------------------------------------------------------+
+ | title         producer      actor                              studioName            
       |
+ | ============================================================================================
|
+ | Star Wars     George Lucas                                     Fox Entertainment Group,
Inc. |
+ | Mighty Ducks  Blair Peters  actor:hero      <Charles Adler>    Paramount Pictures
Corp.      |
+ |                             actor:cameo     <Someone>                          
             |
+ | Bodyguard     Mick Jackson  actor:hero      <Kevin Costner>    Warner Home Video
Inc.        |
+ |                             actor:heroine   <Whitney Houston>                  
             |
+ +----------------------------------------------------------------------------------------------+
+ 
+ R2
+ +---------------------------------------------------------+
+ | name              occupation   birth         knownFor   |
+ | ======================================================= |
+ | Whitney Houston   Singer       Aug 9, 1963   Diva       |
+ +---------------------------------------------------------+
+ 
+ Hbase > R1 = table('movieLog_table');
+ Hbase > R2 = table('personInfo_table');
+ Hbase > Result = R1.join(R1.producer: = R2.ROW) and R2; 
+      or Result = R1.join(R1.actor:hero = R2.Row) and R2;
+      or Result = R1.join(R1.actor:heroine = R2.Row and R1.studioName = 'Warner Home Video'
and R2.occupation = 'Singer') and R2;
+ 
+ Result
+ +--------------------------------------------------------------------------------------------------------------------+
+ | title     producer      actor                            studioName              occupation
 birth       knownFor  |
+ | ==================================================================================================================
|
+ | Bodyguard Mick Jackson  actor:heroine <Whitney Houston>  Warner Home Video Inc.
 Singer      Aug 9, 1963 Diva      |
+ +--------------------------------------------------------------------------------------------------------------------+
+ }}}
+ 
+  * If we don't have an index for a domain in the join, we can still improve on the nested-loop
join using sort join. 
+   * https://issues.apache.org/jira/browse/HADOOP-2021 
+ 
  {{{
  R1
  +----------------------------------------------------------------------------------------------+
@@ -255, +291 @@

  +----------------------------------------------------------------------------------------------+
  
  R2
- +---------------------------------------------------------+
- | name              occupation   birth         knownFor   |
- | ======================================================= |
- | Whitney Houston   Singer       Aug 9, 1963   Diva       |
- +---------------------------------------------------------+
- 
- Hbase > R1 = table('movieLog_table');
- Hbase > R2 = table('personInfo_table');
- Hbase > Result = R1.join(R1.producer: = R2.ROW) and R2; 
-      or Result = R1.join(R1.actor:hero = R2.Row) and R2;
-      or Result = R1.join(R1.actor:heroine = R2.Row and R1.studioName = 'Warner Home Video'
and R2.occupation = 'Singer') and R2;
- 
- Result
- +------------------------------------------------------------------------------------------------------------------------+
- | title         producer      actor                            studioName              occupation
 birth       knownFor  |
- | ======================================================================================================================
|
- | The Bodyguard Mick Jackson  actor:heroine <Whitney Houston>  Warner Home Video Inc.
 Singer      Aug 9, 1963 Diva      |
- +------------------------------------------------------------------------------------------------------------------------+
- }}}
- 
-  * If we don't have an index for a domain in the join, we can still improve on the nested-loop
join using sort join. 
-   * https://issues.apache.org/jira/browse/HADOOP-2021 
- 
- {{{
- R1
- +----------------------------------------------------------------------------------------------+
- | title         producer      actor                              studioName            
       |
- | ============================================================================================
|
- | Star Wars     George Lucas                                     Fox Entertainment Group,
Inc. |
- | Mighty Ducks  Blair Peters  actor:hero      <Charles Adler>    Paramount Pictures
Corp.      |
- |                             actor:cameo     <Someone>                          
             |
- | The Bodyguard Mick Jackson  actor:hero      <Kevin Costner>    Warner Home Video
Inc.        |
- |                             actor:heroine   <Whitney Houston>                  
             |
- +----------------------------------------------------------------------------------------------+
- 
- R2
  +--------------------------------------------------------------------------------------------------+
  | Symbol   corporation                     Market         Management                   
           |
  | ================================================================================================
|

Mime
View raw message