以下查询返回第 1:8 行：输入“EXTERNAL”不匹配。预期：“OR”、“SCHEMA”、“TABLE”、“VIEW”

Question

以下查询返回：

line 1:8: mismatched input 'EXTERNAL'. Expecting: 'OR', 'SCHEMA', 'TABLE', 'VIEW'

CREATE EXTERNAL TABLE IF NOT EXISTS adult_data_clean(
    age bigint,
    workclass string,
    education string,
    relationship string,
    occupation string,
    country string,
    income_cat string
)
ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT
    'org.apache.hadoop.mapred.TextInputFormat'
STORED AS OUTPUTFORMAT
    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION 
    's3://census-income-example/clean.data'
TBLPROPERTIES (
    'classification'='csv'
    'skip.header.line.count'='1')

Answer 1

有两个错误：

• tblProperties缺少参数之间的逗号
• outpeverformat Not not 已将存储为 （由于它只是从inputformat>继续进行）：

CREATE EXTERNAL TABLE IF NOT EXISTS adult_data_clean(
    age bigint,
    workclass string,
    education string,
    relationship string,
    occupation string,
    country string,
    income_cat string
)
ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT
    'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION 
    's3://census-income-example/clean.data'
TBLPROPERTIES (
    'classification'='csv',
    'skip.header.line.count'='1')

是的，这些错误消息令人困惑和误导。