# Error when importing data from maraidb

**URL:** <https://discuss.elastic.co/t/error-when-importing-data-from-maraidb/260665>\
**Category:** Elasticsearch\
**Created:** [January 11, 2021, 4:07am UTC](https://discuss.elastic.co/t/error-when-importing-data-from-maraidb/260665 "2021-01-11T04:07:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tails](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tails/32/81921_2.png) [@Tails](https://discuss.elastic.co/u/Tails)\
**Post date:** [January 11, 2021, 4:07am UTC](https://discuss.elastic.co/t/error-when-importing-data-from-maraidb/260665/1 "2021-01-11T04:07:08Z")

</div>

I installed the ik plugin to elasticsearch and I have the following errors when importing from mariadb.

[2021-01-11T11:49:38,392][WARN][logstash.outputs.elasticsearch][main][6611aaa54ebe00de3255376c35e28d779a2b6f627197b528c9ad04dafe0a88da] Could not index event to Elasticsearch. {:status=\>400, :action=\>["index", {:\_id=\>"34078992", :\_index=\>"p\_photo", :routing=\>nil, :\_type=\>"p\_photo"}, #LogStash::Event:0x63a26ef4], :response=\>{"index"=\>{"\_index"=\>"p\_photo", "\_type"=\>"p\_photo", "\_id"=\>"34078992", "status"=\>400, "error"=\>{"type"=\>"illegal\_argument\_exception", "reason"=\>"Mapper for [caption\_is] conflicts with existing mapper:\n\tCannot update parameter [analyzer] from [ik\_max\_word] to [default]"}}}}

I did something like to set the default.

curl -XPUT [http://192.168.90.13:9200/p\_photo](http://192.168.90.13:9200/p_photo) -H "Content-Type: application/json" -d'  
{  
"settings": {  
"analysis": {  
"analyzer": {  
"default": {  
"type": "ik\_max\_word"  
}  
}  
}  
}  
}'

curl -XPOST [http://192.168.90.13:9200/p\_photo/\_mapping](http://192.168.90.13:9200/p_photo/_mapping) -H 'Content-Type:application/json' -d'  
{"properties":{"@timestamp":{"type":"date"},"@version":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"batch\_no":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}},"analyzer":"standard"},"caption":{"type":"text","fields":{"catchall":{"type":"text","analyzer":"standard"},"keyword":{"type":"keyword","ignore\_above":256}},"analyzer":"ik\_max\_word","search\_analyzer":"ik\_smart"},"caption\_is":{"type":"text","fields":{"catchall":{"type":"text","analyzer":"standard"},"keyword":{"type":"keyword","ignore\_above":256}},"analyzer":"ik\_max\_word","search\_analyzer":"ik\_smart"},"caption\_processed":{"type":"keyword","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"category\_code":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"city":{"type":"keyword","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"copyright":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"copyright\_id":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"country":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"cpoyright":{"type":"long"},"credit":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"date\_created":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"deferral\_datetime":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"file\_path":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"height\_pixel":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"is\_private":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"is\_public":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"issue\_no":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"keywords":{"type":"text","fields":{"catchall":{"type":"text","analyzer":"standard"},"keyword":{"type":"keyword","ignore\_above":256}},"analyzer":"ik\_max\_word","search\_analyzer":"ik\_smart"},"l\_storage\_id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"last\_modify\_by":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"last\_modify\_date":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"m\_storage\_id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"media\_code":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"object\_name":{"type":"text","fields":{"catchall":{"type":"text","analyzer":"standard"},"keyword":{"type":"keyword","ignore\_above":256}},"analyzer":"ik\_max\_word","search\_analyzer":"ik\_smart"},"original\_filename":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"partition\_flag":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"path\_l":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"path\_m":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"path\_s":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"photo\_id":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"photographer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"public\_datetime":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"s\_storage\_id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"sec\_name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"size\_byte":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"spec\_instr":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"status":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"upload\_time":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"url\_path":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"user\_id":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"username":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"width\_pixel":{"type":"long","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}}},"settings":{"index":{"creation\_date":"1608108859766","number\_of\_shards":"3","number\_of\_replicas":"0","uuid":"jqmG3pG\_Szi7dvmAqwsqxg","version":{"created":"6040399"},"provided\_name":"p\_photo"}}}}'

Any ideas?

Thanks and Regards,  
Alan

---

<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:** [February 8, 2021, 4:07am UTC](https://discuss.elastic.co/t/error-when-importing-data-from-maraidb/260665/2 "2021-02-08T04:07:21Z")

</div>

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