Oracle's connect_by query in ES


(psstv2010) #1

Hi

I am very newbie in ElasticSearch and got a too big problem to solve by
myself.

Someone in my company told me that what I am trying to do can be easily
solved if I used Oracle's connect_by query, but I don't have Oracle but
Elasticsearch, so would like to ask for a help.

I would like to query against more than one indexes and they have some keys
in common. So, when querying, I'd like to merge a record into a single row
in the output. The following is my examples.

Sample1 KEY Depth Tag 1001 10 Case 1002 20 Case Sample2 KEY Depth
Tag 1001 10 Control Sample3 KEY Depth Case 1002 10 Case Output
KEY CaseDepth Controdepth 1001 10 10 1002 20;10
Using those three samples, for "1001" key, the value of "Depth" field, is
10 for both "Case and Control" tag.
I need to show case and control "Depth" values separately.

Is it possible to do so in ElasticSearch?
Any suggestion?

Thanks
T.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.


(David Pilato) #2

May be you are looking for https://github.com/elasticsearch/elasticsearch/pull/3278?source=cc?

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 22 oct. 2013 à 08:06, psstv2010@gmail.com a écrit :

Hi

I am very newbie in ElasticSearch and got a too big problem to solve by myself.

Someone in my company told me that what I am trying to do can be easily solved if I used Oracle's connect_by query, but I don't have Oracle but Elasticsearch, so would like to ask for a help.

I would like to query against more than one indexes and they have some keys in common. So, when querying, I'd like to merge a record into a single row in the output. The following is my examples.

Sample1
KEY Depth Tag
1001 10 Case
1002 20 Case
Sample2
KEY Depth Tag
1001 10 Control
Sample3
KEY Depth Case
1002 10 Case
Output
KEY CaseDepth Controdepth
1001 10 10
1002 20;10
Using those three samples, for "1001" key, the value of "Depth" field, is 10 for both "Case and Control" tag.
I need to show case and control "Depth" values separately.

Is it possible to do so in ElasticSearch?
Any suggestion?

Thanks
T.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3