hdfs 导入hive表失败，创建hive外部表失败了

Question

FAILED: ParseException line 3:1 missing EOF at 'ROWFORMAT' near ')'

 

 

 CREATE EXTERNAL TABLE wifite (time  STRING,xiaoqu STRING  , phone STRING,  sum STRING
)      
 ROWFORMAT DELIMITED

Answer 1

补充：

像time这种字段，hive数据类型中有的话，需要修改为：

CREATE EXTERNAL TABLE wifite (
    time_str  STRING,
    xiaoqu STRING,
    phone STRING,  
    sum STRING)
      ROW FORMAT DELIMITED
      FIELDS TERMINATED BY 'n'
      stored as textfile
      LOCATION'/user/root/wifi/'; 
否则还是会报语法错误

Answer 2

你的DDL语句有问题：

CREATE EXTERNAL TABLE wifite (
    time  STRING,
    xiaoqu STRING,
    phone STRING,  
    sum STRING)
      ROW FORMAT DELIMITED
      FIELDS TERMINATED BY 'n'
      stored as textfile
      LOCATION '/user/root/wifi/';