vogievetsky commented on issue #8246: Cryptic error coming from Druid SQL in semi-join condition URL: https://github.com/apache/incubator-druid/issues/8246#issuecomment-518946288 The query I posted is overly simplified (I tried to make the simplest query that will manifest the bug). The way the table works is that it wants to do a group by while still having access to the raw rows:  We achieve this with an outer select but we use an inner group by to actually get a bunch of intervals instead of just a list of segments in whatever order (since there is a limit). The real query (with no filter) right now is: ```sql SELECT ("start" || '/' || "end") AS "interval", "segment_id", "datasource", "start", "end", "size", "version", "partition_num", "num_replicas", "num_rows", "is_published", "is_available", "is_realtime", "is_overshadowed", "payload" FROM sys.segments WHERE ("start" || '/' || "end") IN ( SELECT "start" || '/' || "end" FROM sys.segments GROUP BY 1 LIMIT 25 ) ORDER BY "start" DESC LIMIT 25000 ```
---------------------------------------------------------------- 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]
