[Lucene-hadoop Wiki] Update of "HbaseShell/Examples" by udanax

[Apache Wiki <wi...@apache.org>]

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/HbaseShell/Examples

------------------------------------------------------------------------------
- Describe HbaseShell/Examples here.
+ = Example Of Hbase Shell Use =
+ [[TableOfContents(4)]]
+ ----
  
+ == Basic Data Manipulation Examples On Hbase Shell ==
+ 
+ === Create a table in an HBase ===
+ 
+ {{{
+ HBase > CREATE Movie (
+     --> year, length, inColor, studioName, vote, producer)
+     --> NUM_VERSIONS=10; 
+ 
+ HBase > CREATE MovieStar (
+     --> biography, filmography, gender, birthDate)
+     --> NUM_VERSIONS=10;
+ }}}
+ 
+ === Insert data into a table ===
+ {{{
+ HBase > INSERT INTO Movie (year:, length:, inColor:, studioName:, vote:user_1, producer:)
+     --> VALUES ('1977', '124', 'true', 'Fox', '5', 'George Lucas')
+     --> WHERE row='Star Wars';
+ 
+ 
+ HBase > INSERT INTO MovieStar (biography:, 'filmography:Star Wars', gender:, birthDate:)
+     --> VALUES ('blah blah', 'starring', 'male', 'March 31, 1971')
+     --> WHERE row='Ewan Gordon Mc.Gregor'; 
+ }}}
+ 
+ === Show all data in a table ===
+ {{{
+ HBase > SELECT * Movie;
+ }}}
+ 
+ ||Row Key ||<-12>Column Families ||
+ ||<rowbgcolor="#ececec">title ||<-2> year ||<-2>length ||<-2>inColor ||<-2> studioName ||<-2> vote ||<-2> producer ||
+ ||Star Wars ||year: || 1977 ||length: || 124 ||inColor: || true ||studioName: || Fox || vote:''user_1'' || 5 || producer: || George Lucas ||
+ || || || || || || || || || || vote:''user_2'' || 2 || || ||
+ ||Mighty Ducks ||year: || 1991 ||length: || 104 ||inColor: || true ||studioName: || Disney || vote:''user_1'' || 2 || producer: || Blair Peters ||
+ || || || || || || || || || || vote:''user_3'' || 4 || || ||
+ ||Wayne's World ||year: || 1992 ||length: || 95 ||inColor: || true ||studioName: || Paramount || vote:''user_2'' || 3 || producer: || Penelope Spheeris ||
+ || || || || || || || || || || vote:''user_3'' || 4 || || ||
+ 
+ {{{
+ HBase > SELECT * MovieStar;
+ }}}
+ 
+ ||Row Key ||<-8>Column Families ||
+ ||<rowbgcolor="#ececec">starName ||<-2> biography ||<-2>filmography ||<-2>gender ||<-2> birthDate ||
+ ||Ewan Gordon Mc.Gregor ||biography: ||blah blah ||filmography:Star Wars ||starring ||gender: ||male ||birthDate: ||March 31, 1971 ||
+ || || || ||filmography:Emma ||extra || || || || ||
+ ||Kenan Thompson ||biography: ||blah blah ||filmography:Mighty Ducks ||starring ||gender: ||male ||birthDate: ||May 10, 1978 ||
+ || || || ||filmography:Big Fat Liar  ||cameo || || || || ||
+ ||keanu reeves ||biography: ||blah blah ||filmography:Constantine ||starring ||gender: ||male ||birthDate: ||September 2, 1964||
+ || || || ||filmography:The Matrix Reloaded ||starring || || || || ||
+ 
+ 
+ === Transactions ===
+ 
+ {{{
+ START TRANSACTION Movie ON 'Star Wars';
+ 
+ INSERT INTO Movie ('character:Luke Skywalker', 'character:Han Solo')
+   VALUES ('Mark Hamil', 'Harrison Ford');
+ INSERT INTO Movie (genre:) VALUES ('action, adventure, fantasy');
+ 
+ COMMIT; 
+ }}}
+ 
+ 
+ ||Row Key ||<-12>Column Families ||
+ ||<rowbgcolor="#ececec">title ||<-2> year ||<-2>length ||<-2>inColor ||<-2> studioName ||<-2> vote ||<-2> producer ||<-2> character||
+ ||Star Wars ||year: || 1977 ||length: || 124 ||inColor: || true ||studioName: || Fox || vote:''user_1'' || 5 || producer: || George Lucas || character:Luke Skywalker || Mark Hamil ||
+ || || || || || || || || || || vote:''user_2'' || 2 || || || character:Han Solo || Harrison Ford ||
+ ||Mighty Ducks ||year: || 1991 ||length: || 104 ||inColor: || true ||studioName: || Disney || vote:''user_1'' || 2 || producer: || Blair Peters || || ||
+ || || || || || || || || || || vote:''user_3'' || 4 || || || || ||
+ ||Wayne's World ||year: || 1992 ||length: || 95 ||inColor: || true ||studioName: || Paramount || vote:''user_2'' || 3 || producer: || Penelope Spheeris || || ||
+ || || || || || || || || || || vote:''user_3'' || 4 || || || || ||
+ 
+ 
+ ----
+ 
+ == Relational Operations Example On Hbase Altools ==
+