I'm using kylin 1.5.2.1. I built a cube for a month's event data of
advertisment impression/click/conversion. It consists of 6 dimensions and 8
measures. It consists of 2 uv measures, and uv measure was computed by
DISTINCT COUNT. The cube size is 2G. When i queried uv measures of a month
data, the memory quickly increased to 30G+, and the quey was also slowly. I
don't known why it occupied so much memory, but cube size is only 2G,
memory data expanded so big. Hower, when i executed simple silimar sum or
count query ,it was fast and occupied memory not too much.