# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=925 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 926 --- ## [Mapping the id value with a custom label (select input)](https://discuss.elastic.co/t/mapping-the-id-value-with-a-custom-label-select-input/232181)
**Author:** [@ArnaudDoubremelle](https://discuss.elastic.co/u/ArnaudDoubremelle)\ **Replies:** 0\ **Last updated:** [May 12, 2020, 9:46am UTC](https://discuss.elastic.co/t/mapping-the-id-value-with-a-custom-label-select-input/232181 "2020-05-12T09:46:11Z")
Hello, I have a select input profession with values like (1, 2, 3, 4). What should I use to map these values? 1 = develop 2 = farmer ... And later I may need to rename a profession's label... For example: 2 = rural… --- ## [How to write DtSearchConverter, NotSpanQuery in elastic?](https://discuss.elastic.co/t/how-to-write-dtsearchconverter-notspanquery-in-elastic/231823)
**Author:** [@Attila816](https://discuss.elastic.co/u/Attila816)\ **Replies:** 1\ **Last updated:** [May 12, 2020, 9:26am UTC](https://discuss.elastic.co/t/how-to-write-dtsearchconverter-notspanquery-in-elastic/231823 "2020-05-12T09:26:22Z")
Hi, how can I write NotSpanQuery which is not the same as SpanNotQuery in Elastic? How can I write a query like this in elastic: QueryA AND NOT QueryB what I want to rewrite it as QueryA NOT W/Integer.MAX\_VALUE QueryB … --- ## [Temporary downtime during node migration (and order)](https://discuss.elastic.co/t/temporary-downtime-during-node-migration-and-order/231797)
**Author:** [@blacksmith](https://discuss.elastic.co/u/blacksmith)\ **Replies:** 14\ **Last updated:** [May 12, 2020, 9:15am UTC](https://discuss.elastic.co/t/temporary-downtime-during-node-migration-and-order/231797 "2020-05-12T09:15:15Z")
Hello! We have a 3-node cluster running ES 5.6.16 running in VMware VMs and we will soon migrate the nodes to another VMware-cluster. I'm planning to move it one node at a time, but how do I move it as efficiently as p… --- ## [Regular expession queries in elasticsearch](https://discuss.elastic.co/t/regular-expession-queries-in-elasticsearch/231836)
**Author:** [@Attila816](https://discuss.elastic.co/u/Attila816)\ **Replies:** 10\ **Last updated:** [May 12, 2020, 8:37am UTC](https://discuss.elastic.co/t/regular-expession-queries-in-elasticsearch/231836 "2020-05-12T08:37:51Z")
I know that the .\* operators match any characters of any length, including no characters and elastic has a RegexpQuery syntax. So from that page I see that there are standard operators: . , ? , + , \*, {…}, |, (…), \[ …… --- ## [Creating New index from filtering existing index](https://discuss.elastic.co/t/creating-new-index-from-filtering-existing-index/231503)
**Author:** [@sarvendras](https://discuss.elastic.co/u/sarvendras)\ **Replies:** 3\ **Last updated:** [May 12, 2020, 8:37am UTC](https://discuss.elastic.co/t/creating-new-index-from-filtering-existing-index/231503 "2020-05-12T08:37:27Z")
HelloTeam, I have a index with large volume fo data.I want to create new subset index by doing some filtering (for example Merchant number="something").How can I do this in elasticsearch. Please suggest. Thanks Sarve… --- ## [Getting index rate metrics from elasticsearch](https://discuss.elastic.co/t/getting-index-rate-metrics-from-elasticsearch/232148)
**Author:** [@whysmer](https://discuss.elastic.co/u/whysmer)\ **Replies:** 2\ **Last updated:** [May 12, 2020, 7:39am UTC](https://discuss.elastic.co/t/getting-index-rate-metrics-from-elasticsearch/232148 "2020-05-12T07:39:10Z")
Hello, I need to collect some metrics from elasticsearch but I can't find the way to get them. What I want is : the average index rate for all index on a time interval the max/peak index rate for an index on a time i… --- ## [Rally custom benchmark-only pipeline / track without corpora](https://discuss.elastic.co/t/rally-custom-benchmark-only-pipeline-track-without-corpora/231878)
**Author:** [@crab86](https://discuss.elastic.co/u/crab86)\ **Replies:** 4\ **Last updated:** [May 12, 2020, 6:36am UTC](https://discuss.elastic.co/t/rally-custom-benchmark-only-pipeline-track-without-corpora/231878 "2020-05-12T06:36:10Z")
Hi there, i have an already provisioned elasticsearch setup with an Index that consist of around 30Million documents. I would like to benchmark this existing setup using esrally. In order to do so esrally provides the b… --- ## [Using a document as reference to boost results?](https://discuss.elastic.co/t/using-a-document-as-reference-to-boost-results/230848)
**Author:** [@abhijith\_chandran](https://discuss.elastic.co/u/abhijith_chandran)\ **Replies:** 6\ **Last updated:** [May 12, 2020, 6:18am UTC](https://discuss.elastic.co/t/using-a-document-as-reference-to-boost-results/230848 "2020-05-12T06:18:05Z")
Hi, I was wondering whether there is a way I can feed additional text (from a document) to get more accurate results? For example, a user can upload a PDF that contains text that s/he thinks is relevant to the search. … --- ## [How does Cross Cluster Replication work during a DR failover?](https://discuss.elastic.co/t/how-does-cross-cluster-replication-work-during-a-dr-failover/230734)
**Author:** [@sg.esearch](https://discuss.elastic.co/u/sg.esearch)\ **Replies:** 5\ **Last updated:** [May 12, 2020, 5:40am UTC](https://discuss.elastic.co/t/how-does-cross-cluster-replication-work-during-a-dr-failover/230734 "2020-05-12T05:40:35Z")
Happy Scenario We have setup ES on two data-centers - A and B. Data is coming to A from Kafka/Spark combination hosted in A too. ES in B has a follower index. ES in A has a leader index. Both A and B elastic cluster… --- ## [How to calculate the time taken to process query dsl alone before performing actual searching operation?](https://discuss.elastic.co/t/how-to-calculate-the-time-taken-to-process-query-dsl-alone-before-performing-actual-searching-operation/232137)
**Author:** [@kmdabdulla](https://discuss.elastic.co/u/kmdabdulla)\ **Replies:** 0\ **Last updated:** [May 12, 2020, 5:33am UTC](https://discuss.elastic.co/t/how-to-calculate-the-time-taken-to-process-query-dsl-alone-before-performing-actual-searching-operation/232137 "2020-05-12T05:33:13Z")
I understand that the entire search time is given by the "took" field. But I want to know how much time actually the elasticsearch engine takes to process the query alone before performing the search operation. While it … --- ## [Validation failed: 1 :Mapping type is missing](https://discuss.elastic.co/t/validation-failed-1-mapping-type-is-missing/231938)
**Author:** [@Matish\_Bhuyan](https://discuss.elastic.co/u/Matish_Bhuyan)\ **Replies:** 11\ **Last updated:** [May 12, 2020, 3:15am UTC](https://discuss.elastic.co/t/validation-failed-1-mapping-type-is-missing/231938 "2020-05-12T03:15:41Z")
Hi I am a newbie to Elastic search I have created an index which source field is bit lengthy and i am suspecting that the ignore\_above is restricting to visualize my data in Kibana. So i went on trying to change the I… --- ## [Help with a query strategy around tracking device online/offline aggregation](https://discuss.elastic.co/t/help-with-a-query-strategy-around-tracking-device-online-offline-aggregation/230884)
**Author:** [@miked187](https://discuss.elastic.co/u/miked187)\ **Replies:** 1\ **Last updated:** [May 12, 2020, 3:13am UTC](https://discuss.elastic.co/t/help-with-a-query-strategy-around-tracking-device-online-offline-aggregation/230884 "2020-05-12T03:13:19Z")
We have a series of devices that we track by device name, storing the message that they emit, and the datetime of the message. The devices are come online as system load increases and go offline as load decreases. A de… --- ## [How to put selected rows items on top of results](https://discuss.elastic.co/t/how-to-put-selected-rows-items-on-top-of-results/232118)
**Author:** [@duenguyen](https://discuss.elastic.co/u/duenguyen)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 11:33pm UTC](https://discuss.elastic.co/t/how-to-put-selected-rows-items-on-top-of-results/232118 "2020-05-11T23:33:21Z")
How can I put selected items on top of results? For example I want id 3 and 4 on top after sort by name. Similar to SQL Order in query. Let's say I have an index call person. GET person/\_search { hits: \[ "\_source"… --- ## [Elasticsearch two node cluster](https://discuss.elastic.co/t/elasticsearch-two-node-cluster/232101)
**Author:** [@Gauti](https://discuss.elastic.co/u/Gauti)\ **Replies:** 3\ **Last updated:** [May 11, 2020, 10:49pm UTC](https://discuss.elastic.co/t/elasticsearch-two-node-cluster/232101 "2020-05-11T22:49:14Z")
Hi All, We have been ended up setting a 2 node elasticsearch cluster due to certain issues. As i'm aware there will be a possible split brain issue or HA failure issue. Can someone give me a better advice on how to ta… --- ## [Copy\_to properties isn't queriable](https://discuss.elastic.co/t/copy-to-properties-isnt-queriable/231876)
**Author:** [@emarthinsen](https://discuss.elastic.co/u/emarthinsen)\ **Replies:** 2\ **Last updated:** [May 11, 2020, 10:22pm UTC](https://discuss.elastic.co/t/copy-to-properties-isnt-queriable/231876 "2020-05-11T22:22:09Z")
Hi. I've got a puzzling question here. This is the definition for my index: "mappings": { "properties": { "name\_copy": { "type": "text" }, "name": { "type": "text", … --- ## [Is it possible to distribute unequal loads among the unequal servers (different processing power)](https://discuss.elastic.co/t/is-it-possible-to-distribute-unequal-loads-among-the-unequal-servers-different-processing-power/230612)
**Author:** [@b\_hossein](https://discuss.elastic.co/u/b_hossein)\ **Replies:** 3\ **Last updated:** [May 11, 2020, 10:00pm UTC](https://discuss.elastic.co/t/is-it-possible-to-distribute-unequal-loads-among-the-unequal-servers-different-processing-power/230612 "2020-05-11T22:00:44Z")
Is it possible to distribute unequal loads among the unequal servers (different processing power)? Assume we have an Elasticsearch cluster with different nodes performances. When we create an index in this cluster, all … --- ## [Getting unique fields from Query Result](https://discuss.elastic.co/t/getting-unique-fields-from-query-result/232105)
**Author:** [@tidus](https://discuss.elastic.co/u/tidus)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 7:43pm UTC](https://discuss.elastic.co/t/getting-unique-fields-from-query-result/232105 "2020-05-11T19:43:50Z")
Hi, I would like to know if there is another method besides a scripted metrics aggregation to get all unique document field names from a query result. --- ## [Delete an nonexistent document](https://discuss.elastic.co/t/delete-an-nonexistent-document/232073)
**Author:** [@ekrx](https://discuss.elastic.co/u/ekrx)\ **Replies:** 5\ **Last updated:** [May 11, 2020, 7:40pm UTC](https://discuss.elastic.co/t/delete-an-nonexistent-document/232073 "2020-05-11T19:40:59Z")
I would like to understand what are the implications of sending a delete by id for a document that does not exist. We have such case where we are sending delete operations for a big number of documents where almost 90% o… --- ## [S3 Snapshot issues](https://discuss.elastic.co/t/s3-snapshot-issues/232096)
**Author:** [@Elk\_huh](https://discuss.elastic.co/u/Elk_huh)\ **Replies:** 6\ **Last updated:** [May 11, 2020, 7:34pm UTC](https://discuss.elastic.co/t/s3-snapshot-issues/232096 "2020-05-11T19:34:06Z")
I am trying to set up S3 snapshots and i keep getting this error, anyone has any ideas ? "error" : { "root\_cause" : \[ { "type" : "repository\_verification\_exception", "reason" : "\[s3\] path is… --- ## [Unable to add keystore secure password through kubernetes init containers](https://discuss.elastic.co/t/unable-to-add-keystore-secure-password-through-kubernetes-init-containers/231216)
**Author:** [@avinashashukla](https://discuss.elastic.co/u/avinashashukla)\ **Replies:** 1\ **Last updated:** [May 11, 2020, 7:00pm UTC](https://discuss.elastic.co/t/unable-to-add-keystore-secure-password-through-kubernetes-init-containers/231216 "2020-05-11T19:00:14Z")
Deploying elasticsearch as docker in kubernetes Trying to add keystore secure password as part of kubernetes init container while deploying the a statefulset but the password is not getting added. initContainers:… --- ## [3 node cluster errors](https://discuss.elastic.co/t/3-node-cluster-errors/232088)
**Author:** [@kawalec](https://discuss.elastic.co/u/kawalec)\ **Replies:** 1\ **Last updated:** [May 11, 2020, 6:17pm UTC](https://discuss.elastic.co/t/3-node-cluster-errors/232088 "2020-05-11T18:17:27Z")
I've followed the instructions to set up 3 node cluster. I also have added master node: true and data node: true to all nodes and have tried without. No matter what I do I can not get my cluster to run clean. Can no… --- ## [Elastic search 6.5.4 Caused by:ClassNotFoundException: org.elasticsearch.xpack.core.XPackClientPlugin](https://discuss.elastic.co/t/elastic-search-6-5-4-caused-by-org-elasticsearch-xpack-core-xpackclientplugin/230332)
**Author:** [@rthangaraj5](https://discuss.elastic.co/u/rthangaraj5)\ **Replies:** 16\ **Last updated:** [May 11, 2020, 5:23pm UTC](https://discuss.elastic.co/t/elastic-search-6-5-4-caused-by-org-elasticsearch-xpack-core-xpackclientplugin/230332 "2020-05-11T17:23:12Z")
I am getting ClassNotFoundException: org.elasticsearch.xpack.core.XPackClientPlugin with elastic search 6.5.4 version. pls find the logs which i am getting . Caused by: org.springframework.beans.factory.BeanCreationExc… --- ## [Elastic Search Version](https://discuss.elastic.co/t/elastic-search-version/232021)
**Author:** [@test\_profession](https://discuss.elastic.co/u/test_profession)\ **Replies:** 1\ **Last updated:** [May 11, 2020, 4:11pm UTC](https://discuss.elastic.co/t/elastic-search-version/232021 "2020-05-11T16:11:21Z")
Hi There, Is it mandatory to maintain the same Elastic Search Version on all available environments like Development,Testing,UAT and Production environment? --- ## [JSON Schema for Query](https://discuss.elastic.co/t/json-schema-for-query/231886)
**Author:** [@JLarue](https://discuss.elastic.co/u/JLarue)\ **Replies:** 4\ **Last updated:** [May 11, 2020, 4:09pm UTC](https://discuss.elastic.co/t/json-schema-for-query/231886 "2020-05-11T16:09:20Z")
I am looking for a JSON Schema that describes the Elastic Query syntax so I can use to validate queries in JSON form. Is there something available? --- ## [Unassigned shards after node was restarted](https://discuss.elastic.co/t/unassigned-shards-after-node-was-restarted/231915)
**Author:** [@praveenmak](https://discuss.elastic.co/u/praveenmak)\ **Replies:** 2\ **Last updated:** [May 11, 2020, 3:51pm UTC](https://discuss.elastic.co/t/unassigned-shards-after-node-was-restarted/231915 "2020-05-11T15:51:21Z")
I am using v7.5.2, I have 10 nodes, 6 Data nodes having 8 TB of data and there is plenty of space left. I have an ILM policy to rollover index after a month from Hot to warm. I restarted a node after minor config chang… --- ## [Adding new field to existing index where field does not exist](https://discuss.elastic.co/t/adding-new-field-to-existing-index-where-field-does-not-exist/227587)
**Author:** [@Rowan](https://discuss.elastic.co/u/Rowan)\ **Replies:** 1\ **Last updated:** [May 11, 2020, 2:59pm UTC](https://discuss.elastic.co/t/adding-new-field-to-existing-index-where-field-does-not-exist/227587 "2020-05-11T14:59:38Z")
Firstly, totally new to the ELK stack so still struggling with the terminology. I have been trying to create some visualizations and discovered that merging fields via a JSON scipt is kind of finicky, and apparently not… --- ## [Unable to Get API token](https://discuss.elastic.co/t/unable-to-get-api-token/232051)
**Author:** [@remo\_anil](https://discuss.elastic.co/u/remo_anil)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 2:55pm UTC](https://discuss.elastic.co/t/unable-to-get-api-token/232051 "2020-05-11T14:55:55Z")
Hi all, Need help !! This is my first post. i am trying to get API token/Key to read some logs from Kibana server using API. Below is the information i Have used. API URI - http://xxxxxxxxxxxxxxxx:9200/\_xpack/securit… --- ## [How to change mappings of index data type from "Text" to "float"](https://discuss.elastic.co/t/how-to-change-mappings-of-index-data-type-from-text-to-float/232043)
**Author:** [@Anil\_Kumar8](https://discuss.elastic.co/u/Anil_Kumar8)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 2:18pm UTC](https://discuss.elastic.co/t/how-to-change-mappings-of-index-data-type-from-text-to-float/232043 "2020-05-11T14:18:21Z")
Hi, I have part of one month data existing in old server elastic 6.8 and after re-index moved to new server 7.8. Issues is the mapping of first part of data is showing data type which was moved from 6.8 is showing ""ty… --- ## [Error installing attachment plugin offline - missing x-pack-core\\plugin-descriptor.properties file](https://discuss.elastic.co/t/error-installing-attachment-plugin-offline-missing-x-pack-core-plugin-descriptor-properties-file/231903)
**Author:** [@ImaMacCan](https://discuss.elastic.co/u/ImaMacCan)\ **Replies:** 3\ **Last updated:** [May 11, 2020, 2:18pm UTC](https://discuss.elastic.co/t/error-installing-attachment-plugin-offline-missing-x-pack-core-plugin-descriptor-properties-file/231903 "2020-05-11T14:18:49Z")
Command is: C:\\APPS\\elasticsearch-7.6.2\>bin\\elasticsearch-plugin install file:///C:/install/ingest-attachment-7.6.2.zip Error is: Exception in thread "main" java.lang.IllegalStateException: Could not load plugin descr… --- ## [Error with integer field in kibana](https://discuss.elastic.co/t/error-with-integer-field-in-kibana/232042)
**Author:** [@hiba](https://discuss.elastic.co/u/hiba)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 2:15pm UTC](https://discuss.elastic.co/t/error-with-integer-field-in-kibana/232042 "2020-05-11T14:15:55Z")
Hi, my data source is as follows (API json) { "bookings": \[ { "bookingId": 553267, "bookingRef": "VO20200108460", "statusId": 1, "status": "Confirmed", "createdDate": "2020-01-06 00:00:00", "confirmedDate": "", … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=924) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=926)