Hello Druid community,
I am wondering if it is a best practice to store dimensions as strings in Druid.
For our dimensions, we’ve been storing numerical IDs (not sure why) that are associated to strings stored in various MySQL tables (i.e. for users, domain names, countries, etc).
After making Druid queries, we join the the dimension IDs to their respective names taken from MySQL.
Clearly, this isn’t the best solution and it is very limiting, as it needs to be done in out PHP layer.
I know there are inefficiencies with storing strings in Druid, so what would be the best solution in this case?
I would love to know how others handle this issue!
Thanks in advance!
- Rafael Abbondanza