Hybrid Search Query Expressions for Autodrop

You can configure autodrop for keyword search results, vector search results, or hybrid search results. For best results either use autodrop for keyword search and vector search, or just hybrid search results. Do not use autodrop for all search types together in a query.

The num_drops integer parameter passed to “autodrop_keyword”, “autodrop_vector”, and “autodrop_hybrid” defines the number of significant score drops that hybrid search function must detect in the corresponding score list to truncate results.

Use this syntax for autodrop with keyword search and vector search results.

select * from hybrid_search(
    table(<Search_index_DMO>), 
    ‘<Search String>’,
    '<PreFilteringColumn><Operator><Value>', 
    '<Limit Results>', 
    ‘{ "autodrop_keyword": {"num_drops": 2},  "autodrop_vector":{"num_drops": 5 }}’
);

)

Where:

"autodrop_keyword": {"num_drops": 2}

Drops retrieved keyword search results at the second significant score cutoff point.

"autodrop_vector":{"num_drops": 5 }

Drops retrieved vector search results at the fifth significant cutoff point.

Use this syntax for autodrop with hybrid search results.

select * from hybrid_search(
    table(<Search_index_DMO>), 
    ‘<Search String>’,
    '<PreFilteringColumn><Operator><Value>', 
    '<Limit Results>', 
    ‘{{ "autodrop_hybrid": {"num_drops": 1}}’
);

      

Where:

{ "autodrop_hybrid": {"num_drops": 1}

Drops the combined hybrid search results at the first significant score cutoff point.

If you don’t apply a quality filter in a vector search query, the search always returns the number of results (topK results) requested. Keyword search returns results that only match terms of the query contained in the documents.