Well, if you do not put this dimension in group by, how could you get this dimension from SQL? If you want to fetch data from fact table without any group by (just where), it will not return exactly result so far (kylin does not support query on raw data yet).
Would you mind describe a little bit about your data structure and query sample? Thanks. Best Regards! --------------------- Luke Han On Fri, Jan 8, 2016 at 6:26 PM, Kiriti Sai <kiriti163.i...@gmail.com> wrote: > I don't want to group by or apply any filters for that dimension, I just > want to do all those query related things with other dimensions and just > get the corresponding description column value. > As I mentioned before, I'm not sure if such optimization exists in any OLAP > systems, but just wanted to clarify. > > Thank you. > On Jan 8, 2016 7:19 PM, "hongbin ma" <mahong...@apache.org> wrote: > > > how do you wish to use such dimension if we imaginarily had implemented > it > > ? > > you can't apply groupby or filters on it, and it's obviously not a > measure > > either. > > > > > > -- > > Regards, > > > > *Bin Mahone | 马洪宾* > > Apache Kylin: http://kylin.io > > Github: https://github.com/binmahone > > >