599166320 commented on PR #13168:
URL: https://github.com/apache/druid/pull/13168#issuecomment-1273490010

   > 
   The query with `__time` as the prefix and the sorting direction is the same 
as `__time`, as shown below:
   
   
   ```
   order by __time,a,b,c
   order by __time desc,a desc,b desc
   
   ```
   
   In the above two cases, I think we can consider taking a special path. The 
special path here is the `Segment by segment decision` you mentioned above
   
   At present, I think of two ways to improve:
   
   1. It is up to the user to decide whether to run a special path by passing 
parameters in the query context
   
   2. According to the ingestion specs `dimensionsSpec`, let `druid` 
automatically decide to take a special path.
   
   For example:
   
   ```
   dimensionsSpec{dimensions:[a,b,c,d,e,f,....]}
   ```
   
   If the user's `ingestion specs` is configured as above, does druid sort the 
ingested data? If sorting already exists, the following queries can be run on 
special paths:
   
   ```
   order by __time,a,b,c
   order by __time desc,a desc,b desc
   ```
   
   


-- 
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]

Reply via email to