# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1238 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1239 --- ## [Which Elastic Search GUI would you recommend for local day to day development?](https://discuss.elastic.co/t/which-elastic-search-gui-would-you-recommend-for-local-day-to-day-development/189073)
**Author:** [@Avinash\_D\_Silva](https://discuss.elastic.co/u/Avinash_D_Silva)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 10:42am UTC](https://discuss.elastic.co/t/which-elastic-search-gui-would-you-recommend-for-local-day-to-day-development/189073 "2019-07-05T10:42:34Z")
I am just getting started with Elastic Search, would like to know what kind of interface do you use to browse/edit through the data? --- ## [Map the lookup fields from the CSV to existing index](https://discuss.elastic.co/t/map-the-lookup-fields-from-the-csv-to-existing-index/189071)
**Author:** [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 10:39am UTC](https://discuss.elastic.co/t/map-the-lookup-fields-from-the-csv-to-existing-index/189071 "2019-07-05T10:39:47Z")
Hello, I need to map the fields existing in my index to a lookup file. For eg: In index i am having field=value and in a csv i have value=name , so i need to map field=name. How can this be achieved. So basically when… --- ## [ES 2.4.6 Exception caught on transport layer : connection timeout?](https://discuss.elastic.co/t/es-2-4-6-exception-caught-on-transport-layer-connection-timeout/188298)
**Author:** [@wuxiansen](https://discuss.elastic.co/u/wuxiansen)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 9:52am UTC](https://discuss.elastic.co/t/es-2-4-6-exception-caught-on-transport-layer-connection-timeout/188298 "2019-07-05T09:52:48Z")
Elasticsearch version\*\* : 2.4.6 JVM version\*\* : java version "1.8.0\_144" ### OS version\*\* : Centos 64 elastic yml : ···· gateway.recover\_after\_nodes: 2 gateway.expected\_nodes: 2 gateway.recover\_after\_time: 5m di… --- ## [Keyword with lowercase wildcard search](https://discuss.elastic.co/t/keyword-with-lowercase-wildcard-search/189054)
**Author:** [@ashokraju\_kopparla](https://discuss.elastic.co/u/ashokraju_kopparla)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 9:42am UTC](https://discuss.elastic.co/t/keyword-with-lowercase-wildcard-search/189054 "2019-07-05T09:42:33Z")
Hi, I want perform query using wild card for keyword fileds. It is working fine. Now i want to perform same query with case insensitive . --- ## [How to authenticate with X.509 PEM certificates and PKCS #8 keys](https://discuss.elastic.co/t/how-to-authenticate-with-x-509-pem-certificates-and-pkcs-8-keys/189063)
**Author:** [@tzqtzq](https://discuss.elastic.co/u/tzqtzq)\ **Replies:** 0\ **Last updated:** [July 5, 2019, 9:42am UTC](https://discuss.elastic.co/t/how-to-authenticate-with-x-509-pem-certificates-and-pkcs-8-keys/189063 "2019-07-05T09:42:01Z")
my Component Version ES 5.4.3 ES-hadoop 5.4.3 SearchGuard 5.4.3 in es-hadoop-security Only supported Username/Password or PKI/X.509 ，I don't know how to configure the path of the pem and key files. Just like the f… --- ## [Upgrade version to 7.2](https://discuss.elastic.co/t/upgrade-version-to-7-2/189059)
**Author:** [@omardawed](https://discuss.elastic.co/u/omardawed)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 9:33am UTC](https://discuss.elastic.co/t/upgrade-version-to-7-2/189059 "2019-07-05T09:33:22Z")
Hello , i'm using currently the version 7.0.1 (ELK) i want to upgrade to the version 7.2 (ELK), how to perform the upgrade in the right way ? --- ## [Avg bucket aggregation over date histogram returns incorrect value when having empty bucket](https://discuss.elastic.co/t/avg-bucket-aggregation-over-date-histogram-returns-incorrect-value-when-having-empty-bucket/188911)
**Author:** [@jayqian](https://discuss.elastic.co/u/jayqian)\ **Replies:** 0\ **Last updated:** [July 4, 2019, 12:22pm UTC](https://discuss.elastic.co/t/avg-bucket-aggregation-over-date-histogram-returns-incorrect-value-when-having-empty-bucket/188911 "2019-07-04T12:22:56Z")
Hello all, we build the below query to get the average value of the sales aggregation in the date histogram but we find the value returned seem incorrect. We use extended\_bound to show the empty buckets so that the avg … --- ## [Index script](https://discuss.elastic.co/t/index-script/189045)
**Author:** [@yagami23](https://discuss.elastic.co/u/yagami23)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 9:15am UTC](https://discuss.elastic.co/t/index-script/189045 "2019-07-05T09:15:07Z")
Hi, is it possible we can index a script (shell/python) and when call the index in Kibana, the script output will parse to logstash/elastic and view in Kibana thats something similar to Splunk feature here: https://doc… --- ## [It takes 2 mins to indexing a single doc](https://discuss.elastic.co/t/it-takes-2-mins-to-indexing-a-single-doc/189030)
**Author:** [@erdel](https://discuss.elastic.co/u/erdel)\ **Replies:** 8\ **Last updated:** [July 5, 2019, 9:06am UTC](https://discuss.elastic.co/t/it-takes-2-mins-to-indexing-a-single-doc/189030 "2019-07-05T09:06:28Z")
Hi, I am using monstache for connecting elastic to mongodb. Here is my monstache command: monstache -elasticsearch-url "http://localhost:9200" -mongo-url 'mongodb+srv://XXXX' monstache -direct-read-namespace portaldb.… --- ## [Capacity Planning - Help Required!](https://discuss.elastic.co/t/capacity-planning-help-required/189044)
**Author:** [@Hariom\_Vashisth](https://discuss.elastic.co/u/Hariom_Vashisth)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 9:05am UTC](https://discuss.elastic.co/t/capacity-planning-help-required/189044 "2019-07-05T09:05:54Z")
High-Velocity Elasticsearch Cluster Setup Few Requirements: Ingestion capacity: 1TB per day Retention: 7 days Events: 100000 events per second per day How many nodes (master/data/ingestion/co-rdinating) required? H… --- ## [Update parent doc in scripted \_update\_by\_query](https://discuss.elastic.co/t/update-parent-doc-in-scripted-update-by-query/189048)
**Author:** [@HJK181](https://discuss.elastic.co/u/HJK181)\ **Replies:** 0\ **Last updated:** [July 5, 2019, 8:56am UTC](https://discuss.elastic.co/t/update-parent-doc-in-scripted-update-by-query/189048 "2019-07-05T08:56:05Z")
I have a parent/child relation with join datatype. Now I want to update a parent document, based on a query which find's X children. I need to add the value of a field from each child to a field of the parent of that chi… --- ## [How can I modify the distribution of the shards in nodes with diffent disk capacity?](https://discuss.elastic.co/t/how-can-i-modify-the-distribution-of-the-shards-in-nodes-with-diffent-disk-capacity/188994)
**Author:** [@xyz\_hh](https://discuss.elastic.co/u/xyz_hh)\ **Replies:** 4\ **Last updated:** [July 5, 2019, 8:53am UTC](https://discuss.elastic.co/t/how-can-i-modify-the-distribution-of-the-shards-in-nodes-with-diffent-disk-capacity/188994 "2019-07-05T08:53:01Z")
I have a several of servers with diffent disk capacity in my elasticsearch cluster.I find all the shards is allocated to all the server averagely.But what I want is : more disks ,more shards.When a node have less disks，i… --- ## [What is \[use\_field\_mapping\] format?](https://discuss.elastic.co/t/what-is-use-field-mapping-format/186416)
**Author:** [@simple\_commentateur](https://discuss.elastic.co/u/simple_commentateur)\ **Replies:** 4\ **Last updated:** [July 5, 2019, 8:35am UTC](https://discuss.elastic.co/t/what-is-use-field-mapping-format/186416 "2019-07-05T08:35:48Z")
Hi, I have a problem with my shards failing so I check es logs. I find this warning : \[instance-0000000005\] \[use\_field\_mapping\] is a special format that was only used to ease the transition to 7.x. It has become the d… --- ## [Search analyzer not work](https://discuss.elastic.co/t/search-analyzer-not-work/188776)
**Author:** [@Jinlian\_Chen](https://discuss.elastic.co/u/Jinlian_Chen)\ **Replies:** 6\ **Last updated:** [July 5, 2019, 8:25am UTC](https://discuss.elastic.co/t/search-analyzer-not-work/188776 "2019-07-05T08:25:45Z")
Hi, I've set a custom analyzer, but it seems not work when doing search. ElasticSearch version: 7.0.1 Create index: PUT /analyze\_email { "settings": { "number\_of\_shards": "1", "number\_of\_replicas":… --- ## [Rollover vs monthly based indices](https://discuss.elastic.co/t/rollover-vs-monthly-based-indices/188917)
**Author:** [@Loris](https://discuss.elastic.co/u/Loris)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 7:59am UTC](https://discuss.elastic.co/t/rollover-vs-monthly-based-indices/188917 "2019-07-05T07:59:58Z")
Hi, until today, in each Elastic project we worked on, we have saved ingested documents into monthly based indices (-%{YYYY.mm}). We are considering to move from this logical pattern to the one provided by the combinat… --- ## [Do you have a guide for contributing sources?](https://discuss.elastic.co/t/do-you-have-a-guide-for-contributing-sources/189033)
**Author:** [@xodn0812](https://discuss.elastic.co/u/xodn0812)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 7:50am UTC](https://discuss.elastic.co/t/do-you-have-a-guide-for-contributing-sources/189033 "2019-07-05T07:50:22Z")
I would like to contribute elasticsearch open source, I do not know where to look at the source. Do you have a guide for reference? --- ## [Index lifecycle Management index number](https://discuss.elastic.co/t/index-lifecycle-management-index-number/188690)
**Author:** [@rizkan\_abadi](https://discuss.elastic.co/u/rizkan_abadi)\ **Replies:** 3\ **Last updated:** [July 5, 2019, 7:48am UTC](https://discuss.elastic.co/t/index-lifecycle-management-index-number/188690 "2019-07-05T07:48:27Z")
Hi, is ILM need multiple index with date or single index ? example index tes-2019-07-02 or tes. --- ## [Index has no aliases](https://discuss.elastic.co/t/index-has-no-aliases/189000)
**Author:** [@rizkan\_abadi](https://discuss.elastic.co/u/rizkan_abadi)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 7:47am UTC](https://discuss.elastic.co/t/index-has-no-aliases/189000 "2019-07-05T07:47:17Z")
Hi, i have define the index rollup alias on metricbeat config, but if i add index to policy always show this error on kibana "Index has no aliases Policy test is configured for rollover, but index index-test does not … --- ## [Which is faster GetAsync or SearchAsync in elastic search NEST?](https://discuss.elastic.co/t/which-is-faster-getasync-or-searchasync-in-elastic-search-nest/189005)
**Author:** [@SudevPK](https://discuss.elastic.co/u/SudevPK)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 6:43am UTC](https://discuss.elastic.co/t/which-is-faster-getasync-or-searchasync-in-elastic-search-nest/189005 "2019-07-05T06:43:16Z")
var response = elasticClient .SearchAsync\(a =\> a .Index("item") .AllTypes() .Size(1) .Query(q =\> … --- ## [Getting data from mysql multiple tables](https://discuss.elastic.co/t/getting-data-from-mysql-multiple-tables/189011)
**Author:** [@manish\_kaushik](https://discuss.elastic.co/u/manish_kaushik)\ **Replies:** 0\ **Last updated:** [July 5, 2019, 6:16am UTC](https://discuss.elastic.co/t/getting-data-from-mysql-multiple-tables/189011 "2019-07-05T06:16:51Z")
I am indexing one table using jdbc plugin query and using timestamp column to check for any update and insert but now, I have to import multiple tables from db. What would be the efficient way:- I used the sql join qu… --- ## [How to handle "type" while upgrading from es2.x to es6.x](https://discuss.elastic.co/t/how-to-handle-type-while-upgrading-from-es2-x-to-es6-x/189007)
**Author:** [@pathri](https://discuss.elastic.co/u/pathri)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 5:46am UTC](https://discuss.elastic.co/t/how-to-handle-type-while-upgrading-from-es2-x-to-es6-x/189007 "2019-07-05T05:46:11Z")
since es deprecated "type" in it's es recent versions, how can i move indexes which are created in es2.x version to recent es versions? --- ## [Reverting to basic license after upgrading to 6.8](https://discuss.elastic.co/t/reverting-to-basic-license-after-upgrading-to-6-8/188953)
**Author:** [@Popman](https://discuss.elastic.co/u/Popman)\ **Replies:** 2\ **Last updated:** [July 5, 2019, 5:19am UTC](https://discuss.elastic.co/t/reverting-to-basic-license-after-upgrading-to-6-8/188953 "2019-07-05T05:19:15Z")
Good day, We had an ES6.7 cluster we were trialling RBAC on. We were happy with the results with the intent to purchase and used the cluster in production. In the interim it was announced that the auth functionality wou… --- ## [Querying multiple indexes using dev tools](https://discuss.elastic.co/t/querying-multiple-indexes-using-dev-tools/188842)
**Author:** [@pyerunka](https://discuss.elastic.co/u/pyerunka)\ **Replies:** 4\ **Last updated:** [July 5, 2019, 5:16am UTC](https://discuss.elastic.co/t/querying-multiple-indexes-using-dev-tools/188842 "2019-07-05T05:16:01Z")
Hello, Can anyone help me how to query using two indexes in dev tools of kibana? i have two indexes created with different set of data and fields. Thanks & Regards, Priyanka --- ## [CURL CONNECT SSL WITH CERTIFICATE OF SHA256 get error](https://discuss.elastic.co/t/curl-connect-ssl-with-certificate-of-sha256-get-error/188816)
**Author:** [@GabayAvi](https://discuss.elastic.co/u/GabayAvi)\ **Replies:** 4\ **Last updated:** [July 5, 2019, 4:27am UTC](https://discuss.elastic.co/t/curl-connect-ssl-with-certificate-of-sha256-get-error/188816 "2019-07-05T04:27:14Z")
hay i got a new elk server but CA stuff built the certificate with "Signature Algorithm: sha256WithRSAEncryption" when i execute the command : curl -u elastic --cacert /etc/elasticsearch/crt/ca.crt -XGET "https://dev… --- ## [Completion Suggester Analyzer](https://discuss.elastic.co/t/completion-suggester-analyzer/189001)
**Author:** [@han1](https://discuss.elastic.co/u/han1)\ **Replies:** 0\ **Last updated:** [July 5, 2019, 4:18am UTC](https://discuss.elastic.co/t/completion-suggester-analyzer/189001 "2019-07-05T04:18:14Z")
We have configured a completion suggester filed as: .Completion(c =\> c.Analyzer("standard") .PreserveSeparators(true) .MaxInputLength(100) .Name("… --- ## [How to create dynamic template for nested objects](https://discuss.elastic.co/t/how-to-create-dynamic-template-for-nested-objects/187310)
**Author:** [@muthualagappan](https://discuss.elastic.co/u/muthualagappan)\ **Replies:** 1\ **Last updated:** [July 5, 2019, 4:14am UTC](https://discuss.elastic.co/t/how-to-create-dynamic-template-for-nested-objects/187310 "2019-07-05T04:14:48Z")
I want to create a dynamic template for mapping the array of objects as nested type instead of object type automatically. I have downloaded the basic template from curl -X GET "localhost:9200/\_template". Please let me k… --- ## [Elasticsearch Index writes is really do flush() or synch() at OS level](https://discuss.elastic.co/t/elasticsearch-index-writes-is-really-do-flush-or-synch-at-os-level/188005)
**Author:** [@suvarna](https://discuss.elastic.co/u/suvarna)\ **Replies:** 4\ **Last updated:** [July 5, 2019, 3:54am UTC](https://discuss.elastic.co/t/elasticsearch-index-writes-is-really-do-flush-or-synch-at-os-level/188005 "2019-07-05T03:54:31Z")
Hi Can you please let me whether Elasticsearch Index writes is really do flush() or synch() at OS level --- ## [ES flow](https://discuss.elastic.co/t/es-flow/188220)
**Author:** [@suvarna](https://discuss.elastic.co/u/suvarna)\ **Replies:** 4\ **Last updated:** [July 5, 2019, 3:53am UTC](https://discuss.elastic.co/t/es-flow/188220 "2019-07-05T03:53:58Z")
Hi , Can you please explain the data and control flow of index write in Elasticsearch. Like when we send a documents, how the documents flow from DRAM to persistence device(SSD) . Thanks --- ## [Issue in deserializing WKT Geoshape](https://discuss.elastic.co/t/issue-in-deserializing-wkt-geoshape/188804)
**Author:** [@PatriceMarin](https://discuss.elastic.co/u/PatriceMarin)\ **Replies:** 3\ **Last updated:** [July 5, 2019, 12:38am UTC](https://discuss.elastic.co/t/issue-in-deserializing-wkt-geoshape/188804 "2019-07-05T00:38:24Z")
Hi, I've got an unexpected exception when I'm querying an index containing GeoShape data. My index is a city with a geo\_shape property which represents the polygon of the city. After indexing all my cities, I'm queryi… --- ## [Can I have document count and sum in the same bicket?](https://discuss.elastic.co/t/can-i-have-document-count-and-sum-in-the-same-bicket/188974)
**Author:** [@arseny](https://discuss.elastic.co/u/arseny)\ **Replies:** 1\ **Last updated:** [July 4, 2019, 9:23pm UTC](https://discuss.elastic.co/t/can-i-have-document-count-and-sum-in-the-same-bicket/188974 "2019-07-04T21:23:20Z")
I have documents of shape { amount, status, timestamp ...other } and I was wondering if I can group them by day, status and have count and sum(amount)? Basically, the response be: "buckets" : \[ { "key" : "COMP… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1237) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1239)