AnsweredAssumed Answered

Csv data  loaded into first column other column all null

Question asked by ranan on Sep 21, 2016
Latest reply on Sep 22, 2016 by ranan

1. create table 

CREATE TABLE location (station STRING,latitude
INT, longitude INT);
ROW FORMAT
DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' ;

2.Load data

LOAD data local inpath '/home/cloudera/DA440_LabFiles/DA440_LabFiles/location.csv'
OVERWRITE INTO TABLE location

3.data in csv

Adelaide,67,69
Clean_Air,90,0
Faraday,65,64

inserted screen shot 

if i change the table structure move the station column to the last and change the csv file sequence after load it just insert null data.

Outcomes