Could someone help me please with next question, I created custom analyzer:
create ANALYZER bankruptcies_ngram_and_synonym ( TOKENIZER CustomTokenizer with (type='ngram', min_gram=2, max_gram=2, token_chars=['letter']), TOKEN_FILTERS (my_synonyms WITH (type='synonym', synonyms_path='synonyms.txt'), lowercase, kstem) );
but it is not work well, when I populated and run this:
select * from <my table> WHERE MATCH (firstname,'WILLIMA') AND STATE = 'NY' limit 100;
select * from bankruptcies.bankruptcies WHERE MATCH (firstname,'william') AND STATE = 'NY' limit 100;
I got no hit, but this data 100% exist in this table and this looks like lowercase and ngram not work. Maybe I did this analyzer wrong or I should to do additional steps or something else?