[
https://issues.apache.org/jira/browse/HADOOP-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
stack resolved HADOOP-2671.
---------------------------
Resolution: Invalid
Closing as invalid since Edward moved the comparison table to a better
location,
http://wiki.apache.org/hadoop/Hbase/HbaseShell#head-eacdd17b4d5b95e3da1f0e18bd9caf6f019b7089.
> [HQL discuss] HQL spec definition
> ---------------------------------
>
> Key: HADOOP-2671
> URL: https://issues.apache.org/jira/browse/HADOOP-2671
> Project: Hadoop
> Issue Type: Wish
> Components: contrib/hbase
> Reporter: Edward Yoon
> Priority: Trivial
>
> This is a comparison table between a SQL and HQL.
> IMO, i don't think these features(SQL) are perfectly fit with HQL and Hbase,
> but If you want for anything from here, please let me know using comment.
> Thanks.
> || *SQL* || *HQL* ||
> | *Select Statement* \\
> SELECT "column_name" FROM "table_name" \\ | O \\
> \\ |
> | *Distinct* \\
> SELECT DISTINCT "column_name" \\
> FROM "table_name" \\ | {color:#cc0000}{*}X{*}{color} |
> | *Where* \\
> SELECT "column_name" \\
> FROM "table_name" \\
> WHERE "condition" \\ | {color:#cc0000}{*}X{*}{color} |
> | *And / Or* \\
> SELECT "column_name" \\
> FROM "table_name" \\
> WHERE "simple condition" \\
> \{\[AND\|OR\] "simple condition"\}\+ \\ | {color:#cc0000}{*}X{*}{color}\\ |
> | *In* \\
> SELECT "column_name" \\
> FROM "table_name" \\
> WHERE "column_name" IN ('value1', 'value2', ...) \\ |
> {color:#cc0000}{*}X{*}{color} |
> | *Between* \\
> SELECT "column_name" \\
> FROM "table_name" \\
> WHERE "column_name" BETWEEN 'value1' AND 'value2' \\ |
> {color:#cc0000}{*}X{*}{color} |
> | *Like* \\
> SELECT "column_name" \\
> FROM "table_name" \\
> WHERE "column_name" LIKE \{PATTERN\} \\ | {color:#cc0000}{*}X{*}{color}\\ |
> | *Order By* \\
> SELECT "column_name" \\
> FROM "table_name" \\
> \[WHERE "condition"\] \\
> ORDER BY "column_name" \[ASC, DESC\] \\ | {color:#cc0000}{*}X{*}{color} |
> | *Count / Sum / Min / Max / Avg* \\
> SELECT COUNT("column_name") \\
> FROM "table_name" \\ | {color:#cc0000}{*}X{*}{color}\\ |
> | *Group By* \\
> SELECT "column_name1", SUM("column_name2") \\
> FROM "table_name" \\
> GROUP BY "column_name1" \\ | {color:#cc0000}{*}X{*}{color} |
> | *Having* \\
> SELECT "column_name1", SUM("column_name2") \\
> FROM "table_name" \\
> GROUP BY "column_name1" \\
> HAVING (arithematic function condition) \\ | {color:#cc0000}{*}X{*}{color} \\
> |
> | *Create Table Statement* \\
> CREATE TABLE "table_name" \\
> ("column 1" "data_type_for_column_1", \\
> "column 2" "data_type_for_column_2", \\
> ... ) \\ | O \\ |
> | *Drop Table Statement* \\
> DROP TABLE "table_name" \\ | O \\ |
> | *Truncate Table Statement* \\
> TRUNCATE TABLE "table_name" \\ | O \\ |
> | *Insert Into Statement* \\
> INSERT INTO "table_name" ("column1", "column2", ...) \\
> VALUES ("value1", "value2", ...) \\ | O \\ |
> | *Update Statement* \\
> UPDATE "table_name" \\
> SET "column_1" = \[new value\] \\
> WHERE \{condition\} \\ | {color:#cc0000}{*}X{*}{color} \\ |
> | *Delete From Statement* \\
> DELETE FROM "table_name" \\
> WHERE \{condition\} \\ | O \\ |
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
