on 08-09-2013 12:41 PM
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
Hi Chandra,
Please review the below best practice blogs from one of my favorite SAP HANA expert!
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.