Query Problem

[rahulsingh <ra...@i-link.co.in>]

Hello All,

I am not able to fetch measures data using select * from "table_name", I got
proper data when I used sum on the specific measures. I don't know why it is
giving blank data on all measures.

Please help if anyone has faced this issue.

Thanks,
Rahul

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: Re:Query Problem

[ShaoFeng Shi <sh...@apache.org>]

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 <ne...@tigeranalytics.com> 于2018年9月10日周一 下午4:56写道：

> 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 one cannot get the raw metric value from kylin?
>
> Thanks,
> Neethu
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>


-- 
Best regards,

Shaofeng Shi 史少锋

Re: Re:Query Problem

[mvneethu <ne...@tigeranalytics.com>]

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 one cannot get the raw metric value from kylin?

Thanks,
Neethu

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re:Query Problem

[Ma Gang <mg...@163.com>]

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 query: select * from {table_name},  will be hack to "select {all_columns}, sum({metric_column}) group by {all_columns}", so for the metric column doesn't have "sum" aggregation defined, it will be shown as empty in the result.




At 2018-04-03 19:08:16, "rahulsingh" <ra...@i-link.co.in> wrote:
>Hello All,
>
>I am not able to fetch measures data using select * from "table_name", I got
>proper data when I used sum on the specific measures. I don't know why it is
>giving blank data on all measures.
>
>Please help if anyone has faced this issue.
>
>Thanks,
>Rahul
>
>--
>Sent from: http://apache-kylin.74782.x6.nabble.com/