hi kylin team,
the version of kylin is 1.2.
I build a cube first,and every field does not use  dictionary.
then,I pre calculation every cuboid in storm and update hbase table data
realtime.

I checked the rowkey in hbase is right,but When I query data, only a few are
correct.

for example:
select dt,code,sum(money) as money from mytable a inner join dimtable b on
a.id=b.id  group by dt,code;
2016-03-01  001   100
2016-03-01  002   100
2016-03-02  001   200
select dt,sum(money) as money from mytable a inner join dimtable b on
a.id=b.id group by dt;
2016-03-01  100
2016-03-02  200

the money is 200 in 2016-03-01 ,but the result is 100,

Why ? Is there  other processing when query?

thanks



--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/update-hbase-data-realtime-and-query-it-tp3959.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Reply via email to