As we know , unindexed field will store in _source field,so we can get those unindexed fields in _source.But Elasticsearch-sql can't get unindexed field. GET /_sql/translate { "query":""" select * from "view-laohu-sdk" limit 1 """ } look the picture blow，“_source”:false lead to we can't get …

Elasticsearch-sql can't query unindexed field

Christian_Dahlqvist (Christian Dahlqvist) October 12, 2020, 5:56am 5

Reading unindexed fields has a significant performance impact and can be very slow and scale badly. I wonder if it is therefore disabled within the SQL interface.

Topic		Replies	Views
How to search non indexed field in elasticsearch Elasticsearch	10	21402	July 6, 2017
Stored Fields (by default)? Elasticsearch	6	480	July 6, 2017
Match query against Stored & Unindexed Field (Not storing source) Elasticsearch	4	1025	July 6, 2017
Restrict a field from going to _source field or easily print out all stored fields? Elasticsearch	5	376	July 6, 2017
[SQL] Expose _source in SQL queries Elasticsearch elastic-stack-sql	6	1252	April 3, 2019

Elasticsearch-sql can't query unindexed field

Related topics