Elasticsearch mapping for object with dynamic keys

Question

I have simple document with this mapping:

'product': {
  'properties': {
    'name': { 'type': 'string' },
    'shops': { 
      'type': 'object', 
      'index_name': 'shop', 
      'properties': {
        'name': { 'type': 'string' },
        'url': { 'type': 'string' },
        'price': { 'type': 'integer' },
      }
    }
  }
}

Document look like this:

{ 
  'name': 'Kindle', 
  'shops': [ 
    { 'name': 'amazon', 'url': 'http://...', 'price': 79 },
    { 'name': 'ebay', 'url': 'http://...', 'price': 99 }
}

But I want store documents in this format:

{
  'name': 'Kindle',
  'shops': {
    'amazon': { 'url': 'http://...', 'price': 79 },
    'ebay': { 'url': 'http://...', 'price': 99 }
  }
}

Is there any way to do mapping for this? Or I should create only object 'shops' and keep it schema-less.

Queries will be simple, in most cases string queries for select products for specific shop. For example: { "query_string" : { "query" : "exists:shops.amazon.url" } } I prefer to store shops as object rather than array, because of easier manipulation in ruby. — mrazicz
– mrazicz, Commented Apr 12, 2012 at 22:06
Hi, yeah, I use solution from answer below. But after all, I ended up with my original solution. Turns out, that array of objects is better for my use case. — mrazicz
– mrazicz, Commented Mar 30, 2016 at 7:28

Russ Matney · Accepted Answer · 2016-07-06 23:50:00Z

2

You may be able to use a dynamic_template with a path_match ("shops.*") [1].

[1] https://www.elastic.co/guide/en/elasticsearch/reference/1.4/mapping-root-object-type.html

edited Jul 6, 2016 at 23:50

Russ Matney

1,16513 silver badges16 bronze badges

answered Apr 12, 2012 at 18:42

ejain

3,6443 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

mrazicz Over a year ago

This could be works. But now, how can I check if templates work? any suggestions?

ejain Over a year ago

Just add the documents, then retrieve the mapping.

shivg Over a year ago

link is broken. New link: elastic.co/guide/en/elasticsearch/reference/1.4/…

Keshi Over a year ago

@ejain - can you share your es mapping for this example?

Collectives™ on Stack Overflow

Elasticsearch mapping for object with dynamic keys

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related