Now when I run this query m getting hit as null even though there are documents with 036-192.Looks like it's including * also in the search term because of special character - in 036-192
please take yourself some time and read the Search in depth in the definitive guide to make sure you understand how full text search in Elasticsearch/Lucene works. It is different to SQL or a any regex based search. You can create a specific search (in combination with analysis/mapping on index time), that works much better than any regex based search when you are searching for such kind of ids (i.e. by splitting on dashes only, but using ngrams or edgengram etc, there are a couple of ways to solve this depending your use-case).
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.