Skip to Content
0

Not able to load null values from flat file to Hana

Nov 13, 2017 at 04:58 AM

42

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Prashant Patil Nov 14, 2017 at 11:00 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded