opensearch-project
[BUG] Fix the PPL time Zone
Describe the bug
The PPL query is always giving the results as per the UTC time zone. While i cross check the results with OpenSearch discover those results are mis matching. The discover of OpenSearch is working as per the time zone selected on the dashboard management.
If i select america/newyork as time zone in dashboard management. And checking with ppl the results are mismatching.
If i use UTC as timezone in dashboard management. And checking with ppl the results are matching.
Related component
Search:Aggregations
To Reproduce
- Go to '..OpenSearch and select a America/New York time zone in dashboard management.'
- Click on 'PPL'
- Scroll down to 'query place and write small query like the same filter used in OpenSearch discover and the count'
- See error the results are mismatching
Expected behavior
What time we are picking in dashboard management the PPL and discover as per that time. we are using 2.13 version.
Additional Details
Plugins Please list all plugins currently enabled.
Screenshots If applicable, add screenshots to help explain your problem.
Host/Environment (please complete the following information):
- OS: [e.g. iOS]
- Version [2.13]
Additional context Add any other context about the problem here.
[Search Triage] @opensearch-project/admin -- Can we please move this to the SQL plugin? That's where PPL is implemented.
@SricharanSundar thanks for bring up the issue. You are right, current PPL return date value in UTC timezone. What is the expectation of the PPL query / API, are u suggesting add a timezone paramater when submit PPL query?
@ashwin-pc what is expactation from frontend for handle such case?
@SricharanSundar does it what you expected? https://github.com/opensearch-project/sql/issues/3599