[I] Sometimes Some OFFLINE Table Entries Do Not Appear When Querying the Hybrid Table [pinot]

[via GitHub]

jburgoos opened a new issue, #15171:
URL: https://github.com/apache/pinot/issues/15171

   **Description**
   
   We are experiencing an issue where queries on a hybrid table in Apache Pinot 
do not always return all the expected data from the OFFLINE segments. However, 
when querying the OFFLINE table directly, all expected records are present. 
This suggests that Pinot is not correctly merging the results from OFFLINE and 
REALTIME segments in some cases.
   
   **Observed Behaviour**
   
   This query counts the number of entries grouped into 1-hour buckets. As 
shown in the screenshots, when executing the query on the OFFLINE table 
directly, more data is displayed compared to querying the hybrid table.
   
   
![Image](https://github.com/user-attachments/assets/e2c14acc-9bbb-4daf-a5d0-ee4764147cf2)
   
   
![Image](https://github.com/user-attachments/assets/ebf1df9b-dcab-4468-8828-2409bbca51ff)
   
   **Expected Behavior**
   
   Queries on the hybrid table should return all relevant records from both 
OFFLINE and REALTIME segments, ensuring no data loss from OFFLINE.
   
   **Environment**
   
   - Pinot Version: 1.2.0
   - Deployment Type: Running on physical machines


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org