# Elasticsearch

**URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1197

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1198

---

## [Possible bug in OIDC implementation](https://discuss.elastic.co/t/possible-bug-in-oidc-implementation/194418)

<div class="topic-metadata">

**Author:** [@jhonko](https://discuss.elastic.co/u/jhonko)\
**Replies:** 1\
**Last updated:** [August 8, 2019, 2:24pm UTC](https://discuss.elastic.co/t/possible-bug-in-oidc-implementation/194418 "2019-08-08T14:24:15Z")

</div>

Hello! I'm currently evaluating Elastic Stack. Currently I'm focusing on Elasticsearch SSO features and especially its OpenID Connect (OIDC) support. We have a custom OIDC standard compliant identity provider which I h…

---

## [Incorrect response from elasticsearch Node.js client v7.2.0 for aggregation query](https://discuss.elastic.co/t/incorrect-response-from-elasticsearch-node-js-client-v7-2-0-for-aggregation-query/194442)

<div class="topic-metadata">

**Author:** [@kartikchauhan](https://discuss.elastic.co/u/kartikchauhan)\
**Replies:** 0\
**Last updated:** [August 8, 2019, 1:45pm UTC](https://discuss.elastic.co/t/incorrect-response-from-elasticsearch-node-js-client-v7-2-0-for-aggregation-query/194442 "2019-08-08T13:45:02Z")

</div>

Hello, I am sending a nested aggregation query on a nested object using the Node.js client v7.2.0 for elasticsearch. While executing the query on Node.js client, i am getting all the records for that index and not the f…

---

## [Watcher is Giving 401 Status Errors When Trying to Execute 'email' Action](https://discuss.elastic.co/t/watcher-is-giving-401-status-errors-when-trying-to-execute-email-action/194273)

<div class="topic-metadata">

**Author:** [@nfielder](https://discuss.elastic.co/u/nfielder)\
**Replies:** 4\
**Last updated:** [August 8, 2019, 1:16pm UTC](https://discuss.elastic.co/t/watcher-is-giving-401-status-errors-when-trying-to-execute-email-action/194273 "2019-08-08T13:16:29Z")

</div>

Hi all, I am trying to set up a Watcher to automatically send an email with a PDF of a dashboard. I have been following the documentation here. However I am getting an error when the 'email' action is executed. I can't…

---

## [Custom mapping some questions](https://discuss.elastic.co/t/custom-mapping-some-questions/194217)

<div class="topic-metadata">

**Author:** [@newbie1](https://discuss.elastic.co/u/newbie1)\
**Replies:** 5\
**Last updated:** [August 8, 2019, 1:09pm UTC](https://discuss.elastic.co/t/custom-mapping-some-questions/194217 "2019-08-08T13:09:49Z")

</div>

Hi, I work on certification and mapping exercises. I defined the following index with a custom analyzer. I wonder : Since the analyzer is defined in settings part, is it used for all fields ? If yes, could some on…

---

## [Reindex daily indices to weekly indices](https://discuss.elastic.co/t/reindex-daily-indices-to-weekly-indices/193780)

<div class="topic-metadata">

**Author:** [@Praneet\_Khandelwal](https://discuss.elastic.co/u/Praneet_Khandelwal)\
**Replies:** 8\
**Last updated:** [August 8, 2019, 12:01pm UTC](https://discuss.elastic.co/t/reindex-daily-indices-to-weekly-indices/193780 "2019-08-08T12:01:23Z")

</div>

I am working on a reindexing problem in which I need to reindex the daily indices to weekly indices. I am using the reindex APi and trying to work with the script processor to make the changes. Can anyone help with what …

---

## [Error when trying to aggregate a bucket script with another bucket script](https://discuss.elastic.co/t/error-when-trying-to-aggregate-a-bucket-script-with-another-bucket-script/194416)

<div class="topic-metadata">

**Author:** [@liorg2](https://discuss.elastic.co/u/liorg2)\
**Replies:** 0\
**Last updated:** [August 8, 2019, 11:26am UTC](https://discuss.elastic.co/t/error-when-trying-to-aggregate-a-bucket-script-with-another-bucket-script/194416 "2019-08-08T11:26:23Z")

</div>

Hi, I'm having trouble to make this query work (original fields name were changed). What I'm basically trying to do, is calculate a score for each entity (each entity has a different score weights), and then calculate …

---

## [Elasticsearch 7.0.1 OIDC/SAML support](https://discuss.elastic.co/t/elasticsearch-7-0-1-oidc-saml-support/194199)

<div class="topic-metadata">

**Author:** [@playfair039](https://discuss.elastic.co/u/playfair039)\
**Replies:** 2\
**Last updated:** [August 8, 2019, 11:23am UTC](https://discuss.elastic.co/t/elasticsearch-7-0-1-oidc-saml-support/194199 "2019-08-08T11:23:32Z")

</div>

I'm running an elk stack 7.0.1 which works just fine. However, I'm struggling to enable openid functionality using keycloak. I've enabled secure http over ssl and token service on the elasticsearch. It doesn't take any o…

---

## [Getting proper sorting of product in category](https://discuss.elastic.co/t/getting-proper-sorting-of-product-in-category/194414)

<div class="topic-metadata">

**Author:** [@g\_tsvetanov](https://discuss.elastic.co/u/g_tsvetanov)\
**Replies:** 0\
**Last updated:** [August 8, 2019, 11:19am UTC](https://discuss.elastic.co/t/getting-proper-sorting-of-product-in-category/194414 "2019-08-08T11:19:27Z")

</div>

Hello, I'm trying to make more fancy sorting but I faced an issue by issue maybe because I'm newbie to the elasticsearch. Let me explain the situation: I have a category with ID 1 for example but when someone opened it…

---

## [Quick question about rollups using Kibana](https://discuss.elastic.co/t/quick-question-about-rollups-using-kibana/194292)

<div class="topic-metadata">

**Author:** [@EricJohnson](https://discuss.elastic.co/u/EricJohnson)\
**Replies:** 0\
**Last updated:** [August 7, 2019, 4:55pm UTC](https://discuss.elastic.co/t/quick-question-about-rollups-using-kibana/194292 "2019-08-07T16:55:28Z")

</div>

Greetings! We are performing rollups on metricbeat data that occur periodically so that I can perform analysis on counted data rather than gigabytes of raw data. Right now we are testing with three servers which each h…

---

## [Percolate query matches different query with synonym](https://discuss.elastic.co/t/percolate-query-matches-different-query-with-synonym/194300)

<div class="topic-metadata">

**Author:** [@niketpatel2525](https://discuss.elastic.co/u/niketpatel2525)\
**Replies:** 1\
**Last updated:** [August 8, 2019, 9:23am UTC](https://discuss.elastic.co/t/percolate-query-matches-different-query-with-synonym/194300 "2019-08-08T09:23:54Z")

</div>

I have created a percolate index with custom analyzer and with that custom analyzer I am passing synonyms. Let's say, Synonyms, A =\> A, X B =\> B, X C =\> C, X And my percolate queries also has all different query fo…

---

## [How to enable "Management / Security" in Kibana; runs xpack.security.enabled=true in Elasticsearch (Basic license plan)](https://discuss.elastic.co/t/how-to-enable-management-security-in-kibana-runs-xpack-security-enabled-true-in-elasticsearch-basic-license-plan/190339)

<div class="topic-metadata">

**Author:** [@azhurbilo](https://discuss.elastic.co/u/azhurbilo)\
**Replies:** 10\
**Last updated:** [August 8, 2019, 9:16am UTC](https://discuss.elastic.co/t/how-to-enable-management-security-in-kibana-runs-xpack-security-enabled-true-in-elasticsearch-basic-license-plan/190339 "2019-08-08T09:16:08Z")

</div>

How to enable "Management / Security" in Kibana for Basic plan? According to Subscriptions | Elastic Stack Products & Support | Elastic Basic Plan support Elasticsearch: Role-based access control File and native auth…

---

## [Elastic search error in application, Error message - " An error occurred while requesting elastic search for data on index 'denmod\_y\_\*'](https://discuss.elastic.co/t/elastic-search-error-in-application-error-message-an-error-occurred-while-requesting-elastic-search-for-data-on-index-denmod-y/190261)

<div class="topic-metadata">

**Author:** [@Joseph\_Raj](https://discuss.elastic.co/u/Joseph_Raj)\
**Replies:** 26\
**Last updated:** [August 8, 2019, 9:10am UTC](https://discuss.elastic.co/t/elastic-search-error-in-application-error-message-an-error-occurred-while-requesting-elastic-search-for-data-on-index-denmod-y/190261 "2019-08-08T09:10:36Z")

</div>

Once the application runs & When Elasticsearch for data, it was unable to retrieve. It says error while searching the data. It has two types of error 1) All shards failed error 2) Index not found exception. We have re…

---

## [Node/ cluster consuming too much memory](https://discuss.elastic.co/t/node-cluster-consuming-too-much-memory/194380)

<div class="topic-metadata">

**Author:** [@Rakesh4](https://discuss.elastic.co/u/Rakesh4)\
**Replies:** 0\
**Last updated:** [August 8, 2019, 9:06am UTC](https://discuss.elastic.co/t/node-cluster-consuming-too-much-memory/194380 "2019-08-08T09:06:53Z")

</div>

we have es configuration like 3 master node(16GB, allocation 15 GB , hdd 2 TB) 3 data node (64GB, allocation 12 GB , hdd 2 TB) 2 coord node(32GB, allocation 15 GB , hdd 2 TB) Replica set to 2 . Data node have 2 TB da…

---

## ['type': 'illegal\_argument\_exception', 'reason': 'cannot parse empty date'}](https://discuss.elastic.co/t/type-illegal-argument-exception-reason-cannot-parse-empty-date/194239)

<div class="topic-metadata">

**Author:** [@Saurabh\_Sharma\_IIT](https://discuss.elastic.co/u/Saurabh_Sharma_IIT)\
**Replies:** 4\
**Last updated:** [August 8, 2019, 8:49am UTC](https://discuss.elastic.co/t/type-illegal-argument-exception-reason-cannot-parse-empty-date/194239 "2019-08-08T08:49:01Z")

</div>

Hi, I am using bulk api to inject pandas dataframe into elasticsearch index. I first converted dataframe to dict and then used bulk. In my .csv data file , I have a column name "start\_date", I have converted it into dat…

---

## [Snapshot and restore API question](https://discuss.elastic.co/t/snapshot-and-restore-api-question/194363)

<div class="topic-metadata">

**Author:** [@mmk1995](https://discuss.elastic.co/u/mmk1995)\
**Replies:** 3\
**Last updated:** [August 8, 2019, 8:48am UTC](https://discuss.elastic.co/t/snapshot-and-restore-api-question/194363 "2019-08-08T08:48:00Z")

</div>

Hi all, Is there a best way to restore an index like restoring a relational database? As I know, in Oracle, restoring a backup is overwriting the existing database and replace with the backup, and the behavior of \_res…

---

## [Control number of buckets created in an aggregation](https://discuss.elastic.co/t/control-number-of-buckets-created-in-an-aggregation/194360)

<div class="topic-metadata">

**Author:** [@Ahmad\_Mozafarnia](https://discuss.elastic.co/u/Ahmad_Mozafarnia)\
**Replies:** 6\
**Last updated:** [August 8, 2019, 8:32am UTC](https://discuss.elastic.co/t/control-number-of-buckets-created-in-an-aggregation/194360 "2019-08-08T08:32:05Z")

</div>

This question was originally posted on StackOverflow: I'm having trouble with controlling the number of buckets an aggregation is going to create. This is a simple aggregation containing no nested or sub aggregation…

---

## [Handling data in Elasticsearch with Docker](https://discuss.elastic.co/t/handling-data-in-elasticsearch-with-docker/194142)

<div class="topic-metadata">

**Author:** [@jjarthur](https://discuss.elastic.co/u/jjarthur)\
**Replies:** 4\
**Last updated:** [August 8, 2019, 8:06am UTC](https://discuss.elastic.co/t/handling-data-in-elasticsearch-with-docker/194142 "2019-08-08T08:06:43Z")

</div>

I'm looking at setting up Elasticsearch within Docker and am trying to figure out the best method for inserting new data. Currently, after running docker-compose up, I run a series of curl commands to set up the index an…

---

## [How to aggregate and page results](https://discuss.elastic.co/t/how-to-aggregate-and-page-results/194369)

<div class="topic-metadata">

**Author:** [@Higor\_Cesar\_Ramos](https://discuss.elastic.co/u/Higor_Cesar_Ramos)\
**Replies:** 0\
**Last updated:** [August 8, 2019, 8:04am UTC](https://discuss.elastic.co/t/how-to-aggregate-and-page-results/194369 "2019-08-08T08:04:44Z")

</div>

Hello people, I know that it is not possible to page aggregations and the recommended way is to use composite. My problem is that with composite the Key is the aggregation key and I need to paginate by a "number" like …

---

## [Problem getting multiline json document into ES](https://discuss.elastic.co/t/problem-getting-multiline-json-document-into-es/194350)

<div class="topic-metadata">

**Author:** [@ajhstn](https://discuss.elastic.co/u/ajhstn)\
**Replies:** 5\
**Last updated:** [August 8, 2019, 6:56am UTC](https://discuss.elastic.co/t/problem-getting-multiline-json-document-into-es/194350 "2019-08-08T06:56:04Z")

</div>

Hi, i am producing a valid json document from get-aduser username | convertto-json | out-file file.json I am then sending that file to ES using filebeat, however in ES it is ingesting the document, one document per line…

---

## [Adding search bar for my web application](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841)

<div class="topic-metadata">

**Author:** [@saurabhbora](https://discuss.elastic.co/u/saurabhbora)\
**Replies:** 8\
**Last updated:** [August 8, 2019, 6:23am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841 "2019-08-08T06:23:57Z")

</div>

My web application has all the data stored in the MySQL database. I want to develop a search bar using elastic search for retrieving results faster. How should I go about this?

---

## [Get the specific values from arrays elasticsearch](https://discuss.elastic.co/t/get-the-specific-values-from-arrays-elasticsearch/194358)

<div class="topic-metadata">

**Author:** [@elasticpatrick](https://discuss.elastic.co/u/elasticpatrick)\
**Replies:** 0\
**Last updated:** [August 8, 2019, 6:18am UTC](https://discuss.elastic.co/t/get-the-specific-values-from-arrays-elasticsearch/194358 "2019-08-08T06:18:53Z")

</div>

Hi, I have a field "user\_names" having list of users names in my "user" index. I want to query through the user\_names field and get only match values from the array and if possible can I get apply aggregation on the user…

---

## [Unable to configure 'x-pack-security' under basic license](https://discuss.elastic.co/t/unable-to-configure-x-pack-security-under-basic-license/194236)

<div class="topic-metadata">

**Author:** [@asad\_ali](https://discuss.elastic.co/u/asad_ali)\
**Replies:** 6\
**Last updated:** [August 8, 2019, 5:54am UTC](https://discuss.elastic.co/t/unable-to-configure-x-pack-security-under-basic-license/194236 "2019-08-08T05:54:13Z")

</div>

I'm using ELK 7.1 , I want to configure basic authentication. So far I have performed the following:- curl -u elastic:change http://127.0.0.1:9200/\_security/\_authenticate?pretty { "error" : { "root\_cause" : \[ …

---

## [Elasticsearch did not respond with license information](https://discuss.elastic.co/t/elasticsearch-did-not-respond-with-license-information/194192)

<div class="topic-metadata">

**Author:** [@Sohan\_J](https://discuss.elastic.co/u/Sohan_J)\
**Replies:** 4\
**Last updated:** [August 8, 2019, 5:26am UTC](https://discuss.elastic.co/t/elasticsearch-did-not-respond-with-license-information/194192 "2019-08-08T05:26:34Z")

</div>

My ES yml file: ---------------------------------- Cluster ----------------------------------- Use a descriptive name for your cluster: cluster.name: test-app-cluster ------------------------------------ Node ------…

---

## [How to duplicate every document in an index](https://discuss.elastic.co/t/how-to-duplicate-every-document-in-an-index/194328)

<div class="topic-metadata">

**Author:** [@TeraInferno](https://discuss.elastic.co/u/TeraInferno)\
**Replies:** 1\
**Last updated:** [August 8, 2019, 5:13am UTC](https://discuss.elastic.co/t/how-to-duplicate-every-document-in-an-index/194328 "2019-08-08T05:13:44Z")

</div>

Hello. I would like to duplicate every document I have in my index, changing the value of a single field for each new duplicated document. How would I do this?

---

## [NEST issue backporting from v7.x to v5.x](https://discuss.elastic.co/t/nest-issue-backporting-from-v7-x-to-v5-x/193741)

<div class="topic-metadata">

**Author:** [@Wyzak](https://discuss.elastic.co/u/Wyzak)\
**Replies:** 1\
**Last updated:** [August 8, 2019, 5:03am UTC](https://discuss.elastic.co/t/nest-issue-backporting-from-v7-x-to-v5-x/193741 "2019-08-08T05:03:55Z")

</div>

Hi all, I'm using the C# NEST client to query an ES server running v5.3.x. I successfully implemented a v7.x NEST client but started running into some unexpected exceptions and was told that I should downgrade to a v5.x…

---

## [Query for specific traits in a household](https://discuss.elastic.co/t/query-for-specific-traits-in-a-household/194332)

<div class="topic-metadata">

**Author:** [@marksparrish](https://discuss.elastic.co/u/marksparrish)\
**Replies:** 0\
**Last updated:** [August 7, 2019, 9:42pm UTC](https://discuss.elastic.co/t/query-for-specific-traits-in-a-household/194332 "2019-08-07T21:42:02Z")

</div>

I am trying to retrieve all of the household that have only females in it. My document structure is - name\_first: keyword name\_middle: keyword name\_last: keyword physical\_address\_id: keyword gender: keyword Gender i…

---

## [Painless - way to test if division results in a whole number (no remainder)?](https://discuss.elastic.co/t/painless-way-to-test-if-division-results-in-a-whole-number-no-remainder/194306)

<div class="topic-metadata">

**Author:** [@Zelfapp](https://discuss.elastic.co/u/Zelfapp)\
**Replies:** 1\
**Last updated:** [August 7, 2019, 7:26pm UTC](https://discuss.elastic.co/t/painless-way-to-test-if-division-results-in-a-whole-number-no-remainder/194306 "2019-08-07T19:26:45Z")

</div>

In javascript Number.isInteger() will return a boolean indicating whether or not the given value is an integer. Is there an equivalent function in Painless I can call to test if a division calculation results in a whole …

---

## [How to reset elastic user?](https://discuss.elastic.co/t/how-to-reset-elastic-user/192750)

<div class="topic-metadata">

**Author:** [@Duggina](https://discuss.elastic.co/u/Duggina)\
**Replies:** 2\
**Last updated:** [August 7, 2019, 7:55pm UTC](https://discuss.elastic.co/t/how-to-reset-elastic-user/192750 "2019-08-07T19:55:51Z")

</div>

Hi, is there any way to reset elastic user password with out going to the deployment/security ? Thanks Gopala

---

## [Elasticsearch DSL multi level nesting query not working](https://discuss.elastic.co/t/elasticsearch-dsl-multi-level-nesting-query-not-working/193595)

<div class="topic-metadata">

**Author:** [@prashant\_madaan](https://discuss.elastic.co/u/prashant_madaan)\
**Replies:** 1\
**Last updated:** [August 7, 2019, 7:31pm UTC](https://discuss.elastic.co/t/elasticsearch-dsl-multi-level-nesting-query-not-working/193595 "2019-08-07T19:31:44Z")

</div>

Hi , I am trying to write a multi level nested query in Elastic Search DSL. I am running into an issue where it says cannot create query. This is a sample record: { "memory":123.989807, "disks":\[ { "total":5033, …

---

## [Default OR Search- do you override?](https://discuss.elastic.co/t/default-or-search-do-you-override/194057)

<div class="topic-metadata">

**Author:** [@Christie\_Morin](https://discuss.elastic.co/u/Christie_Morin)\
**Replies:** 4\
**Last updated:** [August 7, 2019, 7:08pm UTC](https://discuss.elastic.co/t/default-or-search-do-you-override/194057 "2019-08-07T19:08:27Z")

</div>

Elastic Search uses OR by default and other search engines, like Google and MS, use AND for default. Training uses to reverse their logic for ES is challenging. Does anyone override the OR and use AND? I'm not a searc…

[Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1196)

[Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1198)
