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.