# Elasticsearch

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

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

**Page:** 1410

---

## [Query versioning](https://discuss.elastic.co/t/query-versioning/166540)

<div class="topic-metadata">

**Author:** [@sesha](https://discuss.elastic.co/u/sesha)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 11:30am UTC](https://discuss.elastic.co/t/query-versioning/166540 "2019-01-31T11:30:25Z")

</div>

Do we have any tools for query versioning other than git?

---

## [Pushing excel data with row and coulumn header in elastic search](https://discuss.elastic.co/t/pushing-excel-data-with-row-and-coulumn-header-in-elastic-search/166508)

<div class="topic-metadata">

**Author:** [@Be1](https://discuss.elastic.co/u/Be1)\
**Replies:** 5\
**Last updated:** [January 31, 2019, 11:30am UTC](https://discuss.elastic.co/t/pushing-excel-data-with-row-and-coulumn-header-in-elastic-search/166508 "2019-01-31T11:30:20Z")

</div>

Hello, I need suggestion on how to proceed with this problem. The following is my csv file.. |value\_type |1-Sep|3-Sep|4-Sep|5-Sep|6-Sep|7-Sep|8-Sep|10-Sep|11-Sep|12-Sep|13-Sep|14-Sep|15-Sep|17-Sep|18-Sep|19-Sep|20-Sep…

---

## [How to modify elasticsearch configuration?](https://discuss.elastic.co/t/how-to-modify-elasticsearch-configuration/166531)

<div class="topic-metadata">

**Author:** [@Cavielee](https://discuss.elastic.co/u/Cavielee)\
**Replies:** 1\
**Last updated:** [January 31, 2019, 11:28am UTC](https://discuss.elastic.co/t/how-to-modify-elasticsearch-configuration/166531 "2019-01-31T11:28:25Z")

</div>

I trying to deploy sonarqube-7.5 on the linux(centOS 6.x). I suffered the problem: unable to install syscall filter: java.lang.UnsupportedOperationException: seccomp unavailable: requires kernel 3.5+ with CONFIG\_SECCOM…

---

## [Field data types size](https://discuss.elastic.co/t/field-data-types-size/166389)

<div class="topic-metadata">

**Author:** [@gorek](https://discuss.elastic.co/u/gorek)\
**Replies:** 5\
**Last updated:** [January 31, 2019, 10:54am UTC](https://discuss.elastic.co/t/field-data-types-size/166389 "2019-01-31T10:54:38Z")

</div>

In documentation I found lot of fields datatypes supported by Elasticsearch but theres not information about how much storage each type consumes. For example which datatype (keyword or ip) will be better for store IP ad…

---

## [Can't find x-pack 5.5.2](https://discuss.elastic.co/t/cant-find-x-pack-5-5-2/166527)

<div class="topic-metadata">

**Author:** [@jugurtha](https://discuss.elastic.co/u/jugurtha)\
**Replies:** 1\
**Last updated:** [January 31, 2019, 10:45am UTC](https://discuss.elastic.co/t/cant-find-x-pack-5-5-2/166527 "2019-01-31T10:45:02Z")

</div>

hi please i can' find x-pack 5.5.2 for my elastci and kibana version 5.5.2 any one can send the me link or the file ? Reagrds

---

## [Update\_By\_Query not creating task](https://discuss.elastic.co/t/update-by-query-not-creating-task/166535)

<div class="topic-metadata">

**Author:** [@gtflagship](https://discuss.elastic.co/u/gtflagship)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 10:43am UTC](https://discuss.elastic.co/t/update-by-query-not-creating-task/166535 "2019-01-31T10:43:47Z")

</div>

When running: ubqResponse = ElasticClient.UpdateByQuery(u =\> u .Type("entity") .Index(IndexName) .Query(q =\> ubqquery) .WaitForCompletion(false) .Slices(ubqslices) .Script(script =\> script.Source(ubqscript).Params…

---

## [How to search by any word in any field with ElasticSearch rest high-level client? Also add aggregation on same query](https://discuss.elastic.co/t/how-to-search-by-any-word-in-any-field-with-elasticsearch-rest-high-level-client-also-add-aggregation-on-same-query/166523)

<div class="topic-metadata">

**Author:** [@sunilgjagtap](https://discuss.elastic.co/u/sunilgjagtap)\
**Replies:** 1\
**Last updated:** [January 31, 2019, 10:31am UTC](https://discuss.elastic.co/t/how-to-search-by-any-word-in-any-field-with-elasticsearch-rest-high-level-client-also-add-aggregation-on-same-query/166523 "2019-01-31T10:31:26Z")

</div>

I have to search a any word in any field with elasticSearch rest high-level client and also apply aggregation on query so get source bucket. Please suggest proper way.

---

## [Elasticsearch for Apache Hadoop doesn't work](https://discuss.elastic.co/t/elasticsearch-for-apache-hadoop-doesnt-work/163971)

<div class="topic-metadata">

**Author:** [@Arthur\_Luz](https://discuss.elastic.co/u/Arthur_Luz)\
**Replies:** 7\
**Last updated:** [January 28, 2019, 9:07am UTC](https://discuss.elastic.co/t/elasticsearch-for-apache-hadoop-doesnt-work/163971 "2019-01-28T09:07:59Z")

</div>

Hello, guys. I need some help with Elasticsearch for Apache Hadoop connector. I have on my environment a hortonworks hdp cluster and with hive. I need to create a external table for elasticsearch to move data from my h…

---

## [Can i add Aindex's documents aggregation result into B Index's document?](https://discuss.elastic.co/t/can-i-add-aindexs-documents-aggregation-result-into-b-indexs-document/166274)

<div class="topic-metadata">

**Author:** [@teemoGod](https://discuss.elastic.co/u/teemoGod)\
**Replies:** 1\
**Last updated:** [January 31, 2019, 9:50am UTC](https://discuss.elastic.co/t/can-i-add-aindexs-documents-aggregation-result-into-b-indexs-document/166274 "2019-01-31T09:50:21Z")

</div>

Hi. i'm using elasticsearch 6.4.1. i was posted this question. and @warkolm answered for me. thank you. but i guess 'Rollup API' doesn't support 'Nested Aggregation'. (Rollup aggregation limitations | Elasticsearch…

---

## [Elasticsearch cluster scaling from 3 nodes to 5 nodes to open many indices/shards, best practices](https://discuss.elastic.co/t/elasticsearch-cluster-scaling-from-3-nodes-to-5-nodes-to-open-many-indices-shards-best-practices/164988)

<div class="topic-metadata">

**Author:** [@kishore419](https://discuss.elastic.co/u/kishore419)\
**Replies:** 6\
**Last updated:** [January 31, 2019, 9:47am UTC](https://discuss.elastic.co/t/elasticsearch-cluster-scaling-from-3-nodes-to-5-nodes-to-open-many-indices-shards-best-practices/164988 "2019-01-31T09:47:23Z")

</div>

We are using three node Elasticsearch cluster in AWS Cloud. here are the configurations. Instance Type: M4 4X Large (Three nodes), each node configurations are given below. CPU, 16 cores, RAM 64GB, EBS volumes: 4TB \*…

---

## [ES Snapshot - RepositoryMissingException missing](https://discuss.elastic.co/t/es-snapshot-repositorymissingexception-missing/166510)

<div class="topic-metadata">

**Author:** [@genseb](https://discuss.elastic.co/u/genseb)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 9:30am UTC](https://discuss.elastic.co/t/es-snapshot-repositorymissingexception-missing/166510 "2019-01-31T09:30:54Z")

</div>

Hi, We are encountering strange behaviours with ElasticSearch snapshots. Snapshots starts then following messages appear for some shards: RepositoryMissingException\[\[\*\*\*\*\*\] missing\] The repository exists because most…

---

## [Calculating percentage growth on Nested Fields](https://discuss.elastic.co/t/calculating-percentage-growth-on-nested-fields/165710)

<div class="topic-metadata">

**Author:** [@prasad.ram1431](https://discuss.elastic.co/u/prasad.ram1431)\
**Replies:** 1\
**Last updated:** [January 31, 2019, 7:27am UTC](https://discuss.elastic.co/t/calculating-percentage-growth-on-nested-fields/165710 "2019-01-31T07:27:34Z")

</div>

Hi All, I would like to calculate, fastest growing company(each document is a company) in Germany for the year 2016 with the below formula, (New value - original value)\*100/original value I have below structure in my …

---

## [Policy](https://discuss.elastic.co/t/policy/166485)

<div class="topic-metadata">

**Author:** [@akhilsai1499](https://discuss.elastic.co/u/akhilsai1499)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 7:23am UTC](https://discuss.elastic.co/t/policy/166485 "2019-01-31T07:23:26Z")

</div>

Hi Elasticsearch team If i am implementing the policy in latest released version of elasticsearch 6.6 still i cant implement my policy Please see my code PUT \_template/my { "index\_patterns": \["abc-\*"\], "settings":…

---

## [Use curl for PKI realm authentication](https://discuss.elastic.co/t/use-curl-for-pki-realm-authentication/165834)

<div class="topic-metadata">

**Author:** [@li\_jessen2016](https://discuss.elastic.co/u/li_jessen2016)\
**Replies:** 12\
**Last updated:** [January 31, 2019, 7:20am UTC](https://discuss.elastic.co/t/use-curl-for-pki-realm-authentication/165834 "2019-01-31T07:20:52Z")

</div>

Is it possible to use curl - for client PKI realm authentication? I know that we can fulfill file realm authentication by using curl -u username:password ... . But how to present client x509 certificate for PKI realm aut…

---

## [Elasticsearch not running on RHEL 7.3](https://discuss.elastic.co/t/elasticsearch-not-running-on-rhel-7-3/166479)

<div class="topic-metadata">

**Author:** [@Chandan1144](https://discuss.elastic.co/u/Chandan1144)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 6:40am UTC](https://discuss.elastic.co/t/elasticsearch-not-running-on-rhel-7-3/166479 "2019-01-31T06:40:53Z")

</div>

Getting error while starting elasticsearch 6.6 from terminal. Java Version -1.8.0.152 OS Version - RHEL 7.3 Installation mode - tar.gz file extracted \[2019-01-31T11:47:30,044\]\[WARN \]\[o.e.b.ElasticsearchUncaughtExcept…

---

## [AND Match All Tokens in Any Order](https://discuss.elastic.co/t/and-match-all-tokens-in-any-order/166469)

<div class="topic-metadata">

**Author:** [@tlovett1](https://discuss.elastic.co/u/tlovett1)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 5:24am UTC](https://discuss.elastic.co/t/and-match-all-tokens-in-any-order/166469 "2019-01-31T05:24:18Z")

</div>

Hello, I am trying to match query a text field. However, I only want the match to count if the analyzed query has the same number of tokens as the searched field. For example: "one two three" would match "two three one…

---

## [Change mapping in pipeline for ingest-attachment plugin](https://discuss.elastic.co/t/change-mapping-in-pipeline-for-ingest-attachment-plugin/166071)

<div class="topic-metadata">

**Author:** [@ottadini](https://discuss.elastic.co/u/ottadini)\
**Replies:** 2\
**Last updated:** [January 31, 2019, 5:12am UTC](https://discuss.elastic.co/t/change-mapping-in-pipeline-for-ingest-attachment-plugin/166071 "2019-01-31T05:12:54Z")

</div>

I have a workflow for storing a range of binary document types (some handled by Tika, others that need pre-processing, with json generated in a script and indexed using PUT). For the documents handled by the ingest-attac…

---

## [Hits are showing exact count as log file count but while searching in kibana getting repeated log lines as well as some lines are missing from index](https://discuss.elastic.co/t/hits-are-showing-exact-count-as-log-file-count-but-while-searching-in-kibana-getting-repeated-log-lines-as-well-as-some-lines-are-missing-from-index/166465)

<div class="topic-metadata">

**Author:** [@timesUser](https://discuss.elastic.co/u/timesUser)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 4:36am UTC](https://discuss.elastic.co/t/hits-are-showing-exact-count-as-log-file-count-but-while-searching-in-kibana-getting-repeated-log-lines-as-well-as-some-lines-are-missing-from-index/166465 "2019-01-31T04:36:31Z")

</div>

Hits are showing exact count as uploaded log file but while searching in kibana getting repeated log lines as well as some lines are missing from index.

---

## [Need help with debugging](https://discuss.elastic.co/t/need-help-with-debugging/166449)

<div class="topic-metadata">

**Author:** [@newbieelastic](https://discuss.elastic.co/u/newbieelastic)\
**Replies:** 5\
**Last updated:** [January 31, 2019, 5:08am UTC](https://discuss.elastic.co/t/need-help-with-debugging/166449 "2019-01-31T05:08:46Z")

</div>

I am getting a parsing error. Could you see what I could be doing wrong? Thanks! PUT /\_template/flightdata\_template { "index\_patterns": \["flightdata\*"\], "mappings" : { "\_doc" : { "dynamic": "strict", "properties" …

---

## [Curl Refused by Local Host with 9200 port](https://discuss.elastic.co/t/curl-refused-by-local-host-with-9200-port/166453)

<div class="topic-metadata">

**Author:** [@caitlinallen](https://discuss.elastic.co/u/caitlinallen)\
**Replies:** 1\
**Last updated:** [January 31, 2019, 5:07am UTC](https://discuss.elastic.co/t/curl-refused-by-local-host-with-9200-port/166453 "2019-01-31T05:07:45Z")

</div>

Hi! Doing a quick standup of a stack on CentOS 7 server for a personal project. I cannot get it to curl the local host if I add a 9200 to the URL. Everything is running fine, everything has an active status. I've adde…

---

## [Search in mutiple indices](https://discuss.elastic.co/t/search-in-mutiple-indices/166463)

<div class="topic-metadata">

**Author:** [@ZY2zZ](https://discuss.elastic.co/u/ZY2zZ)\
**Replies:** 0\
**Last updated:** [January 31, 2019, 3:39am UTC](https://discuss.elastic.co/t/search-in-mutiple-indices/166463 "2019-01-31T03:39:37Z")

</div>

I try to search in a index,it only spends 9-20ms,But if i search in mutiple indices,it spends a long time(about 110-240ms. Isn't it parallel？ And when i use the profile API,i find that next\_doc spents the most time,how c…

---

## [What algorithm is ElasticSearch create Document \_Id based on?Could somebody answer me，plz](https://discuss.elastic.co/t/what-algorithm-is-elasticsearch-create-document-id-based-on-could-somebody-answer-me-plz/166317)

<div class="topic-metadata">

**Author:** [@ennian001](https://discuss.elastic.co/u/ennian001)\
**Replies:** 2\
**Last updated:** [January 31, 2019, 2:56am UTC](https://discuss.elastic.co/t/what-algorithm-is-elasticsearch-create-document-id-based-on-could-somebody-answer-me-plz/166317 "2019-01-31T02:56:37Z")

</div>

the \_id is UUID? If I want to specify my own ID, according to the formula（shard = hash(routing) % number\_of\_primary\_shards）, will it result in uneven sharding? I'm confused about this. Can someone help me? plz, i'd …

---

## [Sum up sort values](https://discuss.elastic.co/t/sum-up-sort-values/166445)

<div class="topic-metadata">

**Author:** [@Kendra\_Kuivenhoven](https://discuss.elastic.co/u/Kendra_Kuivenhoven)\
**Replies:** 0\
**Last updated:** [January 30, 2019, 11:18pm UTC](https://discuss.elastic.co/t/sum-up-sort-values/166445 "2019-01-30T23:18:18Z")

</div>

Hi all, I'm using a script query to get the score of "age". I want to run a query where upon completion of the script query, I can sum up the "sort" value. Here is what I have, how would I write a query to sum up the "…

---

## [Unable to restore from readonly S3 bucket](https://discuss.elastic.co/t/unable-to-restore-from-readonly-s3-bucket/165694)

<div class="topic-metadata">

**Author:** [@davidbkemp](https://discuss.elastic.co/u/davidbkemp)\
**Replies:** 2\
**Last updated:** [January 30, 2019, 10:27pm UTC](https://discuss.elastic.co/t/unable-to-restore-from-readonly-s3-bucket/165694 "2019-01-30T22:27:59Z")

</div>

We don't seem to be able to restore the S3 backup/snapshot of one cluster to another (exactly the same version of Elasticsearch). Note, this is for version 1.7 (yeah, I know that is really ancient). Not sure if it is s…

---

## [Newbie. Trouble getting through the online guide](https://discuss.elastic.co/t/newbie-trouble-getting-through-the-online-guide/162874)

<div class="topic-metadata">

**Author:** [@bmclaugh](https://discuss.elastic.co/u/bmclaugh)\
**Replies:** 3\
**Last updated:** [January 30, 2019, 9:18pm UTC](https://discuss.elastic.co/t/newbie-trouble-getting-through-the-online-guide/162874 "2019-01-30T21:18:40Z")

</div>

Installed v 7.0.0-alpha2 on Windows 10. Using the getting-started guide at https://www.elastic.co/guide/en/elasticsearch/reference/current/getting-started-explore.html I am able to get the cluster health. I am able to…

---

## [Exception in thread "main" java.nio.file.NoSuchFileException: /usr/share/elasticsearch/plugins/.installing-2424676764641674618/plugin-descriptor.properties](https://discuss.elastic.co/t/exception-in-thread-main-java-nio-file-nosuchfileexception-usr-share-elasticsearch-plugins-installing-2424676764641674618-plugin-descriptor-properties/165588)

<div class="topic-metadata">

**Author:** [@admindbypf](https://discuss.elastic.co/u/admindbypf)\
**Replies:** 5\
**Last updated:** [January 30, 2019, 8:46pm UTC](https://discuss.elastic.co/t/exception-in-thread-main-java-nio-file-nosuchfileexception-usr-share-elasticsearch-plugins-installing-2424676764641674618-plugin-descriptor-properties/165588 "2019-01-30T20:46:54Z")

</div>

When I install license-2.4.6.zip on RHEL 7, I get this error: \[root@sldbuetmora01 ~\]# /usr/share/elasticsearch/bin/elasticsearch-plugin install file:/root/license-2.4.6.zip -\> Downloading file:/root/license-2.4.6.zip …

---

## [Search throw multiple fields on a document](https://discuss.elastic.co/t/search-throw-multiple-fields-on-a-document/166419)

<div class="topic-metadata">

**Author:** [@AustinFelipe](https://discuss.elastic.co/u/AustinFelipe)\
**Replies:** 1\
**Last updated:** [January 30, 2019, 7:36pm UTC](https://discuss.elastic.co/t/search-throw-multiple-fields-on-a-document/166419 "2019-01-30T19:36:21Z")

</div>

Hey! Well, I'm a new Elastic Search user and I'd like to know how to query on multiple fields at a document inside Elastic with just on text input. Consider these documents: { "description": "Some pretty nice descr…

---

## [Using ES for historical usage](https://discuss.elastic.co/t/using-es-for-historical-usage/166412)

<div class="topic-metadata">

**Author:** [@eb1](https://discuss.elastic.co/u/eb1)\
**Replies:** 0\
**Last updated:** [January 30, 2019, 6:26pm UTC](https://discuss.elastic.co/t/using-es-for-historical-usage/166412 "2019-01-30T18:26:44Z")

</div>

hi guys, I’m new with ES and I need your help :blush: I working on a system that needs to show the history of the data it’s got- what field changed, what is the new value, and when did it change. :exploding\_head: The …

---

## [Best existing tracks/challenges for benchmarking read-heavy or read-mostly workloads?](https://discuss.elastic.co/t/best-existing-tracks-challenges-for-benchmarking-read-heavy-or-read-mostly-workloads/166380)

<div class="topic-metadata">

**Author:** [@khyron4eva](https://discuss.elastic.co/u/khyron4eva)\
**Replies:** 1\
**Last updated:** [January 30, 2019, 6:05pm UTC](https://discuss.elastic.co/t/best-existing-tracks-challenges-for-benchmarking-read-heavy-or-read-mostly-workloads/166380 "2019-01-30T18:05:08Z")

</div>

Fellow Rally users, I'm interested in benchmarking read-heavy workloads, preferably some that already exist in Rally by default. Are there any tracks or challenges that implement such a workload already? Cheers!

---

## [Bulk get (\_mget) performance when using ES as key value store](https://discuss.elastic.co/t/bulk-get-mget-performance-when-using-es-as-key-value-store/162957)

<div class="topic-metadata">

**Author:** [@mjuric](https://discuss.elastic.co/u/mjuric)\
**Replies:** 2\
**Last updated:** [January 30, 2019, 5:45pm UTC](https://discuss.elastic.co/t/bulk-get-mget-performance-when-using-es-as-key-value-store/162957 "2019-01-30T17:45:18Z")

</div>

We are primarily using ElasticSearch for search index purposes, but we now have an internal use case where we are using ElasticSearch as a key value store through the bulk get API (\_mget) to fetch a lot of documents at o…

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

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