SQL 语句参考
常规参考
DDL 语句
CREATE DATABASE
CREATE TABLE
CREATE VIEW
CREATE FUNCTION
CREATE TABLE FROM
CREATE TABLE USING HIVEFORMAT
CREATE TABLE LIKE
CREATE STREAMING TABLE
CREATE MATERIALIZED VIEW
CREATE VOLUME
ALTER TABLE
ALTER VIEW
ALTER MATERIALIZED VIEW
DROP DATABASE
DROP TABLE
DROP VIEW
DROP FUNCTION
DROP STREAMING TABLE
DROP MATERIALIZED VIEW
DROP VOLUME
DML 语句
INSERT
UPDATE
DELETE
COPY INTO
MERGE
TRUNCATE
查询语句
SELECT
VALUES
CTE
WHERE
LIMIT
OFFSET
HAVING
LATERAL VIEW
ORDER BY
GROUP BY
SORT BY
DSITRIBUTE BY
CLUSTER BY
WINDOW
窗口函数
PIVOT
UNPIVOT
TIMETRAVEL
JOIN
采样查询
集合查询
增量查询
EXPLAIN
描述语句
DESCTIBE DATABASE
DESCTIBE TABLE
DESCTIBE FUNCTION
DESCTIBE QUERY
DESCTIBE HISTORY
显示语句
SHOW DATABASE
SHOW SCHEMAS
SHOW CREATE TABLE
SHOW TABLES
SHOW TABLE EXTENDED
SHOW TABLES DROPPED
SHOW VIEWS
SHOW COLUMNS
SHOW FUNCTIONS
SHOW VOLUMES