Re: Kylin taking too much time

The step 1 is actually a hive command that Kylin triggers. You need to investigate why that hive command takes so long to complete. Looking at YARN console is usually the first step. Cheers Yang On Thu, Jul 13, 2017 at 9:20 AM, bhanuprakash k wrote: > Hello > >I

Re: [jira] [Created] (KYLIN-2745) Remove eclipse .settings directory from each module

Attaching a patch to JIRA is recommended. I see your patch. A volunteer committer will review and then merge the patch if it comply with the coding standards. Thanks Nirav! 2017-07-19 4:20 GMT+08:00 Nirav Patel : > Do we create pull request or attach a patch to JIRA? I am

Re:Re: Re: 回复：技术求助

But the metadata is only 18M, why does it cost much resources. And there are many errors in kylin.log when tableau loads the metadata. 2017-07-19 09:34:48,415 INFO [Query d1337b1e-3635-467e-8919-88797bb33965-54] service.QueryService:338 : Using project: bind_financial_manager 2017-07-19

Re: Re: 回复：技术求助

The root cause is Tableau sends out “select * ” to Kylin which costs much resource. 在 2017年7月18日 下午5:51，沈丹丹 写道： > yes， I use the live model. > > > > > > > > > 在 2017-07-18 17:25:48，"Billy Liu" 写道： > >Did you use Tableau Live mode? > > > >在

Re: Kylin for MapR

We have contacted kyligence but haven't got any response yet. If you or someone else part of kyligence let me know. My engineering director and engineers would be interested in talking about it. Thanks, Nirav On Mon, Jul 17, 2017 at 1:03 PM, Li Yang wrote: > I knew some

Re: Issues running DebugTomcat.java from non sandbox environment

Ok so on MacOS Sierra I had to add following entry to /etc/hosts 127.0.0.1 boomerang.local It works now. Application server finally started! Thanks On Tue, Jul 18, 2017 at 3:17 PM, Nirav Patel wrote: > I tried it. I had to replace parent POM dependency hbase

Re: Issues running DebugTomcat.java from non sandbox environment

I tried it. I had to replace parent POM dependency hbase version as well to make it work with MapR: 1.1.1-mapr-1602 I am still getting following error in multiple places. I think issue is running `InetAddress.getLocalHost` java api on MacOS Sierra (my local mabook).

Re: [jira] [Created] (KYLIN-2745) Remove eclipse .settings directory from each module

Do we create pull request or attach a patch to JIRA? I am little confuse. As 'How to contribute' document says to attach a patch but I also see pull requests on github pages. My patch is here. https://issues.apache.org/jira/browse/KYLIN-2745 Please advice on process. This is my first commit.

Re: [jira] [Created] (KYLIN-2745) Remove eclipse .settings directory from each module

Thanks. Is it okay if I create a patch from my own fork repo and attach it to JIRA? will you be still able to inspect and apply? On Mon, Jul 17, 2017 at 6:12 PM, ShaoFeng Shi wrote: > Hi Nirav, > > It need permission in JIRA system. Let me grant you the role then you

Re: Re: about Measures result stroage

Most of the calculation happens during the Cube build phase; But there are also some calculation in the query phase (we call it as "online calculation") because the query may need merge or filter some records. 2017-07-18 17:52 GMT+08:00 apache_...@163.com : > shaofeng, > >

Re: 答复: intermediate table not found when used the hive view

You're welcome. Thanks for the feedback. 2017-07-18 18:15 GMT+08:00 jianhui.yi : > Thank you Shaofeng, The facts as you said, I'm going to serialize the > build task to avoid this problem, a JIRA will be submitted later > > -邮件原件- > 发件人: ShaoFeng Shi

答复: intermediate table not found when used the hive view

Thank you Shaofeng, The facts as you said, I'm going to serialize the build task to avoid this problem, a JIRA will be submitted later -邮件原件- 发件人: ShaoFeng Shi [mailto:shaofeng...@apache.org] 发送时间: 2017年7月18日 17:49 收件人: dev 抄送: user 主题: Re:

