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, 03 Dec 2007 09:54:23 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:
add a sub-table index

------------------------------------------------------------------------------
  ----
  = Example =
  == Example Of Basic Query Command Uses ==
+ 
+  * [#create Create the table in a Hbase]
+  * [#select Select data from a table]
+  * [#insert Insert data into a table]
+  * [#jars How to use external jars in Hbase Shell]
+ 
+ [[Anchor(create)]]
  === Create the table in a Hbase ===
  
  {{{
@@ -118, +125 @@

    --> anchor max_length=256 bloomfilter=counting                                  
    --> vector_size=1000000 num_hash=4);
  }}}
- 
+ [[Anchor(select)]]
  === Select data from a table ===
  {{{
  hql > help select;
@@ -153, +160 @@

  
  hql > SELECT 'studioName:YoungGu Art, Corp.' FROM movieLog_table WHERE row = 'D-War';
  }}}
- 
+ [[Anchor(insert)]]
  === Insert data into a table ===
  {{{
  hql > help insert;
@@ -179, +186 @@

    --> VALUES ('1977', '124', 'true', 'Fox', '5', 'George Lucas', 'Mark Hamill')
    --> WHERE row='Star Wars';
  }}}
- 
+ [[Anchor(jars)]]
  === How to use external jars in Hbase Shell ===
  
  {{{
@@ -191, +198 @@

  }}}
  
  == Example Of Relational Algebraic Query Command Uses ==
+  * Relational Algebra Operations
+   * [#projection Relational Projection]
+   * [#selection Relational Selection]
+   * [#group Relational Group]
+   * [#join Relational Join]
+   * [#mixture Query mixture examples]
  
+ [[Anchor(projection)]]
  === Relational Projection ===
  
   * selects a subset of the columnfamilies of a relation
@@ -216, +230 @@

  | Mighty Ducks  1991   104     |
  +------------------------------+
  }}}
+ [[Anchor(selection)]]
  === Relational Selection ===
   * selects a subset of the rows in a relation that satisfy a selection condition
   * Result = σ ,,selection_condition,, (Relation) 
@@ -240, +255 @@

  | Star Wars     1977   124     true    Fox Entertainment Group, Inc. |
  +--------------------------------------------------------------------+
  }}}
- 
+ [[Anchor(group)]]
  === Relational Group ===
   * Aggregation functions on collections of data values: average, minimum, maximum, sum,
count.
   * Group rows by value of an columnfamily and apply aggregate function independently to
each group of rows.
@@ -249, +264 @@

  {{{
  Hbase > Group Relation by (studioName, SUM('vote:user'));
  }}}
- 
+ [[Anchor(join)]]
  === 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
@@ -314, +329 @@

  hql > R2 = table('stockCompany_info');
  hql > result = R1.join(R1.studioName = R2.corporation) and R2;
  }}}
- 
+ [[Anchor(mixture)]]
  === Query mixture examples ===
  
  '''(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.

Mime
View raw message