[GitHub] [druid] dbardbar edited a comment on pull request #12078: Grouping on arrays as arrays

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

dbardbar edited a comment on pull request #12078:
URL: https://github.com/apache/druid/pull/12078#issuecomment-998812329


   @cryptoe,
   
   The use-case is that some of the values in the MV field are not interesting for a specific query, and we would like to ignore them for the purpose of the GROUP BY. They are kept there because those ignored tags might be used for filtering, or might be used for GROUP BY when performing a different query.
   
   An example query, using the example data appearing at the top of this PR:
   
   SELECT MV_FILTER_ONLY(tags, ARRAY['t3', 't4']), COUNT(*) FROM test GROUP BY 1
   
   with your new code enabled, I would expect the following to return:
   ```
   ["t3"],       1            (from row1)
   ["t3", "t4"], 1            (from row2)
   null,         2            (from row3+row4)
   ```
   
   
   
   
   
   


-- 
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: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



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