How to find the distinct values in a nested type field in elasticsearch? Can anyone provide one example?
Multi tool use
0
I am looking for one example on how to extract distinct values of a nested type property in elastic search. Could anyone provide an example?
I have a below query where I am trying to retrieve distinct values of "batchId" from nested type "admin" as follows:
"aggs" :
"groupBatches" :
"nested":
"path": "admin"
,
"aggs" :
"batches" :
"terms" : "field" : "admin.ids.batchId"
If what I am trying is wrong, Please provide some example for better understanding.
elasticsearch
asked Nov 13 '18 at 4:28
Deepak
4271723
|
show 2 more comments
0
I am looking for one example on how to extract distinct values of a nested type property in elastic search. Could anyone provide an example?
I have a below query where I am trying to retrieve distinct values of "batchId" from nested type "admin" as follows:
"aggs" :
"groupBatches" :
"nested":
"path": "admin"
,
"aggs" :
"batches" :
"terms" : "field" : "admin.ids.batchId"
If what I am trying is wrong, Please provide some example for better understanding.
elasticsearch
asked Nov 13 '18 at 4:28
Deepak
4271723
What is wrong with the query as it is now? What does your mapping look like?
– ookboy24
Nov 13 '18 at 4:40
This elastic search facilities is provided by the REST end point. All we need to do is query and get the results. Do you think there is something wrong with the mapping? All I know is "admin" is a nested type. If the query looks right, what should I make sure for the mapping to look like for the above query to provide correct results?
– Deepak
Nov 13 '18 at 5:12
The mapping has to be setup for the admin field as nested data type else it will be treated as array type by default. I am not sure what to make of your comment, ES is a RESTFul engine that is basic stuff
– ookboy24
Nov 13 '18 at 6:09
@ookboy24 "admin" is nested for sure. In my previous comment, if you see I mentioned "admin" mapping is nested. Below is the mapping for "admin".. "admin_as_nested": "path_match": "admin", "mapping": "type": "nested"
– Deepak
Nov 13 '18 at 6:20
If you think there is nothing wrong in the query I posted, not sure what am I missing here.. I am not seeing any aggregation result when I hit the query. All it does is retrieve all the records as is. I do not see any aggregation ("groupBatches") specific results.
– Deepak
Nov 13 '18 at 6:23
|
show 2 more comments
0
0
0
I am looking for one example on how to extract distinct values of a nested type property in elastic search. Could anyone provide an example?
I have a below query where I am trying to retrieve distinct values of "batchId" from nested type "admin" as follows:
"aggs" :
"groupBatches" :
"nested":
"path": "admin"
,
"aggs" :
"batches" :
"terms" : "field" : "admin.ids.batchId"
If what I am trying is wrong, Please provide some example for better understanding.
elasticsearch
asked Nov 13 '18 at 4:28
Deepak
4271723
I am looking for one example on how to extract distinct values of a nested type property in elastic search. Could anyone provide an example?
I have a below query where I am trying to retrieve distinct values of "batchId" from nested type "admin" as follows:
"aggs" :
"groupBatches" :
"nested":
"path": "admin"
,
"aggs" :
"batches" :
"terms" : "field" : "admin.ids.batchId"
If what I am trying is wrong, Please provide some example for better understanding.
elasticsearch
elasticsearch
asked Nov 13 '18 at 4:28
Deepak
4271723
asked Nov 13 '18 at 4:28
Deepak
4271723
asked Nov 13 '18 at 4:28
Deepak
4271723
asked Nov 13 '18 at 4:28
Deepak
4271723
asked Nov 13 '18 at 4:28
Deepak
4271723
4271723
What is wrong with the query as it is now? What does your mapping look like?
– ookboy24
Nov 13 '18 at 4:40
This elastic search facilities is provided by the REST end point. All we need to do is query and get the results. Do you think there is something wrong with the mapping? All I know is "admin" is a nested type. If the query looks right, what should I make sure for the mapping to look like for the above query to provide correct results?
– Deepak
Nov 13 '18 at 5:12
The mapping has to be setup for the admin field as nested data type else it will be treated as array type by default. I am not sure what to make of your comment, ES is a RESTFul engine that is basic stuff
– ookboy24
Nov 13 '18 at 6:09
@ookboy24 "admin" is nested for sure. In my previous comment, if you see I mentioned "admin" mapping is nested. Below is the mapping for "admin".. "admin_as_nested": "path_match": "admin", "mapping": "type": "nested"
– Deepak
Nov 13 '18 at 6:20
If you think there is nothing wrong in the query I posted, not sure what am I missing here.. I am not seeing any aggregation result when I hit the query. All it does is retrieve all the records as is. I do not see any aggregation ("groupBatches") specific results.
– Deepak
Nov 13 '18 at 6:23
|
show 2 more comments
What is wrong with the query as it is now? What does your mapping look like?
– ookboy24
Nov 13 '18 at 4:40
This elastic search facilities is provided by the REST end point. All we need to do is query and get the results. Do you think there is something wrong with the mapping? All I know is "admin" is a nested type. If the query looks right, what should I make sure for the mapping to look like for the above query to provide correct results?
– Deepak
Nov 13 '18 at 5:12
The mapping has to be setup for the admin field as nested data type else it will be treated as array type by default. I am not sure what to make of your comment, ES is a RESTFul engine that is basic stuff
– ookboy24
Nov 13 '18 at 6:09
@ookboy24 "admin" is nested for sure. In my previous comment, if you see I mentioned "admin" mapping is nested. Below is the mapping for "admin".. "admin_as_nested": "path_match": "admin", "mapping": "type": "nested"
– Deepak
Nov 13 '18 at 6:20
If you think there is nothing wrong in the query I posted, not sure what am I missing here.. I am not seeing any aggregation result when I hit the query. All it does is retrieve all the records as is. I do not see any aggregation ("groupBatches") specific results.
– Deepak
Nov 13 '18 at 6:23
What is wrong with the query as it is now? What does your mapping look like?
– ookboy24
Nov 13 '18 at 4:40
What is wrong with the query as it is now? What does your mapping look like?
– ookboy24
Nov 13 '18 at 4:40
This elastic search facilities is provided by the REST end point. All we need to do is query and get the results. Do you think there is something wrong with the mapping? All I know is "admin" is a nested type. If the query looks right, what should I make sure for the mapping to look like for the above query to provide correct results?
– Deepak
Nov 13 '18 at 5:12
This elastic search facilities is provided by the REST end point. All we need to do is query and get the results. Do you think there is something wrong with the mapping? All I know is "admin" is a nested type. If the query looks right, what should I make sure for the mapping to look like for the above query to provide correct results?
– Deepak
Nov 13 '18 at 5:12
The mapping has to be setup for the admin field as nested data type else it will be treated as array type by default. I am not sure what to make of your comment, ES is a RESTFul engine that is basic stuff
– ookboy24
Nov 13 '18 at 6:09
The mapping has to be setup for the admin field as nested data type else it will be treated as array type by default. I am not sure what to make of your comment, ES is a RESTFul engine that is basic stuff
– ookboy24
Nov 13 '18 at 6:09
@ookboy24 "admin" is nested for sure. In my previous comment, if you see I mentioned "admin" mapping is nested. Below is the mapping for "admin".. "admin_as_nested": "path_match": "admin", "mapping": "type": "nested"
– Deepak
Nov 13 '18 at 6:20
@ookboy24 "admin" is nested for sure. In my previous comment, if you see I mentioned "admin" mapping is nested. Below is the mapping for "admin".. "admin_as_nested": "path_match": "admin", "mapping": "type": "nested"
– Deepak
Nov 13 '18 at 6:20
If you think there is nothing wrong in the query I posted, not sure what am I missing here.. I am not seeing any aggregation result when I hit the query. All it does is retrieve all the records as is. I do not see any aggregation ("groupBatches") specific results.
– Deepak
Nov 13 '18 at 6:23
If you think there is nothing wrong in the query I posted, not sure what am I missing here.. I am not seeing any aggregation result when I hit the query. All it does is retrieve all the records as is. I do not see any aggregation ("groupBatches") specific results.
– Deepak
Nov 13 '18 at 6:23
|
show 2 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53273822%2fhow-to-find-the-distinct-values-in-a-nested-type-field-in-elasticsearch-can-any%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53273822%2fhow-to-find-the-distinct-values-in-a-nested-type-field-in-elasticsearch-can-any%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
4dr Y IBRfi2478pQeT5gBqPHqSacS8aPMvJjs61 9ZA9eD B9 DrL
What is wrong with the query as it is now? What does your mapping look like?
– ookboy24
Nov 13 '18 at 4:40
This elastic search facilities is provided by the REST end point. All we need to do is query and get the results. Do you think there is something wrong with the mapping? All I know is "admin" is a nested type. If the query looks right, what should I make sure for the mapping to look like for the above query to provide correct results?
– Deepak
Nov 13 '18 at 5:12
The mapping has to be setup for the admin field as nested data type else it will be treated as array type by default. I am not sure what to make of your comment, ES is a RESTFul engine that is basic stuff
– ookboy24
Nov 13 '18 at 6:09
@ookboy24 "admin" is nested for sure. In my previous comment, if you see I mentioned "admin" mapping is nested. Below is the mapping for "admin".. "admin_as_nested": "path_match": "admin", "mapping": "type": "nested"
– Deepak
Nov 13 '18 at 6:20
If you think there is nothing wrong in the query I posted, not sure what am I missing here.. I am not seeing any aggregation result when I hit the query. All it does is retrieve all the records as is. I do not see any aggregation ("groupBatches") specific results.
– Deepak
Nov 13 '18 at 6:23