kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "空" <>
Subject re:group statistics is different with detail count
Date Thu, 04 Aug 2016 01:39:53 GMT
CDH5.7:hadoop 2.6.0/hbase 0.98.17/hive 2.1.0/kylin

I had build three cubes:(the 1st images attached)

there are some strange problem in my test: group statistics is different with detail count
1) sql: select d_city ,S_MOBILE,count(S_MOBILE) from BAS_EXPRESS_DELIVERY where  S_MOBILE
 and d_city='浙江省杭州市' group by d_city ,S_MOBILE
    result: group statistics is 6 (the 2nd images attached)

2)sql:select * from BAS_EXPRESS_DELIVERY where  BAS_EXPRESS_DELIVERY.S_MOBILE ='18137251768'
and d_city='浙江省杭州市'
   result :detail count is 2,but not 6 (the 3rd images attached)

Why does this happen? please help me~~

Thanks a lot!
View raw message