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" <[email protected]> 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/