Error when importing a CSV-file

[Former Member]

Hello,

I tested the import of a CSV-file with a small sample file (see appendix:TestData) and it worked perfectly.

Unfortunately it didn't work with the real file (500mb) which has just more rows than the sample file.

There were many composite errors and "inserted value too large for column"-errors (see appendix: Error).

I guess the problems are the data types of the columns. When I changed the data types there were import errors too.

I have attached a screenshot from the data types which the system suggests automatically.

Do you know how I can solve that problem?

Thank you very much in advance.

Best regards,

Johannes

[rindia]

Dear Johannes,

When i observed your data, the entire row is got pasted in 1 cell of excel sheet.

So i formatted your excel data so that columns are spreaded into different cells as shown below:

Click to enlarge the image.

   

Now your data will looks like

 

Now When I imported the data, it loaded as row store table and data preview is shown below:

  

Regards

Raj

[Former Member]

Dear Raj,

thank you very much for your answer.

The import of the sample file with the SAP HANA Studio was successfull and the import preview of the real file (500mb) was  

ok. But after 15 minuetes of importing there were many composite errors and "inserted value too large for column"-errors. And I don't know why it works with the small file and not with the bigger csv-file.

Do you think the file is maybe to big for the import function?

Best regards,

Johannes