Questions tagged [elasticsearch]
A distributed full text search database, which internally uses Lucene.
37 questions
0 votes
0 answers
15 views
reset elasticsearch node
I know you can delete the data directory on a percona cluster server, and then let it join the cluster again. This will result in a full transfer of data; this has been useful a couple of times. Is ...
- 1
0 votes
1 answer
56 views
Database / Search-Index recommendation: Match time ranges from different categories
300k+ videos 10+ millions of markers, pointing to timeranges in videos { "markerCategory": "something", "markerDesc": "something-more-specific", "...
- 103
1 vote
0 answers
223 views
How to use things like Elasticsearch, Meilisearch, etc. alongside a main database (e.g. PostgreSQL)?
I could be missing something obvious because this seems like a fairly basic question, but I haven't been able to find any explicit guidance anywhere on how to integrate Meilisearch/Elasticsearch with ...
- 131
1 vote
0 answers
81 views
Disabling SSL in ElasticSearch and enrolling new nodes
I am trying to start an elasticsearch container with SSL disabled as I want it to be hosted at http://localhost:9200 (not https). With this I want the ability to enroll new nodes. But as I disable the ...
0 votes
1 answer
1k views
How to get current date and time in Elasticsearch
I need to review the current date and time zone from Elasticsearch. I'm checking the elastic documentation and it mentioned that the default value is UTC. In other environments I use: SELECT NOW(); ...
- 47
1 vote
1 answer
471 views
Secondary indexes vs Using elastic search
When does it make sense to put data in elastic search vs creating secondary indexing on Primary datastore? Elastic search with another primary store Pros: Primary datastore can be optimised for read ...
- 113
0 votes
1 answer
483 views
Developing a database to store 100-dimensional image embeddings along with their paths
Suppose we want to design a database to store images represented in a vector format (each image is stored as a 100-dimensional vector). The goal here is to store image embeddings along with their ...
- 109
0 votes
1 answer
50 views
Are the Informix and Lucene analyzers similar?
Is the analyzer discussed here same as Lucene analyzers? I am confused because most of them show similar properties to Lucene analyzer but the blog posts don't say a word about Lucene; instead they ...
- 13
-1 votes
1 answer
67 views
Room availability [closed]
I was wondering what would the best way to manage availability for rooms or beds like in a hostel (Saas). I was thinking about using MySQL and Elasticsearch. What would be the best schema for the ...
- 1
0 votes
0 answers
289 views
Store Elasticsearch shards in separate partitions on data node
I have an Elasticsearch cluster configured with one head node and three data nodes with the number of replicas set to 2. The data nodes are each split into three partitions called /data1 /data2 and /...
- 291
5 votes
4 answers
727 views
Database events but not triggers
This is a question regarding general DB inner workings, not particular to an implementation or paradigm, though answers for certain technologies are welcome. I am asking if there is a way to listen to ...
0 votes
1 answer
34 views
Help needed with several engines use case [closed]
We are developing an app, aprox 50k RPM read, 1k RPM write, it ask via key and get a JSON. The search is always made by key. I'm inclined to use one MySQL 8 table with a Id field and JSON field with ...
- 113
0 votes
1 answer
2k views
Delete unassigned shards in Elasticsearch
I had an elasticsearch server, which ran in single node mode. When dataset reached 1TB, I added second node and relocated couple of shards with reroute api. Now second node has 2 of 5 shards, but ...
- 123
-1 votes
2 answers
403 views
Which database to use when you have a 6 billion of rows inside and need to query rows with from list of IDs? [closed]
We are currently researching our case of storing the road distances between cities. Right now we have 6 billion of those distances. Our structure right now in SQL Server is that we have a float which ...
1 vote
1 answer
269 views
Query customers attributes
I need to create a system where the user creates dynamic filters based on our customer's attributes. There are more or less 30 possible filters and 30 millions of customers, but the number of customer ...
- 11