# Create index mapping for dataset with large features

**URL:** <https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830>\
**Category:** Elasticsearch\
**Created:** [June 8, 2019, 9:07am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830 "2019-06-08T09:07:41Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prabhav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhav/32/64630_2.png) [@Prabhav](https://discuss.elastic.co/u/Prabhav)\
**Post date:** [June 8, 2019, 9:07am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/1 "2019-06-08T09:07:41Z")

</div>

I am trying to bulk upload my data to ES but it ends up showing parsing exception. I want to create mapping for my index but the main problem is i have more than 70 columns in my dataset, for which specifying data type individually is not possible.  
Is there any other way or do i need to set them manually?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 9:48am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/2 "2019-06-08T09:48:47Z")

</div>

Have a look at [https://www.elastic.co/guide/en/elasticsearch/reference/current/dynamic-mapping.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/dynamic-mapping.html)

---

<div class="post-metadata">

**Author:** ![Prabhav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhav/32/64630_2.png) [@Prabhav](https://discuss.elastic.co/u/Prabhav)\
**Post date:** [June 8, 2019, 10:26am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/3 "2019-06-08T10:26:58Z")

</div>

I didn't get it, is 5 the value of count? Wasn't clear to me.Can you give a clear explanation, What exactly is count is in this case?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 10:42am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/4 "2019-06-08T10:42:14Z")

</div>

Which count? What do you mean ?

---

<div class="post-metadata">

**Author:** ![Prabhav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhav/32/64630_2.png) [@Prabhav](https://discuss.elastic.co/u/Prabhav)\
**Post date:** [June 8, 2019, 10:44am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/5 "2019-06-08T10:44:06Z")

</div>

PUT data/\_doc/1 ![](https://www.elastic.co/guide/en/elasticsearch/reference/current/images/icons/callouts/1.png) { "count": 5 }  
What is this count?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 10:45am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/6 "2019-06-08T10:45:23Z")

</div>

It's a field. It's just an example of a document which doesn't have any fixed mapping.

At the end of the page you have 2 links which introduce dynamic mapping. Did you read?

---

<div class="post-metadata">

**Author:** ![Prabhav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhav/32/64630_2.png) [@Prabhav](https://discuss.elastic.co/u/Prabhav)\
**Post date:** [June 8, 2019, 10:47am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/7 "2019-06-08T10:47:50Z")

</div>

Yeah it's a little complicated for me since i am a beginner

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 10:51am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/8 "2019-06-08T10:51:21Z")

</div>

Please read the documentation I linked to. If there's something you don't understand, feel free to ask. We are happy to help.

---

<div class="post-metadata">

**Author:** ![Prabhav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhav/32/64630_2.png) [@Prabhav](https://discuss.elastic.co/u/Prabhav)\
**Post date:** [June 8, 2019, 10:54am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/9 "2019-06-08T10:54:20Z")

</div>

@dadoonet thanks for your replies,  
I would like to know how would you approach to create index mapping for the data in the link:-

> **[notepad.pw](https://notepad.pw/prbhvgo)**
>
> Save your notes online for free and share them with friends!

  
This is just a document and the time\_stamp field is giving me hard time.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 11:09am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/10 "2019-06-08T11:09:50Z")

</div>

What is the mapping you'd like to have with those documents?

---

<div class="post-metadata">

**Author:** ![Prabhav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhav/32/64630_2.png) [@Prabhav](https://discuss.elastic.co/u/Prabhav)\
**Post date:** [June 8, 2019, 11:35am UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/11 "2019-06-08T11:35:03Z")

</div>

I have approx 50,000 entries in the time\_stamp column but elastic is giving a hard time to display the correct data type for the time stamp rather ends up giving text there as well. Even when i have turned the format off. And i also did this:-

PUT my\_index  
{  
"mappings": {  
"properties": {  
"date": {  
"type": "date",  
"format": "HH.mm.ss.SSS" #valid format in their official documentation.  
}  
}  
}  
}

But ends up showing  
Rejecting mapping update to [latest] as the final mapping would have more than 1 type: [\_doc, purge]  
Even though i have only one entry in the index.

 ![Capture](https://us1.discourse-cdn.com/elastic/original/3X/2/5/25e3ebf467e73e957daa1956e4e59d287e28532f.png)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 12:30pm UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/12 "2019-06-08T12:30:24Z")

</div>

That's because you have already something defined in your index. Drop it.

If you still have problems please provide a full recreation script as described in [About the Elasticsearch category](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

---

<div class="post-metadata">

**Author:** ![Prabhav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prabhav/32/64630_2.png) [@Prabhav](https://discuss.elastic.co/u/Prabhav)\
**Post date:** [June 8, 2019, 12:34pm UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/13 "2019-06-08T12:34:50Z")

</div>

Can you please check your private message?

---

<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:** [July 6, 2019, 12:34pm UTC](https://discuss.elastic.co/t/create-index-mapping-for-dataset-with-large-features/184830/14 "2019-07-06T12:34:51Z")

</div>

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