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 <[email protected]> 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. >
