配置单元的解析异常

ttp71kqs  于 2021-05-29  发布在  Hadoop
关注(0)|答案(1)|浏览(286)

查询:

hive> CREATE TABLE GREENTAXI(VendorID INT, pick_up_date DATE,drop_date DATE,Flag CHAR(1),rate_code INT, pick_up_long STRING,pick_up_lat STRING,drop_off_long STRING,drop_off_lat STRING,passenger_count INT,trip_distance DECIMAL,fare_amount DECIMAL,Extra DECIMAL,Tax DECIMAL,Tip DECIMAL,Tolls INT,Fee INT,Surcharge DECIMAL,total_amount DECIMAL,payment_type INT,trip_type INT)COMMENT 'Data about Green NYC Taxi for the year 2016-Jan’ ROW FORMAT DELIMITED FIELDS TERMINATED BY ','STORED AS TEXTFILE;

我得到这个错误。请告知

omqzjyyz

omqzjyyz1#

好像有什么字符编码问题。使用一个简单的编辑器。试过了,成功了:

CREATE TABLE greentaxi 
  ( 
     vendorid        INT, 
     pick_up_date    DATE, 
     drop_date       DATE, 
     flag            CHAR(1), 
     rate_code       INT, 
     pick_up_long    STRING, 
     pick_up_lat     STRING, 
     drop_off_long   STRING, 
     drop_off_lat    STRING, 
     passenger_count INT, 
     trip_distance   DECIMAL, 
     fare_amount     DECIMAL, 
     extra           DECIMAL, 
     tax             DECIMAL, 
     tip             DECIMAL, 
     tolls           INT, 
     fee             INT, 
     surcharge       DECIMAL, 
     total_amount    DECIMAL, 
     payment_type    INT, 
     trip_type       INT 
  ) 
comment 'Data about Green NYC Taxi for the year 2016-Jan'
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY ','
STORED AS TEXTFILE;

相关问题