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?
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?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.