Unable to load CSV

[Tushar Goel]

Hello Everyone, I am trying to upload a CSV file (present in the S3 AWS cloud) to Aurora MySQL. I have 28 columns present but only having difficulty importing with 2 columns only, I keep getting the following error

SQL Error [1054] [42S22]: Unknown column 'QUESTION' in 'field list'


I see the column present in the table and CSV file. Also data is correct as well. Any help is much appreciated. I am trying following thing:

desc table <name>
QUESTION  VARCHAR(128),



LOAD DATA FROM S3 FILE 's3:///xx/data_0_0_0.csv'
IGNORE
INTO TABLE test.tableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
IGNORE 1 LINES
(ISCORRECT,QUESTION,xxx);

If I remove 2 problematic columns then it is working fine.

Tushar Goel