[
https://issues.apache.org/jira/browse/HADOOP-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12561194#action_12561194
]
stack commented on HADOOP-2671:
-------------------------------
This is a useful looking table Edward in that its explicit about the
differences between HQL and SQL. I'd suggest that it might be more accessible
if it was linked off the HQL page rather than as a description in a JIRA.
> [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.
