Re: V1.5 query no results

2016-03-30 Thread ShaoFeng Shi
suggested Hadoop version is > 2.4-2.7. So I work with Hadoop 2.7. > > Best regards, > > Jie > > > Am 29.03.2016 um 12:35 schrieb ShaoFeng Shi: > >> I checked this query in my sandbox with 1.5.0 binary package, it can >> return >> records; >> >&

Re: V1.5 query no results

2016-03-31 Thread ShaoFeng Shi
with v1.3. It is fine > with my Hbase and Hadoop. > > Best regards, > > Jie > > > > Am 30.03.2016 um 16:36 schrieb ShaoFeng Shi: > >> Hi Jie, >> >> I compared the hadoop version in 1.5 and 1.3, they are almost the same, >> except hbase-hadoop2.v

Re: Stuck with ClassNotFoundException ( HCatInputFormat)

2016-04-02 Thread ShaoFeng Shi
this is a bug in 1.5.0, pls google this error there is a reported JIRA on this, and there is a workaround for it.  Regards, Shaofeng Shi shaofeng...@gmail.com >From Outlook Mobile On Fri, Apr 1, 2016 at 3:57 PM -0700, "Jins George" wrote: Hello Kylin Community

Re: Does INMEM Cubing algorithm release in v1.3?

2016-04-06 Thread ShaoFeng Shi
is " + alg);) > > Is there some docs describ the inmem cubing algorithm ? Is this one ( > http://www.infoq.com/cn/articles/apache-kylin-algorithm)? > -- Best regards, Shaofeng Shi

Re: Hive error when running kylin

2016-04-06 Thread ShaoFeng Shi
//logs/kylin.log > > -- > Regards > *Yagyank chadha* > > *Undergraduate student* > *Computer Science Engineering* > *Thapar University, Patiala* > -- Best regards, Shaofeng Shi

Re: Cube bulid success,insight no display table

2016-04-08 Thread ShaoFeng Shi
gt; Roy He > -- Best regards, Shaofeng Shi

Re: an error occurred when build a sample cube at step 5:create HTable

2016-04-08 Thread ShaoFeng Shi
8.10.10:7070(master1 is my namenode ip,also > running > zookeeper) > kylin.metadata.url=kylin_metadata@hbase > kylin.storage.url=hbase > kylin.hdfs.working.dir=/home/hadoop/kylin/kylin_hdfs_working_dir > kylin.job.jar=/home/hadoop/kylin/lib/kylin-job-1.5.0-SNAPSHOT.jar > > kylin.coprocessor.local.jar=/home/hadoop/kylin/lib/kylin-coprocessor-1.5.0-SNAPSHOT.jar > kylin.job.mapreduce.default.reduce.input.mb=500 > > kylin.job.remote.cli.working.dir=/home/hadoop/kylin/kylin_job_remote_cli_working_dir > > > --- > > in file kylin_job and kylin_hive , i just changed the replication "4" and > compression "fasle" > > > please help me ,thanks > regards > > a hopeless gilr from qingdao.shandong.china > > > (最后,我把我的配置信息贴出来,希望你们帮帮我 —— 一个无助的女程序员) > > ^ ^ > > > > > > > > > > > > > > > > > > > > > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/an-error-occurred-when-build-a-sample-cube-at-step-5-create-HTable-tp4102.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: Re: Cube bulid success,insight no display table

2016-04-08 Thread ShaoFeng Shi
70. so we need modify some config? > > > > > > > > > At 2016-04-08 17:02:32, "ShaoFeng Shi" wrote: > >is your kylin in a singleton mode or cluster mode? does it listen on port > >7070? > > > >2016-04-08 16:05 GMT+08:00 Roy : > >

Re: [VOTE] Release apache-kylin-1.5.1 (release candidate 1)

2016-04-09 Thread ShaoFeng Shi
gt; >> Release artifacts are signed with the following key: > >> https://people.apache.org/keys/committer/lidong.asc > >> > >> > >> Please vote on releasing this package as Apache Kylin 1.5.1. > >> > >> > >> The vote is open for the next 72 hours and passes if a majority of > >> at least three +1 PPMC votes are cast. > >> > >> > >> [ ] +1 Release this package as Apache Kylin 1.5.1 > >> [ ] 0 I don't feel strongly about it, but I'm okay with the release > >> [ ] -1 Do not release this package because... > >> > >> > >> Here is my vote: > >> > >> > >> +1 (binding) > >> > >> > >> Thanks, > >> Dong Li > > -- Best regards, Shaofeng Shi

Re: Welcome new committer and PMC member

2016-04-11 Thread ShaoFeng Shi
oth accepted. > > > >They have made significant contributions, patches, also activity > >answer others questions and issues in Kylin's community. > > > >Welcome:) > > > >Luke > > > >On behalf of the Apache Kylin PPMC > > -- Best regards, Shaofeng Shi

Re: 遇到该问题怎么解决

2016-04-12 Thread ShaoFeng Shi
guration.getClass(Configuration.java:2110) > ... 8 more -- Best regards, Shaofeng Shi

Re: an error occurred when build a sample cube at step 5:create HTable

2016-04-12 Thread ShaoFeng Shi
- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/an-error-occurred-when-build-a-sample-cube-at-step-5-create-HTable-tp4102p4140.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: How to create a streaming model.

2016-04-13 Thread ShaoFeng Shi
ng model. > > I don't know how to configure kafka topics,is it just a simple string(such > as "topic1")? > and where to configure kafka address.... > -- Best regards, Shaofeng Shi

Re: Exception at build streaming cube

2016-04-14 Thread ShaoFeng Shi
ent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) > at > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > at > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > -- Best regards, Shaofeng Shi

Re: version question

2016-04-14 Thread ShaoFeng Shi
https://kylin.apache.org/docs15/install/hadoop_env.html 2016-04-14 18:18 GMT+08:00 耳东 <775620...@qq.com>: > hi all: > > >The latest apache kylin should be installed on what version of hive > hbase and hadoop? -- Best regards, Shaofeng Shi

