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
Post a Comment