Wild card query with case insensitive search


(Sagar Shah) #1

Hello everyone,
We are trying to replace application log storage from postgres db with
elastic search.
We had two features in postgres that should not get affected.

  1. Perform case insensitive search
  2. Perform wild card search

In elastic search, we are using lowercase filter with keyword anlayzer to
meet point# 1.
For performing wild card search, we are using wildQuery (ES Java API).

Everything looks file as long as I am searching for single word like
'sagar', but searches fail to return any results when I use multiple words
in my search criteria like 'sagar shah'. That's probably because of keyword
analyzer, which breaks it into multiple words.

Is there a way to perform search a wild card type search in
case-insensitive format.

Please advise.
Appreciate your inputs.

Regards,
Sagar Shah

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/48b9228e-9cd0-4dc8-b4f2-3e5a5d24ddf9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(David Pilato) #2

Don't use wildcard query unless you want it to be "slow".
Prefer using ngrams based analyzers (will cost you more disk space).

HTH

David

Le 26 mai 2015 à 22:29, Sagar Shah sagarshah1983@gmail.com a écrit :

Hello everyone,
We are trying to replace application log storage from postgres db with elastic search.
We had two features in postgres that should not get affected.

  1. Perform case insensitive search
  2. Perform wild card search

In elastic search, we are using lowercase filter with keyword anlayzer to meet point# 1.
For performing wild card search, we are using wildQuery (ES Java API).

Everything looks file as long as I am searching for single word like 'sagar', but searches fail to return any results when I use multiple words in my search criteria like 'sagar shah'. That's probably because of keyword analyzer, which breaks it into multiple words.

Is there a way to perform search a wild card type search in case-insensitive format.

Please advise.
Appreciate your inputs.

Regards,
Sagar Shah

Please update your bookmarks! We have moved to https://discuss.elastic.co/

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/48b9228e-9cd0-4dc8-b4f2-3e5a5d24ddf9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/AFA7CBFD-AFF9-421F-88EB-A67C67A65AB7%40pilato.fr.
For more options, visit https://groups.google.com/d/optout.


(system) #3