Re: unable to login after adding user

2016-04-14 Thread ShaoFeng Shi
LYST" /> > > > > But unable to login. > > > > > > > > > > > > 郑江雨 云平台 > > Phone: 15155195496 > > > -- Best regards, Shaofeng Shi

Re: kylin Exception log

2016-04-15 Thread ShaoFeng Shi
alina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) > at > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) > at > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > at > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > -- Best regards, Shaofeng Shi

Re: kylin Exception log

2016-04-18 Thread ShaoFeng Shi
$KYLIN_HOME/bin/find-hive-dependency.sh, and then check the output of them to see whether there is such a jar. 2016-04-18 9:56 GMT+08:00 陈佛林 : > kylin version:1.5.0 > hadoop version: 2.5.0-cdh5.3.2 > hbase version : 0.98.6-cdh5.3.2 > > > 2016-04-16 9:14 GMT+08:00 ShaoFeng Shi : > &

Re: One question about ‘kylin’

2016-04-26 Thread ShaoFeng Shi
8d-41c6-8e50-2cd8cf13da17/kylin_sales_cube/statistics/cuboid_statistics.seq > does not exists > > > i am sorry,my english is so bad.i can not Describe it clearly. > if you have free time ,please tail me where problem -- Best regards, Shaofeng Shi

Re: multi hadoop cluster

2016-04-26 Thread ShaoFeng Shi
gt; > > but "kylin_intermediate_cube8_2016030100_2016041300" locate > "hdfs://bihbasemaster/" > > > they are different clusters. > > > The current situation is there will not be any error in WEBUI at step > 1, > > > When cube done, there is nothing in Htable, so What can i do? -- Best regards, Shaofeng Shi

Re: Question about cube size estimation in Kylin 1.5

2016-04-26 Thread ShaoFeng Shi
id) x coefficient > > where coefficient = has_memory_hungry_measures(cube) ? 0.05 : 0.25 > > > > > > Why do we multiply the coefficient? And why it's five times smaller in > > memory hungry case? Cloud someone explain the rationale behind it? > > > > > > Thanks, Dayue > > > > > > > > > > > > > > > > > -- Best regards, Shaofeng Shi

Re: kylin ldap configuration problem

2016-04-26 Thread ShaoFeng Shi
teContext(AbstractContextSource.java:254) > ... 46 more > > >i also run ldap broserer on my pc,and i found i had to use > user/password with "GSS Negotiated" mode to contact my ldap server: > <http://apache-kylin.74782.x6.nabble.com/file/n4257/ldap.png> > >anyone help to tell what am i doing wrong? > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/kylin-ldap-configuration-problem-tp4257.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: cardinality number limit about raw expression

2016-04-26 Thread ShaoFeng Shi
for raw > expression(measure). > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/cardinality-number-limit-about-raw-expression-tp4286.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: how to get the rate value

2016-04-26 Thread ShaoFeng Shi
_NAME SUCC ATT ATT/SUCC > CSMME15BZX 336981 368366 0 > CSMME32BZX 338754 366842 0 > CSMME07BZX 687965 747694 0 > CSMME03BHW 703269 747623 0 > CSMME12BZX 705856 764656 0 > CSMME16BHW 1962293142173 0 -- Best regards, Shaofeng Shi

Re: Re: Re:Re: No detail message when Error.

2016-04-26 Thread ShaoFeng Shi
in Runtime Config > 2016-04-26 13:33:56,732 DEBUG [http-bio-7070-exec-3] > controller.UserController:64 : authentication.getPrincipal() is > org.springframework.security.core.userdetails.User@3b40b2f: Username: > ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; > credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: > ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER > 2016-04-26 13:33:56,826 DEBUG [http-bio-7070-exec-8] > controller.ProjectController:97 : authentication.getPrincipal() is > org.springframework.security.core.userdetails.User@3b40b2f: Username: > ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; > credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: > ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER > 2016-04-26 13:33:56,891 DEBUG [http-bio-7070-exec-1] > service.QueryService:289 : getting table metas > 2016-04-26 13:33:56,893 DEBUG [http-bio-7070-exec-1] > service.QueryService:307 : getting column metas > 2016-04-26 13:33:56,905 DEBUG [http-bio-7070-exec-1] > service.QueryService:321 : done column metas > 2016-04-26 13:34:12,127 INFO [pool-4-thread-1] > threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 0 actual running, > 0 ready, 43 others > > > > > > > At 2016-04-25 17:00:28, "Roger Shi" wrote: > >Hi Roy, > > > >Would you please provide all related logs fetched from > >$KYLIN_HOME/logs/kylin.log? It will help in reproducing the issue and > >finding the root cause. > > > >-- > >View this message in context: > http://apache-kylin.74782.x6.nabble.com/No-detail-message-when-Error-tp4152p4260.html > >Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: multi hadoop cluster

2016-04-26 Thread ShaoFeng Shi
ild cube in 5 minutes, but the result htable has no data. > > > I guess kylin doesn't fetch data from remote hdfs, and kylin doesn't tell > me it can't fetch data, > > > > > so can you help me to resolve it ? > > > > > ---

Re: Question about cube size estimation in Kylin 1.5

2016-04-26 Thread ShaoFeng Shi
The issue is very likely related with https://issues.apache.org/jira/browse/KYLIN-1624; You can wait for v1.5.2, or pick the commits related with HLL (on master branch) made by Yang yesterday. 2016-04-26 17:49 GMT+08:00 ShaoFeng Shi : > Hi Dayue, > > could you please open a JIRA for

Re: KYLIN-955 not work

2016-04-27 Thread ShaoFeng Shi
addResource(org.apache.hadoop.conf.Configuration) > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/KYLIN-955-not-work-tp4313.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: cube data and insight are not synchronized

2016-04-28 Thread ShaoFeng Shi
or > damage to your system. Envision Energy Limited does not guarantee the > integrity of this email message, nor that this email message is free of > viruses, interceptions, or interference. > -- Best regards, Shaofeng Shi

Re: kylin安装后看不到默认的三张表

2016-04-28 Thread ShaoFeng Shi
Expired: true; > credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: > ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER > 2016-04-28 19:27:45,455 DEBUG [http-bio-7070-exec-9] > controller.UserController:64 : authentication.getPrincipal() is > org.springframework.security.core.userdetails.User@3b40b2f: Username: > ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; > credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: > ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER > 2016-04-28 19:28:18,014 INFO [pool-2-thread-1] > threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 0 actual running, > 0 ready, 17 others > > -- > -- > 接口平台项目组-田伟 > 电话:150 1410 4760 > 外网邮箱:372861...@qq.com > 内网邮箱:tian.wei...@zte.com.cn > QQ: 372861232 > -- > > > > > > > > -- 原始邮件 -- > 发件人: "lidong";; > 发送时间: 2016年4月28日(星期四) 晚上7:32 > 收件人: "dev"; > > 主题: 回复: kylin安装后看不到默认的三张表 > > > > Please provide the log, otherwise we are not able to help. > > > Thanks, > Dong > > > Original Message > Sender:︶ㄣ溡簡~~372861...@qq.com > Recipient:dev...@kylin.apache.org > Date:Thursday, Apr 28, 2016 19:11 > Subject:回复: kylin安装后看不到默认的三张表 > > > yes,Please help to see. > > > > > --原始邮件-- > 发件人:"lidong";lid...@apache.org; > 发送时间:2016年4月28日(星期四) 晚上7:08 > 收件人:"dev"dev@kylin.apache.org; > 主题:Re: kylin安装后看不到默认的三张表 > > > Have you checked logs/kylin.log? > > > Thanks, > Dong > > > Original Message > Sender:︶ㄣ溡簡~~372861...@qq.com > Recipient:dev...@kylin.apache.org > Date:Thursday, Apr 28, 2016 18:52 > Subject:kylin安装后看不到默认的三张表 > > > 采用集群分布方式,各版本如下 hadoop-2.4.0.tar.gz hbase-0.98.3-hadoop2-bin.tar.gz > apache-hive-0.13.1-bin.tar.gz apache-kylin-1.5.1-bin.tar.gz > -- > -- Best regards, Shaofeng Shi

Re: java.lang.IllegalArgumentException:KeyValue size too large at Building Dimension Dictionary

2016-05-03 Thread ShaoFeng Shi
job.execution.AbstractExecutable.execute(AbstractExecutable > .java:114) > > at > > org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultS > cheduler.java:124) > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:11 > 45) > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:6 > 15) > > at java.lang.Thread.run(Thread.java:745) > > > > result code:2 > > > > Thanks, > > > > Laney. > > > > -- Best regards, Shaofeng Shi

Re: CubeHFileJob fail with mr job configuration

2016-05-04 Thread ShaoFeng Shi
E)); > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/CubeHFileJob-fail-with-mr-job-configuration-tp4331p4387.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: Exception at build streaming cube

2016-05-05 Thread ShaoFeng Shi
> > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) > > >> > at > > >> > > > >> > > > >> > > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > >> > at > > >> > > > >> > > > >> > > > org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) > > >> > at > > >> > > > >> > > > >> > > > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) > > >> > at > > >> > > > >> > > > >> > > > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) > > >> > at > > >> > > > >> > > > >> > > > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > > >> > at > > >> > com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:195) > > >> > at > > >> > com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) > > >> > at > > >> > > > >> > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > > >> > at > > >> > > > >> > > > >> > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > > >> > at > > >> > > > >> > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) > > >> > at > > >> > > > >> > > > >> > > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) > > >> > at > > >> > > > >> > > > >> > > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > > >> > at > > >> > > > >> > > > >> > > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > > >> > at > > >> > > > >> > > > >> > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > >> > at > > >> > > > >> > > > >> > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > >> > at > > >> > > > >> > > > >> > > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > > >> > at java.lang.Thread.run(Thread.java:745) > > >> > > > >> > > > >> > > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) > > >> > at > > >> > > > >> > > > >> > > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > > >> > at > > >> > > > >> > > > >> > > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > > >> > at > > >> > > > >> > > > >> > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > >> > at > > >> > > > >> > > > >> > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > >> > at > > >> > > > >> > > > >> > > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > > >> > at java.lang.Thread.run(Thread.java:745) > > >> > > > >> > > >> > > >> > > >> -- > > >> Best regards, > > >> > > >> Shaofeng Shi > > >> > > > > > > > > > > > > -- > Regards, > VaibhaV > -- Best regards, Shaofeng Shi

Re: Exception at build streaming cube

2016-05-05 Thread ShaoFeng Shi
amingCLI.java:91) > 2016-05-04 20:29:51,887 INFO [Thread-0 > ConnectionManager$HConnectionImplementation:1677]: Closing zookeeper > sessionid=0x1547c9ab1b10015 > 2016-05-04 20:29:51,889 INFO [Thread-0 ZooKeeper:684]: Session: > 0x1547c9ab1b10015 closed > 2016-05-04 20:29:51,889 IN

Re: Table 'KYLIN_CAL_DT' not found

2016-05-05 Thread ShaoFeng Shi
context.scheme=https > saml.context.serverName=hostname > saml.context.serverPort=443 > saml.context.contextPath=/kylin > > > ganglia.group= > ganglia.port=8664 > > ## Config for mail service > > # If true, will send email notification; > mail.enabled=false > mail.host= > mail.username= > mail.password= > mail.sender= > > ###config info for web### > > #help info ,format{name|displayName|link} ,optional > kylin.web.help.length=4 > kylin.web.help.0=start|Getting Started| > kylin.web.help.1=odbc|ODBC Driver| > kylin.web.help.2=tableau|Tableau Guide| > kylin.web.help.3=onboard|Cube Design Tutorial| > > #guide user how to build streaming cube > kylin.web.streaming.guide=http://kylin.apache.org/ > > #hadoop url link ,optional > kylin.web.hadoop= > #job diagnostic url link ,optional > kylin.web.diagnostic= > #contact mail on web page ,optional > kylin.web.contact_mail= > > ###config info for front### > > #env DEV|QA|PROD > deploy.env=DEV > > ###deprecated configs### > kylin.sandbox=true > kylin.web.hive.limit=2 > > > > wenye...@163.com > -- Best regards, Shaofeng Shi

Re: 答复: Can't create EnumerableAggregate

2016-05-05 Thread ShaoFeng Shi
at this email message is free of > viruses, interceptions, or interference. > > > > > > 本邮件(包括任何附件)内容机密并受法律保护。如果您意外地收到这封邮件,请回复通知发件人并从当前系统中删除本邮件。任何未经授权者,严禁使用并部分或者全部的转发本条信息。任何未经授权的使用或传播都是被严格禁止的。远景能源与其分公司不对因不正确和不完整的转发此邮件包含的信息以及因任何因邮件延迟或对你的系统造成的损害而负责。远景能源不能保证此邮件的真实完整性,也不能确定此邮件是否含有病毒或者监听程序。 > This email message (including any attachments) is confidential and may be > legally privileged. If you have received it by mistake, please notify the > sender by return email and delete this message from your system. Any > unauthorized use or dissemination of this message in whole or in part is > strictly prohibited. Envision Energy Limited and all its subsidiaries shall > not be liable for the improper or incomplete transmission of the > information contained in this email nor for any delay in its receipt or > damage to your system. Envision Energy Limited does not guarantee the > integrity of this email message, nor that this email message is free of > viruses, interceptions, or interference. > -- Best regards, Shaofeng Shi

Re: 答复: 答复: 答复: Can't create EnumerableAggregate

2016-05-05 Thread ShaoFeng Shi
: > > > My configuration environment as follows: > > Hadoop: 2.5.2 > > Hive: 1.2.1 > > Hbase: 1.1.3 > > Kylin: 1.5.1 > > > > -邮件原件- > > 发件人: ShaoFeng Shi [mailto:shaofeng...@apache.org] > > 发送时间: 2016年5月6日 11:13 > > 收件人: dev@kylin

Re: Re: Table 'KYLIN_CAL_DT' not found

2016-05-05 Thread ShaoFeng Shi
If the cube wasn't built, the query won't work; what's the error of the cube build? 2016-05-06 12:12 GMT+08:00 wenye...@163.com : > Build cube falied also! > But in the version of kylin 1.3 successfully ,before build cuse! > > > > wenye...@163.com > > From

Re: problem happened at step "build base cuboid data"

2016-05-06 Thread ShaoFeng Shi
email is taken to accept these risks. > > 收发邮件者请注意: > 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。 > 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。 > > > -- Best regards, Shaofeng Shi

Re: 答复: problem happened at step "build base cuboid data"

2016-05-06 Thread ShaoFeng Shi
int > pt_log_dstring > partner_id string > > # Partition Information > # col_name data_type comment > > pt_log_dstring > partner_id string > Time taken: 0.124 seconds, Fetched: 47 row(s) > hive>

Re: 答复: 答复: problem happened at step "build base cuboid data"

2016-05-06 Thread ShaoFeng Shi
数据分析组) < huzhihua...@pingan.com.cn>: > I think it's difficulty to check, the amount of data is huge. > > Could you give me some suggestion? > > -----邮件原件- > 发件人: ShaoFeng Shi [mailto:shaofeng...@apache.org] > 发送时间: 2016年5月6日 23:33 > 收件人: dev@kylin.apache.or

Re: kylin 1.5.1 start failed on hdpp 2.2.4

2016-05-09 Thread ShaoFeng Shi
2.4.2-2/hbase/lib/ranger-hbase-plugin-0.4.0.2.2.4.2-2.jar > /usr/hdp/2.2.4.2-2/hbase/lib/ranger-plugins-audit-0.4.0.2.2.4.2-2.jar > /usr/hdp/2.2.4.2-2/hbase/lib/ranger-plugins-common-0.4.0.2.2.4.2-2.jar > /usr/hdp/2.2.4.2-2/hbase/lib/ranger-plugins-cred-0.4.0.2.2.4.2-2.jar > /usr/hdp/2.2.4.2-2/hbase/lib/ranger-plugins-impl-0.4.0.2.2.4.2-2.jar > /usr/hdp/2.2.4.2-2/hbase/lib/servlet-api-2.5-6.1.14.jar > /usr/hdp/2.2.4.2-2/hbase/lib/servlet-api-2.5.jar > /usr/hdp/2.2.4.2-2/hbase/lib/slf4j-api-1.6.4.jar > /usr/hdp/2.2.4.2-2/hbase/lib/snappy-java-1.0.4.1.jar > /usr/hdp/2.2.4.2-2/hbase/lib/xercesImpl-2.9.1.jar > /usr/hdp/2.2.4.2-2/hbase/lib/xml-apis-1.3.04.jar > /usr/hdp/2.2.4.2-2/hbase/lib/xmlenc-0.52.jar > /usr/hdp/2.2.4.2-2/hbase/lib/xz-1.0.jar > /usr/hdp/2.2.4.2-2/hbase/lib/zookeeper.jar -what's the > problem? -- Best regards, Shaofeng Shi

Re: Help to go through your lira tickets

2016-05-11 Thread ShaoFeng Shi
, or label it as“fix version: v1.5.3” > > > Also it is preferable if you can go through your recent JIRA ticket > by“project = KYLIN AND assignee= currentUser() ORDER BY updated DESC”to see > if any resolved issues’s fix version being v1.5.2 > > > Thanks, > Dong Li -- Best regards, Shaofeng Shi

Re: how can i increase the count of reduce at Kylin_HFile_Generator_cubename_step?

2016-05-13 Thread ShaoFeng Shi
i increase my reduces of mr at > Kylin_HFile_Generator_cubename_step? > > -- Best regards, Shaofeng Shi

Re: Can't build and refresh job

2016-05-13 Thread ShaoFeng Shi
ttpServlet.service(HttpServlet.java:649) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:727) > > > > I can use others kylin server to build or refresh this cube. > > And, when I restart this kylin server, I can refresh and build > this cube. So, I think that maybe a bug. > > Can you help me to fix it. > > > > Thanks, > > Yapu > > > -- Best regards, Shaofeng Shi

Re: Can't build and refresh job

2016-05-13 Thread ShaoFeng Shi
have any running or error job about this cube. I think I can't > use others Kylin server to build and refresh it. > In this case, it may be a Kylin bug. > > -Original Message- > From: ShaoFeng Shi [mailto:shaofeng...@apache.org] > Sent: Friday, May 13, 2016 10:

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

2016-05-15 Thread ShaoFeng Shi
im_industry) and (dim_city, dim_industrt), is kylin > 1.5.1 support those tow use cases? > > Best Regards! > -- Best regards, Shaofeng Shi

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 ​

Re: About Cube List

2016-05-16 Thread ShaoFeng Shi
gt; > > > Best Wishes! > > > > > > > > > > > -- > > Regards, > > > > *Bin Mahone | 马洪宾* > > Apache Kylin: http://kylin.io > > Github: https://github.com/binmahone > > > -- Best regards, Shaofeng Shi

Re: why can't I see the project which is created by other kylin server when I visit a kylin server ?

2016-05-17 Thread ShaoFeng Shi
; Sent from the Apache Kylin mailing list archive at Nabble.com. > > > > > > -- > Regards, > > *Bin Mahone | 马洪宾* > Apache Kylin: http://kylin.io > Github: https://github.com/binmahone > -- Best regards, Shaofeng Shi

Re: [VOTE] Release apache-kylin-1.5.2 (release candidate 3)

2016-05-23 Thread ShaoFeng Shi
> > > > The vote is open for the next 72 hours and passes if a majority of > > at least three +1 PPMC votes are cast. > > > > [ ] +1 Release this package as Apache Kylin 1.5.2 > > [ ] 0 I don't feel strongly about it, but I'm okay with the release > > [ ] -1 Do not release this package because... > > > > Here is my vote: > > +1 (binding) > > > > Thanks, > > Dong Li > > > -- Best regards, Shaofeng Shi

Re: kylin_client_tool.py

2016-05-25 Thread ShaoFeng Shi
shall > not be liable for the improper or incomplete transmission of the > information contained in this email nor for any delay in its receipt or > damage to your system. Envision Energy Limited does not guarantee the > integrity of this email message, nor that this email message is fre

Re: [ANNOUNCE] Apache Kylin 1.5.2 released

2016-05-26 Thread ShaoFeng Shi
; The Apache Kylin Team > > [1] https://kylin.apache.org/docs15/release_notes.html > [2] https://kylin.apache.org/download/ > -- Best regards, Shaofeng Shi

Re: Understanding the cube building process

2016-05-26 Thread ShaoFeng Shi
of > > these > > > > internals? I did find [1] but I'm looking go descend another level. > I'm > > > > curious about the various steps involved (looks like it ran 18 > "steps" > > > and > > > > 10 MR jobs), what they're doing. I'm also curious about the schema > > design > > > > for the data model in HBase. > > > > > > > > Thanks in advance! > > > > -n > > > > > > > > [0]: http://kylin.apache.org/docs15/tutorial/kylin_sample.html > > > > [1]: http://www.slideshare.net/YangLi43/design-cube-in-apache-kylin > > > > > > > > > > -- Best regards, Shaofeng Shi

Re: question about the joint dimension and query

2016-05-26 Thread ShaoFeng Shi
llows, where should I configure? > # java.lang.OutOfMemoryError: Java heap space > # -XX:OnOutOfMemoryError="kill -9 %p" > # Executing /bin/sh -c "kill -9 1909"... -- Best regards, Shaofeng Shi

Re: when I saved queries,having exception "Table 'kylin_metadata_user' was not found"

2016-05-27 Thread ShaoFeng Shi
e.java:116) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) > at > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) > at > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > at > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > > > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/when-I-saved-queries-having-exception-Table-kylin-metadata-user-was-not-found-tp4745.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: Unable build sample cube.Failing at Step 2

2016-05-30 Thread ShaoFeng Shi
to see any > job. > > Job is not submitting to Hadoop. > > > Can i know any solution for this > Regards, > Mahesh > -- Best regards, Shaofeng Shi

Re: Extract Fact Table Distinct Columns step taking more time

2016-06-01 Thread ShaoFeng Shi
taken by this step? > I am using Kylin version 1.5.2 with default settings. > -- Best regards, Shaofeng Shi

Re: unable to start Kylin

2016-06-03 Thread ShaoFeng Shi
> *This is what I'm getting, and Kylin is not launching. Am I doing any > mistake here.. please help.* > > > > -- > > Thanks & Regards, > Veeresh Kottargi > Cell : 07299166704 / 09035503204 <%2009035503204> > Chennai-India > -- > -- Best regards, Shaofeng Shi

Re: TOPN group by column can not defined in dimension

2016-06-03 Thread ShaoFeng Shi
"name": "F1", > "columns": [ > { > "qualifier": "M", > "measure_refs": [ > "TRANS_CNT", > "TOP", > "SOURCE", > "TOPP" > ] > } > ] > }, > { > "name": "F2", > "columns": [ > { > "qualifier": "M", > "measure_refs": [ > "SELLER_CNT_HLL", > "SELLER_FORMAT_CNT", > "ITEM_COUNT_DISTINCT_COUNT" > ] > } > ] > } > ] > }, > "aggregation_groups": [ > { > "includes": [ > "CATEG_LVL2_NAME", > "CATEG_LVL3_NAME", > "LEAF_CATEG_ID", > "LSTG_FORMAT_NAME", > "LSTG_SITE_ID", > "META_CATEG_NAME", > "PART_DT" > ], > "select_rule": { > "hierarchy_dims": [ > [ > "META_CATEG_NAME", > "CATEG_LVL2_NAME", > "CATEG_LVL3_NAME" > ] > ], > "mandatory_dims": [ > "PART_DT" > ], > "joint_dims": [ > [ > "LEAF_CATEG_ID", > "LSTG_SITE_ID" > ] > ] > } > } > ], > "notify_list": null, > "status_need_notify": [], > "partition_date_start": 132537600, > "partition_date_end": 31536, > "auto_merge_time_ranges": [], > "retention_range": 0, > "engine_type": 2, > "storage_type": 2, > "override_kylin_properties": {} > } > > > Threr are two TOPN deminsions on group by META_CATEG_NAME and one group by > ITEM_COUNT(just for test),I run query : select cal_dt, META_CATEG_NAME, > sum(price) from KYLIN_SALES as f inner join KYLIN_CAL_DT as d on d.cal_dt = > f.part_dt inner join kylin_category_groupings as g on f.LEAF_CATEG_ID = > g.LEAF_CATEG_ID and f.LSTG_SITE_ID = g.SITE_ID group by cal_dt , > META_CATEG_NAME order by sum(price) desc limit 10; > it return :Can't find any realization. Please confirm with providers. > > And I run query : select cal_dt, ITEM_COUNT, sum(price) from KYLIN_SALES > as f inner join KYLIN_CAL_DT as d on d.cal_dt = f.part_dt inner join > kylin_category_groupings as g on f.LEAF_CATEG_ID = g.LEAF_CATEG_ID and > f.LSTG_SITE_ID = g.SITE_ID group by cal_dt , ITEM_COUNT order by > sum(price) desc limit 10; > It return success ! > > I check code and find kylin will remove defined dimension from dimensions > that used in the query, and try to influenceCapabilityCheck with > unmatchedDimensions and unmatchedAggregations, as the dimension(like > META_CATEG_NAME) has been remove and can not find in > TopNMeasureType.influenceCapabilityCheck, Am I right? or sth I do not get. > > Thanks a lot. > -- Best regards, Shaofeng Shi

[VOTE] Release apache-kylin-1.5.2.1 (release candidate 1)

2016-06-04 Thread ShaoFeng Shi
th the release [ ] -1 Do not release this package because... Here is my vote: +1 (binding) Shaofeng Shi

Re: [Draft][REPORT] Apache Kylin - Jun 2016

2016-06-04 Thread ShaoFeng Shi
arge datasets. > > > > ## Issues: > > == > > - there are no issues requiring board attention at this time > > > > ## Activity: > > > > - Mailing list, JIRA, and commit activity are at or above average > > - Yang Li present

Re: No seller_id in dimensions but can create a count distinct measure on it in kylin sample cube

2016-06-06 Thread ShaoFeng Shi
by a single seller_id > > > > CDH: 5.7 > > Kylin: 1.5.2_CDH_5.7 > > > > Can anybody help me out with the confusion,thanks > > > > > > Best regards > > jxHe > > > > -- Best regards, Shaofeng Shi

Re: question to building cube from kafka

2016-06-07 Thread ShaoFeng Shi
r support recursive JSON structure, i.e., a JSON > attribute is an object containing other attributes? Like: > > { > "foo": { > "attr1": 70, > "att2: "blabla" > }, > "fa": > } > > Cheers, > > Jie > -- Best regards, Shaofeng Shi

[RESULT] [VOTE] Release apache-kylin-1.5.2.1 (release candidate 1)

2016-06-07 Thread ShaoFeng Shi
Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 5 binding +1s: Shaofeng Shi Dong Li Dayue Gao Xiaoyu Wang Luke Han 1 non-binding +1s: Chunen Ni No 0s or -1s. Therefore I am delighted to announce that the proposal to release

Re: question to TOP-N feature

2016-06-07 Thread ShaoFeng Shi
nding order rather than descending order? > > Cheers, > > Jie > -- Best regards, Shaofeng Shi

Re: 答复: Timeout visiting cube!

2016-06-07 Thread ShaoFeng Shi
> 每次当我build完 cube之后,都必须去更新 Update HBase Coprocessor > 否则查询的时候便会报错,如下:Error while executing SQL "SELECT * FROM > YOOSHU_BID_REQUEST_VIEWS LIMIT 10": Timeout visiting cube! > > 当执行完$KYLIN_HOME/bin/kylin.sh > org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI > $KYLIN_HOME/lib/kylin-coprocessor-*.jar all > 之后,便可以正常查询。 > 但是下次build之后,又会出现这个问题。 > > 应该如何解决的啊? > > > > > gaolv123...@163.com > -- Best regards, Shaofeng Shi

[Announce] Apache Kylin 1.5.2.1 released

2016-06-07 Thread ShaoFeng Shi
ments and contributions. Thanks, The Apache Kylin Team [1] https://kylin.apache.org/docs15/release_notes.html [2] https://kylin.apache.org/download/ -- Best regards, Shaofeng Shi

Re: question to TOP-N feature

2016-06-07 Thread ShaoFeng Shi
; > Am 07.06.2016 um 16:56 schrieb ShaoFeng Shi: > >> Although there is a JIRA ( >> https://issues.apache.org/jira/browse/KYLIN-1477) >> for this, I haven't found a case; Jie, would you mind to share your >> scenario? >> >> 2016-06-07 17:57 GMT+08:00 Jie Ta

Re: [Announce] Apache Kylin 1.5.2.1 released

2016-06-08 Thread ShaoFeng Shi
e such links for further detail). > > Please can you add that information to future announce mails? > > Thanks. > > > On 8 June 2016 at 03:09, ShaoFeng Shi wrote: > > The Apache Kylin team is pleased to announce the immediate availability > of > > the 1.5.2.1 rel

Re: [Announce] Apache Kylin 1.5.2.1 released

2016-06-08 Thread ShaoFeng Shi
Readers should not have to click the link to find out the basic information > (although of course it is useful to have such links for further detail). > > Please can you add that information to future announce mails? > > Thanks. > > > On 8 June 2016 at 03:09, ShaoFeng Shi

Re: stream build problem

2016-06-08 Thread ShaoFeng Shi
Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: 配置问题

2016-06-08 Thread ShaoFeng Shi
Method.java:606) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > 2016-06-09 00:41:05,335 INFO [Thread-1] > client.ConnectionManager$HConnectionImplementation: Closing zookeeper > sessionid=0x15530aec581000a > 2016-06-09 00:41:05,349 INFO [main-EventThread] zookeeper.ClientCnxn: > EventThread shut down > 2016-06-09 00:41:05,354 INFO [Thread-1] zookeeper.ZooKeeper: Session: > 0x15530aec581000a closed -- Best regards, Shaofeng Shi

Re: stream build problem

2016-06-08 Thread ShaoFeng Shi
I guess you're running the master branch, which is unstable; suggest to use the latest released version 1.5.2.1. For the error you reported, a JIRA is created: https://issues.apache.org/jira/browse/KYLIN-1777 Thanks; 2016-06-09 10:19 GMT+08:00 ShaoFeng Shi : > Hi felix, which version

Re: How to do DateDiff in Kylin

2016-06-09 Thread ShaoFeng Shi
Hi Uma, could you please give a sample SQL with DateDiff? 2016-06-09 13:49 GMT+08:00 Uma Maheshwar Kamuni : > is there any function for DateDiff in Kylin. > -- Best regards, Shaofeng Shi

Re: How to do DateDiff in Kylin

2016-06-10 Thread ShaoFeng Shi
contains date) > > ____ > From: ShaoFeng Shi > Sent: Thursday, June 9, 2016 8:22:08 PM > To: dev@kylin.apache.org > Subject: Re: How to do DateDiff in Kylin > > Hi Uma, could you please give a sample SQL with DateDiff? > > 2016-06-09 13:49 GMT+08:00 Uma Maheshwar Kamuni : > &

Re: How to do DateDiff in Kylin

2016-06-11 Thread ShaoFeng Shi
g/jira/browse/CALCITE-759 but that has not > been implemented. > > Julian > > > On Fri, Jun 10, 2016 at 7:54 AM, ShaoFeng Shi > wrote: > > I don't see such a function in Calcite (Kylin's SQL parser): > > https://calcite.apache.org/docs/reference.html#date

Re: 答复: snapshot table not update

2016-06-11 Thread ShaoFeng Shi
s.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml > > > > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/snapshot-table-not-update-tp4854p4906.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: How to do DateDiff in Kylin

2016-06-11 Thread ShaoFeng Shi
te a few releases. > > > > > On Jun 11, 2016, at 3:27 AM, ShaoFeng Shi > wrote: > > > > Julian, from which version Calcite supports the minus operation between > two > > dates? > > > > I tried "select cal_dt, (current_date - cal_dt) as diff

Re: 答复: 答复: snapshot table not update

2016-06-11 Thread ShaoFeng Shi
Is the table content changed in between? 2016-06-12 10:55 GMT+08:00 yubo-...@yolo24.com : > I updated all the rows. > > Actually, I dropped the table and created it again. > > 发件人: ShaoFeng Shi-2 [via Apache Kylin] [mailto: > ml-node+s74782n490...@n6.nabble.com] > 发送时间: 2

Re: 答复: 答复: 答复: snapshot table not update

2016-06-11 Thread ShaoFeng Shi
Issue created, please subscribe it for update: https://issues.apache.org/jira/browse/KYLIN-1780 2016-06-12 11:54 GMT+08:00 yubo-...@yolo24.com : > Yes. All rows in the table changed > > 发件人: ShaoFeng Shi-2 [via Apache Kylin] [mailto: > ml-node+s74782n4911...@n6.nabble.com] > 发送时间

Re: Timeout visiting cube

2016-06-12 Thread ShaoFeng Shi
hannelImplementation.callBlockingMethod(AbstractRpcClient.java:323) > at > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.execService(ClientProtos.java:32855) > at > org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1616) > ... 13 more > > > > > gaolv123...@163.com > -- Best regards, Shaofeng Shi

Re: Re: Timeout visiting cube

2016-06-12 Thread ShaoFeng Shi
to open a JIRA with the necessary logs, we will investigate. 2016-06-13 9:58 GMT+08:00 gaolv123...@163.com : > version infos : > > Kylin 1.5.1 > HBase 1.1.4 for apache package > hadoop cdh5.7 > > > > gaolv123...@163.com > > From: ShaoFeng Shi > Date: 2016-06-13 0

Re: GHow to query TOP-N

2016-06-13 Thread ShaoFeng Shi
yes 2016-06-14 0:40 GMT+08:00 Jie Tao : > > shall I use "select sum(price) group by seller_id" for the defined measure > TOP_SELLER with sum(price) and seller_id? > > Cheers, > > Jie > -- Best regards, Shaofeng Shi

Re: kylin hbase 1.2.1

2016-06-15 Thread ShaoFeng Shi
unJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > 2016-06-15 17:06:42,218 INFO [Thread-1] > client.ConnectionManager$HConnectionImplementation: Closing zookeeper > sessionid=0x155534c2e010006 > 2016-06-15 17:06:42,313 INFO [Thread-1] zookeeper.ZooKeeper: Session: > 0x155534c2e010006 closed > 2016-06-15 17:06:42,329 INFO [main-EventThread] zookeeper.ClientCnxn: > EventThread shut down > -- Best regards, Shaofeng Shi

Re: Extract Fact Table Distinct Columns problem

2016-06-16 Thread ShaoFeng Shi
function > description? > > > > In this FactDistinctColumnsJob.class , Line 80 ,List > columnsNeedDict = cubeMgr.getAllDictColumnsOnFact(cubeDesc) : The method to > realize the function of what. > > > > > > > > > > Thanks! > > > > > -- Best regards, Shaofeng Shi

Re: kylin intermediate tables in Hive

2016-06-17 Thread ShaoFeng Shi
ing, but > > I still see one "kylin_intermediate_cubename_searchdata" table for each > > cube building in Hive. Are these tables still usefull for Kylin? I use > > Kylin 1.5.2.1. > > > > Cheers, > > > > Jie > > > -- Best regards, Shaofeng Shi

