NOT operator in FTS queries

[wjones127]

We claim to use Tantivy's query parser, but the NOT (-) operator doesn't seem to work:

import lancedb

db = lancedb.connect("memory://")
table = db.create_table('test', [{'text': 'apple fruit'}, {'text': 'apple'}, {'text': 'fruit'}])
table.create_fts_index(field_names='text', use_tantivy=False)
table.search('apple -fruit', query_type="fts").to_list()

[{'text': 'apple fruit', '_score': 0.7803833484649658},
 {'text': 'fruit', '_score': 0.5235483646392822},
 {'text': 'apple', '_score': 0.5235483646392822}]

[renato2099]

hi @wjones127 , I would like to work on this, could you please provide me with some pointers?

[aheev]

We claim to use Tantivy's query parser, but the NOT (-) operator doesn't seem to work:

It's only being used in python

table.create_fts_index(field_names='text', use_tantivy=False)

Your example fails because use_tanivy=False