I can see timestamp and date and time variables in kibana and they are up to date.
But When I use SQL statement such as select It returns old value with 3 or 4 hours differenece.
I think select run query on disk and kibana discover show from memory.
How can I run select on memory and disk ? Or tell to opensearch write memory to disk?