Loading deliminated file using csv loader

Connectors CSV Loader
1

I am trying to load csv file using aerospike loader.

config file: { “version” : “2.0”, “dsv_config”: { “delimiter”: “|” , “n_columns_datafile”: 2, “header_exist”: false }, “mappings”: [ { “key”: {“column_position”:2, “type”: “string”},

          "set": "cust360",
        
          "bin_list": [
            {"name":"daycd","value":{"column_position":1,"type":"string"}},
			{"name":"msisdn","value":{"column_position":2,"type":"string"}}		

          ]
        }
    ]
}

test data

20180404|9824
20180404|9824

I get following error: Column position defined for data file without header !!

2

so, I found if I use

if(dsvHasHeader()) { updateColumnInfoForMappingDefs(columnNames); }

instead of updateColumnInfoForMappingDefs(columnNames);

It would work. I changed the code and checked it.

issue.

1 Like