Hi There,
I am using _xpack/sql/ to do the searching. By default the return records from ES it's 1000 per page.
If there are millions of records need to be returned. Fetch 1000 records per time in this case it's not effective. it slow down the performance. is there any configuration that increase the return hits records limit?
Thank you for your responding.
I used ES SQL to do the searching:
Post _xpack/sql/
{
"query": "select column_A from index_A where query( 'super hero', 'type=phrase;default_operator=OR')"
}
It only return 1000 records per page. Am i missing something here? which parameter i need to increase in order to increase the return hits.
Is it 'max_result_window' ?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.