Re: Is TOP_N measure support multiple dimensions(columns) in one group?

2016-05-15 Thread ShaoFeng Shi
mutiple group-by columns in one Top-N isn't supported; You can open a JIRA to Kylin, then we will evaluate it. 2016-05-14 15:12 GMT+08:00 lancelot chen : > I'm using kylin 1.5.1. I found that current TOP_N UI support only one > column in group by. > For this case: > table name : "tbl" > columns:

Re: kylin query failed

2016-05-15 Thread Li Yang
How high is the cardinality? By saying "failed" and then have to restart, do you mean crash? Any clue in kylin.log? Sorry for many questions, but it's hard to help without the details. The new 1.5.2 release will come with a diagnosis tool that can extract necessary info into a zip, which you can s

Re: killed by admin

2016-05-15 Thread Li Yang
At least the hadoop job history server should have some traces. On Tue, May 10, 2016 at 11:13 AM, 耳东 <775620...@qq.com> wrote: > Hi all: > > When I build the cube, in the second step 'Extract Fact Table > Distinct Columns', the log shows 'killed by admin'. > And I could not find any erro

Re: My cube build successfully,but when query return empty data set

2016-05-15 Thread Li Yang
Kylin is meant for OLAP, it does no remember raw records. Try "select count(*) from ... " On Tue, May 10, 2016 at 5:26 PM, zhangrongkun <563364...@qq.com> wrote: > My HBase table is't empty: > < > http://apache-kylin.74782.x6.nabble.com/file/n4484/QQ%E6%88%AA%E5%9B%BE20160510173749.png > > > > bu

Re: Help to go through your lira tickets

2016-05-15 Thread Li Yang
Mine are clear. On Wed, May 11, 2016 at 5:21 PM, ShaoFeng Shi wrote: > Thanks Dong for the reminding; I have updated most of the JIRAs owned by > me. Look forward to see v1.5.2. > > 2016-05-11 15:38 GMT+08:00 lidong : > > > Hello contributors, > > > > > > As we’re preparing to release v1.5.2. >

Re: qeuestion about query cube

2016-05-15 Thread Li Yang
If you could reproduce the problem with sample cube, we will be able to do something. On Thu, May 12, 2016 at 3:10 PM, streemwu wrote: > > > when I queried by sql > "select sum(sample_value) as aa ,year_int,month_int,day_int,hour_int from > fact_samples > inner join dim_time > on fact_samples.t

Re: A error at cube build. @ #3 Step Name: Build Dimension Dictionary Duration: 0.03 mins

2016-05-15 Thread Li Yang
What's the kylin version? On Fri, May 13, 2016 at 4:30 PM, 陈佛林 wrote: > java.lang.NegativeArraySizeException > at > org.apache.kylin.dict.TrieDictionary.getValueFromIdImpl(TrieDictionary.java:266) > at > org.apache.kylin.common.util.Dictionary.getValueFromId(Dictionary.java:111)

Re: Many2many relationships

2016-05-15 Thread Li Yang
Maybe give an example? On Fri, May 13, 2016 at 11:10 PM, Sarnath K wrote: > Hi, > > Can some1 point me how Kylin handles many2many relationships that > frequently occurs in warehouses? Is there Anything special need to be done? > Especially the queries using bridge tablez and their modeling in K

Re: 编译Kylin

2016-05-15 Thread Dong Li
Hello Xin, About how to work with kylin's source code, please check kylin's dev documents first. http://kylin.apache.org/development/ Thanks, Dong Li 2016-05-12 23:59 GMT+08:00 Luke Han : > Forward to @dev list, please subscribe and check there. > Thanks. > > Regards! > Luke Han > > > > > On Wed

Re: The monitor web page cannot load jobs

2016-05-15 Thread Li Yang
Try refresh kylin metadata from "Admin" tab, or restart Kylin. If the problem persists and you can reproduce stably, open a JIRA. On Sat, May 14, 2016 at 11:37 AM, jyzheng wrote: > > > The version of Kylin is 1.5.0, and Hbase’s version is 0.98. > > > > After submit the refresh of cube, I open th

Re: The monitor web page cannot load jobs

2016-05-15 Thread hongbin ma
suggest to update to 1.5.1 1.5.1 metadata is compatible with 1.5.1 On Sun, May 15, 2016 at 8:55 PM, Li Yang wrote: > Try refresh kylin metadata from "Admin" tab, or restart Kylin. If the > problem persists and you can reproduce stably, open a JIRA. > > On Sat, May 14, 2016 at 11:37 AM, jyzheng

Re: qeuestion about query cube

2016-05-15 Thread hongbin ma
please attach your hbase version as well as kylin version. please also check if you can reproduce on sample cube as liyang asked On Sun, May 15, 2016 at 8:28 PM, Li Yang wrote: > If you could reproduce the problem with sample cube, we will be able to do > something. > > On Thu, May 12, 2016 at 3

[jira] [Created] (KYLIN-1689) bug when a column being dimension as well as in a sum metric

2016-05-15 Thread hongbin ma (JIRA)
hongbin ma created KYLIN-1689: - Summary: bug when a column being dimension as well as in a sum metric Key: KYLIN-1689 URL: https://issues.apache.org/jira/browse/KYLIN-1689 Project: Kylin Issue T

Re: some doubt about query result from in insight

2016-05-15 Thread hongbin ma
looks like a bug in kylin. opened a jira in https://issues.apache.org/jira/browse/KYLIN-1689 since it's not typical for a numerical column to be dimension as well as sum metric, the bug fix may come late On Mon, May 9, 2016 at 10:44 AM, 胡志华(万里通科技及数据中心商务智能团队数据分析组) < huzhihua...@pingan.com.cn> wrote

Re: how to get the rate value

2016-05-15 Thread hongbin ma
for integer metrics, a quick workaround is to modify sum(b)/sum(a) to 1.0* sum(b)/sum(a) On Sun, May 8, 2016 at 8:26 PM, Li Yang wrote: > Thanks for the update. > > On Thu, May 5, 2016 at 2:57 PM, 耳东 <775620...@qq.com> wrote: > > > The datatype is bigint. This problem is solved, when I change t

Re: how to get the rate value

2016-05-15 Thread hongbin ma
​I think it's still worth a JIRA: https://issues.apache.org/jira/browse/KYLIN-1690 On Sun, May 15, 2016 at 11:43 PM, hongbin ma wrote: > for integer metrics, a quick workaround is to modify sum(b)/sum(a) to > 1.0*sum(b)/sum(a) > > On Sun, May 8, 2016 at 8:26 PM, Li Yang wrote: > >> Thanks for

[jira] [Created] (KYLIN-1690) always returning 0 or 1 for sum(a)/sum(b) for integer type a and b

2016-05-15 Thread hongbin ma (JIRA)
hongbin ma created KYLIN-1690: - Summary: always returning 0 or 1 for sum(a)/sum(b) for integer type a and b Key: KYLIN-1690 URL: https://issues.apache.org/jira/browse/KYLIN-1690 Project: Kylin I

?????? killed by admin

2016-05-15 Thread ????
yes, it is because REDUCE capability required is more than the supported max container capability in the cluster. Killing the Job. reduceResourceRequest: maxContainerCapability:. The problem is solved, when I change the memory to 4096 or a bigger number. --

Re: 答复: When build cube, the jobs can't continue go, kylin got this log:

2016-05-15 Thread zhangrongkun
OK,thank you. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/When-build-cube-the-jobs-can-t-continue-go-kylin-got-this-log-tp4503p4545.html Sent from the Apache Kylin mailing list archive at Nabble.com.

automatically build cube

2016-05-15 Thread ????
Hi all: In my fact table, it have data between 3/24 adn 3/30. When I create the model, I choose the starttime column(MMdd) as the partition date column. And I build the cube with data of date 3/24 at the time 5/14 23:18, after two days, it doesn't run any job to build cube again.

?????? automatically build cube

2016-05-15 Thread bitbean
please use restfapi http://kylin.apache.org/docs15/howto/howto_use_restapi.html -- -- ??: "";<775620...@qq.com>; : 2016??5??16??(??) 9:45 ??: "dev"; : automatically build cube Hi all: In my fact table, it have

Re: 答复: When build cube, the jobs can't continue go, kylin got this log:

2016-05-15 Thread ShaoFeng Shi
please also check the hadoop cluster healthy status, as there is network time out error ​

?????? automatically build cube

2016-05-15 Thread ????
Does it mean that Kylin don't have the automatically build function. If I want kylin to build cube automatically, I should call the restful api using schedule tools like quartz. -- -- ??: "bitbean";; : 2016??5??16??(??) 9:47 ??:

?????? automatically build cube

2016-05-15 Thread bitbean
i don't find any docs about automatical building function in kylin.apache.org so ,i think so, btw , i am using schedule tool to build cube every day -- -- ??: "";<775620...@qq.com>; : 2016??5??16??(??) 9:52 ??: "dev"; ???

Re: 回复: automatically build cube