Re: kylin intermediate tables in Hive

2016-06-17 Thread ShaoFeng Shi
BTW, are you using a view as lookup table? 2016-06-17 15:15 GMT+08:00 ShaoFeng Shi : > This is common; If you have a job failed in between, and you discard that > job, the "Garbage collection" step will not be executed, so the garbages > will be left there. > > This

Re: kylin intermediate tables in Hive

2016-06-17 Thread ShaoFeng Shi
ble with job id 8a377e30-e3ba-4fe2-be12-e7d412afec5e > with job status ERROR > > Best regards, > > Jie > > > Am 17.06.2016 um 09:16 schrieb ShaoFeng Shi: > >> BTW, are you using a view as lookup table? >> >> 2016-06-17 15:15 GMT+08:00 ShaoFeng Shi : >> >

Re: kylin intermediate tables in Hive

2016-06-17 Thread ShaoFeng Shi
17.06.2016 um 10:31 schrieb ShaoFeng Shi: > >> Hi Jie, >> >> If a job is "ERROR", the intermediate hive table of it will not be >> dropped, >> as "ERROR" is not a final state; User can resume an "Error" job at any >> time, so Kylin

Re: Number of cube dimensions is limited to 62?

2016-06-17 Thread ShaoFeng Shi
; > *Java Backend Developer*I glispa GmbH > > Sonnenburger Straße 73, 10437 Berlin, Germany > E victoria.tsk...@glispamedia.com e.mail.ru/compose/?mailto=mailto%3avictoria.tsk...@glispamedia.com> > Skype: vikatskhay I www.glispa.com <http://www.glispa.com> > > Sitz Berlin, AG Charlottenburg HRB 114678B > -- Best regards, Shaofeng Shi

Re: 问下怎么调试sample.sh

2016-06-19 Thread ShaoFeng Shi
.RunJar ${job_jar} > org.apache.kylin.common.persistence.ResourceTool upload > ${KYLIN_HOME}/sample_cube/metadata > 这段我想debug查看执行过程应该怎么做? -- Best regards, Shaofeng Shi

Re: join & left join in kylin

2016-06-20 Thread ShaoFeng Shi
n support snowflake schema in data warehouse? > 2.If Kylin can only support star schema, under what circumstances shall > we use join instead of left join? > > > look forward to your help, thx~ > > > > > > > -- > 李寅威 | CVTE > cor...@foxmail.com > 广州视源电子科技股份有限公司 > Guangzhou Shiyuan Electronics Co., Ltd. -- Best regards, Shaofeng Shi

Re: kylin intermediate tables in Hive

2016-06-21 Thread ShaoFeng Shi
; > Cheers, > > Jie > > > Am 17.06.2016 um 11:05 schrieb ShaoFeng Shi: > >> by default the web UI only shows the jobs in LAST ONE WEEK, pls have a >> check. >> >> 2016-06-17 16:58 GMT+08:00 Jie Tao : >> >> actually I discarded all jobs and

Re: kylin question

2016-06-21 Thread ShaoFeng Shi
://apache-kylin.74782.x6.nabble.com/java-lang-NoSuchMethodError-org-apache-hadoop-hbase-coprocessor-RegionCoprocessorEnvironment-getRegi-tp4698p5061.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: DISTINCT_COUNT精确计算问题

2016-06-21 Thread ShaoFeng Shi
int类型的统计. > > 希望可以帮到你. > > Roy > > > > > 在 2016-06-21 15:08:46,"仇同心" 写道: > >大家好: > > > Hive字段类型为varchar,字段内容也包含英文字母和中文,对这样的字段能否做DISTINCT_COUNT精确计算?如果不能,有什么好的建议吗? > > > >谢谢! > -- Best regards, Shaofeng Shi

Re: Timeout visiting cube

2016-06-21 Thread ShaoFeng Shi
ount: 0 Accept Partial: true Is Partial Result: false > Hit Exception Cache: false Storage cache used: false > Message: Error while executing SQL "select count(distinct userid) from > cortanauu LIMIT 5": Timeout visiting cube! > ==[QUERY]=== > > > > -Original Message- > From: hongbin ma [mailto:mahong...@apache.org] > Sent: Wednesday, June 15, 2016 10:09 PM > To: dev > Subject: Re: Timeout visiting cube > > ​actually, can you please attach latest 2 minutes' log before > 2016-06-15 02:18:22,741? > it's still incomplete for our analysis > > > > > -- > Regards, > > *Bin Mahone | 马洪宾* > Apache Kylin: > https://na01.safelinks.protection.outlook.com/?url=http%3a%2f%2fkylin.io&data=01%7c01%7cjiaoli%40064d.mgd.microsoft.com%7ce53a04299632406e334208d395269be8%7c72f988bf86f141af91ab2d7cd011db47%7c1&sdata=vpTxGJMsJQ7CoMHsEjHWBxaRVgQWfLVp6mcuFmlqzzI%3d > Github: https://github.com/binmahone > -- Best regards, Shaofeng Shi

Re: 答复: Re: Timeout visiting cube!

2016-06-21 Thread ShaoFeng Shi
4 for apache package。 > > > > What may be the problem? > > > > > > > > gaolv123...@163.com > > > > 发件人: Li Yang > > 发送时间: 2016-06-08 17:24 > > 收件人: dev > > 抄送: 吴钰彬 > > 主题: Re: 答复: Timeout visiting cube! > > There must b

Re: Number of cube dimensions is limited to 62?

2016-06-21 Thread ShaoFeng Shi
ous one but *replacing values with integers* and > applying *bitwise operations with bitmasks*. E.g. L would be "encoded" with > 01, M - 10, H - 11. Then a string 'HL_' would look like 110100 -> 52. Then > when we want to get an 'L' in the middle ('_L_&#x

Re: Timeout visiting cube

2016-06-21 Thread ShaoFeng Shi
6GB > 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 more information please let me know. > > -Original Message- > From: ShaoFeng Shi [mailto:

<    1   2   3   4   5   6   7   8   9   10   >