SELECT * FROM Customers WHERE City IN ('Paris','London')
How to convert above query in elasticsearch..
3
-
Have a look at this!avr– avr2017-02-24 08:21:44 +00:00Commented Feb 24, 2017 at 8:21
-
Like this: stackoverflow.com/questions/16255416/…paqash– paqash2017-02-24 09:14:53 +00:00Commented Feb 24, 2017 at 9:14
-
1Possible duplicate of Query with multiple values on a property with one value in Elasticsearchpaqash– paqash2017-02-24 09:15:12 +00:00Commented Feb 24, 2017 at 9:15
Add a comment
|
2 Answers
You may use terms query
GET _search
{
"query" : {
"terms" : {
"city" : ["Paris", "London"]
}
}
}
However, please make sure that your mapping has city marked as not_analyzed
In order to make your searches case insensitive, there are two ways I can think of :
- lower case your terms while indexing as well as querying, this is an easy way.
- Create a custom analyzer for lowercase the input without tokenizing it. Use
match queryinstead ofterms query.Terms querydoesn't work onanalyzedfields.
A sample lowercase analyzer would look like this :
"analyzer": {
"lowercase_analyzer": {
"type": "custom",
"tokenizer": "keyword",
"filter": [
"lowercase",
"asciifolding"
]
}
}
4 Comments
Nirdesh
After mapping not_analyzed then search don't work as a case incensitive.How to resolve it..thanks for your reply
Rahul
Updated the answer for the same.
Nirdesh
$results=$client->search([ 'index' => 'morsol', 'type' => 'ms_emp_db', 'body' => [ 'query' => [ "multi_match" => [ "fields" => ["colmun1","column2"], "query" => $searchKeyword, "type" => "phrase_prefix" ] ] ] ]); i am using laravel and elasticsearch.column1 and column2 is not_analyzed..how to search case insensitive.
Rahul
Please refer to : stackoverflow.com/questions/24036708/…
Your query should look like:
The POST request:
http://localhost:9200/Customers/_search? <--assuming customers as your index
and the request BODY:
"query":{
"query_string":{
"query":"City:(Paris London)"
}
}
IN acts like : in ES. Hope this helps!
