Re: if can add where clause to a measure?

Kylin can do this (by defining "price" as dimension) but the cube explosion rate might be high since "price"'s cardinality is high; Usually when face such a scenario we can optimize it in this way: 1. define a hive view, adding another column say "price_grade"; normalizing the price values into g

Re: if can add where clause to a measure?

I never use, but Kylin 976 can be useful for you 2016-12-21 8:14 GMT+01:00 ZhouJie : > hi, everyone > i want to know if kylin can filter a column which has been measured, as > follows: > select sum(price) from hotprice_copy1 where price > 100.0 an

if can add where clause to a measure?

hi, everyone i want to know if kylin can filter a column which has been measured, as follows: select sum(price) from hotprice_copy1 where price > 100.0 and price <5000.0 thanks joe