I'm an Elasticsearch beginner.
I have a problem about exporting csv in ES|QL.
Environment
OS: Debian 12
Elasticsearch Version: 8.15.2 (elasticsearch and kibana)
Problem
I tried exporting csv and got timeout error.
The message was as bellow.
Report contains warnings
Encountered an unknown error: Request timed out
Output
Status
Completed
Kibana version
8.15.2
Attempts
1 of 3
Content type
text/csv
Size in bytes
0
CSV rows
0
Search strategy
scroll
Report job ID
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
Processed by
hostname (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)
Timeout
3600 seconds
Timestamps
Time zone
Asia/Tokyo
Created at
2024-12-24T15:31:29.928+09:00
Started at
2024-12-24T15:31:32.401+09:00
Completed at
2024-12-24T15:32:04.304+09:00
Queue time
2.473 seconds
Execution time
31.903 seconds
I had changed the following parameters in kibana.yml but got the error yet.
xpack.reporting.queue.timeout: 3600000
xpack.reporting.csv.scroll.strategy: scroll
I want to get the result in csv format.
What should I do?