Unable to load CSV
Posted by: Tushar Goel
Date: May 16, 2022 04:35AM

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

Options: ReplyQuote


Subject
Written By
Posted
Unable to load CSV
May 16, 2022 04:35AM
May 16, 2022 08:52AM
May 16, 2022 10:49PM
May 17, 2022 11:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.