My version is 1.0 too, As far as I know, kylin can not get all values from a dimension column, but you can get distinct values using 'select distinct city from fact_table' or 'select city from fact_table group by city', when I execute sql like 'select city from fact_table', it always return just one line..
2015-11-25 10:48 GMT+08:00 Xiaoyu Wang <[email protected]>: > As far as I know,The dimension column query from fact table is OK in 1.x > What do you mean "the server does’t return a satisfactory result"? > Can you report more detail? > > > 在 2015年11月25日 10:38, 杨海乐 写道: > >> Hi all, >> After building my cube,I query a sql ,but the server does’t return a >> satisfactory result. The sql is :‘select city from fact_table’, City is >> dimension .My version of kylin is 1.0, I want to know whether the question >> has been fixed in 1.1 version because I notice we can query fact tables in >> 1.1 >> Best regards. >> > >
