1 2 3 11 Previous Next 152 Replies Latest reply: Nov 4, 2013 9:33 AM by Kevin Che RSS

How to load CSV files into HANA

Alvaro Tejada Galindo
Currently Being Moderated


1.- Create an CSV file with your data


2.- Copy the file to dropbox/yourname inside the HANA box


3.- Create a table in HANA with the structure of your file


4.- create the control file BBB with the following information:


import data

into table XXX."YYY"

from 'ZZZ.csv'

record delimited by '\n'  

fields delimited by ','

optionally enclosed by '"'

error log 'Text_Tables.err'


Where XXX is your schema, YYY is your HANA Table and ZZZ is your file


5.- Open an Script File and write the following:


LOAD FROM '/filer/dropbox/yourname/BBB.ctl';


where BBB is the name of your control file






1 2 3 11 Previous Next