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 <wobenpingfa...@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.
>
