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




Reply via email to