querydsl - Sql's LIKE search alternative in elasticsearch -


i have requirement of searching number string "234" given field contains values "abc:+123456789". more sql's search.

i tried following options around 3 billion documents indexed:

1- wildcards:

curl -xpost 'localhost:9200/ccp/_search?pretty' -d '{   "from": 0,"size": 10,      "query": {       "wildcard": {        "original_address": {           "value": "*6421685922*"        }     }    }    }' 

this taking around 600 sec much.

2- query-string

curl -xpost 'localhost:9200/ccp/_search?pretty' -d '{     "query": {"filtered": {"query": { "query_string": {           "fields": [ "original_address" ],           "query": "*7570850706*"         }       }           }   } }' 

still taking time.

what best alternative of same in elastic querydsl or curl?


Comments