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)]]
