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" <rahul.si...@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/