Search code examples
databasecsvhana

import data into a specific column in HANA table

I have loaded data into HANA using a CSV file and now I have added a new column to the table by

ALTER TABLE <tablename> ADD (<columnname> <datatype>);

Now I want to import data into this specific column using a CSV file. I could not find any methods to import to a specific column. Any help is appreciated. Thanks in advance.

Solution

  • The CSV import feature doesn't allow for partial loading and "column filling". What you could do is to load the new data (together with the key columns of course) to a staging table and then update the target table columns from there.

    Be aware that the CSV import is not meant to be an ETL solution. For that, the smart data integration features are there.