kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 张天生 <>
Subject Query server occupy memory too high
Date Fri, 29 Jul 2016 08:54:55 GMT
I'm using kylin 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.

View raw message