vogievetsky opened a new issue #8246: Cryptic error coming from Druid SQL in semi-join condition URL: https://github.com/apache/incubator-druid/issues/8246 ### Affected Version 0.16.0-snapshot ### Description The query ```sql SELECT "segment_id", "datasource", "start", "end" FROM sys.segments WHERE "start" IN ( SELECT "start" FROM sys.segments WHERE "datasource" = 'wikiticker' GROUP BY 1 LIMIT 5 ) AND "datasource" = 'wikiticker' ORDER BY "start" DESC LIMIT 100 ``` Produces this cryptic error: `Unknown exception / Got a sink null to which there is no match source type! / java.lang.IllegalStateException` But strangely removing the `datasource` filter clause in the outer SQL makes it all work:  As it stands right now this is a release blocker for 0.16.0 as this type of query is generated by a feature added to the web console. To unblock we could do one of: 1. Fix this issue 2. Remove/hide the 'group by interval' feature in the segments view 3. Change how that view fetches data (make it make two calls) 2 or 3 are very simple to do but wanted to get some discussion going on weather we should do 1.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
