Skip to Content
avatar image
Former Member

Not able to load null values from flat file to Hana

Hello experts,

i have a flat file need to load to hana. It has null values on date column.

am getting error while loading.

please suggest.

thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 14, 2017 at 11:00 AM

    Hello Srikanth,

    SAP HANA would always expect a date value to be in 'yyyy-mm-dd' format. Any date values not in this format (including blank dates) would throw an error during flat file load even if the not null condition is unchecked.

    As per my knowledge, I would suggest to use some invalid date like '1900-01-01' (which you can exclude in later case) in place of null values in flat file and load.

    Regards,

    Prashant

    Add comment
    10|10000 characters needed characters exceeded