I checked this query in my sandbox with 1.5.0 binary package, it can return records;
Just check a couple of things: 1. whether the hive table has data; 2. whether the cube has built the date range which covers 2012 to 2013; 2016-03-29 17:06 GMT+08:00 Jie Tao <[email protected]>: > Hi, > > I installed v1.5 and built the sample cube. All was fine. But when I query > with > > 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 > > I got No Result / Results (0). Kylin.log shows: > > User: ADMIN > Success: true > Duration: 0.172 > 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 > > > I created a cube with my own table and also no results. I installed v1.2 > earlier but I deleted all tables (including kylin_metadata) in Hbase. I > think there should be no problem now with version conflict. But I did not > delte Hive table. > > What is wrong? > > Best regards, > > Jie > -- Best regards, Shaofeng Shi