2016-05-15 Thread nichunen
Hi, Please refer to http://kylin.apache.org/docs/tutorial/kylin_client_tool.html  if you are using Kylin 1.2.  I’ll submit a patch for 1.5.x version later.  George/倪春恩 Mobile:+86-13501723787| WeChat:nceecn 北京明略软件系统有限公司(MiningLamp.COM ) 上海市浦东新区晨晖路258号G座iDream张江科创中心C125 Room C125#,In

expansion rate so high

2016-05-15 Thread Peng
Hi, Is it normal when the expansion rate is about 1600% ? My cube : about one hundred million data; fact table has one lookup table; 5 dimensions , in which 4 dimensions' encoding are fixed length, separately the length are 9, 8, 8, 33 ; 2 measures, finally the expansion rat

RE: expansion rate so high

2016-05-15 Thread Yapu Jia
Which kylin version do you use? The latest version have a good improvement in data expansion. -Original Message- From: Peng [mailto:pengli0...@outlook.com] Sent: Monday, May 16, 2016 10:21 AM To: dev@kylin.apache.org Subject: expansion rate so high Hi, Is it normal when the expansi

[jira] [Created] (KYLIN-1691) can not load project info from hbase when startup.

2016-05-15 Thread Hanhui LI (JIRA)
Hanhui LI created KYLIN-1691: Summary: can not load project info from hbase when startup. Key: KYLIN-1691 URL: https://issues.apache.org/jira/browse/KYLIN-1691 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-1692) kylin server hanged during startup if hbase is not up.

2016-05-15 Thread Hanhui LI (JIRA)
Hanhui LI created KYLIN-1692: Summary: kylin server hanged during startup if hbase is not up. Key: KYLIN-1692 URL: https://issues.apache.org/jira/browse/KYLIN-1692 Project: Kylin Issue Type: Bug

答复: expansion rate so high

2016-05-15 Thread Peng
Kylin is the latest version 1.5.1 In the Advances Setting, all 5 dimensions are in an aggregation group. Thanks -邮件原件- 发件人: Yapu Jia [mailto:yapu...@microsoft.com] 发送时间: 2016年5月16日 10:38 收件人: dev@kylin.apache.org 主题: RE: expansion rate so high Which kylin version do you use? The lates

[jira] [Created] (KYLIN-1693) Support multiple group-by columns for TOP_N meausre

2016-05-15 Thread JunAn Chen (JIRA)
JunAn Chen created KYLIN-1693: - Summary: Support multiple group-by columns for TOP_N meausre Key: KYLIN-1693 URL: https://issues.apache.org/jira/browse/KYLIN-1693 Project: Kylin Issue Type: New F

Re: Many2many relationships

2016-05-15 Thread Sarnath K
Sure. Thanks for the revert. This Pythian blog explains very clearly - much better than what I can sum up. https://www.pythian.com/blog/implementing-many-to-many-relationships-in-data-warehousing/

Kylin configuration requirements

2016-05-15 Thread yaoxiao...@huan.tv
Hello , the 600 million data with kylin, four machines (3 slave node), need what configuration. yaoxiao...@huan.tv

RE: Kylin configuration requirements

2016-05-15 Thread Yapu Jia
Please refer to : http://kylin.apache.org/docs15/install/kylin_cluster.html -Original Message- From: yaoxiao...@huan.tv [mailto:yaoxiao...@huan.tv] Sent: Monday, May 16, 2016 11:11 AM To: dev Subject: Kylin configuration requirements Hello , the 600 million data with kylin, four machi

[jira] [Created] (KYLIN-1694) make multiply coefficient configurable when estimating cuboid size

2016-05-15 Thread kangkaisen (JIRA)
kangkaisen created KYLIN-1694: - Summary: make multiply coefficient configurable when estimating cuboid size Key: KYLIN-1694 URL: https://issues.apache.org/jira/browse/KYLIN-1694 Project: Kylin I

[jira] [Created] (KYLIN-1695) disable cardinality calculation job when loading hive table

2016-05-15 Thread kangkaisen (JIRA)
kangkaisen created KYLIN-1695: - Summary: disable cardinality calculation job when loading hive table Key: KYLIN-1695 URL: https://issues.apache.org/jira/browse/KYLIN-1695 Project: Kylin Issue Ty

[jira] [Created] (KYLIN-1696) Have caught exception when connection issue occurs for some Broker

2016-05-15 Thread Zhong Yanghong (JIRA)
Zhong Yanghong created KYLIN-1696: - Summary: Have caught exception when connection issue occurs for some Broker Key: KYLIN-1696 URL: https://issues.apache.org/jira/browse/KYLIN-1696 Project: Kylin