[GitHub] [incubator-druid] vogievetsky commented on issue #8246: Cryptic error coming from Druid SQL in semi-join condition

[GitBox <gi...@apache.org>]

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:
   
   ![image](https://user-images.githubusercontent.com/177816/62597034-7d1bed00-b899-11e9-93c1-5d50e74ff731.png)
   
   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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org