V1.5 query no results

2016-03-29 Thread Jie Tao
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

Re: V1.5 query no results

2016-03-29 Thread 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 : > Hi, > > I installed v1.5 and bui

Re: V1.5 query no results

2016-03-29 Thread Jie Tao
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.

Re: V1.5 query no results

2016-03-30 Thread ShaoFeng Shi
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

Re: V1.5 query no results

2016-03-30 Thread Jie Tao
Thanks for the message. You are right, it may be Hbase problem. I have hbase-0.98.17-hadoop2. It may not be the Hadoop problem because I tested with Hadoop 2.6 and got the same error: Java.lang.IllegalArgumentException: No enum constant org.apache.hadoop.mapreduce .JobCounter.VCORES_MILLIS_RED

Re: V1.5 query no results

2016-03-31 Thread ShaoFeng Shi
v1.5.1 is on the way; it will include a couple of bug fixes; The next release date hasn't been decided. You will receive the vote email when it is kick off. 2016-03-31 14:54 GMT+08:00 Jie Tao : > Thanks for the message. You are right, it may be Hbase problem. I have > hbase-0.98.17-hadoop2. It ma

Re: V1.5 query no results

2016-04-04 Thread Li Yang
v1.5.1 should be out in a few weeks. On Thu, Mar 31, 2016 at 6:37 PM, ShaoFeng Shi wrote: > v1.5.1 is on the way; it will include a couple of bug fixes; The next > release date hasn't been decided. You will receive the vote email when it > is kick off. > > 2016-03-31 14:54 GMT+08:00 Jie Tao : >