Hive SQL的關鍵字(也被稱為保留字)包括以下列表中的一些:
- ADD
- ALL
- ALTER
- ANALYZE
- AND
- ARRAY
- AS
- ASC
- AT
- BETWEEN
- BY
- CALL
- CASCADE
- DATABASE
- DATABASES
- DELETE
- DESC
- DISTINCT
- DO
- ELSE
- ENCLOSED
- END
- FALSE
- FETCH
- FIRST
- FOLLOWING
- FOR
- FROM
- FULL
- GET
- GROUPING
- HAVING
- IF
- IGNORE
- JOIN
- KEY
- KEYS
- LEFT
- LIKE
- LOCAL
- LOCATION
- MASTER
- MODIFY
- NATURAL
- NOT
- NULL
- OF
- ON
- ONLY
- OPTIMIZE
- OR
- ORDER
- OUTER
- OVER
- PARTITION
- PARTITIONS
- PRECISION
- READ
- READS
- RECURSIVE
- REPLACE
- RESTRICT
- RETURNING
- SELECT
- SET
- SHOW
- TABLE
- TABLES
- THEN
- UNSIGNED
- UPDATE
- USE
- WHEN
- WHERE
- XOR
- YEAR
- ZEROFILL
請注意,盡管這些關鍵字在Hive SQL中通常被保留,但在某些上下文中,它們可能被用作標識符(例如,數據庫、表或列名)。然而,為了避免潛在的沖突和混淆,建議盡量不要在編寫Hive SQL查詢時使用這些關鍵字作為標識符。