Presto 保留了一些关键词。如果你想将这些关键词直接用作字段名,请使用双引号 " 将其包裹。

例如:

1
2
"VALUES"
"GROUP"

以下是 Presto 保留关键词完整列表:

A

ALTER

AND

AS

B

BETWEEN

BY

C

CASE

CAST

CONSTRAINT

CREATE

CROSS

CUBE

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

D

DEALLOCATE

DELETE

DESCRIBE

DISTINCT

DROP

E

ELSE

END

ESCAPE

EXCEPT

EXECUTE

EXISTS

EXTRACT

F

FALSE

FOR

FROM

FULL

G

GROUP

GROUPING

H

HAVING

I

IN

INNER

INSERT

INTERSECT

INTO

IS

J

JOIN

L

LEFT

LIKE

LOCALTIME

LOCALTIMESTAMP

N

NATURAL

NORMALIZE

NOT

NULL

O

ON

OR

ORDER

OUTER

P

PREPARE

R

RECURSIVE

RIGHT

ROLLUP

S

SELECT

T

TABLE

THEN

TRUE

U

UESCAPE

UNION

UNNEST

USING

V

VALUES

W

WHEN

WHERE

WITH

(END)