Problem Description:


The CSV file Mapping fails with the below ERROR in the UI in Data Foundry 3.1



Root cause

This issue occurs if the Target relative path that you have provided in the table mapping is used by any other CSV table.


Solution:


Provide the Target relative path that is not used by any other table. Under the Target Base Path i.e. /iw/sources/Training_CSV, you need to have separate directories for the tables that you are ingesting/creating.


You could provide the Target Relative Path as /webscoresMacEOL (name of the Target Table) to avoid the path conflicts as mentioned above and the target HDFS files will be created under /iw/sources/Training_CSV/webscoresMacEOL directory.


Applicable IWX versions:

Data Foundry 3.1