Error while loading CSV file

[Former Member]

Hello Experts,

I am getting following error while importing CSV file into HANA Database.

I have tried changing the datatype and size of the fields, but then too the load is getting failed.

Could you please suggest me the reason?

Thanks and Regards,

Pragati Gupta

[DeepakVarandani · Accepted solution]

Hi Pragati,

    I think date format might be incorrect in CSV file. Please convert date into 'YYYY-MM-DD' format in CSV file and then try importing into HANA Database.

Regards,

Deepak

[Former Member]

Hello Pragati,

I have recreated the issue locally and the errors seems to be that you are using an incorrect datatype against the data being imported. Specifically in this case, it seems to be importing the data into a column of datatype "DATE" but it is not of that format.

Perhaps, check other datatypes that might be more suitable for importing. Have a look here for more information: https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/a1569875191014b507cf392724b7eb/content.htm#...

If you are satisfied that this solves your issue, please mark the thread as such.

Thanks.

Ruaidhri

[Saritha_K]

Hi Pragati,

Can you share the table definition in hana and a sample record that you are trying to load?

Regards,

Saritha K