ankitnayan opened a new issue #10678: URL: https://github.com/apache/druid/issues/10678
My data format is like: ``` { timestamp string, name string, kind int, status_code int, ... tags: { key1: value1, key2: value2, ... } } ``` **The list of keys in tags is varying in size for each row and the keys are also not defined (it can be anything string).** I want to query dataset by tags, i.e., return all rows which have given key: value pair. In Pinot, we can achieve this by storing all keys in a multi-value dimension TAGS__KEYS and all values in another multi-value dimension TAGS__VALUES and then query using MAP_VALUE function. Sample query: ```SELECT * FROM xyzView WHERE ( tags__KEYS = 'key1' AND tags__VALUES = 'value1' AND mapValue(tags__KEYS,'key1',tags__VALUES) = 'value1' )``` How can we achieve the same in Druid? Druid also has a multi-value dimension but does not have mapValue functionality. Or can we achieve this using any other way in Druid? ---------------------------------------------------------------- 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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org