kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "空" <35965...@qq.com>
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 1.5.2.1


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
='18137251768'
 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!
Mime
View raw message