hadoop - 如何从HIVE（SQL）的列中删除文本(How do I remove text from columns in HIVE (sql))

Question

I am trying to import data from a CSV file (latlong.csv) and I want to remove all of the quotes from my columns.

(我正在尝试从CSV文件（latlong.csv）导入数据，并且想从列中删除所有引号。)

Please Refer to first image.

(请参考第一张图片。)

First image

(第一张图片)

This is the code I used to import the data

(这是我用来导入数据的代码)

CREATE TABLE IF NOT EXISTS latlong
    (COUNTRY String, ALPHA2 String, ALPHA3 String, NUMERICCODE String,
    LATITUDE String, LONGITUDE String)
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '
'
    STORED AS TEXTFILE
    tblproperties("skip.header.line.count"="1");

LOAD DATA LOCAL INPATH '/tmp/project2/latlong.csv' INTO TABLE latlong; 

I tried to use the command below but I get an error.

(我尝试使用下面的命令，但出现错误。)

Error saying I can only insert into the table and not update it (i think).

(错误说我只能插入表中而不能更新它（我认为）。)

Update latlong set country = replace(country, '"', '')

error message

(错误信息)

  ask by Alex translate from so