# \#none **URL:** https://discuss.elastic.co/tag/none.md?no_tags=true&page=1000 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1001 --- ## [How to compare the sums of multiple columns?](https://discuss.elastic.co/t/how-to-compare-the-sums-of-multiple-columns/268491)
**Author:** [@saintjohn](https://discuss.elastic.co/u/saintjohn)\ **Replies:** 1\ **Last updated:** [March 27, 2021, 12:08am UTC](https://discuss.elastic.co/t/how-to-compare-the-sums-of-multiple-columns/268491 "2021-03-27T00:08:54Z")
Hi, I have datasets like below. { count\_A: 10, count\_B: 5 } { count\_A: 20, count\_: 5 } I would to create a Kibana pie chart that compares the sums of each columns. In this case, 30 vs 10 for count\_A and count\_… --- ## [Send data via mqtt](https://discuss.elastic.co/t/send-data-via-mqtt/268372)
**Author:** [@accateo](https://discuss.elastic.co/u/accateo)\ **Replies:** 11\ **Last updated:** [March 26, 2021, 9:40pm UTC](https://discuss.elastic.co/t/send-data-via-mqtt/268372 "2021-03-26T21:40:19Z")
Hello, I am using an Elastic Cloud instance and I was wondering if there was the possibility to send data via MQTT from a Linux system device in the cloud. How can I do? Thank you --- ## [Problem with filter](https://discuss.elastic.co/t/problem-with-filter/268466)
**Author:** [@modesto](https://discuss.elastic.co/u/modesto)\ **Replies:** 6\ **Last updated:** [March 26, 2021, 8:19pm UTC](https://discuss.elastic.co/t/problem-with-filter/268466 "2021-03-26T20:19:16Z")
Hi community I'm quite new to Elastic and have run into some obstacles. I want to do a search on a specific company id, with filters, but can't it to work, although it works with query. Why is that? curl --location -… --- ## [Elastic SaaS on Azure - Securing data and communication](https://discuss.elastic.co/t/elastic-saas-on-azure-securing-data-and-communication/268222)
**Author:** [@ceiche](https://discuss.elastic.co/u/ceiche)\ **Replies:** 1\ **Last updated:** [March 26, 2021, 7:59pm UTC](https://discuss.elastic.co/t/elastic-saas-on-azure-securing-data-and-communication/268222 "2021-03-26T19:59:36Z")
One of my client is planning to use Elastic SaaS Solution from Elastic on Azure (native Elasticsearch) for document search. It will be storing very sensitive data. So the question is how "secure" an Elastic SaaS solutio… --- ## [Logstash http output basic auth base64 encode not parsed](https://discuss.elastic.co/t/logstash-http-output-basic-auth-base64-encode-not-parsed/268432)
**Author:** [@lemoncodes91](https://discuss.elastic.co/u/lemoncodes91)\ **Replies:** 1\ **Last updated:** [March 26, 2021, 5:02pm UTC](https://discuss.elastic.co/t/logstash-http-output-basic-auth-base64-encode-not-parsed/268432 "2021-03-26T17:02:53Z")
Hello i followed some guides on how to do basic auth in logstash. However, when i check the outgoing packet from logstash, the HTTP protocol contains "Authorization: Basic %{password}" instead of "Authorization: Basic \ **Author:** [@GrahamHannington](https://discuss.elastic.co/u/GrahamHannington)\ **Replies:** 5\ **Last updated:** [March 26, 2021, 4:58pm UTC](https://discuss.elastic.co/t/replay-old-events-as-if-they-were-new/268218 "2021-03-26T16:58:01Z") Suppose I have: A Kibana dashboard that shows the last few minutes, automatically refreshing every few seconds A Logstash config that reads JSON Lines from a file (via stdin), sets the event timestamp to the value of a… --- ## [Elasticsearch Output Plugin - Batching, How?](https://discuss.elastic.co/t/elasticsearch-output-plugin-batching-how/268469)
**Author:** [@Liam\_B](https://discuss.elastic.co/u/Liam_B)\ **Replies:** 1\ **Last updated:** [March 26, 2021, 4:51pm UTC](https://discuss.elastic.co/t/elasticsearch-output-plugin-batching-how/268469 "2021-03-26T16:51:51Z")
In the Logstash elastic search output documentation it mentions... Batch Sizes: This plugin attempts to send batches of events to the \[Elasticsearch Bulk API\] I can't find any information on how the batches are buffere… --- ## [Is case-insensitive sort on keyword aggregation. ES 7.7.0](https://discuss.elastic.co/t/is-case-insensitive-sort-on-keyword-aggregation-es-7-7-0/268198)
**Author:** [@Cular](https://discuss.elastic.co/u/Cular)\ **Replies:** 3\ **Last updated:** [March 26, 2021, 4:44pm UTC](https://discuss.elastic.co/t/is-case-insensitive-sort-on-keyword-aggregation-es-7-7-0/268198 "2021-03-26T16:44:49Z")
I have similar case like here and here2. I am trying to achive alphabetical sorting (case insensitive) with original value from aggregation. Simplified example mapping: PUT test\_data { "mappings": { "prope… --- ## [Logstash does not pick up all gzip log files](https://discuss.elastic.co/t/logstash-does-not-pick-up-all-gzip-log-files/268446)
**Author:** [@erictung](https://discuss.elastic.co/u/erictung)\ **Replies:** 1\ **Last updated:** [March 26, 2021, 4:39pm UTC](https://discuss.elastic.co/t/logstash-does-not-pick-up-all-gzip-log-files/268446 "2021-03-26T16:39:25Z")
Hi community, this is my first post in this forum and I would like to seek help regarding Logstash. So here's the scenario: I have a Python script to pull logs from Cloudflare ELS and then save it into local folder as … --- ## [Filter documents prior to bucketing using GeoTile Aggregation](https://discuss.elastic.co/t/filter-documents-prior-to-bucketing-using-geotile-aggregation/268517)
**Author:** [@jvanulde](https://discuss.elastic.co/u/jvanulde)\ **Replies:** 0\ **Last updated:** [March 26, 2021, 4:10pm UTC](https://discuss.elastic.co/t/filter-documents-prior-to-bucketing-using-geotile-aggregation/268517 "2021-03-26T16:10:57Z")
Hi all, I am looking for an example where documents are filtered prior to bucketing via the GeoTile aggregation. For example I would like to have buckets that hold the number of documents where some value is greater than… --- ## [Как достать вложенные объекты в скрипте при агрегации. How get object in script](https://discuss.elastic.co/t/how-get-object-in-script/268075)
**Author:** [@Marina\_S](https://discuss.elastic.co/u/Marina_S)\ **Replies:** 17\ **Last updated:** [March 26, 2021, 4:19pm UTC](https://discuss.elastic.co/t/how-get-object-in-script/268075 "2021-03-26T16:19:35Z")
Есть объект такой вложенности "sizeData" : { "id" : 1, "elasticSizeScale" : { "id" : 3, "sizes" : \[ { "id" : 321, "sizeOrd… --- ## [Unable to tesselate shape error on indexing ES 7.11.1](https://discuss.elastic.co/t/unable-to-tesselate-shape-error-on-indexing-es-7-11-1/268356)
**Author:** [@mario.l](https://discuss.elastic.co/u/mario.l)\ **Replies:** 8\ **Last updated:** [March 26, 2021, 4:18pm UTC](https://discuss.elastic.co/t/unable-to-tesselate-shape-error-on-indexing-es-7-11-1/268356 "2021-03-26T16:18:33Z")
Dear all, I'm tring to save the following geometry MULTIPOLYGON(((177.59 59.9735,180 62.288856810085,180 63.763900213475,178.731 64.0348,177.44 64.2967,176.148 64.5406,174.809 64.7792,173.45 65.005,172.047 65.2202,170.… --- ## [Extract value from regex with parentheses in if condition](https://discuss.elastic.co/t/extract-value-from-regex-with-parentheses-in-if-condition/268190)
**Author:** [@Romanian\_Coder](https://discuss.elastic.co/u/Romanian_Coder)\ **Replies:** 8\ **Last updated:** [March 26, 2021, 4:14pm UTC](https://discuss.elastic.co/t/extract-value-from-regex-with-parentheses-in-if-condition/268190 "2021-03-26T16:14:24Z")
I have next input in logstash { logstash | "sourceRecordPosition" =\> 11, logstash | "rejectionReason" =\> "", logstash | "key" =\> 2251799813685255, logstash … --- ## [APM Java Agent getting not all data](https://discuss.elastic.co/t/apm-java-agent-getting-not-all-data/266935)
**Author:** [@Katharina](https://discuss.elastic.co/u/Katharina)\ **Replies:** 3\ **Last updated:** [March 26, 2021, 3:45pm UTC](https://discuss.elastic.co/t/apm-java-agent-getting-not-all-data/266935 "2021-03-26T15:45:16Z")
Hi all, I'm new here and hopefully using the forum right. I set up an ELK stack with beats version 7.11.1 newly in a local environment via Ansible and Vagrant. Everything is working fine. Now I wanted to collect and vi… --- ## [Painless scripted field - access query range](https://discuss.elastic.co/t/painless-scripted-field-access-query-range/268135)
**Author:** [@Nuno\_Centeio](https://discuss.elastic.co/u/Nuno_Centeio)\ **Replies:** 1\ **Last updated:** [March 26, 2021, 3:38pm UTC](https://discuss.elastic.co/t/painless-scripted-field-access-query-range/268135 "2021-03-26T15:38:03Z")
Hi, I'm new to Painless (and to Elasticsearch as well) and I'm building a query that looks like this: "script\_fields": { "PeriodTime": { "script": { "source": "doc\['@timestamp'\].value.millis - doc\['… --- ## [How to get the data from yesterday to today's date range](https://discuss.elastic.co/t/how-to-get-the-data-from-yesterday-to-todays-date-range/268493)
**Author:** [@suresh123](https://discuss.elastic.co/u/suresh123)\ **Replies:** 4\ **Last updated:** [March 26, 2021, 3:23pm UTC](https://discuss.elastic.co/t/how-to-get-the-data-from-yesterday-to-todays-date-range/268493 "2021-03-26T15:23:59Z")
Hello Experts, I have tried to get the data between dates as below, but the exact date it is not giving.It is under UTC format. "range" : { "@timestamp" : { "gte": "now-1d/d ", … --- ## [Elasticsearch space character problem](https://discuss.elastic.co/t/elasticsearch-space-character-problem/268506)
**Author:** [@Celal\_Poyraz](https://discuss.elastic.co/u/Celal_Poyraz)\ **Replies:** 3\ **Last updated:** [March 26, 2021, 3:21pm UTC](https://discuss.elastic.co/t/elasticsearch-space-character-problem/268506 "2021-03-26T15:21:05Z")
I do elasticsearch indexing, but the first 2 characters after the space character do not search. For example, when I search for "John", the results come, but when I search for "John S", the result is not available. The n… --- ## [Data from SQL to Azure Data Lake Gen2](https://discuss.elastic.co/t/data-from-sql-to-azure-data-lake-gen2/268500)
**Author:** [@\_Louw](https://discuss.elastic.co/u/_Louw)\ **Replies:** 0\ **Last updated:** [March 26, 2021, 1:34pm UTC](https://discuss.elastic.co/t/data-from-sql-to-azure-data-lake-gen2/268500 "2021-03-26T13:34:34Z")
What I want to do: Input: Query from a SQL MariaDB Output: Put everything into an Azure Data Lake Gen2 What Azure wants in order to put a file on the data lake: A precise count of all characters in the input My pro… --- ## [Indexing the content from Yammer](https://discuss.elastic.co/t/indexing-the-content-from-yammer/268437)
**Author:** [@mruthyu](https://discuss.elastic.co/u/mruthyu)\ **Replies:** 2\ **Last updated:** [March 26, 2021, 1:10pm UTC](https://discuss.elastic.co/t/indexing-the-content-from-yammer/268437 "2021-03-26T13:10:43Z")
Do we have the connector to get the content indexed from Yammer? --- ## [ECS template initial import](https://discuss.elastic.co/t/ecs-template-initial-import/268492)
**Author:** [@Til\_bardaga](https://discuss.elastic.co/u/Til_bardaga)\ **Replies:** 0\ **Last updated:** [March 26, 2021, 12:38pm UTC](https://discuss.elastic.co/t/ecs-template-initial-import/268492 "2021-03-26T12:38:37Z")
I am having trouble figuring out how to start using an ECS index template. I have read through a lot of the documentation and familiarized myself with the concepts of ECS. Now I want to test it in practice. The questi… --- ## [ES 6.x / 7.x freezes on index deletion/creation for a long time ONLY with big amount of deprecation warnings](https://discuss.elastic.co/t/es-6-x-7-x-freezes-on-index-deletion-creation-for-a-long-time-only-with-big-amount-of-deprecation-warnings/265516)
**Author:** [@Ivan\_Rabotyga](https://discuss.elastic.co/u/Ivan_Rabotyga)\ **Replies:** 9\ **Last updated:** [March 26, 2021, 12:13pm UTC](https://discuss.elastic.co/t/es-6-x-7-x-freezes-on-index-deletion-creation-for-a-long-time-only-with-big-amount-of-deprecation-warnings/265516 "2021-03-26T12:13:19Z")
Hello everyone :wave: ! I'm getting a mysterious case on the CI. ES freezes on an index deletion or creation for a long time, when I run application tests using ES 6.8.13 (same for 7.10.1) and the application is config… --- ## [How can I plot geoinformation from elasticsearch index on kibana maps? I am using kibana version 7.11.1](https://discuss.elastic.co/t/how-can-i-plot-geoinformation-from-elasticsearch-index-on-kibana-maps-i-am-using-kibana-version-7-11-1/268301)
**Author:** [@Husnain](https://discuss.elastic.co/u/Husnain)\ **Replies:** 4\ **Last updated:** [March 26, 2021, 11:26am UTC](https://discuss.elastic.co/t/how-can-i-plot-geoinformation-from-elasticsearch-index-on-kibana-maps-i-am-using-kibana-version-7-11-1/268301 "2021-03-26T11:26:01Z")
Hii.I have documents in my elasticsearch index which contains geographical information.How can I plot this information on kibana maps? This is my document:- { "@timestamp" =\> 2021-03-25T07:39:16.648Z, "myl… --- ## [Embed dashboard with filters in web site page](https://discuss.elastic.co/t/embed-dashboard-with-filters-in-web-site-page/268408)
**Author:** [@stefano\_de\_simone](https://discuss.elastic.co/u/stefano_de_simone)\ **Replies:** 4\ **Last updated:** [March 26, 2021, 10:24am UTC](https://discuss.elastic.co/t/embed-dashboard-with-filters-in-web-site-page/268408 "2021-03-26T10:24:50Z")
Hi, is it possible to embed a dashboard with filters in a web page? The requirement is that the user can set filters. Thanks in advance Stefano --- ## [Is it possible to search on the field name through wildcard?](https://discuss.elastic.co/t/is-it-possible-to-search-on-the-field-name-through-wildcard/268452)
**Author:** [@Miguel\_BA](https://discuss.elastic.co/u/Miguel_BA)\ **Replies:** 4\ **Last updated:** [March 26, 2021, 10:06am UTC](https://discuss.elastic.co/t/is-it-possible-to-search-on-the-field-name-through-wildcard/268452 "2021-03-26T10:06:47Z")
Hello, I need to make a query that returns all the document names that have a value greater than 3. The problem is that the names of the documents are changing and are all different, so I do not know the full name of th… --- ## [Mysql database monitoring](https://discuss.elastic.co/t/mysql-database-monitoring/266761)
**Author:** [@jonsacri](https://discuss.elastic.co/u/jonsacri)\ **Replies:** 13\ **Last updated:** [March 26, 2021, 9:54am UTC](https://discuss.elastic.co/t/mysql-database-monitoring/266761 "2021-03-26T09:54:15Z")
colleagues to be able to monitor a database which are the permissions that the user must have. and which table is the one that should have these permissions in my SQL --- ## [Convert ElasticSearch index to sql](https://discuss.elastic.co/t/convert-elasticsearch-index-to-sql/268310)
**Author:** [@Weathmious](https://discuss.elastic.co/u/Weathmious)\ **Replies:** 8\ **Last updated:** [March 26, 2021, 8:32am UTC](https://discuss.elastic.co/t/convert-elasticsearch-index-to-sql/268310 "2021-03-26T08:32:56Z")
Hello, I currently use elasticsearch for my graylog server, everything works fine but disk space fills up too fast I understood that it is possible to convert elasticsearch indexes into sql tables, which seems to me to… --- ## [GSOC| Elasticsearch: mongoDB-ElasticSearch request translator. project discussion](https://discuss.elastic.co/t/gsoc-elasticsearch-mongodb-elasticsearch-request-translator-project-discussion/125488)
**Author:** [@elska](https://discuss.elastic.co/u/elska)\ **Replies:** 11\ **Last updated:** [March 26, 2021, 7:52am UTC](https://discuss.elastic.co/t/gsoc-elasticsearch-mongodb-elasticsearch-request-translator-project-discussion/125488 "2021-03-26T07:52:56Z")
Hi, ElasticSearch team! I'm Denis Gorev, a 1st year CS phD student at MIPT, Moscow, Russian Federation. I would like to participate in GSOC with my own project, and would like to clarify if my idea is interesting for el… --- ## [Elasticsearch does not find the result in the first search after the space character in NEST](https://discuss.elastic.co/t/elasticsearch-does-not-find-the-result-in-the-first-search-after-the-space-character-in-nest/268447)
**Author:** [@Celal\_Poyraz](https://discuss.elastic.co/u/Celal_Poyraz)\ **Replies:** 0\ **Last updated:** [March 26, 2021, 7:26am UTC](https://discuss.elastic.co/t/elasticsearch-does-not-find-the-result-in-the-first-search-after-the-space-character-in-nest/268447 "2021-03-26T07:26:20Z")
I am indexing in elasticsearch as I share below. But after I do the indexing process, when I search in autocomplete, it finds the text I searched for before the space, but the first key I press after the space character … --- ## [Clarification on buckets for range aggregation](https://discuss.elastic.co/t/clarification-on-buckets-for-range-aggregation/268435)
**Author:** [@Amphagory](https://discuss.elastic.co/u/Amphagory)\ **Replies:** 1\ **Last updated:** [March 26, 2021, 4:53am UTC](https://discuss.elastic.co/t/clarification-on-buckets-for-range-aggregation/268435 "2021-03-26T04:53:02Z")
I just wanted some clarification on what data would be included in my buckets if I did a range aggregation, it was not clear to me in reading the documentation (Range aggregation | Elasticsearch Reference \[7.12\] | Elasti… --- ## [I want to combine field](https://discuss.elastic.co/t/i-want-to-combine-field/268300)
**Author:** [@BlackCat](https://discuss.elastic.co/u/BlackCat)\ **Replies:** 2\ **Last updated:** [March 26, 2021, 1:46am UTC](https://discuss.elastic.co/t/i-want-to-combine-field/268300 "2021-03-26T01:46:38Z")
I want to new create "Message" field by "Thread" + "Loglevel" + "Content". Please teach me how to do it. Raw log. \[13172\] \[INFO\] 2021-03-25 09:18:21.150 +0900 : Java class name: org.apache.catalina.startup.Bootstrap; … [Previous page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=999) [Next page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=1001)