select without group by call "query on detail" - KYLIN-1122 <https://issues.apache.org/jira/browse/KYLIN-1122> Xiaoyu contributed one patch which is under review and testing now.
Please always include "group by" in your query to interactive with Kylin. Thanks. Best Regards! --------------------- Luke Han On Wed, Nov 25, 2015 at 11:26 AM, yu feng <[email protected]> wrote: > 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. > >> > > > > >
