# \#none **URL:** https://discuss.elastic.co/tag/none.md?no_tags=true&page=835 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 836 --- ## [Elasticsearch data to mysql](https://discuss.elastic.co/t/elasticsearch-data-to-mysql/283488)
**Author:** [@zhyp](https://discuss.elastic.co/u/zhyp)\ **Replies:** 0\ **Last updated:** [September 7, 2021, 5:13am UTC](https://discuss.elastic.co/t/elasticsearch-data-to-mysql/283488 "2021-09-07T05:13:35Z")
Hi :grinning: My data is in elasticsearch. I want to use logstash to synchronize to MySQL, or use other tools. What can I do to achieve it？ --- ## [How to use api/shorten\_url?](https://discuss.elastic.co/t/how-to-use-api-shorten-url/283423)
**Author:** [@wajika](https://discuss.elastic.co/u/wajika)\ **Replies:** 2\ **Last updated:** [September 7, 2021, 5:06am UTC](https://discuss.elastic.co/t/how-to-use-api-shorten-url/283423 "2021-09-07T05:06:21Z")
Examples in the documentation: # curl -H "kbn-xsrf: reporting" -XPOST http://192.168.10.148:5601/api/shorten\_url -d ' \> { \> "url": "/app/kibana#/dashboard?\_g=()&\_a=(description:'',filters:!(),fullScreenMode:!f,option… --- ## [Add large attachments from S3 to Elastic Search](https://discuss.elastic.co/t/add-large-attachments-from-s3-to-elastic-search/283452)
**Author:** [@Reghu\_Shanker](https://discuss.elastic.co/u/Reghu_Shanker)\ **Replies:** 5\ **Last updated:** [September 7, 2021, 3:37am UTC](https://discuss.elastic.co/t/add-large-attachments-from-s3-to-elastic-search/283452 "2021-09-07T03:37:42Z")
Hi, I have large pdf files which are located in AWS S3 which needs to be indexed and searchable. I want to upload these files to elastic search. The files need to be uploaded as single documents. How can I do this from… --- ## [Kibana 7.14 - Canvas var\_set no longer accepts input context](https://discuss.elastic.co/t/kibana-7-14-canvas-var-set-no-longer-accepts-input-context/281420)
**Author:** [@markbyrnegkc](https://discuss.elastic.co/u/markbyrnegkc)\ **Replies:** 3\ **Last updated:** [September 7, 2021, 2:41am UTC](https://discuss.elastic.co/t/kibana-7-14-canvas-var-set-no-longer-accepts-input-context/281420 "2021-09-07T02:41:23Z")
In 7.14 the var\_set function in- Canvas no longer accepts the input context as the value. One needs to explicitly set the value now. Trying to run this expression: date | var\_set "mydate" | var "mydate" | render as="de… --- ## [Boost score on token order over proximity](https://discuss.elastic.co/t/boost-score-on-token-order-over-proximity/283126)
**Author:** [@Dahea\_Moon](https://discuss.elastic.co/u/Dahea_Moon)\ **Replies:** 2\ **Last updated:** [September 7, 2021, 1:21am UTC](https://discuss.elastic.co/t/boost-score-on-token-order-over-proximity/283126 "2021-09-07T01:21:55Z")
Hello, elastic team. Is there way to adjust score between proximity and order? I want to search by "any word in order with some slop". I found out that most of DSLs that matters with proximity and in order option cann… --- ## [To retrieve complete metricbeat data from the elasticsearch](https://discuss.elastic.co/t/to-retrieve-complete-metricbeat-data-from-the-elasticsearch/283112)
**Author:** [@nehasinha1807](https://discuss.elastic.co/u/nehasinha1807)\ **Replies:** 4\ **Last updated:** [September 6, 2021, 11:01pm UTC](https://discuss.elastic.co/t/to-retrieve-complete-metricbeat-data-from-the-elasticsearch/283112 "2021-09-06T23:01:46Z")
I want to get full metricbeat data from elasticsearch in json through API. I tried with - /metricbeat\*/\_search but it is not giving complete data. Please suggest. --- ## [Joining aggregation results to the original documents](https://discuss.elastic.co/t/joining-aggregation-results-to-the-original-documents/282547)
**Author:** [@lyubimtsev](https://discuss.elastic.co/u/lyubimtsev)\ **Replies:** 4\ **Last updated:** [September 6, 2021, 5:20pm UTC](https://discuss.elastic.co/t/joining-aggregation-results-to-the-original-documents/282547 "2021-09-06T17:20:21Z")
Hi I need help to create a query that creates metrics aggregations, merge created metrics to original documents and then filters documents using these metrics. Let's consider following dataset with managers' sales: … --- ## [Kibana Duplicate data](https://discuss.elastic.co/t/kibana-duplicate-data/283299)
**Author:** [@rp346](https://discuss.elastic.co/u/rp346)\ **Replies:** 1\ **Last updated:** [September 6, 2021, 4:07pm UTC](https://discuss.elastic.co/t/kibana-duplicate-data/283299 "2021-09-06T16:07:34Z")
I have ELSK Steup to aggregate Kubernetes logs. But in Kibana I see all logs appearing twice, here is the sample 10:43:02.416 \[2021-09-03 14:43:02,414\] \[INFO\] - Encoding password to hash! 10:43:02.416 \[2021-09-03 14:43:… --- ## [Edit custom labels on Kibana Visualizations](https://discuss.elastic.co/t/edit-custom-labels-on-kibana-visualizations/283272)
**Author:** [@pavank](https://discuss.elastic.co/u/pavank)\ **Replies:** 6\ **Last updated:** [September 6, 2021, 1:41pm UTC](https://discuss.elastic.co/t/edit-custom-labels-on-kibana-visualizations/283272 "2021-09-06T13:41:28Z")
Kibana version 7.9.3 I'm trying to create a visualization of type Metric, and I see the visualization as attached in the screenshot. How do I get the label to read only Confirm Shipment - PORTUGAL and not Confirm Shipm… --- ## [Convert Elasticsearch Date/Time field from UTC To Local Time?](https://discuss.elastic.co/t/convert-elasticsearch-date-time-field-from-utc-to-local-time/283441)
**Author:** [@padamrai](https://discuss.elastic.co/u/padamrai)\ **Replies:** 9\ **Last updated:** [September 6, 2021, 1:11pm UTC](https://discuss.elastic.co/t/convert-elasticsearch-date-time-field-from-utc-to-local-time/283441 "2021-09-06T13:11:52Z")
I am getting 12 Hours difference in Date. I want to set that date format to local time that is GMT+5. And I have set kibana default time period to Browser. Any one can help me how to set is as local time. --- ## [How to get all Field names with filter(or query) criteria on ElasticSearch?](https://discuss.elastic.co/t/how-to-get-all-field-names-with-filter-or-query-criteria-on-elasticsearch/283435)
**Author:** [@jinssssun](https://discuss.elastic.co/u/jinssssun)\ **Replies:** 2\ **Last updated:** [September 6, 2021, 12:40pm UTC](https://discuss.elastic.co/t/how-to-get-all-field-names-with-filter-or-query-criteria-on-elasticsearch/283435 "2021-09-06T12:40:09Z")
PUT /test-product { "mappings": { "properties": { "profile": { "type": "nested" }, "product": { "type": "nested" } } } } i have a index that name's 'test-product' POS… --- ## [Sort data so that my exact match will be on top and then semi exact match with most words snd so on](https://discuss.elastic.co/t/sort-data-so-that-my-exact-match-will-be-on-top-and-then-semi-exact-match-with-most-words-snd-so-on/283338)
**Author:** [@Jaymin](https://discuss.elastic.co/u/Jaymin)\ **Replies:** 2\ **Last updated:** [September 6, 2021, 12:30pm UTC](https://discuss.elastic.co/t/sort-data-so-that-my-exact-match-will-be-on-top-and-then-semi-exact-match-with-most-words-snd-so-on/283338 "2021-09-06T12:30:48Z")
I am using query\_string for searching my data. and wanted to sort my data such that exact match should be on top and less matched words would follow exact match. For Instance, { "size": 100, //"explain":true, "qu… --- ## [What is the difference between logstash and kibana pipelines?](https://discuss.elastic.co/t/what-is-the-difference-between-logstash-and-kibana-pipelines/283420)
**Author:** [@rodri.gz](https://discuss.elastic.co/u/rodri.gz)\ **Replies:** 6\ **Last updated:** [September 6, 2021, 11:55am UTC](https://discuss.elastic.co/t/what-is-the-difference-between-logstash-and-kibana-pipelines/283420 "2021-09-06T11:55:52Z")
Hi! I have always used logstash but I would like to know if it could be replaced by kibana pipelines or if using kibana pipelines has any limitations thanks in advance! --- ## [Database file changed error](https://discuss.elastic.co/t/database-file-changed-error/281903)
**Author:** [@acezeus](https://discuss.elastic.co/u/acezeus)\ **Replies:** 13\ **Last updated:** [September 6, 2021, 11:38am UTC](https://discuss.elastic.co/t/database-file-changed-error/281903 "2021-09-06T11:38:42Z")
hello, i installed the elastic search for the first time along with kibana. everything was working fine until i switched off my pc for the day and started it the next morning. now when i try to start elasticsearch by ty… --- ## [Installation seems to hang](https://discuss.elastic.co/t/installation-seems-to-hang/281116)
**Author:** [@D-Groenewegen](https://discuss.elastic.co/u/D-Groenewegen)\ **Replies:** 4\ **Last updated:** [September 6, 2021, 11:12am UTC](https://discuss.elastic.co/t/installation-seems-to-hang/281116 "2021-09-06T11:12:31Z")
Dear all, I hope you'll forgive me for my utter noobness. With the help of Install Elasticsearch from archive on Linux or MacOS | Elasticsearch Guide \[7.14\] | Elastic, I tried installing ES for Linux. When I got to step… --- ## [Replace the kibana logo?](https://discuss.elastic.co/t/replace-the-kibana-logo/27547)
**Author:** [@allenmchan](https://discuss.elastic.co/u/allenmchan)\ **Replies:** 60\ **Last updated:** [September 6, 2021, 10:33am UTC](https://discuss.elastic.co/t/replace-the-kibana-logo/27547 "2021-09-06T10:33:23Z")
Does anyone know if it is possible to replace the kibana logo with my company's logo? Only for corporate use. --- ## [Distance feature relevance score behaviour with boost \> 1](https://discuss.elastic.co/t/distance-feature-relevance-score-behaviour-with-boost-1/283386)
**Author:** [@Courtan](https://discuss.elastic.co/u/Courtan)\ **Replies:** 0\ **Last updated:** [September 5, 2021, 9:00pm UTC](https://discuss.elastic.co/t/distance-feature-relevance-score-behaviour-with-boost-1/283386 "2021-09-05T21:00:30Z")
Hello, I am confused about the calculation of relevance scores with distance\_feature. In the documentation it says that: The distance\_feature query calculates a document’s relevance score as follows: relevance score … --- ## [Date filter plugin doesn't take the timezone into account when using ISO8601](https://discuss.elastic.co/t/date-filter-plugin-doesnt-take-the-timezone-into-account-when-using-iso8601/283306)
**Author:** [@Jose\_E](https://discuss.elastic.co/u/Jose_E)\ **Replies:** 3\ **Last updated:** [September 6, 2021, 9:14am UTC](https://discuss.elastic.co/t/date-filter-plugin-doesnt-take-the-timezone-into-account-when-using-iso8601/283306 "2021-09-06T09:14:37Z")
Hi, I'm trying to normalize some timestamps into UTC from CEST, so far I've had no issues whatsoever except for when the parsed timestamp is already in ISO8601. At first, I wasn't sure whether the date-filter-plugin was… --- ## [Find all indices belonging to box type hot](https://discuss.elastic.co/t/find-all-indices-belonging-to-box-type-hot/283415)
**Author:** [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)\ **Replies:** 1\ **Last updated:** [September 6, 2021, 9:00am UTC](https://discuss.elastic.co/t/find-all-indices-belonging-to-box-type-hot/283415 "2021-09-06T09:00:55Z")
Is there an easy way to find all indices belonging to box type hot? I know that I can run GET /\_nodes/box\_type:hot to get all the nodes, and then maybe run a second step to find which node an index belong to, but I’m tr… --- ## [Min aggregation issue](https://discuss.elastic.co/t/min-aggregation-issue/283171)
**Author:** [@str8y](https://discuss.elastic.co/u/str8y)\ **Replies:** 3\ **Last updated:** [September 6, 2021, 8:46am UTC](https://discuss.elastic.co/t/min-aggregation-issue/283171 "2021-09-06T08:46:24Z")
If a min aggregation is used inside a terms aggregation, the result doesn't contain any buckets for the terms aggregation, as long as no mapping exists for the min aggregation field (e.g. there is no value for that field… --- ## [Query and sort inside nested object](https://discuss.elastic.co/t/query-and-sort-inside-nested-object/283404)
**Author:** [@Are](https://discuss.elastic.co/u/Are)\ **Replies:** 2\ **Last updated:** [September 6, 2021, 8:29am UTC](https://discuss.elastic.co/t/query-and-sort-inside-nested-object/283404 "2021-09-06T08:29:51Z")
Edit: see step-by-step and deeper explanation in post below. I am trying to sort my search results based on a field inside a nested object. Running ES 7.9. The mapping of the nested object looks like this: { "metaDate… --- ## [Sheduled Tasks](https://discuss.elastic.co/t/sheduled-tasks/281024)
**Author:** [@tractor\_boy](https://discuss.elastic.co/u/tractor_boy)\ **Replies:** 2\ **Last updated:** [September 6, 2021, 7:48am UTC](https://discuss.elastic.co/t/sheduled-tasks/281024 "2021-09-06T07:48:43Z")
Is it possible to identify the state of a scheduled task. Not reading the event log and seeing if something has been written recently. I need to go the scheduled task and see what its actual state is. Is this possible… --- ## [Utilisateur kibana règle de fonctionnement](https://discuss.elastic.co/t/utilisateur-kibana-regle-de-fonctionnement/283285)
**Author:** [@Greg\_Spr](https://discuss.elastic.co/u/Greg_Spr)\ **Replies:** 2\ **Last updated:** [September 6, 2021, 7:26am UTC](https://discuss.elastic.co/t/utilisateur-kibana-regle-de-fonctionnement/283285 "2021-09-06T07:26:42Z")
Bonjour, Je suis actuellement sur la version 7.9.2 Basic et je cherche a mettre en place une gestion de filtrage par utilisateur. Je m'explique, est ce qu'il est possible de mettre des règles pour un utilisateur sur la… --- ## [Nested aggregation referencing outer aggregation](https://discuss.elastic.co/t/nested-aggregation-referencing-outer-aggregation/283164)
**Author:** [@Jakob](https://discuss.elastic.co/u/Jakob)\ **Replies:** 2\ **Last updated:** [September 6, 2021, 6:29am UTC](https://discuss.elastic.co/t/nested-aggregation-referencing-outer-aggregation/283164 "2021-09-06T06:29:14Z")
I am learning about aggregations by looking at the "kibana\_sample\_data\_flights" index and I'm trying to find how many flights have the same weather on departure and arrival. Here is what I have so far: GET /kibana\_samp… --- ## [Why does es upgrade index data synchronously？](https://discuss.elastic.co/t/why-does-es-upgrade-index-data-synchronously/283226)
**Author:** [@jiankunking](https://discuss.elastic.co/u/jiankunking)\ **Replies:** 12\ **Last updated:** [September 6, 2021, 5:50am UTC](https://discuss.elastic.co/t/why-does-es-upgrade-index-data-synchronously/283226 "2021-09-06T05:50:32Z")
When I upgrade from 5.x to 7.x, I find that I cannot upgrade directly and need to reindex all index data. Why not update the index data automatically during the upgrade? --- ## [Index management](https://discuss.elastic.co/t/index-management/283393)
**Author:** [@alipujaistopo](https://discuss.elastic.co/u/alipujaistopo)\ **Replies:** 2\ **Last updated:** [September 6, 2021, 5:31am UTC](https://discuss.elastic.co/t/index-management/283393 "2021-09-06T05:31:53Z")
what does indices mean? and why do i have so many indices? and what is the difference between xxxx-000004 and xxxx-000005? here's my indices for example: \* winlogbeat-7.10.2-2021.08.22-000005 \* auditbeat-7.11.2-2021.0… --- ## ["Unable to connect to Elasticsearch. Error: \[search\_phase\_execution\_exception\] all shards failed"](https://discuss.elastic.co/t/unable-to-connect-to-elasticsearch-error-search-phase-execution-exception-all-shards-failed/283344)
**Author:** [@ShashikanthKomandoor](https://discuss.elastic.co/u/ShashikanthKomandoor)\ **Replies:** 1\ **Last updated:** [September 5, 2021, 10:22pm UTC](https://discuss.elastic.co/t/unable-to-connect-to-elasticsearch-error-search-phase-execution-exception-all-shards-failed/283344 "2021-09-05T22:22:02Z")
Hi Team, I have been running ELK Cluster of version 7.8 with 3 master nodes and 5 data nodes. I am running this on RHEL 7.5. I have installed httpd to proxy the requests to Kibana. I installed httpd, Kibana, Elasticsear… --- ## [Curl query to delete index patterns, and, parsefailures to stdout](https://discuss.elastic.co/t/curl-query-to-delete-index-patterns-and-parsefailures-to-stdout/280110)
**Author:** [@kriss332](https://discuss.elastic.co/u/kriss332)\ **Replies:** 6\ **Last updated:** [September 5, 2021, 6:35pm UTC](https://discuss.elastic.co/t/curl-query-to-delete-index-patterns-and-parsefailures-to-stdout/280110 "2021-09-05T18:35:38Z")
Hi all... I have 2 questions- I have created more than 150 index patterns based on the indexes I have. Yesterday I changed the names of indexes for better visibility. Now I need to delete all old index-patterns using… --- ## [Using memcached for logstash](https://discuss.elastic.co/t/using-memcached-for-logstash/283381)
**Author:** [@kriss332](https://discuss.elastic.co/u/kriss332)\ **Replies:** 0\ **Last updated:** [September 5, 2021, 5:57pm UTC](https://discuss.elastic.co/t/using-memcached-for-logstash/283381 "2021-09-05T17:57:12Z")
Hi all. I have to work with memcached for logstash to get the alerts about the destination IPs (belonging to C2 IPs) from my firewall's destination IPs. I have MISP for finding malicious/suspicious IPs about the traffic. … --- ## [Msip threat intel import not working](https://discuss.elastic.co/t/msip-threat-intel-import-not-working/283210)
**Author:** [@finbarr996](https://discuss.elastic.co/u/finbarr996)\ **Replies:** 2\ **Last updated:** [September 5, 2021, 6:05pm UTC](https://discuss.elastic.co/t/msip-threat-intel-import-not-working/283210 "2021-09-05T18:05:07Z")
I've edited the /etc/filebeat/modules.d/threatintel.yml and updated the entry for misp to enable it and also to add the API key from my local misp server. My config looks like this: misp: enabled: true var.in… [Previous page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=834) [Next page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=836)