Re: Kylin Cube Performance

Sure, see kylin.log below: 2016-08-04 00:47:35,839 INFO [http-bio-7070-exec-7] controller.QueryController:175 : The original query: SELECT SUM(clicks) FROM hpa_reporting2 GROUP BY site_id, child_id, search_type, hotel_id, report_date 2016-08-04 00:47:35,839 INFO [http-bio-7070-exec-7]

Re: cube query problem with kylin-1.5.3

“Caused by: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/hbase/regionserver/Region;” It’s sure your current hbase is not compatible to kylin. Tty to do this:

Re: cube query problem with kylin-1.5.3

sorry I am not describe rightly , my kylin version is apache-kylin-1.5.3-HBase1.x-bin. I did not use apache-kylin-1.5.3-bin.tar.gz ... 2016-08-04 11:37 GMT+08:00 Cheng Wang : > I meant that you need to check your Kylin version. According to your > environment, try this

Re: cube query problem with kylin-1.5.3

I meant that you need to check your Kylin version. According to your environment, try this version: http://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-1.5.3/apache-kylin-1.5.3-HBase1.x-bin.tar.gz On 8/4/16, 11:03 AM, "wangfeng" wrote: as you say, I check the

Re: cube query problem with kylin-1.5.3

as you say, I check the details logs of kylin-1.5.3,and found those info: ==[QUERY]=== SQL: select * from KYLIN_SALES User: ADMIN Success: false Duration: 0.0 Project: learn_kylin Realization Names: [kylin_sales_cube_desc_clone_clone]

Re: cube query problem with kylin-1.5.3

as you say, I check the details logs of kylin-1.5.3,and found those info: ==[QUERY]=== SQL: select * from KYLIN_SALES User: ADMIN Success: false Duration: 0.0 Project: learn_kylin Realization Names: [kylin_sales_cube_desc_clone_clone] Cuboid

[jira] [Created] (KYLIN-1938) Document for Hive/HBase/Hadoop permission required

Billy(Yiming) Liu created KYLIN-1938: Summary: Document for Hive/HBase/Hadoop permission required Key: KYLIN-1938 URL: https://issues.apache.org/jira/browse/KYLIN-1938 Project: Kylin

Re: Kylin Cube Performance

Hi Jason, could you please provide the full log since sending query to and getting result back? The key information is which cuboid is used for the query, cuboid exact match or fuzzy match, how many records be scanned and how long it tooks; Thanks. 2016-08-03 23:19 GMT+08:00 Jason Hale

cube query problem with kylin-1.5.3

Hi, when I installed the kylin-1.5.3 and run sample.sh, everything looks good. However , when I queried the result cube in "Insight", tables "KYLIN_CAL_DT" and "KYLIN_CATEGORY_GROUPINGS" did not show any error with SQL, as for table "KYLIN_SALES" could not run and show log: "Error while

Re: Kylin Cube Performance

Yes, it would have to do post-aggregation in that case, but the strange thing is that query was running fast (about 1 second), while queries with more dimensions, such as "SELECT SUM(clicks) FROM reporting GROUP BY site_id, child_id, report_date, hotel_id". This query will take about 106 seconds,

Re: HCatalogFormat error

Thanks for the response Li Yang. This was an EMR cluster which I don't have running now. I switched to setting up a HDP sandbox to get it up and running for testing purposes. If I get a chance to spin up the EMR cluster again, I will look into this further. To answer your question, though, it was