"double barreled" surname search fails


(Mark Perry) #1

Can anyone tell me why this search works:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

but this one doesn't:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones-walker"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

i.e. second search has a "double barreled" surname in it?

--
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/a04c9815-ce66-4357-a3e1-ef1e4b288c4c%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(paul) #2

It depends on your mapping , can you show the mapping for your surname.

Reagrds
Avinash

On Friday, 20 December 2013 14:45:45 UTC+5:30, Mark Perry wrote:

Can anyone tell me why this search works:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

but this one doesn't:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones-walker"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

i.e. second search has a "double barreled" surname in it?

--
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/3f42fff1-faca-4aa1-be51-3704571b3112%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Mark Perry) #3

All the data is going through the bulk uploader. In C# I serialize the
object that represents the individual and add it to a string that will be
passed to a PUT request. I don't think I have a specific mapping - can you
recommend something I need to read up on?

sb.Append("{ "create" : {"_index" : "knowsleycitizen", "_type" :
"attendance", "_id" : "" + id.ToString() + ""} }\n" +
Newtonsoft.Json.JsonConvert.SerializeObject(b) + "\n");

On Friday, 20 December 2013 09:36:07 UTC, paul wrote:

It depends on your mapping , can you show the mapping for your surname.

Reagrds
Avinash

On Friday, 20 December 2013 14:45:45 UTC+5:30, Mark Perry wrote:

Can anyone tell me why this search works:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

but this one doesn't:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones-walker"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

i.e. second search has a "double barreled" surname in it?

--
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/2278cdea-4952-49d5-a8f4-c604acfd870c%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(paul) #4

On Friday, 20 December 2013 14:45:45 UTC+5:30, Mark Perry wrote:

Can anyone tell me why this search works:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

but this one doesn't:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones-walker"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

i.e. second search has a "double barreled" surname in it?

--
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/70d89699-861b-4495-8431-d3dbd4690e2f%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(paul) #5

By default Strings are analyzed using "standard analyzer"
http://localhost:9200//_analyze?analyzer=standard&text=jones-walker&prettyhttp://localhost:9200/sports/_analyze?analyzer=standard&text=jones-walker&pretty

{ "tokens" : [ { "token" : "jones", "start_offset" : 0, "end_offset" : 5, "type"
: "", "position" : 1 }, { "token" : "walker", "start_offset" : 6, "end_offset"
: 12, "type" : "", "position" : 2 } ] }

So the terms stored after analysis are as aboveRead standard analyzer

On Friday, 20 December 2013 16:28:35 UTC+5:30, Mark Perry wrote:

All the data is going through the bulk uploader. In C# I serialize the
object that represents the individual and add it to a string that will be
passed to a PUT request. I don't think I have a specific mapping - can you
recommend something I need to read up on?

sb.Append("{ "create" : {"_index" : "knowsleycitizen", "_type" :
"attendance", "_id" : "" + id.ToString() + ""} }\n" +
Newtonsoft.Json.JsonConvert.SerializeObject(b) + "\n");

On Friday, 20 December 2013 09:36:07 UTC, paul wrote:

It depends on your mapping , can you show the mapping for your surname.

Reagrds
Avinash

On Friday, 20 December 2013 14:45:45 UTC+5:30, Mark Perry wrote:

Can anyone tell me why this search works:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

but this one doesn't:

{"query":{"bool":{"must":[{"term":{"chosenforename":"brian"}},{"term":{"surname":"jones-walker"}},{"term":{"dob":"2002-02-12T00:00:00"}},{"range":{"eventstart":{"from":"2013-09-01T00:00:00","to":"2013-11-14T00:00:00"}}}]}}}

i.e. second search has a "double barreled" surname in it?

--
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/d972987f-9e6c-46fa-8dc6-301d2e8a583f%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #6