[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.
