Hi Jie, I compared the hadoop version in 1.5 and 1.3, they are almost the same, except hbase-hadoop2.version, which is 0.98.8 on v1.3 but 0.98.4 on v1.5.0). Maybe it has some impactions; if you couldn't wait for next release, you can clone Kylin's v1.5.0 tag, change the pom.xml, make a new binary package, and then deploy it in your cluster to see whether it solve this issue.
Thank you for reporting issue to Kylin! 2016-03-29 22:41 GMT+08:00 Jie Tao <[email protected]>: > > I see errors in the log: > java.lang.IllegalArgumentException: No enum constant > org.apache.hadoop.mapreduce > .JobCounter.VCORES_MILLIS_REDUCES > > The problem may be my Hadoop version 2.7, according to this JIRA: > https://issues.apache.org/jira/browse/KYLIN-1183. > > But: v1.2 and v1.3 run on Hadoop 2.7 without any problem. Maybe you can > check v1.5 to find what was changed. Your suggested Hadoop version is > 2.4-2.7. So I work with Hadoop 2.7. > > Best regards, > > Jie > > > Am 29.03.2016 um 12:35 schrieb ShaoFeng Shi: > >> 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
