kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: query double column in fact table
Date Wed, 25 Jan 2017 17:39:42 GMT
Make the price column a dimension and you should be able to do the query.
However double being a very high cardinality type may not work well (high
expansion rate, long build time etc). If you could lower the price's
cardinality by rounding to integer or even tens/hundreds, the resulted cube
will be much better.

Cheers

On Sun, Jan 22, 2017 at 10:56 AM, xiaofan <wobenpingfanyw@gmail.com> wrote:

> hi all
>  i have a double type column price in the fact table,when i query  'select
> *
> ' get data price=8.0,so i must query sql like 'select price form product
> where price=8.0',both price=8 and price=8.00 can get nothing,so is there
> some method to adapt this scene?thanks
>
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/query-double-column-in-fact-table-tp7009.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message