hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Trivial Update of "Hbase/HbaseShell" by udanax
Date Thu, 31 Jan 2008 11:07:19 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The following page has been changed by udanax:
http://wiki.apache.org/hadoop/Hbase/HbaseShell

------------------------------------------------------------------------------
  {{{    }}}1.1 [#DAL Database administration language] [[BR]]
  {{{    }}}1.2 [#DDL Data definition language] [[BR]]
  {{{    }}}1.3 [#DML Data manipulation language] [[BR]]
- {{{ }}}2. [#SQLvsHQL Comparison table between SQL and HQL] [[BR]] 
- {{{    }}}2.1 [#devList Under Development List] [[BR]]
- {{{ }}}3. [#Example Example Of HQL Uses] [[BR]]
+ {{{ }}}2. [#Example Example Of HQL Uses] [[BR]]
- {{{    }}}3.1 [#Create Create the table in a Hbase] [[BR]]
+ {{{    }}}2.1 [#Create Create the table in a Hbase] [[BR]]
- {{{    }}}3.2 [#Select Select data from a table] [[BR]]
+ {{{    }}}2.2 [#Select Select data from a table] [[BR]]
- {{{    }}}3.3 [#Insert Insert data into a table] [[BR]]
+ {{{    }}}2.3 [#Insert Insert data into a table] [[BR]]
- {{{    }}}3.4 [#Delete Delete data in a table] [[BR]]
+ {{{    }}}2.4 [#Delete Delete data in a table] [[BR]]
- {{{    }}}3.5 [#Jar How to use external jars in Hbase Shell] [[BR]]
+ {{{    }}}2.5 [#Jar How to use external jars in Hbase Shell] [[BR]]
  
  [[Anchor(QueryGrammars)]]
  == Query Grammars ==
@@ -74, +72 @@

  ||Insert ||<99%>'''Insert''' one row into the table with a value for specified column
in the table.[[BR]][[BR]]~-''INSERT INTO table_name (colmn_name, ...)[[BR]]{{{    }}}VALUES
('value', ...)[[BR]]{{{    }}}WHERE row = 'row-key'[[BR]]{{{    }}}[TIMESTAMP 'timestamp'];''-~
||
  ||Delete ||'''Delete''' specified rows in table. [[BR]][[BR]]~-''DELETE { column_name, [,
column_name] ... | COLUMNFAMILIES(column_family[, column_family] ... | *} [[BR]]{{{    }}}FROM
table_name[[BR]]{{{    }}}[WHERE row = 'row-key'];''-~ ||
  ||Select ||<99%>'''Select''' syntax retrieves rows from a table.[[BR]]Several aggregate
operators: COUNT()[[BR]][[BR]]~-''SELECT { column_name [, column_name] ... | expr[alias] |
* }[[BR]]{{{    }}}FROM table_name[[BR]]{{{    }}}[WHERE row = 'row-key' | STARTING FROM 'row-key'
[UNTIL 'stop-key']][[BR]]{{{    }}}[NUM_VERSIONS = version_count][[BR]]{{{    }}}[TIMESTAMP
'timestamp'][[BR]]{{{    }}}[LIMIT = row_count][[BR]]{{{    }}}[INTO FILE 'file_name'][[BR]][[BR]]''-~'''column_name:'''~-''[[BR]]{{{
    }}}column_family_name[[BR]]{{{    }}}| column_family_name:column_label_name''-~ ||
- 
- [[Anchor(SQLvsHQL)]]
- == Comparison table between SQL and HQL ==
- 
- ||<bgcolor="#ececec">'''SQL''' ||<bgcolor="#ececec">'''HQL 0.0.2'''||
- ||'''Select Statement'''[[BR]]SELECT "column_name" FROM "table_name"||O||
- ||'''Distinct'''[[BR]]SELECT DISTINCT "column_name"[[BR]]FROM "table_name"||O ||
- ||'''Where'''[[BR]]SELECT "column_name"[[BR]]FROM "table_name"[[BR]]WHERE "condition"||Only
row/column/timestamp ||
- ||'''And/Or'''[[BR]]SELECT "column_name"[[BR]]FROM "table_name"[[BR]]WHERE "simple condition"[[BR]{[AND|OR]
"simple condition"}+ ||X ||
- ||'''In'''[[BR]]SELECT "column_name"[[BR]]FROM "table_name"[[BR]]WHERE "column_name" IN
('value1', 'value2', ...) ||X ||
- ||'''Between'''[[BR]]SELECT "column_name"[[BR]]FROM "table_name"[[BR]]WHERE "column_name"
BETWEEN 'value1' AND 'value2'||X ||
- ||'''Like'''[[BR]]SELECT "column_name"[[BR]]FROM "table_name"[[BR]]WHERE "column_name" LIKE
{PATTERN} ||X ||
- ||'''Order By'''[[BR]]SELECT "column_name"[[BR]]FROM "table_name"[[BR]][WHERE "condition"][[BR]]ORDER
BY "column_name" [ASC, DESC] ||X ||
- ||'''Count/Sum/Min/Max/Avg'''[[BR]]SELECT COUNT("column_name")[[BR]]FROM "table_name" ||Only
COUNT() ||
- ||'''Group By'''[[BR]]SELECT "column_name1", SUM("column_name2")[[BR]]FROM "table_name"[[BR]]GROUP
BY "column_name1"||X ||
- ||'''Having'''[[BR]]SELECT "column_name1", SUM("column_name2")[[BR]]FROM "table_name"[[BR]]GROUP
BY "column_name1"[[BR]]HAVING (arithematic function condition)||X ||
- ||'''Create Table Statement'''[[BR]]CREATE TABLE "table_name"[[BR]]("column 1" "data_type_for_column_1",[[BR]]"column
2" "data_type_for_column_2",[[BR]]... ) ||O ||
- ||'''Drop Table Statement'''[[BR]]DROP TABLE "table_name"||O ||
- ||'''Truncate Table Statement'''[[BR]]TRUNCATE TABLE "table_name" ||O ||
- ||'''Insert Into Statement'''[[BR]]INSERT INTO "table_name" ("column1", "column2", ...)[[BR]]VALUES
("value1", "value2", ...) ||O ||
- ||'''Update Statement'''[[BR]]UPDATE "table_name"[[BR]]SET "column_1" = [new value][[BR]]WHERE
{condition} ||X ||
- ||'''Delete From Statement'''[[BR]]DELETE FROM "table_name"[[BR]]WHERE {condition} ||O ||
- 
- [[Anchor(devList)]]
- === Under Development List ===
- 
- If you find need of something that has not been implemented, please send a request to [:udanax:me]
or [https://issues.apache.org/jira JIRA]
- 
-  * Delete Command
- 
  [[Anchor(Example)]]
  == Example Of HQL Uses ==
  [[Anchor(Create)]]

Mime
View raw message