[jira] [Created] (KYLIN-1812) need info

2016-06-21 Thread Anonymous (JIRA)
Anonymous created KYLIN-1812: Summary: need info Key: KYLIN-1812 URL: https://issues.apache.org/jira/browse/KYLIN-1812 Project: Kylin Issue Type: Bug Components: Web

Kylin failed to startup

2016-06-21 Thread ????????
Hi I'm a new user for Kylin. install the Cloudera QuickStart VM 5.4 in my computer and the Kylin version is Apache Kylin v1.5.2.1 set KYLIN_HOME and CATALINA_HOME when I finish installatioin, enter the hbase shell create a table, it's can reach by my java program in eclipse.

RE: Timeout visiting cube

2016-06-21 Thread Jiaojiao Li
In my case, related information is like this. Kylin version: 1.5.2 HBase version: HBase 0.98.4.2.2.9.0-3393 Cube size: 13.16GB Source records: 85,794,927 Dimension number: 20 (several joint groups) Measure type: bigint SQL query: select count(distinct userid) from XXX LIMIT 5 If you need

Re: 答复: Re: Timeout visiting cube!

2016-06-21 Thread ShaoFeng Shi
Hi Gaolv, Did you compare the difference of the HTable before and after running " org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI"? You can build a new segment, and then describe the table in hbase shell; and then run the DeployCoprocessorCLI, then describe it again to see whether there

[jira] [Created] (KYLIN-1810) NPE in org.apache.kylin.dict.lookup.SnapshotTable.equals(SnapshotTable.java:164)

2016-06-21 Thread Richard Calaba (JIRA)
Richard Calaba created KYLIN-1810: - Summary: NPE in org.apache.kylin.dict.lookup.SnapshotTable.equals(SnapshotTable.java:164) Key: KYLIN-1810 URL: https://issues.apache.org/jira/browse/KYLIN-1810

?????? Timeout visiting cube

2016-06-21 Thread ????????????????-??????
-- -- ??: "ShaoFeng Shi";; : 2016??6??21??(??) 10:51 ??: "dev"; "user"; : "mahong...@apache.org"; : Re: Timeout visiting cube In my

Re: Timeout visiting cube

2016-06-21 Thread ShaoFeng Shi
Hi all, Recently we noticed a couple of users are facing this timeout error, even with some tiny cubes; We will try to re-produce it in our side first; If you can provide more information about your case (like hbase version, cube size, dimension nubmer, measure type, SQL query, etc), that would

Re: DISTINCT_COUNT精确计算问题

2016-06-21 Thread ShaoFeng Shi
For the precise distinct count on all data types feature, Yerui Sun is working on that; you should look at: https://issues.apache.org/jira/browse/KYLIN-1379 在 2016年6月21日 下午3:53,Roy 写道: > Hash 可能会存在重复数值.我们建立映射表的方法是使用 Dense_Rank() 函数.然后去统计. > > 而且目前kyiin count(distinct xx)

Re: kylin question

2016-06-21 Thread ShaoFeng Shi
Cool, good to know you solved the issue; your feedback to Kylin is welcomed! 2016-06-21 10:47 GMT+08:00 倪成伟 <549066...@qq.com>: > you are right,I upgrade Hbase to 1.1x, All the problems have been > solved.Thank you very much! > > -- > View this message in context: >

Re: kylin intermediate tables in Hive

2016-06-21 Thread ShaoFeng Shi
Hi Jie, would you mind to report a JIRA with this problem you found? If you can attache the json of this job and a couple of screen shot, that would be great for analysis. Thank you! 2016-06-21 16:49 GMT+08:00 Jie Tao : > actually the jobs have been disgarded. Maybe it is

Re: kylin intermediate tables in Hive

2016-06-21 Thread Jie Tao
actually the jobs have been disgarded. Maybe it is a bug that the status of the job is still "ERROR". I have a look of the jobs at the Kylin Web UI and found that the job was not marked with black colors like other discarded jobs althouth the "action" button only has one choice "diagonose".

答复: 回复:DISTINCT_COUNT精确计算问题

2016-06-21 Thread 仇同心
您好: Hash值是否会出现重复呢? 谢谢! 发件人: Weatherpop [mailto:623891...@qq.com] 发送时间: 2016年6月21日 15:11 收件人: u...@kylin.apache.org; dev@kylin.apache.org 主题: 回复:DISTINCT_COUNT精确计算问题 可以自己做一张映射表,把值hash成int后就可以用精确的count distinct了 我们这边目前实践暂时是这样的 -- 原始邮件 -- 发件人:

DISTINCT_COUNT精确计算问题

2016-06-21 Thread 仇同心
大家好: Hive字段类型为varchar,字段内容也包含英文字母和中文,对这样的字段能否做DISTINCT_COUNT精确计算?如果不能,有什么好的建议吗? 谢谢!