gianm opened a new issue, #18198:
URL: https://github.com/apache/druid/issues/18198
On the wikipedia dataset, this query yields incorrect results on realtime
data:
```sql
SELECT COUNT(*) FROM "wikipedia"
WHERE countryName IN (
SELECT countryName
FROM "wikipedia"
WHERE countryName IS NOT NULL
GROUP BY 1
ORDER BY COUNT(*) DESC
LIMIT 1
)
```
The query results are the same as `SELECT COUNT(*) FROM "wikipedia"`. Under
the hood this query runs using a broadcast join. It may be that the `join`
datasource is not being correctly passed down to the realtime server.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
