How to set elasticsearch field not to be indexed but still need it to be queryable

e.g. "testcolumn" this field in index_test , let's set it not as a full-txt index, but we still can use the query as below. How we can achieve this?

Post _xpack/sql/
{

"query": "select * from index_test where testcolumn= 'BVM'"
}

Not sure about what you mean.

If it's not indexed, it's not searchable.

can we set it to an not full-text index( not need to be analyzed), and still searchable.

"type": "keyword" will do it.

Thank you! That work for me.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.