Re: parent/child where parent exists query

2014-01-24 Thread Thomas
Hi Adrien and thanks for the reply,

This sounds like what I was looking for :) Will investigate it

Thanks
Thomas

On Thursday, 23 January 2014 20:25:01 UTC+2, Thomas wrote:

 Hi,

 I have been working with a parent child schema creation and I was 
 wondering if there is a way to perform a search in children documents with 
 the query where parent exists and get only those documents.

 I can index children documents and there is no mandatory to have parent 
 document. Therefore, I want only to get the children who have a parent 
 document.

 Is this functionality possible? How is possible to perform such query? I 
 work with latest version 1.0.0.RC1


 Thank you
 Thomas 



-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/3bda84b6-a01c-4123-a875-05d7b23e9389%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: parent/child where parent exists query

2014-01-24 Thread Thomas
Hi,

I have two questions with regards this feature

1) I have been reading the documentation and at some point it described 
that all _ids are loaded into memory:

all _id values are loaded to memory (heap) in order to support fast lookups


This means that only the parent _ids that match correct? Not all the _ids 
of the parent/child relationship

 
2) Is it possible to perform an aggregation and take some values from the 
parent document and some from the child document? for example take some 
information from the parent document (e.g. city) and some information from 
the child document (e.g. for car model= BMW) and do some counts? and 
present them all together?

e.g.

{

parentDoc:{ 

 properties: {

 city:{

type: string,

index: not_analyzed 

}

}

}

}

{

childDoc:{ 

 properties: {

 carModel:{

type: string,

index: not_analyzed 

}

}

}

}
 

Aggregate child documents per child Document where parent exists (because i 
have childDocuments without parent info and i do not want to take those) 
per city and carModel. Below is an idea of what I'm trying to do

curl -XGET 'localhost:9200/delivery_logs_pc_idx/childDoc/_search?pretty' -d 
'{
query: {
match_all:{}
},
aggregations : {
myFilter : {
filter : {
{
has_parent : {
type : deliveryLog,
query: {match_all:{}}
}
} 
},
aggregations : {
preferrence : { terms : { script : 
*doc.parent.city.value* +  *doc.child.carModel.value*, size:100 } }
}
}
},
size:0
}'

Is there an alternative way of achieving that?

Thank you

On Thursday, 23 January 2014 20:25:01 UTC+2, Thomas wrote:

 Hi,

 I have been working with a parent child schema creation and I was 
 wondering if there is a way to perform a search in children documents with 
 the query where parent exists and get only those documents.

 I can index children documents and there is no mandatory to have parent 
 document. Therefore, I want only to get the children who have a parent 
 document.

 Is this functionality possible? How is possible to perform such query? I 
 work with latest version 1.0.0.RC1


 Thank you
 Thomas 



-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/05e42115-b73f-40fe-81ef-332ca0ab75b1%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.