How to check not exist field in document in vespa

Question

curl --location --request POST 'http://xxxxxx/search/' \
--header 'Content-Type: application/json' \
--data-raw '{
    "offset": 0,
    "hits": 60,
    "ranking.softtimeout.factor": 0.7,
    "ranking.profile": "default",
    "yql": "select id, origin_id from mt_challenge where best_score = \"null\";",
    "timeout": "1500ms",
    "request_timeout": 5
}'

best_score field is float type how to checkout all document with not exist best_score field

Answer 1

Sorry but NaN/null values are not searchable so this is currently not supported. Using a default value at ingestion time which does not conflict with your real data can be used to work around this.