In evaluating ES as a replacement for our current brute force SQL
search strategy, I need to verify that I can do the following searches
in ES (although I realize this perhaps relates more to Lucene?).
When searching on string value columns in the DB, we offer the
following in our search interface:
- Contains any of - this is a whitespace tokenizer search that does
an OR between the various tokens
- Contains all of - this is a whitespace tokenizer search that does
an AND between the various tokens
- Contains exactly - this is a whitespace tokenizer that checks that
the entire column value matches exactly the token given
- Does not contain - this is a whitespace tokenizer that ensures that
an entity does not contain the given value
#'s 3 and 4 are the main ones I need to verify here. Will those
searches be possible in Lucene vernacular, via ES?