How to search by text in Google App Engine database?

Question

Google Workspace

Those. there is a certain table in BigTable, for example, a table with news. There is a String header, there is a Text article body. There is a news search form where you can enter keywords.
Actually, there are no queries like %LIKE% in the database API itself, although of course everything is logical based on the ideology that each query should have its own index.
There is a full text search API - it accepts a collection of documents and looks for words in text fields, substrings are not supported. Of course, you can generate different versions of the word by cutting prefixes and endings, but in fact this is also not the case. And even if you search by the full occurrence of the word, the question arises - I need to pull out the first 20 news for some keywords, I can naturally transfer some amount to the search API, but how many entities should I take out of the database? 20, 40? Again, it's not clear.
In general, what would you advise how to do a search by a set of keywords?
PS all this refers to the Java API, but in fact it does not really matter

Answer 1

There are 2 types of search allowing you to do what you need! Old and new .