# Error while loading data using aerospike-loader

**URL:** <https://discuss.aerospike.com/t/error-while-loading-data-using-aerospike-loader/4280>\
**Category:** CSV Loader\
**Tags:** query\
**Created:** [June 18, 2017, 4:23pm UTC](https://discuss.aerospike.com/t/error-while-loading-data-using-aerospike-loader/4280 "2017-06-18T16:23:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ytejas](https://avatars.discourse-cdn.com/v4/letter/y/71e660/32.png) [@ytejas](https://discuss.aerospike.com/u/ytejas)\
**Post date:** [June 18, 2017, 4:23pm UTC](https://discuss.aerospike.com/t/error-while-loading-data-using-aerospike-loader/4280/1 "2017-06-18T16:23:01Z")

</div>

I am trying to load data into aerospike with the pages.json file as follows: { “version” : “2.0”, “dsv\_config”: { “delimiter”: “,” , “n\_columns\_datafile”: 4, “ignore\_first\_line”: false}, “mappings”:[{ “key”: {“column\_position”:2, “type”: “string”}, “set”: {“column\_position”:1, “type”: “string”}, “binlist”: [{“name”: “number\_of\_requests”, “value”: {“column\_position”: 3, “type” : “integer”}}, {“name”: “size\_of\_the\_content\_returned”, “value”: {“column\_position”: 4, “type” : “integer”}}]}] }

Using the aerospike-loader command: `./run_loader -h localhost -c ./wiki_data/pages.json ./wiki_data/`

I am facing the following error: INFO AerospikeLoad :119 - Aerospike loader started INFO AerospikeLoad :205 - Number of data files:1 ERROR Parser :243 - “bin\_list” Key is missing in mapping. Mapping: {“set”:{“column\_position”:1,“type”:“string”},“binlist”:[{“name”:“number\_of\_requests”,“value”:{“column\_position”:3,“type”:“integer”}},{“name”:“size\_of\_the\_content\_returned”,“value”:{“column\_position”:4,“type”:“integer”}}],“key”:{“column\_position”:2,“type”:“string”}} ERROR Parser :181 - Error in parsing mappingdef: {“set”:{“column\_position”:1,“type”:“string”},“binlist”:[{“name”:“number\_of\_requests”,“value”:{“column\_position”:3,“type”:“integer”}},{“name”:“size\_of\_the\_content\_returned”,“value”:{“column\_position”:4,“type”:“integer”}}],“key”:{“column\_position”:2,“type”:“string”}} ERROR AerospikeLoad :213 - java.lang.Exception: Config file parsing Error INFO AerospikeLoad :220 - Aerospike loader completed INFO AerospikeLoad :227 - Loader completed in 0.122sec [root@localhost aerospike-loader]# ./run\_loader -h localhost -c ./wiki\_data/pages.json ./wiki\_data/ INFO AerospikeLoad :119 - Aerospike loader started INFO AerospikeLoad :205 - Number of data files:4 ERROR Parser :243 - “bin\_list” Key is missing in mapping. Mapping: {“set”:{“column\_position”:1,“type”:“string”},“binlist”:[{“name”:“number\_of\_requests”,“value”:{“column\_position”:3,“type”:“integer”}},{“name”:“size\_of\_the\_content\_returned”,“value”:{“column\_position”:4,“type”:“integer”}}],“key”:{“column\_position”:2,“type”:“string”}} ERROR Parser :181 - Error in parsing mappingdef: {“set”:{“column\_position”:1,“type”:“string”},“binlist”:[{“name”:“number\_of\_requests”,“value”:{“column\_position”:3,“type”:“integer”}},{“name”:“size\_of\_the\_content\_returned”,“value”:{“column\_position”:4,“type”:“integer”}}],“key”:{“column\_position”:2,“type”:“string”}} ERROR AerospikeLoad :213 - java.lang.Exception: Config file parsing Error INFO AerospikeLoad :220 - Aerospike loader completed INFO AerospikeLoad :227 - Loader completed in 0.130sec

---

<div class="post-metadata">

**Author:** ![pgupta](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/pgupta/32/2351_2.png) [@pgupta](https://discuss.aerospike.com/u/pgupta)\
**Post date:** [June 26, 2017, 5:00pm UTC](https://discuss.aerospike.com/t/error-while-loading-data-using-aerospike-loader/4280/2 "2017-06-26T17:00:20Z")

</div>

Also at: [aerospike - Missing key in mapping - Stack Overflow](https://stackoverflow.com/questions/44750811/missing-key-in-mapping)

Wondering if “binlist” in docs should be “bin\_list”.

`https://github.com/aerospike/aerospike-loader/blob/master/src/main/java/com/aerospike/load/Constants.java`

`public static final String BINLIST = "bin_list";`