ElasticSearch queries always return all the datas stored in the index


(Alexandre Touret) #1

hello,

https://stackoverflow.com/questions/24323480/elasticsearch-queries-always-return-all-the-datas-stored-in-the-index#

I'm trying to index and query an index store in ES 1.2. I both create and
populate the index with the JAVA API using the transportclient api. I have
the following mapping:

get /tp/carte/_mapping{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}}

When I search ob object with the ID, it works fine but, when I try to query
the content of one of my nested objects, ES always returns all the objects
stored in the index
. I also tried to create the objects manually with
sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(David Pilato) #2

Hey Alexandre,

This is correct. You are searching for a carte which contains an adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for that use case.
Or you can have one carte object per adherent?

Makes sense?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alexandre@touret.info) a écrit:

hello,

I'm trying to index and query an index store in ES 1.2. I both create and populate the index with the JAVA API using the transportclient api. I have the following mapping:

get /tp/carte/_mapping
{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}
}

When I search ob object with the ID, it works fine but, when I try to query the content of one of my nested objects, ES always returns all the objects stored in the index. I also tried to create the objects manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search
{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/etPan.53a3fad7.5bd062c2.198d%40MacBook-Air-de-David.local.
For more options, visit https://groups.google.com/d/optout.


(Alexandre Touret) #3

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature ?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :

Hey Alexandre,

This is correct. You are searching for a carte which contains an adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch
gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for that
use case.
Or you can have one carte object per adherent?

Makes sense?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info
<javascript:>) a écrit:

hello,

https://stackoverflow.com/questions/24323480/elasticsearch-queries-always-return-all-the-datas-stored-in-the-index#

I'm trying to index and query an index store in ES 1.2. I both create and
populate the index with the JAVA API using the transportclient api. I have
the following mapping:

get /tp/carte/_mapping{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}}

When I search ob object with the ID, it works fine but, when I try to
query the content of one of my nested objects, ES always returns all the
objects stored in the index
. I also tried to create the objects manually
with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(David Pilato) #4

Searching for DOE gives you that answer?
If so, it's not normal IMHO. You should try to reproduce it with a full SENSE script recreation so we can replay it and help you from here.

See http://www.elasticsearch.org/help/ for information.

About parent child, you could read this: http://www.elasticsearch.org/blog/managing-relations-inside-elasticsearch/

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr

Le 20 juin 2014 à 11:19:23, Alexandre Touret (alexandre@touret.info) a écrit:

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature ?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :
Hey Alexandre,

This is correct. You are searching for a carte which contains an adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for that use case.
Or you can have one carte object per adherent?

Makes sense?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info) a écrit:

hello,

I'm trying to index and query an index store in ES 1.2. I both create and populate the index with the JAVA API using the transportclient api. I have the following mapping:

get /tp/carte/_mapping
{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}
}

When I search ob object with the ID, it works fine but, when I try to query the content of one of my nested objects, ES always returns all the objects stored in the index. I also tried to create the objects manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search
{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/etPan.53a3fdc2.1f16e9e8.198d%40MacBook-Air-de-David.local.
For more options, visit https://groups.google.com/d/optout.


(Alexandre Touret) #5

Yes
My request for doe always return that answer

Le vendredi 20 juin 2014 11:24:33 UTC+2, David Pilato a écrit :

Searching for DOE gives you that answer?
If so, it's not normal IMHO. You should try to reproduce it with a full
SENSE script recreation so we can replay it and help you from here.

See http://www.elasticsearch.org/help/ for information.

About parent child, you could read this:
http://www.elasticsearch.org/blog/managing-relations-inside-elasticsearch/

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:19:23, Alexandre Touret (alex...@touret.info
<javascript:>) a écrit:

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature ?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :

Hey Alexandre,

This is correct. You are searching for a carte which contains an
adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch
gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for that
use case.
Or you can have one carte object per adherent?

Makes sense?

 -- 

David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info) a
écrit:

hello,

https://stackoverflow.com/questions/24323480/elasticsearch-queries-always-return-all-the-datas-stored-in-the-index#

I'm trying to index and query an index store in ES 1.2. I both create and
populate the index with the JAVA API using the transportclient api. I have
the following mapping:

get /tp/carte/_mapping{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}}

