There is no error during the process of model and cube creation and building. I check
<http://apache-kylin.74782.x6.nabble.com/file/n4034/empty.png> <http://apache-kylin.74782.x6.nabble.com/file/n4034/cube.png> <http://apache-kylin.74782.x6.nabble.com/file/n4034/hbase.png> The version is kylin-1.5 for hbase 0.98. the kylin.log: 2016-04-03 15:33:37,878 INFO [http-bio-7070-exec-1] controller.QueryController:175 : Using project: learn_kylin 2016-04-03 15:33:37,878 INFO [http-bio-7070-exec-1] controller.QueryController:176 : The original query: select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt 2016-04-03 15:33:37,879 INFO [http-bio-7070-exec-1] service.QueryService:269 : The corrected query: select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt LIMIT 50000 2016-04-03 15:33:37,930 INFO [http-bio-7070-exec-1] routing.QueryRouter:48 : The project manager's reference is org.apache.kylin.metadata.project.ProjectManager@dc62504 2016-04-03 15:33:37,930 INFO [http-bio-7070-exec-1] routing.QueryRouter:60 : Find candidates by table DEFAULT.KYLIN_SALES and project=LEARN_KYLIN : org.apache.kylin.query.routing.Candidate@4ee23a1 2016-04-03 15:33:37,931 INFO [http-bio-7070-exec-1] routing.QueryRouter:49 : Applying rule: class org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule, realizations before: [kylin_sales_cube(CUBE)], realizations after: [kylin_sales_cube(CUBE)] 2016-04-03 15:33:37,931 INFO [http-bio-7070-exec-1] routing.QueryRouter:49 : Applying rule: class org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before: [kylin_sales_cube(CUBE)], realizations after: [kylin_sales_cube(CUBE)] 2016-04-03 15:33:37,931 INFO [http-bio-7070-exec-1] routing.QueryRouter:72 : The realizations remaining: [kylin_sales_cube(CUBE)] And the final chosen one is the first one 2016-04-03 15:33:37,977 DEBUG [http-bio-7070-exec-1] enumerator.OLAPEnumerator:107 : query storage... 2016-04-03 15:33:37,979 DEBUG [http-bio-7070-exec-1] enumerator.OLAPEnumerator:127 : return TupleIterator... 2016-04-03 15:33:37,979 DEBUG [http-bio-7070-exec-1] enumerator.OLAPEnumerator:128 : Storage cache used for this storage query:null 2016-04-03 15:33:37,981 INFO [http-bio-7070-exec-1] service.QueryService:253 : ==========================[QUERY]=============================== SQL: select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt User: ADMIN Success: true Duration: 0.101 Project: learn_kylin Realization Names: [kylin_sales_cube] Cuboid Ids: [64] Total scan count: 0 Result row count: 0 Accept Partial: true Is Partial Result: false Hit Exception Cache: false Storage cache used: false Message: null ==========================[QUERY]=============================== -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Empty-result-return-in-the-Insight-tp4034.html Sent from the Apache Kylin mailing list archive at Nabble.com.
