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 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" 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
> >
>
