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 ------------------------------------------------------------------------------ ||DESC ||'''Desc''' command will provides information about the columnfamilies in a table.[[BR]][[BR]]~-''DESC table_name;''-~ || ||CREATE ||'''Create''' command will create a new table.[[BR]][[BR]]~-''CREATE table_name[[BR]]COLUMNFAMILIES('columnfamily_name1'[, 'columnfamily_name2', ...])[[BR]][LIMIT=limitNumber_of_Version];''-~ || ||DROP ||'''Drop''' command will droping columnfamilies in a table or tables.[[BR]][[BR]]~-''DROP table_name1[, table_name2, ...] or columnfamily_name1[, columnfamily_name2, ...];''-~ || - ||SUBSTITUTE[[BR]] || '''Substitute''' query to [A~Z][[BR]][[BR]]~-''X = Matrix(table_name, columnfamily_name);''-~|| + ||SUBSTITUTE[[BR]] || '''Substitute''' expression to [A~Z][[BR]][[BR]]~-''X = Matrix(table_name, columnfamily_name);''-~|| ||STORE ||'''STORE''' command will store results to specified table. [[BR]][[BR]]~-''A = Table('movieLog_table'); [[BR]]B = A.Selection('length' > 100); [[BR]]STORE B TO X run_style;''-~ || ||EXIT ||<99%>'''Exit''' from the current shell script.[[BR]][[BR]]~-''EXIT;''-~ || And, Commands to manually manipulate data on more detailed parts. @@ -64, +64 @@ ||DELETE ||'''Delete''' command will delete specified rows in table. [[BR]][[BR]]~-''DELETE table_name[[BR]]WHERE row='row_key'[[BR]][AND column='columnfamily_name:column_key'];''-~ || ||SELECT ||<99%>'''Select''' command will retrieves rows from a table.[[BR]][[BR]]~-''SELECT table_name[[BR]][WHERE row='row_key'][[BR]][AND column='columnfamily_name:column_key'];[[BR]][AND time='Specified_Timestamp'];[[BR]][LIMIT=Number_of_Version];''-~ || - == Relational Operations == + == Relational Operatiors == - ||<bgcolor="#ececec">'''Operators''' ||<bgcolor="#ececec">'''Explanation''' || + ||<bgcolor="#ececec">'''Operator''' ||<bgcolor="#ececec">'''Explanation''' || - ||PROJECTION||<99%>is defined as the set that is obtained when all tuples in ~+R+~ are restricted to the set {a,,1,,,...,a,,n,,}.|| - ||SELECTION||<99%>...|| - ||PRODUCT||<99%>...|| - ||RENAME||<99%>'''Rename''' r to x|| - ||GROUP||<99%>...|| - ||SORT||<99%>...|| + ||PROJECTION||<99%>'''Projection''' of a relation ~+R+~, It makes a new relation as the set that is obtained when all tuples(rows) in ~+R+~ are restricted to the set {columnfamily,,1,,,...,columnfamily,,n,,}.[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Projection('year','length');''-~|| + ||SELECTION||<99%>'''Selection''' of a relation ~+R+~, It makes a new relation as the set of specified tuples(rows) of the relation ~+R+~[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Selection('length' > 100);''-~|| + ||PRODUCT||<99%>'''Product''' of relations R and S, It makes a new relation as the set of all possible combinations of tuples of the two operation relations.[[BR]]'''NOTE''' that this is the most computationally expensive operator in the relational algebra.|| + ||RENAME||<99%>'''Rename''' r to x, The columnfamily names in the columnfamily-list replace the columnfamily names of the relation.[[BR]][[BR]]~-''A = Table('movieLog_table');[[BR]]B = A.Rename('length' = 'movieLength');''-~|| + ||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');''-~|| - - ||<bgcolor="#ececec">'''Operators''' ||<bgcolor="#ececec">'''Explanation''' || + ||<bgcolor="#ececec">'''Operator''' ||<bgcolor="#ececec">'''Explanation''' || - ||UNION ||<99%>'''Union''' AâªB contains all the elements of A and it contains all the elements of B.|| - ||INTERSECTION ||<99%>'''Intersection''' Aâ©B is a subset of A and it is a subset of B.|| - ||DIFFERENCE ||'''Difference''' of A and B (A-B).|| + ||UNION ||<99%>'''Union''' R1âªR2 is a relation that includes all tuples(rows) that are either in R1 or R2 or in both without duplicate tuples.|| + ||INTERSECTION ||<99%>'''Intersection''' R1â©R2 is a relation that includes only those tuples(rows) in R1 that also appear in R2.|| + ||DIFFERENCE ||'''Difference''' of R1 and R2, R1 - R2 is a relation that includes all tuples that are in R1 and not in R2.|| - ||<bgcolor="#ececec">'''Functions''' ||<bgcolor="#ececec">'''Explanation''' || - ||AVG ||<99%>...|| - ||SUM ||<99%>...|| - ||COUNT ||<99%>...|| - ||MIN ||<99%>...|| - ||MAX ||<99%>...|| - - == Matrix Operations == + == Matrix Operators == ||<bgcolor="#ececec">'''Operation''' ||<bgcolor="#ececec">'''Explanation''' || ||DOUBLEMATRIX||<99%>...|| @@ -153, +145 @@ ||Star Wars ||1977 ||124 ||true ||Fox ||12345 || ||Mighty Ducks ||1991 ||104 ||true ||Disney ||67890 || + === Renaming === + + '''~+^ÏS^+~'''~-columnfamily-list-~'''~+^(movieLog_table)^+~''' + + === Groupping === + + '''~+^γ^+~'''~-columnfamily-list-~'''~+^(R)^+~''' + + === Sorting === + + '''~+^Ï^+~'''~-columnfamily-list-~'''~+^(R)^+~''' === Example ===