# Unable to load CSV data into elastic search

**URL:** <https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868>\
**Category:** Elasticsearch\
**Created:** [October 24, 2018, 8:14pm UTC](https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868 "2018-10-24T20:14:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![anilpraneeth](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@anilpraneeth](https://discuss.elastic.co/u/anilpraneeth)\
**Post date:** [October 24, 2018, 8:14pm UTC](https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868/1 "2018-10-24T20:14:38Z")

</div>

Hi Team,  
Trying elasticsearch for the first time, bear with my layman questions. I'm trying to load csv formatted data into kafka topic and eventual load into elastic search index. But i'm facing errors loading data from my topic into elasticsearch. Any thoughts on this? appreciate the help.

Cannot create mapping {"kafka-connect":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}} -- {"root\_cause":[{"type":"mapper\_parsing\_exception","reason":"Root mapping definition has unsupported parameters: [type : text] [fields : {keyword={type=keyword, ignore\_above=256}}]"}],"type":"mapper\_parsing\_exception","reason":"Root mapping definition has unsupported parameters: [type : text] [fields : {keyword={type=keyword, ignore\_above=256}}]"}

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [October 24, 2018, 10:54pm UTC](https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868/2 "2018-10-24T22:54:50Z")

</div>

How is the topic sending data to Elasticsearch?

---

<div class="post-metadata">

**Author:** ![anilpraneeth](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@anilpraneeth](https://discuss.elastic.co/u/anilpraneeth)\
**Post date:** [October 24, 2018, 11:22pm UTC](https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868/3 "2018-10-24T23:22:02Z")

</div>

using open source confluent version of kafka and i'm executing below command to load into elasticsearch.

./bin/connect-standalone etc/kafka/connect-standalone.properties etc/kafka-connect-elasticsearch/quickstart-elasticsearch.properties &

---

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [October 25, 2018, 5:28am UTC](https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868/4 "2018-10-25T05:28:15Z")

</div>

hope this helps you

> [@Load csv file in logstash](https://discuss.elastic.co/t/load-csv-file-in-logstash/151319/3):
>
> Thanks for reply,hope this works fine, input { file { path =\> "D:/Balu/ELK-stack/csvfile.csv" start\_position =\> "beginning" sincedb\_path =\> "NUL" } } filter { csv { separator =\> "," columns =\> ["open","high","low","close","volume"] } } output { elasticsearch { hosts =\> "[http://localhost:9200](http://localhost:9200)" index =\> "wallet-address-index" } stdout { codec =\> rubydebug } }

---

<div class="post-metadata">

**Author:** ![anilpraneeth](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@anilpraneeth](https://discuss.elastic.co/u/anilpraneeth)\
**Post date:** [October 26, 2018, 2:49am UTC](https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868/5 "2018-10-26T02:49:22Z")

</div>

Used Logstash and it worked pretty seamlessly, thank you for all the help.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 23, 2018, 2:49am UTC](https://discuss.elastic.co/t/unable-to-load-csv-data-into-elastic-search/153868/6 "2018-11-23T02:49:24Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.