[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

[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

答复: 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

[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

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

[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

[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

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.

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

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

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

?????? 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

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.

?????? 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

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

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 > > > >

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

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 >

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

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

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

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

[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

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>

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

[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

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

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