New blog "Improving Spark Cubing in Kylin 2.0"

2017-07-21 Thread ShaoFeng Shi
Hello Kyliner, The blog "Improving Spark Cubing in Kylin 2.0" from committer Kangkai Sen is published in Kylin website today. For the users who are interested about Spark + Kylin, it can help: https://kylin.apache.org/blog/2017/07/21/Improving-Spark-Cubing/ The original Chinese version is in Kai

Re: paged query

2017-07-21 Thread ShaoFeng Shi
The following SQL works in my side: select * from KYLIN_SALES LIMIT 100 OFFSET 1 ROWS FETCH FIRST 10 ROWS ONLY Here are two tricky things: 1) In Kylin's web GUI, it will automatically append a "LIMIT" after each SQL if "LIMIT" wasn't appeared (this is to avoid too much data returned to the we

Re: the api of kylin

2017-07-21 Thread ShaoFeng Shi
Hi Miao, For query 1, we haven't received similar issue reporting; Did you properly set "kylin.server.cluster-servers" in all Kylin instances? Would you please provide more information? For question 2, try to allocate more resources to the job engine node, which build the dictionaries and need mo

Re: Upgrade from kylin-1.5 to kylin-2.0

2017-07-21 Thread qiumingming
Thanks a lot! -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Upgrade-from-kylin-1-5-to-kylin-2-0-tp8515p8519.html Sent from the Apache Kylin mailing list archive at Nabble.com.

paged query

2017-07-21 Thread apache_...@163.com
Hi, Kylin can support paged query? This sql can't work select * from KYLIN_SALES OFFSET 100 ROWS FETCH FIRST 10 ROWS Calcite doc: query: values | WITH withItem [ , withItem ]* query | { select | selectWithoutFrom | query UNION [ ALL | DISTINCT ] query | query EXCEPT [ AL

Review Request 61022: KYLIN-2703 kylin supports managing access rights for project and cube through apache ranger.

2017-07-21 Thread pengjianhua
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/61022/ --- Review request for kylin, Dayue Gao, Dong Li, hongbin ma, and Wang Xiaoyu. Bugs

Re: Upgrade from kylin-1.5 to kylin-2.0

2017-07-21 Thread ShaoFeng Shi
Ken, you can check the upgrade document: https://kylin.apache.org/docs20/howto/howto_upgrade.html Try upgrade in QA environment first, then you can identify the gaps there. The upgrade should be okay. 2017-07-21 16:47 GMT+08:00 qiumingming : > Hi all, I'm going to Upgrade from kylin-1.5 to kylin

Upgrade from kylin-1.5 to kylin-2.0

2017-07-21 Thread qiumingming
Hi all, I'm going to Upgrade from kylin-1.5 to kylin-2.0. And I want to reuse the old cube data in kylin-2.0. Is CubeMigrationCLI can do this thing? Will it involve any errors? If this operation make the cube can not be queryed any more would be extremely worse! -- View this message in context: h

the api of kylin

2017-07-21 Thread 崔苗
we have some problems in using kylin api:1 the wipe cache doesn't work,we want to 'drop' the 'kylin_sales_cube',the response status_code was 200,but the cube is still ready2 we want to build job by hour, and there were a dozen of cubes,so the jobs were building parallelly,how to manage these job