# Elastic Search **URL:** https://discuss.elastic.co/c/search/84.md?page=18 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 19 --- ## [IDs Query Performance Problems](https://discuss.elastic.co/t/ids-query-performance-problems/359391)
**Author:** [@yottabyte](https://discuss.elastic.co/u/yottabyte)\ **Replies:** 4\ **Last updated:** [May 13, 2024, 4:36pm UTC](https://discuss.elastic.co/t/ids-query-performance-problems/359391 "2024-05-13T16:36:20Z")
Hello, I have documents with the same ids (guid) split across indices in my system. When a search is run across indices, I join them in my client code. This is done using IDs queries: IDs | Elasticsearch Guide \[8.13\] | … --- ## [AppSearch using few features throwing error 502 when CPU consumption increases](https://discuss.elastic.co/t/appsearch-using-few-features-throwing-error-502-when-cpu-consumption-increases/359332)
**Author:** [@aa1t](https://discuss.elastic.co/u/aa1t)\ **Replies:** 1\ **Last updated:** [May 13, 2024, 7:38am UTC](https://discuss.elastic.co/t/appsearch-using-few-features-throwing-error-502-when-cpu-consumption-increases/359332 "2024-05-13T07:38:47Z")
Hello everybody! I'm using AppSearch as a search engine for the production environment of my marketplace, hosted in docker, same as the single instance Elastic Search. I'm not using appsearch logs, alias, boosts, etc..… --- ## [Optimizing Elastic-Agent Performance](https://discuss.elastic.co/t/optimizing-elastic-agent-performance/359322)
**Author:** [@wangsubo](https://discuss.elastic.co/u/wangsubo)\ **Replies:** 4\ **Last updated:** [May 12, 2024, 3:07pm UTC](https://discuss.elastic.co/t/optimizing-elastic-agent-performance/359322 "2024-05-12T15:07:05Z")
I am currently evaluating the use of ELK to collect Checkpoint data. On a VM, I have a QRadar Event Collector and an Elastic-Agent, both configured with 8 cores, 8GB RAM, and HDD. Checkpoint logs are being sent at a rat… --- ## [Elastic Search Connector Fails on ca\_certs config when running in Docker](https://discuss.elastic.co/t/elastic-search-connector-fails-on-ca-certs-config-when-running-in-docker/358996)
**Author:** [@Matt\_Crysler](https://discuss.elastic.co/u/Matt_Crysler)\ **Replies:** 13\ **Last updated:** [May 10, 2024, 9:38am UTC](https://discuss.elastic.co/t/elastic-search-connector-fails-on-ca-certs-config-when-running-in-docker/358996 "2024-05-10T09:38:54Z")
Rather than retype the entire issue, the following topic is exactly what I am running into with no resolution. I have tried everything with no luck! Can someone PLEASE respond with something that has worked for them? Tha… --- ## [AppSearch synonyms](https://discuss.elastic.co/t/appsearch-synonyms/359143)
**Author:** [@Cong\_Hoang](https://discuss.elastic.co/u/Cong_Hoang)\ **Replies:** 1\ **Last updated:** [May 9, 2024, 12:35pm UTC](https://discuss.elastic.co/t/appsearch-synonyms/359143 "2024-05-09T12:35:18Z")
Hello Team, I'm using AppSearch 8.12 and I want to know all about AppSearch synonyms. So I have questions, can help me? : Appsearch can have synonyms API for one direction as Elasticsearch done, example : "car =\> tru… --- ## [How to customize "crawl\_config" parameters for web crawler](https://discuss.elastic.co/t/how-to-customize-crawl-config-parameters-for-web-crawler/359024)
**Author:** [@Martin\_BR](https://discuss.elastic.co/u/Martin_BR)\ **Replies:** 2\ **Last updated:** [May 8, 2024, 2:39pm UTC](https://discuss.elastic.co/t/how-to-customize-crawl-config-parameters-for-web-crawler/359024 "2024-05-08T14:39:10Z")
Hi, We are currently building a search application based on web crawler. We are facing some difficulties to customize the "crawl\_config". "crawl\_config": { "crawl\_rules": \[ { "policy": "allow", … --- ## [Change size in Preview on the Relevance Tuning](https://discuss.elastic.co/t/change-size-in-preview-on-the-relevance-tuning/359027)
**Author:** [@hung\_dinh](https://discuss.elastic.co/u/hung_dinh)\ **Replies:** 2\ **Last updated:** [May 8, 2024, 12:29pm UTC](https://discuss.elastic.co/t/change-size-in-preview-on-the-relevance-tuning/359027 "2024-05-08T12:29:09Z")
hi, I am a newbie. When I search in the preview on the Relevance Tuning, it shows only 10 documents. Is there any way to change the limit to 30? --- ## [Is it possible to apply document-level permissions to Google Drive synchronized documents?](https://discuss.elastic.co/t/is-it-possible-to-apply-document-level-permissions-to-google-drive-synchronized-documents/358922)
**Author:** [@m-amano](https://discuss.elastic.co/u/m-amano)\ **Replies:** 5\ **Last updated:** [May 8, 2024, 8:38am UTC](https://discuss.elastic.co/t/is-it-possible-to-apply-document-level-permissions-to-google-drive-synchronized-documents/358922 "2024-05-08T08:38:22Z")
Hello. I'm using WorkplaceSearch of v.8.12.0 Elastic Cloud. I have connected WorkplaceSearch and Google Drive with Google Drive connector. Is there a way to give the WorkplaceSearch user the same permission as the Go… --- ## [Add an external identity API looks like it does not work](https://discuss.elastic.co/t/add-an-external-identity-api-looks-like-it-does-not-work/359003)
**Author:** [@m-amano](https://discuss.elastic.co/u/m-amano)\ **Replies:** 1\ **Last updated:** [May 8, 2024, 8:32am UTC](https://discuss.elastic.co/t/add-an-external-identity-api-looks-like-it-does-not-work/359003 "2024-05-08T08:32:51Z")
I'm using WorkplaceSearch of v.8.12.0 Elastic Cloud. I have connected WorkplaceSearch and Google Drive with Google Drive connector. I tried \[this API \] to give Elastic users document-level permission (External Identiti… --- ## [Is there API to create a new Elastic user to workplace Search?](https://discuss.elastic.co/t/is-there-api-to-create-a-new-elastic-user-to-workplace-search/358950)
**Author:** [@m-amano](https://discuss.elastic.co/u/m-amano)\ **Replies:** 3\ **Last updated:** [May 7, 2024, 7:04pm UTC](https://discuss.elastic.co/t/is-there-api-to-create-a-new-elastic-user-to-workplace-search/358950 "2024-05-07T19:04:35Z")
Hi. I have a question if there is an API to create Elastic users to workplace Search. Therefore I don't have to create a user one by one via console. --- ## [How to get the synchronized new file information of WorkplaceSearch?](https://discuss.elastic.co/t/how-to-get-the-synchronized-new-file-information-of-workplacesearch/358889)
**Author:** [@m-amano](https://discuss.elastic.co/u/m-amano)\ **Replies:** 1\ **Last updated:** [May 7, 2024, 9:21am UTC](https://discuss.elastic.co/t/how-to-get-the-synchronized-new-file-information-of-workplacesearch/358889 "2024-05-07T09:21:48Z")
Hello. I'm using WorkplaceSearch of v.8.12.0 Elastic Cloud. I managed to get the last runtime of content source synchronization with this code. POST \/api/ws/v1/sources/\ N… --- ## [React with elastic search api connector returns all documents](https://discuss.elastic.co/t/react-with-elastic-search-api-connector-returns-all-documents/358863)
**Author:** [@Gordon\_Vidaver](https://discuss.elastic.co/u/Gordon_Vidaver)\ **Replies:** 0\ **Last updated:** [May 6, 2024, 4:59pm UTC](https://discuss.elastic.co/t/react-with-elastic-search-api-connector-returns-all-documents/358863 "2024-05-06T16:59:08Z")
I'm using the react-search-ui library and the ElasticsearchAPIConnector. If I type in a search term, I get all the documents in the index back, sorted with the hits at the top. In the examples it only returns the documen… --- ## [Load multiple tables from psql to elastic search](https://discuss.elastic.co/t/load-multiple-tables-from-psql-to-elastic-search/358804)
**Author:** [@Rajesh03](https://discuss.elastic.co/u/Rajesh03)\ **Replies:** 5\ **Last updated:** [May 6, 2024, 2:56pm UTC](https://discuss.elastic.co/t/load-multiple-tables-from-psql-to-elastic-search/358804 "2024-05-06T14:56:36Z")
I have a config file like this: input { jdbc { jdbc\_connection\_string =\> "jdbc:postgresql://localhost:5432/mydb" jdbc\_user =\> "postgres" jdbc\_driver\_library =\> "/path/to/postgresql-9.4-1201.j… --- ## [Workplace SF connector fail "Unable to load page"](https://discuss.elastic.co/t/workplace-sf-connector-fail-unable-to-load-page/358664)
**Author:** [@Nokki123123](https://discuss.elastic.co/u/Nokki123123)\ **Replies:** 3\ **Last updated:** [May 6, 2024, 10:22am UTC](https://discuss.elastic.co/t/workplace-sf-connector-fail-unable-to-load-page/358664 "2024-05-06T10:22:19Z")
Hi Team, After we succeed to sync Sharepoint with Elastic workspace I'm trying to connect Salesforce with no success. We getting "Unable to load page" and the URL - https://elastic.xxxxx.com:xxxx/app/enterprise\_sear… --- ## [Confluence server ver 7.17](https://discuss.elastic.co/t/confluence-server-ver-7-17/358799)
**Author:** [@Nokki123123](https://discuss.elastic.co/u/Nokki123123)\ **Replies:** 1\ **Last updated:** [May 6, 2024, 9:24am UTC](https://discuss.elastic.co/t/confluence-server-ver-7-17/358799 "2024-05-06T09:24:03Z")
Hi, we are trying to connect confluence server via workspace. with no success. Our confluence version is 7.17.4. Does Elastic support this version? Thank you, Noam --- ## [Confluence Connector syncing limited pages](https://discuss.elastic.co/t/confluence-connector-syncing-limited-pages/358708)
**Author:** [@Adhish\_Thite](https://discuss.elastic.co/u/Adhish_Thite)\ **Replies:** 1\ **Last updated:** [May 6, 2024, 9:15am UTC](https://discuss.elastic.co/t/confluence-connector-syncing-limited-pages/358708 "2024-05-06T09:15:43Z")
Context I have created a Confluence Cloud connector, and I want to ingest documents from a specific space called, say, ZZZZ in my index. Problem On Confluence, the ZZZZ space has 1000+ documents. However, when the sync … --- ## [How to delete index document after 30 days?](https://discuss.elastic.co/t/how-to-delete-index-document-after-30-days/358761)
**Author:** [@Kishor\_Patidar](https://discuss.elastic.co/u/Kishor_Patidar)\ **Replies:** 3\ **Last updated:** [May 5, 2024, 5:34pm UTC](https://discuss.elastic.co/t/how-to-delete-index-document-after-30-days/358761 "2024-05-05T17:34:59Z")
I'm working with AWS OpenSearch and tried to implement an Index State Management (ISM) policy to delete documents that are older than 30 days. However, the policy ended up deleting the entire index, not just the aged doc… --- ## [Advice on user correlation / enrichment](https://discuss.elastic.co/t/advice-on-user-correlation-enrichment/358733)
**Author:** [@David\_Lam](https://discuss.elastic.co/u/David_Lam)\ **Replies:** 0\ **Last updated:** [May 4, 2024, 12:39am UTC](https://discuss.elastic.co/t/advice-on-user-correlation-enrichment/358733 "2024-05-04T00:39:04Z")
Hey all. I am currently onboarding new log sources onto our new Elastic instance, and there was something that I was thinking about and trying to figure out how/if it would work in Elastic. The issue is that there are … --- ## [How to query multiple hosts?](https://discuss.elastic.co/t/how-to-query-multiple-hosts/358596)
**Author:** [@MelasticSan](https://discuss.elastic.co/u/MelasticSan)\ **Replies:** 1\ **Last updated:** [May 2, 2024, 9:09am UTC](https://discuss.elastic.co/t/how-to-query-multiple-hosts/358596 "2024-05-02T09:09:12Z")
Often times we upgrade the agents and want to validate if we are receiving data from a particular host into the Kibana dashboard . Is there a simple quick query that can show data for last 1 hour . I tried something lik… --- ## [Error: BadRequestError(400, 'parsing\_exception', 'Unknown key for a START\_OBJECT in \[knn\].')](https://discuss.elastic.co/t/error-badrequesterror-400-parsing-exception-unknown-key-for-a-start-object-in-knn/358551)
**Author:** [@Sharmishtha\_Paliwal](https://discuss.elastic.co/u/Sharmishtha_Paliwal)\ **Replies:** 2\ **Last updated:** [May 1, 2024, 2:42pm UTC](https://discuss.elastic.co/t/error-badrequesterror-400-parsing-exception-unknown-key-for-a-start-object-in-knn/358551 "2024-05-01T14:42:10Z")
I am not able to figure to this issue response = es.search(index="cv\_resume\_dense",query= { "match": { "work\_experience": { "query": query, "boost": 0.9 }, }, }, knn= { "field": "vector\_skills", "query\_vector"… --- ## [How can use filter and except a number](https://discuss.elastic.co/t/how-can-use-filter-and-except-a-number/358562)
**Author:** [@baber1223](https://discuss.elastic.co/u/baber1223)\ **Replies:** 3\ **Last updated:** [May 1, 2024, 1:31pm UTC](https://discuss.elastic.co/t/how-can-use-filter-and-except-a-number/358562 "2024-05-01T13:31:49Z")
This my log sample : 172.20.100.100 - - \[01/May/2024:16:08:12 +0330\] "POST /serve/digiPay/requestStatus HTTP/1.0" 200 134 "-" "Java/17.0.6" process-time:644 session-id: - 172.20.100.100 - - \[01/May/2024:16:08:13 +0330\]… --- ## [Search times too long on a big index](https://discuss.elastic.co/t/search-times-too-long-on-a-big-index/358475)
**Author:** [@gius\_alt\_01](https://discuss.elastic.co/u/gius_alt_01)\ **Replies:** 4\ **Last updated:** [April 30, 2024, 4:59pm UTC](https://discuss.elastic.co/t/search-times-too-long-on-a-big-index/358475 "2024-04-30T16:59:12Z")
On one environment we have too high query execution times (greater than 10 seconds). The query is as follows: {"query": { "bool": { "filter": \[{"terms": {"id": \[237601\]}}\], "must": \[ { … --- ## [Inquiry on Connectors to pull Stored Procedure](https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465)
**Author:** [@aisyaharifin](https://discuss.elastic.co/u/aisyaharifin)\ **Replies:** 2\ **Last updated:** [April 30, 2024, 1:10pm UTC](https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465 "2024-04-30T13:10:48Z")
Hello Elastic, I want to ask, can Microsoft SQL Connectors able to query directly to pull data from stored procedure? The stored procedure will pull direct from the tables and in total we have 7 tables. Thank you. --- ## [Poor knn results from \*some\* nodes](https://discuss.elastic.co/t/poor-knn-results-from-some-nodes/358239)
**Author:** [@peedeeboy](https://discuss.elastic.co/u/peedeeboy)\ **Replies:** 6\ **Last updated:** [April 29, 2024, 7:33pm UTC](https://discuss.elastic.co/t/poor-knn-results-from-some-nodes/358239 "2024-04-29T19:33:05Z")
For customer requests we currently run two searches - a classic keyword search, and a knn search on a dense vector field. We calculate the query vector outside of ES and we have our own function to calculate final score… --- ## [Error while searching over dense vector](https://discuss.elastic.co/t/error-while-searching-over-dense-vector/358374)
**Author:** [@hiwora1211](https://discuss.elastic.co/u/hiwora1211)\ **Replies:** 1\ **Last updated:** [April 29, 2024, 2:02am UTC](https://discuss.elastic.co/t/error-while-searching-over-dense-vector/358374 "2024-04-29T02:02:19Z")
Hello , while doing query on my embedding field with this mapping :slight\_smile: "keywordsEmbedding": { "type": "dense\_vector", "dims": 1536 }, and this query : GET /my\_index/\_search { … --- ## [Issue with Compression Not Working in Elastic Agent](https://discuss.elastic.co/t/issue-with-compression-not-working-in-elastic-agent/358343)
**Author:** [@wangsubo](https://discuss.elastic.co/u/wangsubo)\ **Replies:** 3\ **Last updated:** [April 27, 2024, 3:16pm UTC](https://discuss.elastic.co/t/issue-with-compression-not-working-in-elastic-agent/358343 "2024-04-27T15:16:08Z")
I am using Elastic Agent to collect data from Fortigate. In order to reduce storage space, I have set compression\_level: 5 in elastic-agent.yml. outputs: default: type: elasticsearch hosts: \[xxx.xxx.xxx.xxx:9200\] ap… --- ## [Can I use ILM to switch index\_code to DEFLATE after 40 days ？](https://discuss.elastic.co/t/can-i-use-ilm-to-switch-index-code-to-deflate-after-40-days/358272)
**Author:** [@wangsubo](https://discuss.elastic.co/u/wangsubo)\ **Replies:** 1\ **Last updated:** [April 26, 2024, 7:53am UTC](https://discuss.elastic.co/t/can-i-use-ilm-to-switch-index-code-to-deflate-after-40-days/358272 "2024-04-26T07:53:35Z")
Within 40 days, I plan to utilize LZ4 for fast compression and decompression - Hot Node. After exceeding 40 days, switching to DEFLATE (high compression ratio) can effectively reduce storage space - Warm Node. Can Inde… --- ## [Get the major version of an index](https://discuss.elastic.co/t/get-the-major-version-of-an-index/357781)
**Author:** [@staubt](https://discuss.elastic.co/u/staubt)\ **Replies:** 2\ **Last updated:** [April 26, 2024, 7:39am UTC](https://discuss.elastic.co/t/get-the-major-version-of-an-index/357781 "2024-04-26T07:39:45Z")
Hello I need to get the major version of an index. So before I used indexName/\_settings?human=true. And in the result I parsed the "created\_string" from version. There I took the number before the fist dot. Now with … --- ## [Prefix query on fields mapped as keyword](https://discuss.elastic.co/t/prefix-query-on-fields-mapped-as-keyword/355111)
**Author:** [@india](https://discuss.elastic.co/u/india)\ **Replies:** 5\ **Last updated:** [April 24, 2024, 6:59pm UTC](https://discuss.elastic.co/t/prefix-query-on-fields-mapped-as-keyword/355111 "2024-04-24T18:59:53Z")
Hello, I use Elasticsearch version 7.17. In a Elasticsearch blog post ( Find strings within strings faster with the Elasticsearch wildcard field | Elastic Blog ) it's mentioned that keyword fields can offer better perf… --- ## [Elastic search sub\_searches with knn and rrf](https://discuss.elastic.co/t/elastic-search-sub-searches-with-knn-and-rrf/357804)
**Author:** [@avranjan](https://discuss.elastic.co/u/avranjan)\ **Replies:** 3\ **Last updated:** [April 24, 2024, 6:37pm UTC](https://discuss.elastic.co/t/elastic-search-sub-searches-with-knn-and-rrf/357804 "2024-04-24T18:37:39Z")
Is there an example to use sub\_searches with knn? Why the k value is not allowed in query? Here is an example: { "\_source": {"excludes": \["vector", "elser\_vector"\]}, "size": 1000,… [Previous page](https://discuss.elastic.co/c/search/84.md?page=17) [Next page](https://discuss.elastic.co/c/search/84.md?page=19)