Create Elasticsearch curl query for not null and not empty(“”)

A null value and an empty string both result in no value being indexed, in which case you can use the exists filter curl -XGET ‘http://127.0.0.1:9200/test/test/_search?pretty=1’ -d ‘ { “query” : { “constant_score” : { “filter” : { “exists” : { “field” : “myfield” } } } } } ‘ Or in combination with (eg) … Read more

Redis Vs RabbitMQ as a data broker/messaging system in between Logstash and elasticsearch [closed]

After evaluating both Redis and RabbitMQ I chose RabbitMQ as our broker for the following reasons: RabbitMQ allows you to use a built in layer of security by using SSL certificates to encrypt the data that you are sending to the broker and it means that no one will sniff your data and have access … Read more

no [query] registered for [filtered]

The filtered query has been deprecated and removed in ES 5.0. You should now use the bool/must/filter query instead. { “query”: { “bool”: { “must”: { “multi_match”: { “operator”: “and”, “fields”: [ “author”, “title”, “publisher”, “year” ], “query”: “George Orwell” } }, “filter”: { “terms”: { “year”: [ 1980, 1981 ] } } } } … Read more

how to move elasticsearch data from one server to another

The selected answer makes it sound slightly more complex than it is, the following is what you need (install npm first on your system). npm install -g elasticdump elasticdump –input=http://mysrc.com:9200/my_index –output=http://mydest.com:9200/my_index –type=mapping elasticdump –input=http://mysrc.com:9200/my_index –output=http://mydest.com:9200/my_index –type=data You can skip the first elasticdump command for subsequent copies if the mappings remain constant. I have just done … Read more

Elasticsearch vs Cassandra vs Elasticsearch with Cassandra

One of our applications uses data that is stored into both Cassandra and ElasticSearch. We use Cassandra to access those records whenever we can, and have data duplicated into query tables designed to adhere to specific application-side requests. For a more liberal search than our query tables can allow, ElasticSearch performs that functionality nicely. We … Read more

What are some use cases for using Elasticsearch versus standard sql queries? [closed]

There are two primary Elasticsearch use cases: Text search You want Elasticsearch when you’re doing a lot of text search, where traditional RDBMS databases are not performing really well (poor configuration, acts as a black-box, poor performance). Elasticsearch is highly customizable, extendable through plugins. You can build robust search without much knowledge quite fast. Logging … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)