When I search ob object with the ID, it works fine but, when I try to
query the content of one of my nested objects, ES always returns all
the objects stored in the index
. I also tried to create the objects
manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Cédric Hourcade) #6

It looks like you are doing a GET rather than a POST, if so your query
content is ignored.

Cédric Hourcade
ced@wal.fr

On Fri, Jun 20, 2014 at 11:26 AM, Alexandre Touret alexandre@touret.info
wrote:

Yes
My request for doe always return that answer

Le vendredi 20 juin 2014 11:24:33 UTC+2, David Pilato a écrit :

Searching for DOE gives you that answer?
If so, it's not normal IMHO. You should try to reproduce it with a full
SENSE script recreation so we can replay it and help you from here.

See http://www.elasticsearch.org/help/ for information.

About parent child, you could read this: http://www.
elasticsearch.org/blog/managing-relations-inside-elasticsearch/

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:19:23, Alexandre Touret (alex...@touret.info) a
écrit:

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature ?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :

Hey Alexandre,

This is correct. You are searching for a carte which contains an
adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch
gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for
that use case.
Or you can have one carte object per adherent?

Makes sense?

 --

David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info) a
écrit:

hello,

https://stackoverflow.com/questions/24323480/elasticsearch-queries-always-return-all-the-datas-stored-in-the-index#

I'm trying to index and query an index store in ES 1.2. I both create
and populate the index with the JAVA API using the transportclient api. I
have the following mapping:

get /tp/carte/_mapping{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}}

When I search ob object with the ID, it works fine but, when I try to
query the content of one of my nested objects, ES always returns all
the objects stored in the index
. I also tried to create the objects
manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAJQxjPO6khU8VkbOqsdHpWFeJhaoGH5nhbnyOzGjo_d_7Ecfyg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Alexandre Touret) #7

That's right
Thanks for your help :slight_smile:

Regards

Le vendredi 20 juin 2014 11:28:26 UTC+2, Cédric Hourcade a écrit :

It looks like you are doing a GET rather than a POST, if so your query
content is ignored.

Cédric Hourcade
c...@wal.fr <javascript:>

On Fri, Jun 20, 2014 at 11:26 AM, Alexandre Touret <alex...@touret.info
<javascript:>> wrote:

Yes
My request for doe always return that answer

Le vendredi 20 juin 2014 11:24:33 UTC+2, David Pilato a écrit :

Searching for DOE gives you that answer?
If so, it's not normal IMHO. You should try to reproduce it with a full
SENSE script recreation so we can replay it and help you from here.

See http://www.elasticsearch.org/help/ for information.

About parent child, you could read this: http://www.
elasticsearch.org/blog/managing-relations-inside-elasticsearch/

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:19:23, Alexandre Touret (alex...@touret.info) a
écrit:

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature ?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :

Hey Alexandre,

This is correct. You are searching for a carte which contains an
adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch
gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for
that use case.
Or you can have one carte object per adherent?

Makes sense?

 -- 

David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info) a
écrit:

hello,

https://stackoverflow.com/questions/24323480/elasticsearch-queries-always-return-all-the-datas-stored-in-the-index#

I'm trying to index and query an index store in ES 1.2. I both create
and populate the index with the JAVA API using the transportclient api. I
have the following mapping:

get /tp/carte/_mapping{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}}

When I search ob object with the ID, it works fine but, when I try to
query the content of one of my nested objects, ES always returns all
the objects stored in the index
. I also tried to create the objects
manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/16c653f1-a932-415c-8aae-9226f2f3d7ee%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(David Pilato) #8

No. GET works for running searches.

It could be an issue if you are using an OLD SENSE version and not Marvel.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr

Le 20 juin 2014 à 11:28:23, Cédric Hourcade (ced@wal.fr) a écrit:

It looks like you are doing a GET rather than a POST, if so your query content is ignored.

Cédric Hourcade
ced@wal.fr

On Fri, Jun 20, 2014 at 11:26 AM, Alexandre Touret alexandre@touret.info wrote:
Yes
My request for doe always return that answer

Le vendredi 20 juin 2014 11:24:33 UTC+2, David Pilato a écrit :
Searching for DOE gives you that answer?
If so, it's not normal IMHO. You should try to reproduce it with a full SENSE script recreation so we can replay it and help you from here.

See http://www.elasticsearch.org/help/ for information.

