There's a question that was posted in PrestoDB slack. Can anyone help?
```*Ritwik* [3:04 AM]
Hi everyone,
We are using
presto-pinot connector, to query the data stored in apache pinot. The same query when ran in presto(using pinot catalog) and pinot(directly in pinot) were giving different results. The number of output records were different in both cases.
Query:
select id, count(id) from table_name group by user_id HAVING COUNT(id) = 39 LIMIT 500000;
Number of records in presto = 14
Number of records in pinot = 4051
Seems like there is some issue with
presto-pinot connector. Does anyone have any idea on this?
If you are in the Presto Slack.
Here is the link to the post:
https://prestodb.slack.com/archives/C07JH9WMQ/p1655719450882479