cancel
Showing results for 
Search instead for 
Did you mean: 

can we load tsv files into hana server through HANA Studio directly

0 Kudos

I have a TSV flat file of data more than 3GB. How can i load into HANA server through HANA Studio directly.

Please suggest me.

Thanks

kala

Accepted Solutions (0)

Answers (2)

Answers (2)

rama_shankar3
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi Kala,

You may not upload it to HANA server by HANA studio, because it is large data to upload, one way, you can upload it by BODS, other way, you upload it on HANA server side directly.

For HANA server side upload, if your load file is using tab separated, then you can open it use excel to save as CSV file, by this way, you can FTP your large data to HANA server and upload it on server side by ctl sript.

For example ctl script.

import data

into table "schema name"."table anme"

from 'csv file name'

    record delimited by '\n'

    field delimited by ','

    optionally enclosed by '"'

error log 'xxxxtablename.err'

Hope this can help you.

Regards,

Jerry