# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1995 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1996 --- ## [Regexp on Standard Analyzer Field](https://discuss.elastic.co/t/regexp-on-standard-analyzer-field/95176)
**Author:** [@mbrosnan](https://discuss.elastic.co/u/mbrosnan)\ **Replies:** 0\ **Last updated:** [July 31, 2017, 11:29am UTC](https://discuss.elastic.co/t/regexp-on-standard-analyzer-field/95176 "2017-07-31T11:29:16Z")
Hi, new to Elasticsearch, is there any way to do a regex search on a field mapped by a standard analyzer. "message" : { "type" : "string", "analyzer" : "standard" } This is a graylog index so … --- ## [ElasticSearch Natural Sort](https://discuss.elastic.co/t/elasticsearch-natural-sort/95168)
**Author:** [@natsudragoneye](https://discuss.elastic.co/u/natsudragoneye)\ **Replies:** 0\ **Last updated:** [July 31, 2017, 10:32am UTC](https://discuss.elastic.co/t/elasticsearch-natural-sort/95168 "2017-07-31T10:32:32Z")
ElasticSearch support Natural Sort? I check this thread: Natural sort , but I didnt find If ES 5.X already support it. It supports? --- ## [Failed to execute \[org.elasticsearch.action.search.SearchRequest@2b540127\] lastShard \[true\]](https://discuss.elastic.co/t/failed-to-execute-org-elasticsearch-action-search-searchrequest-2b540127-lastshard-true/95164)
**Author:** [@yedukondalu](https://discuss.elastic.co/u/yedukondalu)\ **Replies:** 0\ **Last updated:** [July 31, 2017, 10:15am UTC](https://discuss.elastic.co/t/failed-to-execute-org-elasticsearch-action-search-searchrequest-2b540127-lastshard-true/95164 "2017-07-31T10:15:10Z")
\[2017-07-31 09:19:30,905\]\[DEBUG\]\[action.search.type \] \[James Proudstar\] \[cms-all\]\[0\], node\[ZftIWI9OQ-uZOXi0R4Jfkg\], \[P\], s\[STARTED\]: Failed to execute \[org.elasticsearch.action.search.SearchRequest@2b540127\] org.e… --- ## [Calculations with ELK](https://discuss.elastic.co/t/calculations-with-elk/95091)
**Author:** [@marwa](https://discuss.elastic.co/u/marwa)\ **Replies:** 1\ **Last updated:** [July 31, 2017, 9:45am UTC](https://discuss.elastic.co/t/calculations-with-elk/95091 "2017-07-31T09:45:31Z")
Hello, i am using ELK in order to analyse retails transactions and in my project i have data that contains transactions made between 2016 and 2017, product , revenue by each product … i need to calculate the total reven… --- ## [Scripted metrics](https://discuss.elastic.co/t/scripted-metrics/95159)
**Author:** [@marwa](https://discuss.elastic.co/u/marwa)\ **Replies:** 0\ **Last updated:** [July 31, 2017, 9:41am UTC](https://discuss.elastic.co/t/scripted-metrics/95159 "2017-07-31T09:41:07Z")
Hello , i created an index with date, product and revenue fields. i need to calculate the total revenue made in 2016 then divide for each document that its product is sold in 2017 the revenue by the total revenue of 201… --- ## [ElasticsearchException: could not initialize mac](https://discuss.elastic.co/t/elasticsearchexception-could-not-initialize-mac/94582)
**Author:** [@Ihjaz](https://discuss.elastic.co/u/Ihjaz)\ **Replies:** 5\ **Last updated:** [July 31, 2017, 9:27am UTC](https://discuss.elastic.co/t/elasticsearchexception-could-not-initialize-mac/94582 "2017-07-31T09:27:09Z")
Hi, I'm trying to start elasticsearch in secure mode with x-pack. I have the following configuration in the elasticsearch.yml #---------------xpack security----------------------- xpack.ssl.key: /… --- ## [Snapshot 'repository\_missing\_exception'](https://discuss.elastic.co/t/snapshot-repository-missing-exception/95151)
**Author:** [@frasdav](https://discuss.elastic.co/u/frasdav)\ **Replies:** 0\ **Last updated:** [July 31, 2017, 9:02am UTC](https://discuss.elastic.co/t/snapshot-repository-missing-exception/95151 "2017-07-31T09:02:51Z")
We’ve got two Elasticsearch 2.4 clusters configured identically. Both have a snapshot repository called ‘backups’ defined. If I do: curl -XGET https://$(hostname --fqdn):9200/\_snapshot?pretty …on any node in either clu… --- ## [Unable to install new elasticsearch 5.5](https://discuss.elastic.co/t/unable-to-install-new-elasticsearch-5-5/95146)
**Author:** [@vijjun123](https://discuss.elastic.co/u/vijjun123)\ **Replies:** 1\ **Last updated:** [July 31, 2017, 9:00am UTC](https://discuss.elastic.co/t/unable-to-install-new-elasticsearch-5-5/95146 "2017-07-31T09:00:01Z")
Unable to install elasticsearch 5.5 While executing ./elasticsearch got the below error Could you please guide the further $ ./elasticsearch \[2017-07-31T08:42:26,945\]\[INFO \]\[o.e.n.Node \] \[\] initializing… --- ## [Specifying content type for attachment](https://discuss.elastic.co/t/specifying-content-type-for-attachment/93142)
**Author:** [@jshraddha](https://discuss.elastic.co/u/jshraddha)\ **Replies:** 3\ **Last updated:** [July 31, 2017, 8:52am UTC](https://discuss.elastic.co/t/specifying-content-type-for-attachment/93142 "2017-07-31T08:52:23Z")
Hi, I am using ingest attachment plugin to ingest my html documents . Plugin automatically takes content type and it is showing "text/html" for one document and "text/plain" for other. Is there any way where we can sp… --- ## [\[USE CASE\] ES as cache manager](https://discuss.elastic.co/t/use-case-es-as-cache-manager/95136)
**Author:** [@Aleks\_Smith](https://discuss.elastic.co/u/Aleks_Smith)\ **Replies:** 4\ **Last updated:** [July 31, 2017, 8:44am UTC](https://discuss.elastic.co/t/use-case-es-as-cache-manager/95136 "2017-07-31T08:44:52Z")
Hello, Is ES good to be used as a cache manager, in order to access data without going to the database everytime you need it. I have loads of tables with relations between them, my persistence layer can manage to inser… --- ## [Adding X-Pack to the existing elasticsearch cluster](https://discuss.elastic.co/t/adding-x-pack-to-the-existing-elasticsearch-cluster/95119)
**Author:** [@mruthyu](https://discuss.elastic.co/u/mruthyu)\ **Replies:** 4\ **Last updated:** [July 31, 2017, 8:14am UTC](https://discuss.elastic.co/t/adding-x-pack-to-the-existing-elasticsearch-cluster/95119 "2017-07-31T08:14:11Z")
We have a multi node elasticsearch cluster with Hot and warm data nodes, master nodes and coordinating nodes. Wanted to know whether X-Pack can been added to the cluster nodes with rolling restart? --- ## [ElasticSearch 5.5.0 query regression?](https://discuss.elastic.co/t/elasticsearch-5-5-0-query-regression/95076)
**Author:** [@drippel](https://discuss.elastic.co/u/drippel)\ **Replies:** 2\ **Last updated:** [July 31, 2017, 8:08am UTC](https://discuss.elastic.co/t/elasticsearch-5-5-0-query-regression/95076 "2017-07-31T08:08:18Z")
I index the following document on ElasticSearch 5.5.0: { "\_index": "fts-english", "\_type": "Document", "\_id": "black1", "\_version": 1, "\_score": 1, "\_source": { "streamId": 1, "WordB": "Cat", "WordC": "Dog",… --- ## [Computing value from query or storing every required field from starting which one is better?](https://discuss.elastic.co/t/computing-value-from-query-or-storing-every-required-field-from-starting-which-one-is-better/95120)
**Author:** [@vaibhav\_goel](https://discuss.elastic.co/u/vaibhav_goel)\ **Replies:** 0\ **Last updated:** [July 31, 2017, 5:54am UTC](https://discuss.elastic.co/t/computing-value-from-query-or-storing-every-required-field-from-starting-which-one-is-better/95120 "2017-07-31T05:54:37Z")
i am using arithmetic operation on two fields using script in my aggregation. Whether I should continue this or compute those value and stored them to my es and directly apply my aggregation on those fields . Which would… --- ## [Is the new join datatype available in 6 alpha yet?](https://discuss.elastic.co/t/is-the-new-join-datatype-available-in-6-alpha-yet/95118)
**Author:** [@davidbkemp](https://discuss.elastic.co/u/davidbkemp)\ **Replies:** 0\ **Last updated:** [July 31, 2017, 5:22am UTC](https://discuss.elastic.co/t/is-the-new-join-datatype-available-in-6-alpha-yet/95118 "2017-07-31T05:22:08Z")
I want to test out what changes we will need to make in version 6 when parent/child relationships are to be replaced with the new “join” data type. I downloaded elasticsearch-6.0.0-alpha2 and tried the example in the do… --- ## [Ngram and score in query](https://discuss.elastic.co/t/ngram-and-score-in-query/93901)
**Author:** [@weibin.wu](https://discuss.elastic.co/u/weibin.wu)\ **Replies:** 2\ **Last updated:** [July 31, 2017, 1:28am UTC](https://discuss.elastic.co/t/ngram-and-score-in-query/93901 "2017-07-31T01:28:03Z")
Hi Elasticsearch. When we do a ngram tokenizer, we will get token with start\_offset. { "token": "vi", "start\_offset": 0, "end\_offset": 2, "type": "word", "position": 0 }, { … --- ## [Pipelines and nested aggs](https://discuss.elastic.co/t/pipelines-and-nested-aggs/95089)
**Author:** [@PaulieMac](https://discuss.elastic.co/u/PaulieMac)\ **Replies:** 0\ **Last updated:** [July 30, 2017, 6:56pm UTC](https://discuss.elastic.co/t/pipelines-and-nested-aggs/95089 "2017-07-30T18:56:46Z")
Hi all, Anyone know if it is possible to do pipeline aggs when the sibling agg is nested? I always get the following error: “reason” : “org.elasticsearch.search.aggregations.bucket.nested.InternalNested cannot be cast … --- ## [Date\_histogram to compare query to global aggregate](https://discuss.elastic.co/t/date-histogram-to-compare-query-to-global-aggregate/95088)
**Author:** [@pushshift](https://discuss.elastic.co/u/pushshift)\ **Replies:** 0\ **Last updated:** [July 30, 2017, 6:43pm UTC](https://discuss.elastic.co/t/date-histogram-to-compare-query-to-global-aggregate/95088 "2017-07-30T18:43:32Z")
I have an Elasticsearch index that contains all public Reddit comments (~3.3 billion comments). What I would like to do is a date\_histogram for a specific query but also get the total number of comments within each buck… --- ## [Copy a value from 'parent' to all nested objects](https://discuss.elastic.co/t/copy-a-value-from-parent-to-all-nested-objects/95087)
**Author:** [@PaulieMac](https://discuss.elastic.co/u/PaulieMac)\ **Replies:** 0\ **Last updated:** [July 30, 2017, 6:43pm UTC](https://discuss.elastic.co/t/copy-a-value-from-parent-to-all-nested-objects/95087 "2017-07-30T18:43:11Z")
Hi all, I have an index with a type mapped with nested objects… In order to tune up a query, I’d like to copy a value from each document to all of its nested ‘children’… Anyone know a way of doing so? Thanks, Paul --- ## [Authentical failed while i did curl -XGET http://localhost:9200](https://discuss.elastic.co/t/authentical-failed-while-i-did-curl-xget-http-localhost-9200/95019)
**Author:** [@shroh](https://discuss.elastic.co/u/shroh)\ **Replies:** 7\ **Last updated:** [July 30, 2017, 2:52pm UTC](https://discuss.elastic.co/t/authentical-failed-while-i-did-curl-xget-http-localhost-9200/95019 "2017-07-30T14:52:09Z")
I have newly setup the ELK stack on a single EC2 instance. I am getting the following error when i am doing a CURL to check the ES status. Although the output is pretty long. But this should give an idea on whats happeni… --- ## [Version 5.5 building index error](https://discuss.elastic.co/t/version-5-5-building-index-error/95078)
**Author:** [@hubiao](https://discuss.elastic.co/u/hubiao)\ **Replies:** 0\ **Last updated:** [July 30, 2017, 2:05pm UTC](https://discuss.elastic.co/t/version-5-5-building-index-error/95078 "2017-07-30T14:05:09Z")
Elasticsearch version: 5.5.0 JVM version: 1.8.0\_72 Operating system version: Windows 10 This is part of my configuration. Notice that I use the dynamic template and the NGram word segmentation device “settings”: { “… --- ## [Compare two nested fields inside one document](https://discuss.elastic.co/t/compare-two-nested-fields-inside-one-document/94903)
**Author:** [@tokraft](https://discuss.elastic.co/u/tokraft)\ **Replies:** 1\ **Last updated:** [July 30, 2017, 11:40am UTC](https://discuss.elastic.co/t/compare-two-nested-fields-inside-one-document/94903 "2017-07-30T11:40:45Z")
I have an index with two nested documents. Is there any possibility two compare two fields of the same document that are in different nested objects? This is my sample mapping: "mappings": { "person": { "p… --- ## [Connection Spark and ElasticSearch](https://discuss.elastic.co/t/connection-spark-and-elasticsearch/94251)
**Author:** [@SG87](https://discuss.elastic.co/u/SG87)\ **Replies:** 2\ **Last updated:** [July 30, 2017, 8:10am UTC](https://discuss.elastic.co/t/connection-spark-and-elasticsearch/94251 "2017-07-30T08:10:17Z")
Hi, I am using Python SQL Spark 2.1.0 and ElasticSearch 5.5.0 and I am trying to use the following command: df.write.format("es").save("db/test") My configuration options are as follows: $SPARK\_HOME/bin/pyspark --pac… --- ## [IndexExists() with wildcard index name always returns true after upgrading to NEST 5.4.0](https://discuss.elastic.co/t/indexexists-with-wildcard-index-name-always-returns-true-after-upgrading-to-nest-5-4-0/94183)
**Author:** [@jqin](https://discuss.elastic.co/u/jqin)\ **Replies:** 2\ **Last updated:** [July 30, 2017, 5:55am UTC](https://discuss.elastic.co/t/indexexists-with-wildcard-index-name-always-returns-true-after-upgrading-to-nest-5-4-0/94183 "2017-07-30T05:55:30Z")
Hi, I had the following code that used to work in NEST 2.4.1 and Elasticsearch 2.3.1 : var indices = Indices.Index("prefix\*"); while (myClient.IndexExists(indices).Exists) { //code to delete them } I recently up… --- ## [When does a task's stored result removed?](https://discuss.elastic.co/t/when-does-a-tasks-stored-result-removed/94322)
**Author:** [@adavidai](https://discuss.elastic.co/u/adavidai)\ **Replies:** 1\ **Last updated:** [July 30, 2017, 4:46am UTC](https://discuss.elastic.co/t/when-does-a-tasks-stored-result-removed/94322 "2017-07-30T04:46:48Z")
Hi :slight\_smile: I am using the tasks management api to asynchronously get the result of a reindex action. I was wondering, when will the task result be deleted? When is the task status deleted (and I'll get 404 when … --- ## [Date field in elastic hive table is created as text in ES](https://discuss.elastic.co/t/date-field-in-elastic-hive-table-is-created-as-text-in-es/95048)
**Author:** [@aliyesami](https://discuss.elastic.co/u/aliyesami)\ **Replies:** 1\ **Last updated:** [July 29, 2017, 8:48pm UTC](https://discuss.elastic.co/t/date-field-in-elastic-hive-table-is-created-as-text-in-es/95048 "2017-07-29T20:48:26Z")
any data that I insert in the hadoop Elasticsearch table in HIVE is being mapped as text . I think that's why the date operations are not working on my Index. 0: jdbc:hive2://hadoop2:10000/default\> desc pa\_lane\_txn\_es… --- ## [Sorting a terms aggregation by sub-terms-aggregation cardinality aggregation](https://discuss.elastic.co/t/sorting-a-terms-aggregation-by-sub-terms-aggregation-cardinality-aggregation/95049)
**Author:** [@liamwhite](https://discuss.elastic.co/u/liamwhite)\ **Replies:** 0\ **Last updated:** [July 29, 2017, 7:33pm UTC](https://discuss.elastic.co/t/sorting-a-terms-aggregation-by-sub-terms-aggregation-cardinality-aggregation/95049 "2017-07-29T19:33:27Z")
I’d like to be able to order a terms aggregation by the value of a child terms aggregation. Can this be done? Here’s what I have so far: :vote\_stats: :size: 0 :aggs: :ip\_votes: :terms: { field: 'ip', orde… --- ## [Search words in order with stems and analyzed](https://discuss.elastic.co/t/search-words-in-order-with-stems-and-analyzed/94721)
**Author:** [@NetDefender](https://discuss.elastic.co/u/NetDefender)\ **Replies:** 1\ **Last updated:** [July 29, 2017, 5:59pm UTC](https://discuss.elastic.co/t/search-words-in-order-with-stems-and-analyzed/94721 "2017-07-29T17:59:34Z")
Is there a way to search two words in some order. For example i have the words "Foo" and "Bar". In the following phrases : Foo is the way to bar==\> OK Bar is not the way to Foo==\> No Foos are the way to bars==\> OK (Stemm… --- ## [Help with error - broken test input](https://discuss.elastic.co/t/help-with-error-broken-test-input/95025)
**Author:** [@hukh](https://discuss.elastic.co/u/hukh)\ **Replies:** 4\ **Last updated:** [July 29, 2017, 4:13pm UTC](https://discuss.elastic.co/t/help-with-error-broken-test-input/95025 "2017-07-29T16:13:51Z")
Hello I am working on a project that extract the existed fault in other project, in this case i am working with Elasticsearch. Basically, we got the reversions that flagged as bug and compile the source and the tests th… --- ## [What's the advantage of setting up index manually vs handled by client](https://discuss.elastic.co/t/whats-the-advantage-of-setting-up-index-manually-vs-handled-by-client/95006)
**Author:** [@Jessec](https://discuss.elastic.co/u/Jessec)\ **Replies:** 5\ **Last updated:** [July 29, 2017, 4:10pm UTC](https://discuss.elastic.co/t/whats-the-advantage-of-setting-up-index-manually-vs-handled-by-client/95006 "2017-07-29T16:10:02Z")
If I use transport client for elasticsearch, when indexing a document to a non-existing index, it will automatically generate the new index and figure out the mapping from the first document. Please correct me if I got i… --- ## [Elasticsearch-rails and related gems: feels like abandoned](https://discuss.elastic.co/t/elasticsearch-rails-and-related-gems-feels-like-abandoned/92980)
**Author:** [@jogaco](https://discuss.elastic.co/u/jogaco)\ **Replies:** 1\ **Last updated:** [July 29, 2017, 4:08pm UTC](https://discuss.elastic.co/t/elasticsearch-rails-and-related-gems-feels-like-abandoned/92980 "2017-07-29T16:08:29Z")
Hello, I have been using ES for over two years now. I have it as data store for a Rails app. I love ES and I like the Ruby gems that connect your Ruby or Rails apps to ES. However, I cannot avoid a sensation of frust… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1994) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1996)