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
