Re: Computing aggregate sum on a measurement with a filter

2020-07-30 Thread Kirill Bogdanov
? > > You can design cube according the SQL statement you want to query, such as > add BATCH_ID and SEGMENT_SIZE to dimension, add sum(VALUE) as a measure. > These can make your query faster. > > 在 2020年7月29日,21:50,Kirill Bogdanov 写道: > > To answer my own questions, I have came

Re: Computing aggregate sum on a measurement with a filter

2020-07-29 Thread Kirill Bogdanov
WHERE msg_count=sgmnt_size Could you please comment on the performance characteristics of the above statement in the context of Kylin? Is there a better way of achieving the same? Thanks! On Wed, 29 Jul 2020 at 14:15, Kirill Bogdanov wrote: > Hi, > > I am working on a real time data

Computing aggregate sum on a measurement with a filter

2020-07-29 Thread Kirill Bogdanov
Hi, I am working on a real time data analytics and evaluating the possibility of using Kylin for our project. To date, I was able to connect Kafka with Kylin and run basic queries on cubes. However, I have a specific functionality requirements that I currently don't know how to achieve in Kylin.