sql - 失败 : ParseException line 1:36 cannot recognize input near '1987'

Question

我正在尝试用它在 Hive 中创建一个外部表

CREATE EXTERNAL TABLE IF NOT EXISTS 1987(
    YEAR INT,
    MONTH INT,
    DAYOFMONTH INT,
    DAYOFWEEK INT,
    DEPTIME INT,
    CRS INT,
    ARRTIME TIME,
    CARRIER STRING,
    FLIGHTNUM INT,
    TAILNUM STRING,
    ACTUALELAPSED INT,
    CRSELAPSED INT,
    AIRTIME INT,
    ARRDELAY INT,
    DEPDELAY INT,
    ORIGIN STRING,
    DEST STRING,
    DISTANCE INT,
    TAXIIN INT,
    TAXIOUT INT,
    CANCELLED INT,
    CANCELLATIONCODE STRING,
    DIVERTED INT,
    CARRIERDELAY INT,
    WEATHERDELAY INT,
    NASDELAY INT,
    SECURITYDELAY INT,
    LATEAIRCRAFT INT,
    Origin CHAR(1))
COMMENT 'A??O 1987'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
location '/user/raj_ops/PROYECTO/'1987.csv';

但是得到如下错误:

org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:36 cannot recognize input near '1987' '(' 'YEAR' in table name

谁知道为什么？谢谢:)

Answer 1

位置应该是 '/user/raj_ops/PROYECTO/'(没有文件本身)。如果您在同一位置有其他文件，则将它们移动到不同的位置，例如 1987 年的 /user/raj_ops/PROYECTO/1987/。因为表可以建立在位置之上，而不是文件。

并且表名不能以数字开头。使用反引号 1987 或重命名为 year_1987