# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1445 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1446 --- ## [Aggregations on fields indexed as text (Almost) painless](https://discuss.elastic.co/t/aggregations-on-fields-indexed-as-text-almost-painless/161851)
**Author:** [@daver208](https://discuss.elastic.co/u/daver208)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 1:34pm UTC](https://discuss.elastic.co/t/aggregations-on-fields-indexed-as-text-almost-painless/161851 "2018-12-21T13:34:50Z")
So I'm sure this has happened to some folks, you've made a decision to index a field as text, but don't set field data to true. At some point later, you realize this field isn't very high cardinality, and you want to do… --- ## [Document count is lesser than the number of document indexed](https://discuss.elastic.co/t/document-count-is-lesser-than-the-number-of-document-indexed/161686)
**Author:** [@msmani](https://discuss.elastic.co/u/msmani)\ **Replies:** 4\ **Last updated:** [December 21, 2018, 1:14pm UTC](https://discuss.elastic.co/t/document-count-is-lesser-than-the-number-of-document-indexed/161686 "2018-12-21T13:14:12Z")
I am indexing via bulk api (provided by org.elasticsearch.client.RestHighLevelClient ), the number of document I index is 381942 but when I use the \_count api of elasticsearch it shows lesser count, that number varies… --- ## [REST High Level Client: CreateIndexRequest Timeout](https://discuss.elastic.co/t/rest-high-level-client-createindexrequest-timeout/161828)
**Author:** [@higgs01](https://discuss.elastic.co/u/higgs01)\ **Replies:** 2\ **Last updated:** [December 21, 2018, 12:43pm UTC](https://discuss.elastic.co/t/rest-high-level-client-createindexrequest-timeout/161828 "2018-12-21T12:43:51Z")
Hello I'm trying to create an index: client.indices().create(new CreateIndexRequest(indexName) .settings(Settings.builder().put("index.number\_of\_replicas", 0)) .mapping(shipmentI… --- ## [POC with ELK](https://discuss.elastic.co/t/poc-with-elk/161640)
**Author:** [@hariprasanthdurairaj](https://discuss.elastic.co/u/hariprasanthdurairaj)\ **Replies:** 2\ **Last updated:** [December 21, 2018, 12:14pm UTC](https://discuss.elastic.co/t/poc-with-elk/161640 "2018-12-21T12:14:05Z")
Hi , I'm a Performance Tester and new to ELK tool. I'm doing POC for my project to install Logstash , ELastic search and Kibana in my local machine . I couldnt find any details about the Minimum hardware requirements … --- ## [How does elasticsearch move a primary shard?](https://discuss.elastic.co/t/how-does-elasticsearch-move-a-primary-shard/161815)
**Author:** [@Attila\_Nagy](https://discuss.elastic.co/u/Attila_Nagy)\ **Replies:** 9\ **Last updated:** [December 21, 2018, 12:12pm UTC](https://discuss.elastic.co/t/how-does-elasticsearch-move-a-primary-shard/161815 "2018-12-21T12:12:03Z")
Hi, I wonder, what is the exact process of moving a primary shard to another node? I'm not interested in how to do this with the HTTP API but what happens when the user or elasticsearch decides to do this. How does the… --- ## [Elastic Rest Client - Connection pooling](https://discuss.elastic.co/t/elastic-rest-client-connection-pooling/160846)
**Author:** [@sivakumarp11](https://discuss.elastic.co/u/sivakumarp11)\ **Replies:** 1\ **Last updated:** [December 21, 2018, 12:07pm UTC](https://discuss.elastic.co/t/elastic-rest-client-connection-pooling/160846 "2018-12-21T12:07:16Z")
It is not clear as to whether connection pool is available for Elastic REST client - synchronous call or not ? If yes, please provide sample configuration class. If not, 2.1 please explain why it is not provided for s… --- ## [Template for .monitoring\* indices](https://discuss.elastic.co/t/template-for-monitoring-indices/161636)
**Author:** [@Hari\_Prasad](https://discuss.elastic.co/u/Hari_Prasad)\ **Replies:** 8\ **Last updated:** [December 21, 2018, 11:49am UTC](https://discuss.elastic.co/t/template-for-monitoring-indices/161636 "2018-12-21T11:49:40Z")
Hi, In my setup I am using template from Logstash to set the configuration for various indices that are being created in Elasticsearch. But I am not able to do the same for the monitoring indices, that is .monitoring-es… --- ## [Dynamic Templates - Query](https://discuss.elastic.co/t/dynamic-templates-query/161812)
**Author:** [@Dhruti\_Prajapati](https://discuss.elastic.co/u/Dhruti_Prajapati)\ **Replies:** 5\ **Last updated:** [December 21, 2018, 11:35am UTC](https://discuss.elastic.co/t/dynamic-templates-query/161812 "2018-12-21T11:35:46Z")
Hello, Can I have example of query which uses dynamic template in mapping. --- ## [Improving Reindex Performance in v5.6](https://discuss.elastic.co/t/improving-reindex-performance-in-v5-6/161659)
**Author:** [@ndtreviv](https://discuss.elastic.co/u/ndtreviv)\ **Replies:** 7\ **Last updated:** [December 21, 2018, 10:53am UTC](https://discuss.elastic.co/t/improving-reindex-performance-in-v5-6/161659 "2018-12-21T10:53:55Z")
I'm currently reindexing 3.2bn documents from a 5 shard index into a 20 shard index on a 2-node cluster where the machines are AWS EC2 i3.4xlarge instances. The elasticsearch installs are configured to use both ephemera… --- ## [Is there size limit in sql with group by?](https://discuss.elastic.co/t/is-there-size-limit-in-sql-with-group-by/161832)
**Author:** [@Joonho\_Eom](https://discuss.elastic.co/u/Joonho_Eom)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 10:19am UTC](https://discuss.elastic.co/t/is-there-size-limit-in-sql-with-group-by/161832 "2018-12-21T10:19:11Z")
When I translate my sql, I've been seeing size with 1000 limit. "aggregations" : { "groupby" : { "composite" : { "size" : 1000, "sources" : \[ { And it shows limited result. After I search with translated DSL, whi… --- ## [Query match with range is not working](https://discuss.elastic.co/t/query-match-with-range-is-not-working/161450)
**Author:** [@nayun\_oh](https://discuss.elastic.co/u/nayun_oh)\ **Replies:** 5\ **Last updated:** [December 21, 2018, 10:00am UTC](https://discuss.elastic.co/t/query-match-with-range-is-not-working/161450 "2018-12-21T10:00:08Z")
I find out that match with range query is not working. When I search data using range query, I can see "ACTION" text in payload field. But when I search data using both range and match, I can see empty result. Than… --- ## [How to find out list of indices in elastic which are not having aliases](https://discuss.elastic.co/t/how-to-find-out-list-of-indices-in-elastic-which-are-not-having-aliases/161797)
**Author:** [@prabhakar\_talari](https://discuss.elastic.co/u/prabhakar_talari)\ **Replies:** 2\ **Last updated:** [December 21, 2018, 9:44am UTC](https://discuss.elastic.co/t/how-to-find-out-list-of-indices-in-elastic-which-are-not-having-aliases/161797 "2018-12-21T09:44:51Z")
Hi All, Could any one help me how to find out list of indices which are not having aliases Thanks in advance ! --- ## [Issue with API communication](https://discuss.elastic.co/t/issue-with-api-communication/161560)
**Author:** [@Dawid\_WWW](https://discuss.elastic.co/u/Dawid_WWW)\ **Replies:** 2\ **Last updated:** [December 21, 2018, 9:44am UTC](https://discuss.elastic.co/t/issue-with-api-communication/161560 "2018-12-21T09:44:22Z")
Hello, in our company we use cloud.elastic.co and I would like to configure automation new cluster deployment from existing snapshot of secondary cluster. I have a problem with API communication. I wanted to send reque… --- ## [ES loses the data being collected when deleting the index](https://discuss.elastic.co/t/es-loses-the-data-being-collected-when-deleting-the-index/160377)
**Author:** [@horaceli](https://discuss.elastic.co/u/horaceli)\ **Replies:** 13\ **Last updated:** [December 21, 2018, 9:10am UTC](https://discuss.elastic.co/t/es-loses-the-data-being-collected-when-deleting-the-index/160377 "2018-12-21T09:10:19Z")
es lose data when the cluster is deleting index.As shown below how to fix the problem? I mean, when I delete the index, the amount of data being collected is also reduced.The picture shows the amount of data collected … --- ## [Terms Aggregation - Maximum acceptable cardinality](https://discuss.elastic.co/t/terms-aggregation-maximum-acceptable-cardinality/161817)
**Author:** [@ananth](https://discuss.elastic.co/u/ananth)\ **Replies:** 1\ **Last updated:** [December 21, 2018, 9:04am UTC](https://discuss.elastic.co/t/terms-aggregation-maximum-acceptable-cardinality/161817 "2018-12-21T09:04:31Z")
I have an id field (keyword field) with one billion unique values. What will be performance impact of terms aggregation on this field with a size parameter of 10000. --- ## [Elasticsearch credentials for Kibana from keystore for ES 5.6](https://discuss.elastic.co/t/elasticsearch-credentials-for-kibana-from-keystore-for-es-5-6/161639)
**Author:** [@jrdtrstn](https://discuss.elastic.co/u/jrdtrstn)\ **Replies:** 3\ **Last updated:** [December 21, 2018, 8:39am UTC](https://discuss.elastic.co/t/elasticsearch-credentials-for-kibana-from-keystore-for-es-5-6/161639 "2018-12-21T08:39:47Z")
I don't want to put the property elasticsearch.password in my kibana.yml. When I try to add this setting into the keystore, ES won't start up with the following error: Suppressed: java.lang.IllegalArgumentException: un… --- ## [Thread blocked due to error org.elasticsearch.common.util.concurrent.BaseFuture$Sync](https://discuss.elastic.co/t/thread-blocked-due-to-error-org-elasticsearch-common-util-concurrent-basefuture-sync/161808)
**Author:** [@santoshcbmi](https://discuss.elastic.co/u/santoshcbmi)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 8:23am UTC](https://discuss.elastic.co/t/thread-blocked-due-to-error-org-elasticsearch-common-util-concurrent-basefuture-sync/161808 "2018-12-21T08:23:08Z")
Hi All, I am getting Thread blocked state when executing the getChildrenCount() using the \_parent key. We have a Parent - Child mapping with \_parent as parentKey in child. While retrieving the children count using t… --- ## [Delete Snaphost can't reduce disk usage](https://discuss.elastic.co/t/delete-snaphost-cant-reduce-disk-usage/161667)
**Author:** [@yan\_gong](https://discuss.elastic.co/u/yan_gong)\ **Replies:** 4\ **Last updated:** [December 21, 2018, 6:27am UTC](https://discuss.elastic.co/t/delete-snaphost-cant-reduce-disk-usage/161667 "2018-12-21T06:27:40Z")
Hi, I am using the version of Es is 5.6.8. Recently ,I have met a question that I want to use api to delete snapshot to reduce disk usage , but when I deleted some of snapshots ,there was no change of my disk ,… --- ## [Nested data not shown correctly with painless script](https://discuss.elastic.co/t/nested-data-not-shown-correctly-with-painless-script/157012)
**Author:** [@junkoshimane](https://discuss.elastic.co/u/junkoshimane)\ **Replies:** 5\ **Last updated:** [December 21, 2018, 6:22am UTC](https://discuss.elastic.co/t/nested-data-not-shown-correctly-with-painless-script/157012 "2018-12-21T06:22:14Z")
Hi all, I may find issue with the combination of "nested data" and "painless script". In case "painless script" is NOT used, documents are shown correctly. In case "painless script" is used, they are shown wrongly. Of… --- ## [Mapping with doc\_values set true but searching with wildcard not performed](https://discuss.elastic.co/t/mapping-with-doc-values-set-true-but-searching-with-wildcard-not-performed/161787)
**Author:** [@saktara](https://discuss.elastic.co/u/saktara)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 5:29am UTC](https://discuss.elastic.co/t/mapping-with-doc-values-set-true-but-searching-with-wildcard-not-performed/161787 "2018-12-21T05:29:27Z")
I'm creating mapping of elasticsearch index by enabled doc\_values set to true and field type as keyword but searching message contained with relevant keyword as wildcard see only there is no words to search EX: message… --- ## [Jumpcloud.com saml integration](https://discuss.elastic.co/t/jumpcloud-com-saml-integration/161750)
**Author:** [@Vladimir\_Khazin](https://discuss.elastic.co/u/Vladimir_Khazin)\ **Replies:** 1\ **Last updated:** [December 21, 2018, 4:26am UTC](https://discuss.elastic.co/t/jumpcloud-com-saml-integration/161750 "2018-12-21T04:26:20Z")
Hello there, I am trying to integrate hosted cloud.elastic.co deployment on GCP with jumpcloud.com SAML I have configured jumpcloud.com custom/generic custom provider and am able to login to the sso end-point after the… --- ## [How to use the sniffer with Java High Rest Level](https://discuss.elastic.co/t/how-to-use-the-sniffer-with-java-high-rest-level/161783)
**Author:** [@AuroraLove](https://discuss.elastic.co/u/AuroraLove)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 4:10am UTC](https://discuss.elastic.co/t/how-to-use-the-sniffer-with-java-high-rest-level/161783 "2018-12-21T04:10:42Z")
hi,everyone! I want to use the sniffer in 6.5.1 version,but I couldn't find the API to operate High Rest Level. My code is following: SniffOnFailureListener sniffOnFailureListener = new SniffOnFailureListener(); … --- ## [How do i sorting by buckets index in nested aggregation instead doc\_count?](https://discuss.elastic.co/t/how-do-i-sorting-by-buckets-index-in-nested-aggregation-instead-doc-count/161774)
**Author:** [@teemoGod](https://discuss.elastic.co/u/teemoGod)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 3:00am UTC](https://discuss.elastic.co/t/how-do-i-sorting-by-buckets-index-in-nested-aggregation-instead-doc-count/161774 "2018-12-21T03:00:08Z")
my ES/Kibana version is 6.4.1. i'm using nested aggregation. i am making log system with analysis via kibana's vega. so, i want to sort by buckets index these nested fields , not field name. (for call method sequence… --- ## [Help needed with Percolate performance issue](https://discuss.elastic.co/t/help-needed-with-percolate-performance-issue/161773)
**Author:** [@dr\_work](https://discuss.elastic.co/u/dr_work)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 2:38am UTC](https://discuss.elastic.co/t/help-needed-with-percolate-performance-issue/161773 "2018-12-21T02:38:45Z")
I am trying to figure out a performance issue related to Elasticsearch Percolate functionality. I have provided steps to recreate below and the sample data has been created off the Elasticsearch Percolate documentation (h… --- ## [In what types of queries is the query string syntax available and how can it be disabled?](https://discuss.elastic.co/t/in-what-types-of-queries-is-the-query-string-syntax-available-and-how-can-it-be-disabled/161769)
**Author:** [@anaym](https://discuss.elastic.co/u/anaym)\ **Replies:** 0\ **Last updated:** [December 21, 2018, 2:07am UTC](https://discuss.elastic.co/t/in-what-types-of-queries-is-the-query-string-syntax-available-and-how-can-it-be-disabled/161769 "2018-12-21T02:07:03Z")
I need to disable the ability of the users to use query string syntax and Lucene query parser syntax in search queries. However, I am not sure that query string syntax and lucene query parser syntax are used only in quer… --- ## [Master-slave configuration setting](https://discuss.elastic.co/t/master-slave-configuration-setting/161614)
**Author:** [@aabababba](https://discuss.elastic.co/u/aabababba)\ **Replies:** 8\ **Last updated:** [December 21, 2018, 1:58am UTC](https://discuss.elastic.co/t/master-slave-configuration-setting/161614 "2018-12-21T01:58:58Z")
Master-slave configuration setting, how to set slave automatic change to the main ,when the main hang up. --- ## [Ec2 instances for AWS ElasticSearch with good write performance and storage](https://discuss.elastic.co/t/ec2-instances-for-aws-elasticsearch-with-good-write-performance-and-storage/161215)
**Author:** [@Natalia\_Kuleniuk](https://discuss.elastic.co/u/Natalia_Kuleniuk)\ **Replies:** 2\ **Last updated:** [December 21, 2018, 12:59am UTC](https://discuss.elastic.co/t/ec2-instances-for-aws-elasticsearch-with-good-write-performance-and-storage/161215 "2018-12-21T00:59:38Z")
Hi ElasticSearch community. I’m using AWS Elasticsearch and need advice on what instance types to choose for my cluster and. How many shard to use. My use-case is the following: My system produces at max 150,000,000 re… --- ## [Issue with free\_disk\_space example](https://discuss.elastic.co/t/issue-with-free-disk-space-example/159795)
**Author:** [@songxuelian](https://discuss.elastic.co/u/songxuelian)\ **Replies:** 2\ **Last updated:** [December 20, 2018, 9:59pm UTC](https://discuss.elastic.co/t/issue-with-free-disk-space-example/159795 "2018-12-20T21:59:58Z")
Hello there, I am trying to apply the free disk space example in my my own system: (elasticsearch 6.0.1 trial version) https://github.com/elastic/examples/tree/master/Alerting/Sample%20Watches/monitoring\_free\_disk\_space … --- ## [POST a bulk to elasticsearch from datatables output](https://discuss.elastic.co/t/post-a-bulk-to-elasticsearch-from-datatables-output/161628)
**Author:** [@prajogo.atmaja](https://discuss.elastic.co/u/prajogo.atmaja)\ **Replies:** 10\ **Last updated:** [December 20, 2018, 9:04pm UTC](https://discuss.elastic.co/t/post-a-bulk-to-elasticsearch-from-datatables-output/161628 "2018-12-20T21:04:56Z")
Hello, I just installed elasticsearch today. I downloaded some stock market data from an exchange using curl and saved them as a json. I'm having trouble with uploading the json files to the elasticsearch. I'm trying to … --- ## [Wildcards on indices upgraded to Elasticsearch 6.5 don't work correctly](https://discuss.elastic.co/t/wildcards-on-indices-upgraded-to-elasticsearch-6-5-dont-work-correctly/160788)
**Author:** [@lcremonesi](https://discuss.elastic.co/u/lcremonesi)\ **Replies:** 3\ **Last updated:** [December 20, 2018, 8:55pm UTC](https://discuss.elastic.co/t/wildcards-on-indices-upgraded-to-elasticsearch-6-5-dont-work-correctly/160788 "2018-12-20T20:55:26Z")
We performed a rolling upgrade from Elasticsearch 5.6.7 to 6.5.0 (following the instructions reported on this page), without re-indexing any existing index. After this upgrade, when you execute a search using a query st… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1444) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1446)