Questions tagged [elasticsearch]
A distributed full text search database, which internally uses Lucene.
28
questions
0
votes
0answers
13 views
Best database for indexing [on hold]
I am using an elastic cluster to store a few hundred GBs of data.
Sometimes, I have to make searches on the data in the form of 3rd level indexes.
Let's say that I have a table of gender, age, past ...
0
votes
0answers
17 views
Postgres, use via elasticsearch, in php, how to? [on hold]
What is the simplest way to use elasticsearch for postgresql, for example for searching on the web in php?
I browse internet for 2 days, but I still don't understand how is elasticsearch exactly ...
0
votes
0answers
10 views
Difference between index and update with doc_as_upsert
I am trying to find out what is the difference between using "index" versus using "update with doc_as_upsert set to true".
Which one is better from a performance perspective?
Thank you
0
votes
1answer
31 views
Use data from Mysql to ElasticSearch with Logstash
I'm using logstash for use my mysql database in ElasticSearch
My conf is the next.
input {
jdbc {
jdbc_connection_string => "jdbc:mysql://[ip]:3306/nextline_dev"
jdbc_user =&...
0
votes
0answers
16 views
Elasticsearch - Need to improve cluster performance, (sock hang up) happening a lot
We have Elasticsearch cluster of 3 nodes where 1 node is dedicated master and 2 nodes are dedicated data nodes. we have around 200GB of data on server and heavy _bulk and _search operations. The nodes ...
1
vote
2answers
45 views
NoSQL or MySQL for storing API usage
I need to be able to track API usage in order to generate reports or charts later. I've been struggling to decide whether to use regular MySQL or something like MongoDB or Elastic Search which I don't ...
1
vote
0answers
9 views
Elastic: Are Analyzers only for `text` type fields?
Most of the documentation about Elastic Analyzers assumes that you NEED an Analyzer and so the documentation talks mostly about how Analyzers work and the differences between the different Analyzers.
...
0
votes
1answer
288 views
ElasticSearch - Daily index mapping
Let's say i have an Index and I am want to create a daily index with an aliases.
Then I have some application that works against the elastic search(Mostly adding new documents to the index) and I am ...
0
votes
0answers
12 views
Elasticsearch exceeded low water mark on only one node
I get only this done filed up to 89% and not any other nodes. Do we need to change any settings. We are in ES 2.3. We totally have 31 datanodes.
[2018-09-06 13:01:03,723][INFO ][cluster.routing....
7
votes
1answer
693 views
Combine relational DB and Elastic search
We have a large quanitity of text files we want to free-text/full text search, combined with relational structured metadata about the text file.
So, a search could be "Give me all files that belong to ...
1
vote
1answer
591 views
How to insert several csv files into Elasticsearch?
I have several csv files on university courses that all seem linked by an ID, that you can find here, and I wondered how to put them on Elasticsearch. I know, thanks to this video and Logstash, how to ...
-1
votes
1answer
91 views
Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)
I am hoping some of you highly skilled DBAs can provide some insight as to the best DB to use for this dataset.
This is a relatively simple dataset with no relationship needed between the entries. ...
1
vote
1answer
2k views
change analyzer for an elasticsearch index?
I'd like to change the analyzer for an existing index in ElasticSearch, but I can't figure out the syntax (and I'm not grokking the error message).
GET /ccc_test/_mapping
{
"ccc_test": {
"...
1
vote
1answer
730 views
JDBC Sqlserver to elastic search : one input to different output?
I have a sqlserver2016 database that I want to index in elasticsearch using logstash.
Here is my logstash config file which somewhat works :
input {
jdbc {
jdbc_driver_library => "C:\elastic\...
2
votes
2answers
484 views
How we can do full text search and facets stuffs on BigQuery?
In the future, we will have millions ofs record in our web product. So we had used BigQuery for data storage and analysis. We have to build filters on our search page like Flipkart and Amazon provide ...
1
vote
0answers
314 views
Architecture alternatives to solve large table issues in Postgres 9.0
We use PostgreSQL 9.0 for our application and there is a table called events with a lot of metadata columns about event itself. The most important is resource_id that tells for which resource is ...
1
vote
0answers
68 views
Is it possible to use Kibi with Elasticsearch 5.2?
We are in the process of migrating our MSSQL database to an elasticsearch platform, and have run into the (apparently common) problem of many parents to one child relationship, when trying to access ...
0
votes
1answer
633 views
Synchronize between two elastic-search for redundancy
I am new to all the DB and therefore also to ElasticSearch.
I got a project where I have to connect two Elastic Search DBs from two different IPs for redundancy. I searched google and https://www....
-1
votes
2answers
215 views
MongoDB or ElasticSearch
Which one of them is good to use? I'm developing a application which will have the following functionalities.
Multiple users
Each user will have their own database
Data objects will be different; ...
1
vote
1answer
267 views
Dedicated tables VS Multipurpose Tables
I am developing a forum like app using a MySQL database. I have posts, comments and replies just any other forum.
At the moment I have a table for posts, a table for comments/replies and a table for ...
2
votes
1answer
95 views
On Elasticsearch, what is the required response for a directory URL of a HTTP URL repository?
The official document of Elasticsearch says we can use URL as a setting of Read-only repository. The document also says several protocols, including HTTP, is supported for the URL. (refer: https://www....
0
votes
1answer
137 views
How to add complex calculations to Elastic Search
I'm using elastic search to index large amounts of sensor data for analytics purposes. The table has 4 million + rows and growing fast - expecting 40 million within the next year. This makes Elastic ...
3
votes
1answer
4k views
Kibana-like tool for PosgreSQL [closed]
I'm looking for a tool that could browse and visualize data from db like Kibana does.
I'd prefer a native Posgres tool to any that transfers data from a db somewhere else. I know that rivers for ...
0
votes
2answers
1k views
Tracking the update or changes in mysql table
I need to stream the changes to elasticsearch to keep in sync with my database(mysql).
What will be best way to do this ? I have thought for below approaches
Using trigger( but my table will have ...
1
vote
2answers
161 views
ElasticSearch: is this problem suitable for ElasticSearch DB? [closed]
I have some hardware instruments each one recording a signal and generating sequences of timestamp/value pairs. Timestamp is a basic UTC posix time and value is a double.
I'd like to record such ...
1
vote
1answer
242 views
Elasticsearch and product characteristics
I have a small question about elasticsearch. Let's say I have a database with products to sell, like an ecommerce.
I know that elasticsearch can help me to find the best product with, for instance a ...
1
vote
1answer
1k views
Elasticsearch: Versioning a document on revisions
I currently have a document which gets revised regularly, I want to keep track of the document by keeping each old version of the document. So if document A has a summary and update date I want to, ...
1
vote
1answer
390 views
structure when storing books in elasticsearch
I want to use elasticsearch as a web search engine for books. A book has several editions with different titles in different languages, ISBN's as well as author names in different languages. I want ...
