# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1600 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1601 --- ## [Amazon\_es (elasticsearch plugin) assuming role?](https://discuss.elastic.co/t/amazon-es-elasticsearch-plugin-assuming-role/142014)
**Author:** [@David\_Chait](https://discuss.elastic.co/u/David_Chait)\ **Replies:** 1\ **Last updated:** [July 28, 2018, 5:51am UTC](https://discuss.elastic.co/t/amazon-es-elasticsearch-plugin-assuming-role/142014 "2018-07-28T05:51:50Z")
Hello, I am attempting to allow a logstash server in one AWS account access to Amazon hosted Elasticsearch in another. I have roles set up in each account, and trusts enabled, however I do not see how I can force logstas… --- ## [Elasticsearch JAVA API Aggregations casting error](https://discuss.elastic.co/t/elasticsearch-java-api-aggregations-casting-error/142009)
**Author:** [@James\_Drinkard](https://discuss.elastic.co/u/James_Drinkard)\ **Replies:** 0\ **Last updated:** [July 28, 2018, 3:26am UTC](https://discuss.elastic.co/t/elasticsearch-java-api-aggregations-casting-error/142009 "2018-07-28T03:26:50Z")
I had a task to create a nested AggregationBuilder with two levels with Elasticsearch 5.6. The query was similar to: GET \_data/\_search { "aggs":{ "nestedAttributes":{ "nested": { "path": "ATTRIBUTES": { }, "aggs… --- ## [Threadpool search rejections](https://discuss.elastic.co/t/threadpool-search-rejections/141336)
**Author:** [@mfabry](https://discuss.elastic.co/u/mfabry)\ **Replies:** 1\ **Last updated:** [July 28, 2018, 3:17am UTC](https://discuss.elastic.co/t/threadpool-search-rejections/141336 "2018-07-28T03:17:58Z")
Hi everyone, I have been unable to figure out (or find in documentation) what exactly happens when elasticsearch data node starts rejecting search requests, so I am hoping you guys could help me to understand. My main … --- ## [Monitor Nodes filter doesn't seem to work](https://discuss.elastic.co/t/monitor-nodes-filter-doesnt-seem-to-work/141654)
**Author:** [@rugenl](https://discuss.elastic.co/u/rugenl)\ **Replies:** 3\ **Last updated:** [July 28, 2018, 2:49am UTC](https://discuss.elastic.co/t/monitor-nodes-filter-doesnt-seem-to-work/141654 "2018-07-28T02:49:56Z")
My nodes are named like mes-0x for data, mes-kx for kibana client nodes and mes-mx for master nodes. I thought I could type es-m in filter and only see my master nodes. If I type m, i see only the current master node, … --- ## [Username, password server and port](https://discuss.elastic.co/t/username-password-server-and-port/141998)
**Author:** [@mkaczor](https://discuss.elastic.co/u/mkaczor)\ **Replies:** 1\ **Last updated:** [July 28, 2018, 2:26am UTC](https://discuss.elastic.co/t/username-password-server-and-port/141998 "2018-07-28T02:26:24Z")
Hi, I need the username, password, server and port with the values from your Elasticsearch deployment and I would like to know if I can change the username and password or add a new one. If yes how do that? Thanks --- ## [Restore from S3 times out since updating from ES 2.4 to 6.3](https://discuss.elastic.co/t/restore-from-s3-times-out-since-updating-from-es-2-4-to-6-3/142005)
**Author:** [@jazoom](https://discuss.elastic.co/u/jazoom)\ **Replies:** 2\ **Last updated:** [July 28, 2018, 12:43am UTC](https://discuss.elastic.co/t/restore-from-s3-times-out-since-updating-from-es-2-4-to-6-3/142005 "2018-07-28T00:43:25Z")
Restores have always worked fine with Elasticsearch 2.4, but I recently updated to 6.3 and I haven't been able to get a restore to work even once for my largest index (14GB with 7 million documents). Connection is 50Mbit… --- ## [Log every request](https://discuss.elastic.co/t/log-every-request/141997)
**Author:** [@simplesmente](https://discuss.elastic.co/u/simplesmente)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 11:34pm UTC](https://discuss.elastic.co/t/log-every-request/141997 "2018-07-27T23:34:28Z")
Hi, everyone. I need to log every request made to Elasticsearch and its response for making reports purposes. I'm thinking of creating a new index to hold all this information. The thing is that I need to analyse queri… --- ## [Delete an index with alias pointed to multiple indices](https://discuss.elastic.co/t/delete-an-index-with-alias-pointed-to-multiple-indices/142001)
**Author:** [@Akshay\_Deshpande](https://discuss.elastic.co/u/Akshay_Deshpande)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 11:31pm UTC](https://discuss.elastic.co/t/delete-an-index-with-alias-pointed-to-multiple-indices/142001 "2018-07-27T23:31:26Z")
I have 10 indices and each has the alias akshay-search. If I want to delete one index 'akshay-index1' out of these 10, do I need to remove the alias 'akshay-search' from akshay-index1 before I delete it? OR just delet… --- ## [Range filter on bucket aggregation](https://discuss.elastic.co/t/range-filter-on-bucket-aggregation/141995)
**Author:** [@benes12](https://discuss.elastic.co/u/benes12)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 8:13pm UTC](https://discuss.elastic.co/t/range-filter-on-bucket-aggregation/141995 "2018-07-27T20:13:31Z")
I could have sworn there was a way to do this, but basically I'm trying to apply a from and to range on a sum from another agg. { "size": 0, "query": { "bool": { "must": \[ { "range": { … --- ## [UnavailableShardsException occurs spontaneously when indexing](https://discuss.elastic.co/t/unavailableshardsexception-occurs-spontaneously-when-indexing/141793)
**Author:** [@wassx](https://discuss.elastic.co/u/wassx)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 8:05pm UTC](https://discuss.elastic.co/t/unavailableshardsexception-occurs-spontaneously-when-indexing/141793 "2018-07-27T20:05:37Z")
Hi, I have an ES 6.3.1 running in a docker container with a volume where data is stored. I post images as base64 in the doc which worked very well over the last year. It could be by hazard that, after an backup and res… --- ## [Disabling all the relocation that is happening in the cluster](https://discuss.elastic.co/t/disabling-all-the-relocation-that-is-happening-in-the-cluster/141989)
**Author:** [@fhalde](https://discuss.elastic.co/u/fhalde)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 7:46pm UTC](https://discuss.elastic.co/t/disabling-all-the-relocation-that-is-happening-in-the-cluster/141989 "2018-07-27T19:46:25Z")
We have a 2.4 cluster. We excluded few nodes for certain indices using the exclude setting in our cluster which triggered a relo of 220 shards. we had concurrent\_rebalance set to 2 but it didnt take any effect. Is there… --- ## [How to pass the raw aggregation query in JSON using REST HighLevelClient in E.S 5.6.9?](https://discuss.elastic.co/t/how-to-pass-the-raw-aggregation-query-in-json-using-rest-highlevelclient-in-e-s-5-6-9/141675)
**Author:** [@kant\_kodali](https://discuss.elastic.co/u/kant_kodali)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 6:50pm UTC](https://discuss.elastic.co/t/how-to-pass-the-raw-aggregation-query-in-json-using-rest-highlevelclient-in-e-s-5-6-9/141675 "2018-07-27T18:50:51Z")
How do I pass raw json aggregation query to REST HighLevelClient in E.S 5.6.9? For Example, Given the json below how do I pass the json below as is to the REST HighLevelClient? { "aggs" : { "genres" : { … --- ## [Problem with timezone conversion - full timestamp vs time only field](https://discuss.elastic.co/t/problem-with-timezone-conversion-full-timestamp-vs-time-only-field/141979)
**Author:** [@cvraocv](https://discuss.elastic.co/u/cvraocv)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 6:09pm UTC](https://discuss.elastic.co/t/problem-with-timezone-conversion-full-timestamp-vs-time-only-field/141979 "2018-07-27T18:09:19Z")
All, I am facing a problem with inconsitent timezone conversion in visualization - between a full timestamp field and a time only field. Looked around and didn't find a solution. Please help! I have loaded 2 different … --- ## [Find and delete duplicate documents](https://discuss.elastic.co/t/find-and-delete-duplicate-documents/26575)
**Author:** [@noamt](https://discuss.elastic.co/u/noamt)\ **Replies:** 7\ **Last updated:** [July 27, 2018, 5:52pm UTC](https://discuss.elastic.co/t/find-and-delete-duplicate-documents/26575 "2018-07-27T17:52:34Z")
Sorry if this has already been asked; I've mostly seen questions of how to deal with duplicate documents in the result set, but not how to actually locate and remove them from the index. We have a type within an index … --- ## [Field limit exceeded, Docs count too high](https://discuss.elastic.co/t/field-limit-exceeded-docs-count-too-high/140785)
**Author:** [@Jacob\_Steele](https://discuss.elastic.co/u/Jacob_Steele)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 5:30pm UTC](https://discuss.elastic.co/t/field-limit-exceeded-docs-count-too-high/140785 "2018-07-27T17:30:30Z")
Hello Elastic-co, We are currently using a full ride of your system, LogStash to Kibana to Elastic Search. However I have some questions, 1. Field Limit Exceeded: I am randomly getting in my logs an error about the: \[… --- ## [Query full senetnce with synonyms](https://discuss.elastic.co/t/query-full-senetnce-with-synonyms/140729)
**Author:** [@ruti](https://discuss.elastic.co/u/ruti)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 5:05pm UTC](https://discuss.elastic.co/t/query-full-senetnce-with-synonyms/140729 "2018-07-27T17:05:21Z")
Hi everybody. I'm new here, learning the elasticsearch. I want to be able to find a full sentence like "live usa" while "usa" is an synonyms of (usa,united states,u s a,united states of america" if I search for only "… --- ## [Hive external table performance issue](https://discuss.elastic.co/t/hive-external-table-performance-issue/141965)
**Author:** [@Serge\_Lashdev](https://discuss.elastic.co/u/Serge_Lashdev)\ **Replies:** 2\ **Last updated:** [July 27, 2018, 4:48pm UTC](https://discuss.elastic.co/t/hive-external-table-performance-issue/141965 "2018-07-27T16:48:36Z")
Hi there, I created an external table in hive to query indices in ES whith the following statement. CREATE EXTERNAL TABLE svaadclog ( bytexfr BIGINT, httpquery STRING, httpreferer STRING, httpresultcode INT, ipsrc… --- ## [Change port for cloud.elastic.co instance](https://discuss.elastic.co/t/change-port-for-cloud-elastic-co-instance/141951)
**Author:** [@agonzalez](https://discuss.elastic.co/u/agonzalez)\ **Replies:** 4\ **Last updated:** [July 27, 2018, 4:21pm UTC](https://discuss.elastic.co/t/change-port-for-cloud-elastic-co-instance/141951 "2018-07-27T16:21:36Z")
I am running cloud instance in cloud.elastic.co but elasticsearch port is on 9243, i need to change this port to be 443. how is it possible to do such a change? --- ## [How to enable Machine Learning in cloud version 6.3.2?](https://discuss.elastic.co/t/how-to-enable-machine-learning-in-cloud-version-6-3-2/141699)
**Author:** [@jcastellano](https://discuss.elastic.co/u/jcastellano)\ **Replies:** 2\ **Last updated:** [July 27, 2018, 3:54pm UTC](https://discuss.elastic.co/t/how-to-enable-machine-learning-in-cloud-version-6-3-2/141699 "2018-07-27T15:54:46Z")
Iam using Elastic Cloud, and in Kibana "Machine Learning" section, iam unable to create jobs. A warning says: "No ML Nodes available. There are no ML nodes available." I try to edit elasticsearch.yml file with settings… --- ## [MultiMatch Over Different Field Types Fails](https://discuss.elastic.co/t/multimatch-over-different-field-types-fails/141875)
**Author:** [@eskrew](https://discuss.elastic.co/u/eskrew)\ **Replies:** 5\ **Last updated:** [July 27, 2018, 3:48pm UTC](https://discuss.elastic.co/t/multimatch-over-different-field-types-fails/141875 "2018-07-27T15:48:31Z")
If you have both number and string fields and you try and multimatch it , it will fail on the low level call. I am not sure if it fails on converting the string to the int for comparision or what. I assumed it would igno… --- ## [Is it possible to validate every request to the cluster?](https://discuss.elastic.co/t/is-it-possible-to-validate-every-request-to-the-cluster/141963)
**Author:** [@Marco\_Costantini](https://discuss.elastic.co/u/Marco_Costantini)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 3:22pm UTC](https://discuss.elastic.co/t/is-it-possible-to-validate-every-request-to-the-cluster/141963 "2018-07-27T15:22:32Z")
How can I go about validating every request that comes to my cluster? My goal is to analyse a request, and allow it (showing normal output) or deny it (showing some reason for denial). If this is done via a plugin, any … --- ## [Elasticsearch server does not work and stop](https://discuss.elastic.co/t/elasticsearch-server-does-not-work-and-stop/141850)
**Author:** [@Diego\_Moreno](https://discuss.elastic.co/u/Diego_Moreno)\ **Replies:** 3\ **Last updated:** [July 27, 2018, 3:15pm UTC](https://discuss.elastic.co/t/elasticsearch-server-does-not-work-and-stop/141850 "2018-07-27T15:15:56Z")
\[2018-07-26T15:41:44,661\]\[INFO \]\[o.e.x.m.j.p.l.CppLogMessageHandler\] \[controller/3472\] \[Main.cc@109\] controller (64 bit): Version 6.3.2 (Build 903094f295d249) Copyright (c) 2018 Elasticsearch BV \[2018-07-26T15:41:45,326… --- ## [Drill down in graph xpack](https://discuss.elastic.co/t/drill-down-in-graph-xpack/141519)
**Author:** [@Gokul\_15](https://discuss.elastic.co/u/Gokul_15)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 3:10pm UTC](https://discuss.elastic.co/t/drill-down-in-graph-xpack/141519 "2018-07-27T15:10:35Z")
Hi all,I have done drilldown from graph to visualization chart,,and i have a doubt, is drill down from same ended visualization to other chart is possible?? i am using platinum trail license --- ## [Generating Node Certificates for X-Pack](https://discuss.elastic.co/t/generating-node-certificates-for-x-pack/141493)
**Author:** [@Ong](https://discuss.elastic.co/u/Ong)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 3:08pm UTC](https://discuss.elastic.co/t/generating-node-certificates-for-x-pack/141493 "2018-07-27T15:08:34Z")
I am installing X-Pack on a 3 node cluster and am now at the step to generate the node certificates based on the X-Pack installation documentation. Is it necessary to create a certificate authority (CA) on every node of… --- ## [Spark sql query for empty string](https://discuss.elastic.co/t/spark-sql-query-for-empty-string/141588)
**Author:** [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\ **Replies:** 3\ **Last updated:** [July 27, 2018, 3:02pm UTC](https://discuss.elastic.co/t/spark-sql-query-for-empty-string/141588 "2018-07-27T15:02:18Z")
I am using spark sql to query for an empty string . Documents are returned exactly when I use elasticsearch dsl as following: user/\_search { "query": { "term": { "type": "" } } } But in spark sql, I written a s… --- ## [\[6.3\]Map data not showing on optimized for printing .pdf](https://discuss.elastic.co/t/6-3-map-data-not-showing-on-optimized-for-printing-pdf/141279)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 2:57pm UTC](https://discuss.elastic.co/t/6-3-map-data-not-showing-on-optimized-for-printing-pdf/141279 "2018-07-27T14:57:08Z")
Hi, I just started the xpack trial to check out some functionality. I loaded up the logs test data provided by elastic. When generating a .pdf using the optimized for .pdf option the geo data on the map is not showing … --- ## [Error in executing Groovy script in Watcher (Elasticsearch 6.3.1)](https://discuss.elastic.co/t/error-in-executing-groovy-script-in-watcher-elasticsearch-6-3-1/140924)
**Author:** [@ayush219](https://discuss.elastic.co/u/ayush219)\ **Replies:** 10\ **Last updated:** [July 27, 2018, 2:02pm UTC](https://discuss.elastic.co/t/error-in-executing-groovy-script-in-watcher-elasticsearch-6-3-1/140924 "2018-07-27T14:02:24Z")
Hi, I am getting below error when trying to execute Groovy script from Watcher. (Working on ElasticSearch 6.3.1 version): { "error": { "root\_cause": \[ { "type": "illegal\_argument\_exception", "reason": "unable to … --- ## [Deploy Elastic Search on Azure blob storage](https://discuss.elastic.co/t/deploy-elastic-search-on-azure-blob-storage/141943)
**Author:** [@luminaelastic](https://discuss.elastic.co/u/luminaelastic)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 1:48pm UTC](https://discuss.elastic.co/t/deploy-elastic-search-on-azure-blob-storage/141943 "2018-07-27T13:48:04Z")
Hi, We have millions of file on Azure blob storage. I want to index blob and apply query on that. So how i can deploy elastic search on Azure blob. Please suggest me, how i can deploy elastic search on Azure cloud. Th… --- ## [Store and query by user metadata (last viewed, etc.)](https://discuss.elastic.co/t/store-and-query-by-user-metadata-last-viewed-etc/141569)
**Author:** [@cdekker](https://discuss.elastic.co/u/cdekker)\ **Replies:** 4\ **Last updated:** [July 27, 2018, 1:47pm UTC](https://discuss.elastic.co/t/store-and-query-by-user-metadata-last-viewed-etc/141569 "2018-07-27T13:47:04Z")
I have per-customer static indices of up to 20M documents and 200GB in size which forms the basis for our search engine. Queries are always executed against a single index. Cross-index search is not used. Now I would li… --- ## [Omit database collection when importing from MongoDB to ElasticSearch](https://discuss.elastic.co/t/omit-database-collection-when-importing-from-mongodb-to-elasticsearch/141649)
**Author:** [@committer](https://discuss.elastic.co/u/committer)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 1:23pm UTC](https://discuss.elastic.co/t/omit-database-collection-when-importing-from-mongodb-to-elasticsearch/141649 "2018-07-27T13:23:21Z")
I'm trying to omit a collection from being included when importing from a MongoDB database to ElasticSearch. https://github.com/appbaseio/abc is being used with a transform file, which has the following code: t.Source(… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1599) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1601)