Missing data that should be present based upon histogram (hourly) and time range

Bug Description

Reviewing panels that should have consistent data show gaps, so when I looked closer at the queries themselves, I was able to narrow down to the exact same query, only modifying the time range by 1 hour. Below, you can see the differing results:

Assumed correct result:

Assumed incorrect, with gap/missing data between 19:00:00 - 05:00:00

In this case, here's the SQL query: SELECT histogram(_timestamp, '1 hour') as "x_axis_1", count(distinct(body_file_uuid)) as "y_axis_1" FROM "gpe_comm" WHERE k8s_labels_app_kubernetes_io_name = 'comm' AND k8s_container_name = 'send' AND body_msg = 'accepted file' GROUP BY x_axis_1 ORDER BY x_axis_1 ASC

Priority

P1 - High

Severity

Major

Related Story/Issue

Not Available

Is this a regression?

Yes

Steps to Reproduce (Optional)

No response

Environment Details

Version v1.0.0

Which OpenObserve Functionalities Are Affected?

• Home & Login
• Logs / Metrics / Traces
• Dashboards
• Alerts
• Streams, Pipelines & Functions
• Ingestion
• Real User Monitoring (RUM)
• Reports
• IAM & Management
• UI / Styling
• Unknown / Other