Full text search vs Non full text search

General Discussions - English
1

Greetings,

I have a json field that is in the format of {“text”: “some text”}, I was wondering if I can conduct a search against this field that will achieve the same result if I were to do a full text search on it (In a json payload through the /search route). If so what would be the difference in terms of performance, compute power, and efficiency comparing to a full text search if I convert this json field to a Text field in the manticore table. Thanks in advance.

2

you could use /insert endpoint to populate your RT table with the JSON source

curl -sX POST http://localhost:8312/insert  -d '
{
  "table":"products",
  "id":1,
  "doc":
  {
    "text" : "some text",
    "price" : 19.85
  }
}

as described in the manual Data creation and modification > Adding documents to a table > Adding documents to a real-time table | Manticore Search Manual at the JSON examples

3

Thanks for your response, let me clarify my question further. I have already populated the necessary table, however instead of populating it your way in the sample json payload, I need to populate/update my database in the below format

{
  "table":"products",
  "id":1,
  "doc":
  {
    "text" : {"text": some text"},
    "price" : 19.85
  }
}

In this case, the text field is stored as a JSON object instead of TEXT in the database. Now it comes back to my previous question which is asking if I can somehow conduct a full text search on this field. Right now when I try to do a search query with full text search syntax described in the api e.g. (Match: "_all": "some | text")
I would not get any result back. Hopefully I have clarified my question here.