失败：ParseException行3：0无法识别附近的输入＆＃x27;格式＆＃x27; ＆＃x27;脱墨＆＃x27;在表行格式规范中（状态= 42000，代码= 40000）

Question

CREATE EXTERNAL TABLE CLIENTES (
   'idcliente int,
    cnh string,
    cpf string,
    validacnh date,
    nome string,
    datacadastro date,
    datanascimento date, 
    telefone string,
    status string'
 )  
 row format demilited
 fields terminated by ', ' 
 STORED AS TEXTFILE;

Answer 1

由于某种原因，您将这些列作为字符串文字。取出引号

CREATE EXTERNAL TABLE CLIENTES (
    idcliente int,
    cnh string,
    cpf string,
    validacnh date,
    nome string,
    datacadastro date,
    datanascimento date, 
    telefone string,
    status string
 )  
 row format demilited
 fields terminated by ', ' 
 STORED AS TEXTFILE;