Re: Re:Query Problem

2018-09-10 Thread ShaoFeng Shi
Hi Neethu, Kylin doesn't support raw data query; Please send to another engine, or configure Kylin's query pushdown function: https://kylin.apache.org/docs/tutorial/query_pushdown.html mvneethu 于2018年9月10日周一 下午4:56写道: > Hi, > > Even I get empty values in the metric column if I give select * and

Re: Re:Query Problem

2018-09-10 Thread mvneethu
Hi, Even I get empty values in the metric column if I give select * and I am using kylin version 2.3.2. What will be the work around to get the raw metric values. I tried "select dimensions, sum(metric_col) group by dimension", but this gives the grouped data and not the raw data. Does that mean

Re:Query Problem

2018-04-04 Thread Ma Gang
Hi Rahul, Currently Kylin only store pre-aggregate data, and no raw data is stored in the system, so Kylin can only support the aggregate query(has group by clause). For the no-aggregate query, in order to return better results, Kylin just hack to output sum of metric columns, for example, the q