About parent child, you could read this: http://www.elasticsearch.org/blog/managing-relations-inside-elasticsearch/

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr

Le 20 juin 2014 à 11:19:23, Alexandre Touret (alex...@touret.info) a écrit:

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature ?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :
Hey Alexandre,

This is correct. You are searching for a carte which contains an adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for that use case.
Or you can have one carte object per adherent?

Makes sense?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info) a écrit:

hello,

I'm trying to index and query an index store in ES 1.2. I both create and populate the index with the JAVA API using the transportclient api. I have the following mapping:

get /tp/carte/_mapping
{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}
}

When I search ob object with the ID, it works fine but, when I try to query the content of one of my nested objects, ES always returns all the objects stored in the index. I also tried to create the objects manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search
{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAJQxjPO6khU8VkbOqsdHpWFeJhaoGH5nhbnyOzGjo_d_7Ecfyg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/etPan.53a4003a.1befd79f.198d%40MacBook-Air-de-David.local.
For more options, visit https://groups.google.com/d/optout.


(Alexandre Touret) #9

I just upgraded to ES 1.2.1 and the latest release of mavel.
I have the same behaviour

Le vendredi 20 juin 2014 11:34:59 UTC+2, David Pilato a écrit :

No. GET works for running searches.

It could be an issue if you are using an OLD SENSE version and not Marvel.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:28:23, Cédric Hourcade (c...@wal.fr <javascript:>) a
écrit:

It looks like you are doing a GET rather than a POST, if so your query
content is ignored.

Cédric Hourcade
c...@wal.fr <javascript:>

On Fri, Jun 20, 2014 at 11:26 AM, Alexandre Touret <alex...@touret.info
<javascript:>> wrote:

Yes
My request for doe always return that answer

Le vendredi 20 juin 2014 11:24:33 UTC+2, David Pilato a écrit :

Searching for DOE gives you that answer?
If so, it's not normal IMHO. You should try to reproduce it with a full
SENSE script recreation so we can replay it and help you from here.

See http://www.elasticsearch.org/help/ for information.

About parent child, you could read this:
http://www.elasticsearch.org/blog/managing-relations-inside-elasticsearch/

 -- 

David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:19:23, Alexandre Touret (alex...@touret.info) a
écrit:

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature ?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :

Hey Alexandre,

This is correct. You are searching for a carte which contains an
adherent.
Elasticsearch gives you a carte object as an answer. And elasticsearch
gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for
that use case.
Or you can have one carte object per adherent?

Makes sense?

 -- 

David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info) a
écrit:

hello,

https://stackoverflow.com/questions/24323480/elasticsearch-queries-always-return-all-the-datas-stored-in-the-index#

I'm trying to index and query an index store in ES 1.2. I both create
and populate the index with the JAVA API using the transportclient api. I
have the following mapping:

get /tp/carte/_mapping{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}}

When I search ob object with the ID, it works fine but, when I try to
query the content of one of my nested objects, ES always returns all
the objects stored in the index
. I also tried to create the objects
manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com?utm_medium=email&utm_source=footer.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CAJQxjPO6khU8VkbOqsdHpWFeJhaoGH5nhbnyOzGjo_d_7Ecfyg%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAJQxjPO6khU8VkbOqsdHpWFeJhaoGH5nhbnyOzGjo_d_7Ecfyg%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/4cd45b68-32ca-4427-8523-d898c75fc44b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Cédric Hourcade) #10

Ah yes sorry you are right, I am using some old tools :slight_smile:

Cédric Hourcade
ced@wal.fr

On Fri, Jun 20, 2014 at 11:49 AM, Alexandre Touret alexandre@touret.info
wrote:

I just upgraded to ES 1.2.1 and the latest release of mavel.
I have the same behaviour

Le vendredi 20 juin 2014 11:34:59 UTC+2, David Pilato a écrit :

No. GET works for running searches.

It could be an issue if you are using an OLD SENSE version and not Marvel.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:28:23, Cédric Hourcade (c...@wal.fr) a écrit:

It looks like you are doing a GET rather than a POST, if so your query
content is ignored.

Cédric Hourcade
c...@wal.fr

On Fri, Jun 20, 2014 at 11:26 AM, Alexandre Touret alex...@touret.info
wrote:

Yes
My request for doe always return that answer

