Making an elasticsearch nested query for match on all fields of nested object -



Making an elasticsearch nested query for match on all fields of nested object -

the basic question follows: there convenient way specify multi-field match on fields nested query? normal query { match : { _all : "query string" }} works. doesn't work in nested query perhaps because nested object doesn't have _all?

the more detailed question below:

i have nested document called "parent" follows:

{ "children" : [ { "field_a": "value_a_1", "field_b" : "value_b_1", "field_c" : [ { "field_c_a" : "value_c_a_1", "field_c_b" : "value_c_b_1" } ] }, { "field_a": "value_a_2", "field_b" : "value_b_2", "field_c" : [ { "field_c_a" : "value_c_a_2", "field_c_b" : "value_c_b_2" } ] } ] }

this mapping used making children nested objects:

"parent" : { "properties" : { "children" : { "type" : "nested", "include_in_parent" : true } } }

and here query, want select few terms using match on children fields query, , term query:

"query" : { "nested": { "path" : "children", "query" : { "bool" : { "must" : [ {"multi_match" : {"query": "value_c_a_1", "fields" : ["children.*"]}}, {"term" : {children.field_a : "value_a_1" }} ] } } } }

the above query doesn't work because can't select fields in multimatch query nested object.

"query" : { "nested": { "path" : "children", "query" : { "bool" : { "must" : [ {"multi_match" : {"query": "value_c_a_1", "fields" : ["*_c_a"]}} ] } } } }

the query above works because pattern matching allows * placed before string not after reason (?)

is there nice shorthand way select fields of nested object?

it nice know why expected children.* wildcard doesn't work expected.

worked me (note: elasticsearch 1.7). notice different names though (aparent, somechildren) - haven't tested original names, have it.

schema:

curl -xput localhost:9200/test -d '{ "mappings": { "aparent": { "properties": { "somechildren": { "type": "nested", "include_in_parent": true } } } } }'

document:

curl -xput localhost:9200/test/aparent/1 -d '{ "somechildren" : [ { "field_a": "value_a_1", "field_b" : "value_b_1", "field_c" : [ { "field_c_a" : "value_c_a_1", "field_c_b" : "value_c_b_1" } ] }, { "field_a": "value_a_2", "field_b" : "value_b_2", "field_c" : [ { "field_c_a" : "value_c_a_2", "field_c_b" : "value_c_b_2" } ] } ] }'

query:

get test/_search { "query": { "nested": { "path": "somechildren", "query": { "bool": { "must": [ { "multi_match": { "query": "value_c_a_1", "fields": [ "somechildren.*" ] } }, { "term": { "somechildren.field_a": { "value": "value_a_1" } } } ] } } } } }

result:

{ "took": 2, "timed_out": false, "_shards": { "total": 5, "successful": 5, "failed": 0 }, "hits": { "total": 1, "max_score": 0.8603305, "hits": [ { "_index": "test", "_type": "aparent", "_id": "1", "_score": 0.8603305, "_source": { "somechildren": [ { "field_a": "value_a_1", "field_b": "value_b_1", "field_c": [ { "field_c_a": "value_c_a_1", "field_c_b": "value_c_b_1" } ] }, { "field_a": "value_a_2", "field_b": "value_b_2", "field_c": [ { "field_c_a": "value_c_a_2", "field_c_b": "value_c_b_2" } ] } ] } } ] } }

elasticsearch

Comments

Post a Comment

Popular posts from this blog

c - Compilation of a code: unkown type name string -

c - Compilation of a code: unkown type name string - i have next lines of code compiler says following: "unknown type name 'string'" both in declaration , definition of function. can tell me what's wrong? thanks. #include <stdio.h> #include <stdlib.h> #include <string.h> void frecognizeclient(string *actualclient) there no string type in c. need utilize array so: char array[10]; then can pass in function: void frecognizeclient(char *actualclient); c arrays string compilation
Read more

java - Bypassing "final local variable defined in an enclosing type" -

java - Bypassing "final local variable defined in an enclosing type" - i'm writing programme , i'm getting "the final local variable asd cannot assigned, since it's defined in enclosing type". i provide illustration not code produces error aswell. have arraylist utilize later (if define within button can't utilize later on), outside of button, pressing button should give values arraylist. in illustration "create new arraylist" cause same problem. button btn = new button("asd"); final arraylist asd = new arraylist(); btn.setonaction(new eventhandler<actionevent>() { public void handle(final actionevent event) { asd = new arraylist(); //here's error.. } }); clear arraylist , add together values. java javafx
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more