Dear Kylin:
kylin 1.5.2
hbase 0.98
I am very confused in a little experiment for testing detail query with
kylin. First, I import a table 'COFFEE' contains about 4258 records, and then
build a simplest cube (only one dimension named 'MARKET', and one measure
'COUNT').
(1) When I query with SQL 'select count(*) from COFFEE', it shows '4258'.
(2) When I query detail with SQL 'select * from COFFEE', it shows only 4
records:
(3) When I query with SQL 'select market, count(*) from COFFEE group by
market', it shows different results with the previous query:
(4) When I query with SQL "select * from COFFEE where market =
'Central' ", one ressult is shown.
How to explain and understand these results, and what should be noted
when we build a cube expected to be able to query detail data ? Thank you.