[jira] [Created] (KYLIN-2746) Separate filter row count & aggregated row count for metrics collection returned by coprocessor

Zhong Yanghong created KYLIN-2746: - Summary: Separate filter row count & aggregated row count for metrics collection returned by coprocessor Key: KYLIN-2746 URL: https://issues.apache.org/jira/browse/KYLIN-2746

Re:Re: 回复：技术求助

yes， I use the live model. 在 2017-07-18 17:25:48，"Billy Liu" 写道： >Did you use Tableau Live mode? > >在 2017年7月18日 下午2:59，沈丹丹 写道： > >> >> >> >> Thank you. But the SQL is automatically generated when tableau loads >> metadata, but it not

Re: Re: about Measures result stroage

shaofeng, thinks. Is it(measures result) calculated during the cube running or calculated at query time? apache_...@163.com From: ShaoFeng Shi Date: 2017-07-18 17:31 To: dev Subject: Re: about Measures result stroage One Cube may has 1 or multiple Cube segments; Each segment

Re: intermediate table not found when used the hive view

Let me confirm one thing; the deleted hive table is an intermediate table for a view, "kylin_intermediate_DW_ZYB_V_DIM_SCENIC" in this case. The view "DW_ZYB_V_DIM_SCENIC" is a lookup table. This is a know issue; It impacts on using View as lookup, and run multiple builds in parallel. I had

Re: about Measures result stroage

One Cube may has 1 or multiple Cube segments; Each segment will be saved as a HBase table. All your measures will be saved together in HTable. So the HBase table number will be equals to Cube segment numbers. 2017-07-18 15:34 GMT+08:00 apache_...@163.com : > Hi, > > I

Re: 回复：技术求助

Did you use Tableau Live mode? 在 2017年7月18日 下午2:59，沈丹丹 写道： > > > > Thank you. But the SQL is automatically generated when tableau loads > metadata, but it not supported. And I can't control it. > > > > > > 在 2017-07-18 14:45:08，"江昆" <346453...@qq.com> 写道： > >because

about Measures result stroage

Hi, I have a question, when i create model(have many measures) ,and run a cube base this model what store about measures result in hbase , Other Single hbase table ? apache_...@163.com

Re:回复：技术求助

Thank you. But the SQL is automatically generated when tableau loads metadata, but it not supported. And I can't control it. 在 2017-07-18 14:45:08，"江昆" <346453...@qq.com> 写道： >because the sql parser of kylin is calcite,it is different from sql which we >offen use...you could use your sql

??????????????

because the sql parser of kylin is calcite,it is different from sql which we offen use...you could use your sql in kylin web application-insight,you could try then you know what sql could pass or not...good luck... -- -- ??:

技术求助

大家好： 我在使用kylin整合tableau的时候遇到一些问题，我不知道如何解决，希望能得到你们的帮助。我使用的是kylin1.6版本，jdk1.7版本的，结合tableau9.0使用，但是在tableau加载kylin元数据的时候每次都会花费10分钟左右，并且内存狂飙至99%导致电脑会卡住一段时间。但是元数据很小，才18M左右。请问这是为什么？而且看kylin.log文件，里面会报很多Not Supported SQL 错误，这个该怎么解决呢？（ps，附件是tableau加载kylin元数据时kylin.log日志文件） 盼回复！谢谢！

技术求助

大家好： 我在使用kylin整合tableau的时候遇到一些问题，我不知道如何解决，希望能得到你们的帮助。我使用的是kylin1.6版本，jdk1.7版本的，结合tableau9.0使用，但是在tableau加载kylin元数据的时候每次都会花费10分钟左右，并且内存狂飙至99%导致电脑会卡住一段时间。但是元数据很小，才18M左右。请问这是为什么？而且看kylin.log文件，里面会报很多Not Supported SQL 错误，这个该怎么解决呢？（ps，附件是tableau加载kylin元数据时kylin.log日志文件）