Le vendredi 20 juin 2014 11:24:33 UTC+2, David Pilato a écrit :

Searching for DOE gives you that answer?
If so, it's not normal IMHO. You should try to reproduce it with a
full SENSE script recreation so we can replay it and help you from here.

See http://www.elasticsearch.org/help/ for information.

About parent child, you could read this: http://www.
elasticsearch.org/blog/managing-relations-inside-elasticsearch/

 --

David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:19:23, Alexandre Touret (alex...@touret.info) a
écrit:

Hello,
thanks for your response

When I add an other carte

put /tp/carte/20450813
{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1963-03-22T23:00:00.000Z",
"firstname": "FLORENCE",
"lastname": "SMITH"
},
{
"birthday": "2001-10-12T22:00:00.000Z",
"firstname": "M ANGELO",
"lastname": "SMITH" },
{
"birthday": "2003-07-30T22:00:00.000Z",
"firstname": "M LILI",
"lastname": "SMITH"
}
]
}

and I run the query described above, I have both of the two 'carte'

Is it "normal" ?
Do you have an example or a link to illustrate the parent/child feature
?

Thanks

Le vendredi 20 juin 2014 11:12:04 UTC+2, David Pilato a écrit :

Hey Alexandre,

This is correct. You are searching for a carte which contains an
adherent.
Elasticsearch gives you a carte object as an answer. And
elasticsearch gives you back exactly what you have indexed.

That being said, I think you could look at parent/child feature for
that use case.
Or you can have one carte object per adherent?

Makes sense?

 --

David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfr
https://twitter.com/elasticsearchfr

Le 20 juin 2014 à 11:06:40, Alexandre Touret (alex...@touret.info) a
écrit:

hello,

https://stackoverflow.com/questions/24323480/elasticsearch-queries-always-return-all-the-datas-stored-in-the-index#

I'm trying to index and query an index store in ES 1.2. I both create
and populate the index with the JAVA API using the transportclient api. I
have the following mapping:

get /tp/carte/_mapping{
"tp": {
"mappings": {
"carte": {
"properties": {
"adherents": {
"properties": {
"birthday": {
"type": "date",
"format": "dateOptionalTime"
},
"firstname": {
"type": "string"
},
"lastname": {
"type": "string"
}
}
},
"dateEdition": {
"type": "date",
"format": "dateOptionalTime"
}
}
}
}
}}

When I search ob object with the ID, it works fine but, when I try
to query the content of one of my nested objects, ES always returns
all the objects stored in the index
. I also tried to create the
objects manually with sense and I have the same behaviour.

Example of my insert

put /tp/carte/20454795{
"dateEdition": "2014-06-01T22:00:00.000Z",
"adherents": [
{
"birthday": "1958-05-05T23:00:00.000Z",
"firstname": "ANDREW",
"lastname": "DOE"
},
{
"birthday": "1964-03-01T23:00:00.000Z",
"firstname": "ROBERT",
"lastname": "DOE"
},
{
"birthday": "1989-02-27T23:00:00.000Z",
"firstname": "DAVID",
"lastname": "DOE"
},
{
"birthday": "1990-12-11T23:00:00.000Z",
"firstname": "JOHN",
"lastname": "DOE"
}
]
}

Finally, you could find below a query executed in sense

get /tp/carte/_search{
"query": {
"bool": {
"must": [
{
"match": {
"adherents.lastname": {
"query": "DOE"
}
}
}
]
}
}

How can I fix that ?

Thanks

Regards

Alexandre

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6102e860-e997-45db-9db4-7da309e6c761%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/6abc6213-b1f7-4145-9573-49401e720029%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/e399b978-4d27-43f7-a294-fc2b1033e438%40googlegroups.com?utm_medium=email&utm_source=footer.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/CAJQxjPO6khU8VkbOqsdHpWFeJhaoG
H5nhbnyOzGjo_d_7Ecfyg%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAJQxjPO6khU8VkbOqsdHpWFeJhaoGH5nhbnyOzGjo_d_7Ecfyg%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/4cd45b68-32ca-4427-8523-d898c75fc44b%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/4cd45b68-32ca-4427-8523-d898c75fc44b%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAJQxjPOg_und7KTvuJzecJwSGxmxx7HPzkRewPNoEyDzFpRAqQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(system) #11