We are considering using Druid for analytics in our company and one of our use cases is groupping data by up to 2 dimensions for relatively big combination. It takes several minutes and we don’t know what is problem.
Can you advice something to help ?
we have simple configuration with 1 historical node and 1 broker node.
DIM_1 has (5,000 Cardinality), DIM_2 has (60,000 Cardinality), Measure_1 ( group sum of count )
Any idea ?