[GitHub] [incubator-druid] clintropolis edited a comment on issue #8947: Unnecessary cartesian explosion if multi-value column is reused in expression

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

clintropolis edited a comment on issue #8947: Unnecessary cartesian explosion if multi-value column is reused in expression
URL: https://github.com/apache/incubator-druid/issues/8947#issuecomment-561453513
 
 
   >so this should yield a result of [other, 1], [b, 1], [g, 1] ?
   
   With the adjusted behavior in  #8957, the expression would be translated into something like
   ```
   map(dstGroups -> case_searched((dstGroups == 'b'),'b',(dstGroups == 'g'),'g','Other'), dstGroups)
   ```
   which would yield the per row results:
   ```
   [other, b, other, other]
   [other, other, other]
   [other, g]
   ```
   Druid does an implicit "un-nest" when grouping on a multi-value string dimension, so the final results would be I think:
   ```
   other, 7
   b, 1
   g, 1
   ```
   if I can add correctly

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