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 "HbaseShell" by udanax
Date Thu, 21 Jun 2007 10:17:15 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/HbaseShell

------------------------------------------------------------------------------
  I expect Hadoop + Hbase to handle sparsity and data explosion very well in near future.
[[BR]]Moreover, i believe the design of the multi-dimensional structure and the 3-dim space
model of the data are [[BR]]optimized for rapid ad-hoc information retrieval in any orientation,
as well as for fast, flexible calculation and transformation of [[BR]]raw data based on formulaic
relationships.
  
  Then, I thought it would require a more user-friendly interface to enable querying the data
interactive. 
- [[BR]]So, I began building parallel processing shell  [[BR]]to help make general algebraic
and logical data modeling works easier on Hadoop + Hbase
  
  == Rationale ==
  ...
@@ -36, +35 @@

  == Basic Commands ==
  
  ||<#ececec> '''Command''' ||<#ececec> '''Explanation''' ||
+ ||HELP ||<99%>'''Help''' command provides information about the use of shell script.[[BR]][[BR]]~-''HELP
[function_name];''-~ ||
- ||SHOW ||<99%>'''Show''' command will list the tables.[[BR]][[BR]]~-''SHOW tables''-~
||
+ ||SHOW ||<99%>'''Show''' command will list the tables.[[BR]][[BR]]~-''SHOW tables;''-~
||
- ||DESC ||'''Desc''' command will provides information about the columnfamilies in a table.[[BR]][[BR]]~-''DESC
table_name''-~ ||
+ ||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 column in a table or tables.[[BR]][[BR]]~-''DROP
table_name1[, table_name2, ...];''-~ ||
+ ||DROP ||'''Drop''' command will droping columnfamilies in a table or tables.[[BR]][[BR]]~-''DROP
table_name1[, table_name2, ...] or columnfamily_name1[, columnfamily_name2, ...];''-~ ||
- ||PRINT ||'''Print''' command will print a results to the console output. [[BR]][[BR]]~-''A
= array([1, 2, 3]);[[BR]]PRINT A;[[BR]]B = SELECT table_name WHERE row="rowKey";[[BR]]PRINT
B;''-~||
+ ||PRINT ||'''Print''' command will print a results to the console output. [[BR]][[BR]]~-''A
= array([1, 2, 3]);[[BR]]PRINT A;[[BR]]B = SELECT table_name WHERE row="row_key";[[BR]]PRINT
B;''-~||
- ||STORE ||'''STORE''' command will store results to specified table. [[BR]][[BR]]~-''M =
matrix('table_name','columnfamily_name');[[BR]]A = array([[1, 2],[3, 4]]);[[BR]]STORE A TO
M run_style;[[BR]]B = SELECT table_name WHERE row="row_key";[[BR]]STORE B TO ('table_name','columnfamily_name1'[,
'columnfamily_name2']) run_style;''-~||
+ ||STORE ||'''STORE''' command will store results to specified table. [[BR]][[BR]]~-''M =
matrix('table_name','columnfamily_name');[[BR]]A = array([[1, 2],[3, 4]]);  //In this case,
Key should be an integer index. [[BR]]STORE A TO M run_style;[[BR]]B = SELECT table_name WHERE
row="row_key";[[BR]]STORE B TO ('table_name','columnfamily_name1'[, 'columnfamily_name2'])
run_style;''-~||
+ ||EXIT ||<99%>'''Exit''' from the current shell script.[[BR]][[BR]]~-''EXIT;''-~ ||
  
  And, Commands to manually manipulate data on more detailed parts.
  
+ ||<#ececec> '''Command''' ||<#ececec> '''Explanation''' ||
+ ||INSERT ||<99%>'''Insert''' command will insert one row into the table with a value
for specified column in the table.[[BR]][[BR]]~-''INSERT table_name[[BR]] VALUES('columnfamily_name:column_key','entry')[[BR]]WHERE
row="row_key";''-~ ||
+ ||SET ||'''SET''' command will change the values. [[BR]][[BR]]~-''SET table_name[[BR]] VALUES('columnfamily_name:column_key','entry')[[BR]]WHERE
row="row_key" AND time="Specified_Timestamp";''-~||
+ ||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"];''-~||
+ 
+ === Relational Algebra Operators ===
  
  ||<#ececec> '''Command''' ||<#ececec> '''Explanation''' ||
+ ||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];''-~ ||
- ||INSERT ||<99%>'''Insert''' command will insert one row into the table with a value
for specified column in the table.[[BR]][[BR]]~-''INSERT table_name[[BR]] VALUES('columnfamily_name:column_key','entry')[[BR]]WHERE
row="row_key";''-~ ||
- ||SET ||'''SET''' command will change the values. [[BR]][[BR]]~-''SET table_name[[BR]] VALUES('columnfamily_name:column_key','entry')[[BR]]WHERE
row="row_key";''-~||
- ||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"];''-~||
  
  === Aggregation Functions ===
  
+ Generic one dimensional counting??
+ 
- ||<#ececec> '''Command''' ||<#ececec> '''Explanation''' ||
+ ||<#ececec> '''Functions''' ||<#ececec> '''Explanation''' ||
- ||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];''-~ ||
+ ||SUM ||<99%>'''SUM''' 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];''-~ ||
  
  ...
  
@@ -79, +86 @@

  ..
  == Basic Usage ==
  ..
+ == Relation Algebra Operations ==
+ ..
  == Matrix Operations ==
  ..
  
@@ -91, +100 @@

  ..
  == Consistency Assessment Of Topological Relationship By Matrix-Union ==
  .. 
- 
  ----
  = People Involved =
  

Mime
View raw message