> https://issues.apache.org/jira/browse/KYLIN-2725 <
> https://issues.apache.org/jira/browse/KYLIN-2725>
>
> Thanks,
> Ketan
>
> > On 31-Oct-2017, at 12:36 PM, ShaoFeng Shi <shaofeng...@apache.org>
> wrote:
> >
> > Hi Ketan,
> >
> > Whi
kylin new metrics, any
> plans of it making to v2.2.
>
> Thanks,
> Ketan
--
Best regards,
Shaofeng Shi 史少锋
passes if a majority of
> > at least three +1 PPMC votes are cast.
> >
> > [ ] +1 Release this package as Apache Kylin 2.2.0
> > [ ] 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 史少锋
planation. If we want to add new aggregation group , what
> should I do?
>
> 2017-10-25 18:36 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
>
> > Hi hao,
> >
> > It will go to the base cuboid: ABCDE, and aggregate D at running time. So
> > in theory, it
ter to take a backup):
"metastore.sh remove /execute"
2017-10-26 9:29 GMT+08:00 op <520075...@qq.com>:
> hello shaofeng .
> i want to know how to clean the monitor list. could you help me?
>
>
>
>
> ------ 原始邮件 --
> 发件人: "Shao
ot;group by A B C E" , is it OK?
>
--
Best regards,
Shaofeng Shi 史少锋
Please drop an email to dev-unsubscr...@kylin.apache.org to proceed.
在 2017年10月24日 下午1:45,郭元培 <yuanpei@marcpoint.com>写道:
> 退订,谢谢了
--
Best regards,
Shaofeng Shi 史少锋
3 18:00 GMT+08:00 op <520075...@qq.com>:
> on kylin web,there is no "Edit Json" . my version 2.0
>
>
> ------ 原始邮件 --
> *发件人:* "ShaoFeng Shi";<shaofeng...@apache.org>;
> *发送时间:* 2017年10月23日(星期一) 下午5:53
>
find the json file
> or you mean change it on kylin web?
>
>
>
>
> ------ 原始邮件 --
> 发件人: "ShaoFeng Shi";<shaofeng...@apache.org>;
> 发送时间: 2017年10月23日(星期一) 下午5:09
> 收件人: "dev"<dev@kylin.apache.org>;
>
>
t;KYLIN_SALES.PART_DT",
"partition_time_column" : null,
"partition_date_start" : 0,
"partition_date_format" : "-MM-dd",
"partition_time_format" : "HH:mm:ss",
"partition_type" : "APPEND",
&
Shaofeng SHI created KYLIN-2944:
---
Summary: HLLCSerializer, RawSerializer returns shared object in
serialize()
Key: KYLIN-2944
URL: https://issues.apache.org/jira/browse/KYLIN-2944
Project: Kylin
mat?
> our hive tables are partitioned by month_id(format :mm) and
> subpartitioned by day_id(format :dd)
>
> thanks!
>
--
Best regards,
Shaofeng Shi 史少锋
any users. We are so glad to have him to be our new
> committer and looking forward to his continued involvement.
> >
> >Congratulations and Welcome, Cheng!
>
--
Best regards,
Shaofeng Shi 史少锋
/c_customer_portrait[2017100100_2017101000]
> while executing “
>
> this issue occurs on KYLIN VERSION: 2.10, 2.2.0-SNAPSHOT
>
> PS: our kylin is deployed on write-read mode ( one hadoop cluster for
> building cube, one hbase cluster for storing data)
>
> any help is appreciate, thanks
>
> --
> cludezhu
> Sent with Airmail
--
Best regards,
Shaofeng Shi 史少锋
"1");
> newParams.put("hbase.rpc.timeout", "5000");
> newParams.put("hbase.client.retries.number", "3");
> newParams.putAll(url.getAllParameters());
>
> return url.copy(newParams);
> }
>
>
>
>
>
>
--
Best regards,
Shaofeng Shi 史少锋
e ways to limit the bandwidth of the BulkLoad job will be
> great. Do you have some good idea?
>
> 2017-10-16 11:32 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
>
> > Did you configure "kylin.hbase.cluster.fs", pointing to your HBase HDFS?
> >
> > Check thi
a very big BulkLoad, the HDFS
> is blocking (network or disk I/O), which block Hbase.
>
> 2017-10-15 9:38 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
>
> > The generation of HFile is happened in the "Convert to HFile" step, which
> > is an MR job, won't b
query. especially
> when the cube's merge job maybe write to hbase N TB in a mr job.
>
> Has anyone met the problem?
>
--
Best regards,
Shaofeng Shi 史少锋
Controller.doPrivileged(Native Method) at
> javax.security.auth.Subject.doAs(Subject.java:422) at
> org.apache.hadoop.security.UserGroupInformation.doAs(
> UserGroupInformation.java:1724) at org.apache.hadoop.mapred.
> YarnChild.main(YarnChild.java:162)
>
>
> What is the cause?
>
>
>
> apache_...@163.com
>
--
Best regards,
Shaofeng Shi 史少锋
spark-conf.spark.yarn.*archive*=hdfs://
> namenode:8020/kylin/spark/spark-libs.jar
> ?
>
> This difference doesn't change my listbox problem.
>
> Thank you.
>
> Arnault
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
want to investigate this? We welcome community contributions.
--
Best regards,
Shaofeng Shi 史少锋
> building streaming cubes?we succeed to build streaming a cube on the sample
> data supplied by kylin,but failed on our own data,it's avro format,not json
> format.
> 在 2017-10-10 14:47:30,ShaoFeng Shi <shaofeng...@apache.org> 写道:
> >Hi Miao,
> >
> >It doesn'
Flat Hive Table was null. I want to know
> could kylin derive other time values like “year_start”, “day_start” from
> the bigint timestamp in hive as it does in kafka table? or we must change
> the bigint timestamp into data format such as "2017-10-09" in hive?
> At 2017-10-
-633 ,
>
> it seems kylin already supprt Timestamp for cube partition,but when we
> define timestamp as partition , kylin failed to load data from hive tables.
>
>
> thanks in advanced for your reply.
>
>
>
>
>
--
Best regards,
Shaofeng Shi 史少锋
; Table ACL is half done at the moment. So either we release the 2.2.0
> with a
> > clear warning of the half done feature. Or we postpone the release till
> > Table ACL is fully done.
> >
> > Any suggestion?
> >
> > Yang
> >
> > On Wed, Sep 27, 20
t for the Spark jars creation of course.
>
> Any advice ?
>
> Arnault
>
>
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
t; --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
umn in on cube both as
> dimension and distinct count?
> 在 2017-09-29 11:41:02,ShaoFeng Shi <shaofeng...@apache.org> 写道:
> >Split that into two cubes: in one it acts as a dimension, in the other, it
> >acts as count distinct measure.
> >
> >2017-09-29 11:12 GMT+08:00
The issue is discussed in https://issues.apache.org/jira/browse/KYLIN-2679
2017-09-29 11:41 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
> Split that into two cubes: in one it acts as a dimension, in the other, it
> acts as count distinct measure.
>
> 2017-09-29 11:12
Split that into two cubes: in one it acts as a dimension, in the other, it
acts as count distinct measure.
2017-09-29 11:12 GMT+08:00 崔苗 <cuim...@danale.com>:
> if a column was used both as dimension and distinct count,what should be
> use to encode ?
> 在 2017-09-29 11:05:
; -- 原始邮件 ------
> 发件人: "ShaoFeng Shi";<shaofeng...@apache.org>;
> 发送时间: 2017年9月29日(星期五) 上午9:41
> 收件人: "dev"<dev@kylin.apache.org>;
>
> 主题: Re: A problem about Global Dictionary and cube merge
>
>
>
> I se
egment could not be merged, even if
> run this command ,the hbase tables could not be cleaned.
>
>
>
>
> -- 原始邮件 ----------
> 发件人: "ShaoFeng Shi";<shaofeng...@apache.org>;
> 发送时间: 2017年9月28日(星期四) 晚上9:29
> 收件人: "dev"<d
build the cube
> every day, that means a new hbase table will be created every day. And the
> segment could not be merged, that means the hbase tables could not be
> cleaned. That`t terrible.Give me some advice?
> Thank you! Looking forward to your reply.
--
Best regards,
Shaofeng Shi 史少锋
finished the calculating job, and only the hbase cluster will be left.
> >
> > our problem is:
> > Is that possible that run a simply kylin query instance on hbase cluster
> > without the hadoop cluster.
> >
> > any help is appreciate.
> >
> > clude
> >
>
--
Best regards,
Shaofeng Shi 史少锋
ze(),
> kylinConfig.getLargeQueryThreshold()))
> {
> cacheManager.getCache(SUCCESS_QUERY_CACHE)
> .put(new Element(sqlRequest.getCacheKey(),
> sqlResponse));
> }
> ```
Shaofeng SHI created KYLIN-2912:
---
Summary: Remove "hfile" folder after bulk load to HBase
Key: KYLIN-2912
URL: https://issues.apache.org/jira/browse/KYLIN-2912
Project: Kylin
Cool, when do you plan to kick off the release?
2017-09-25 21:49 GMT+08:00 Li Yang <liy...@apache.org>:
> Anything you want to squeeze into the release, it's time.
>
>
> Cheers
> Yang
>
--
Best regards,
Shaofeng Shi 史少锋
joda-time 2.8.3 i get this problem in
> > > "org.springframework.web.servlet.mvc.method.annotation.Reque
> > > stMappingHandlerAdapter"
> > >
> > > I'm using OpenJDK 1.7.0_151, Hadoop 2.8.1 Hive 2.3.0, Hbase 1.3.1 and
> > > Kylin 2.1.0.
> > >
> > > Any tips just pointing me in the right direction would be greatly
> > > appreciated.
> > >
> > >
> > > Best regards Ludvig Flink
> > > Genesis IT AB
> > >
> > > Sweden
> > >
> >
>
--
Best regards,
Shaofeng Shi 史少锋
e community open to it? And how should I
> do it?
>
> Best regards,
> Paul Lam
>
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
AopProxy.java:720)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:157)
> at org.springframework.security.access.intercept.aopalliance.
> MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:179)
> at org.springframework.aop.framework.CglibAopProxy$
> DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> at org.apache.kylin.rest.service.ModelService$$
> EnhancerBySpringCGLIB$$63dbdcd1.dropModel()
> at org.apache.kylin.rest.controller.ModelController.
> deleteModel(ModelController.java:161)
> ... 76 more
> 2017-09-19 18:59:23,782 INFO [pool-8-thread-1]
> threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0 actual
> running, 0 stopped, 0 ready, 136 already succeed, 21 error, 5 discarded, 0
> others
>
>
>
>
> apache_...@163.com
>
> From: Li Yang
> Date: 2017-09-17 15:17
> To: dev
> Subject: Re: How to clean up the invisible cube
> The cube should be there unless something wrong with your metadata. You may
> check kylin.log to see if any error during system start when cubes are
> loaded.
>
> On Thu, Sep 14, 2017 at 3:39 PM, apache_...@163.com <apache_...@163.com>
> wrote:
>
> > Hi:
> >
> > Sometime,When I delete a model, Prompt is referenced by cube, But I
> > can't see the cube by webUI
> >
> > So,how to delete this model?
> >
> >
> >
> >
> >
> > apache_...@163.com
> >
>
--
Best regards,
Shaofeng Shi 史少锋
Shaofeng SHI created KYLIN-2869:
---
Summary: When using non-default FS as the working-dir, Kylin puts
large metadata file to default FS
Key: KYLIN-2869
URL: https://issues.apache.org/jira/browse/KYLIN-2869
ur answer.
>
> Arnault
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
che and then refresh, kylin can't connect with hive too. What is the
> reason for this? Have you met?
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
the
> kylin-2.1 will write content to cluster of mapreduce. In kylin-2.0, the
> destination is hbase's cluster.
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
4782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
Welcome!
2017-09-11 9:51 GMT+08:00 mailpig <alex...@163.com>:
> Sorry, I forget it. Thank you.
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
t;http://apache-kylin.74782.x6.nabble.com/file/t635/%E6%8D%95%E8%8E%B7.png>
>
> hbase version is 1.25.
> Please help me, thank you verry much.
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
I also encounter this issue in AWS EMR 5.8; The Hive
uses jackson-databind 2.6.6, which is higher than the compilation level of
Kylin.
As a temporary solution, I downgrade to EMR 5.5 now...
2017-09-01 13:34 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
> Root cause:
You can open a JIRA first, follow this guide[1] to make a patch, verify it
fixed the issue, and then attach it to the JIRA. Thanks!
[1] https://kylin.apache.org/development/howto_contribute.html
2017-09-08 9:13 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
> Good shot; This is a b
s(redirectPath)/, so it will throw the above
> exception.Please check it out~
>
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
://issues.apache.org/ji
>> ra/browse/KYLIN-2740.
>>
>> Global dictionary in 2.0 doesn't work out of the box. I patched kylin as
>> described in ticket.
>>
>> On Sun, Aug 13, 2017 at 4:24 AM, ShaoFeng Shi <shaofeng...@apache.org>
>> wrote:
>>
accounter this problem.
> >
> > --
> > Sent from: http://apache-kylin.74782.x6.nabble.com/
> >
>
--
Best regards,
Shaofeng Shi 史少锋
ect?
> But i didn't have time to save the picture.Then i refresh the same
> segment,it only took three minutes this time(I almost broke down),then i
> save the CPU diagram.
> [image: 内嵌图片 1]
>
>
> 2017-09-06 22:58 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
>
ill be of great help !
> >
> >
> > --
> > Sent from: http://apache-kylin.74782.x6.nabble.com/
> >
>
--
Best regards,
Shaofeng Shi 史少锋
38
> MSG_TXN_CODE varchar(10)6
> DELETED char(1) 2
> How can i resolve the problem? Can I use fixed_length in all
> dimensions? Maybe the step 4 will take less time.
> Thank you.
>
>
> 2017-08-30 18:44 GMT+08:00 ShaoFen
489...@qq.com>:
> have anybody know it?
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
--
Best regards,
Shaofeng Shi 史少锋
oint on how i can ingest data?
> >
> >
> >
> > --
> > Thanks & Regards,
> > K M B
> > Balaji Muniswami
> >
>
--
Best regards,
Shaofeng Shi 史少锋
t; On Fri, Sep 1, 2017 at 2:47 PM, 杨浩 <yangha...@gmail.com> wrote:
>>
>> > If a index is less than 2, we don't want to store it in hbase . How to
>> > filter the long tail data ?
>> >
>>
>
>
--
Best regards,
Shaofeng Shi 史少锋
.java:655)
> > >at org.apache.kylin.rest.service.CubeService$$
> > EnhancerBySpringCGLIB$$a843c409.updateCubeAndDesc()
> > >at org.apache.kylin.rest.controller.CubeController.
> > updateCubeDesc(CubeController.java:511)
> > >at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:62)
> > >at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:43)
> > >at java.lang.reflect.Method.invoke(Method.java:498)
> > >
> > >
> > >
> > >apache_...@163.com
> >
>
--
Best regards,
Shaofeng Shi 史少锋
jectMapperBuilder.java:554)
> at org.springframework.http.converter.json.
> MappingJackson2HttpMessageConverter.(MappingJackson2HttpMessageConv
> erter.java:57)
> at org.springframework.http.converter.support.
> AllEncompassingFormHttpMessageConverter.(
> AllEncompassingFormHttpMessageConverter.java:61)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.(RequestMappingHandlerAdapter.java:187)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(
> NativeConstructorAccessorImpl.java:62)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
> DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at org.springframework.beans.BeanUtils.instantiateClass(
> BeanUtils.java:147)
> ... 28 more
>
>
> thanks!
>
>
>
> zili_w...@163.com
>
--
Best regards,
Shaofeng Shi 史少锋
Hi,
Joanna He (jingke...@kyligence.io) contributed a doc on how to integrate
Kylin with MicroStrategy. The doc has been published on Kylin website[1]
today. Thanks Joanna's contribution.
https://kylin.apache.org/docs21/tutorial/microstrategy.html
--
Best regards,
Shaofeng Shi 史少锋
Hi Mingming,
I put my comment in the JIRA, please check.
2017-08-31 15:31 GMT+08:00 qiumingming <csurj...@gmail.com>:
> Hi Shaofeng SHI, Is there any status update? Should I start to make a new
> version patch for KYLIN-2720? I am afraid you have not seen my message
> below
>
Shaofeng SHI created KYLIN-2825:
---
Summary: Make "ModelDataGenerator.java" serilizable
Key: KYLIN-2825
URL: https://issues.apache.org/jira/browse/KYLIN-2825
Project: Kylin
rds":0,"input_records_size":0,"last_build_time":0,"
> last_build_job_id":null,"creat
> e_time_utc":1504077397616,"cuboid_shard_nums":{},"total_
> shards":1,"blackout_cuboids":[],"binary_signature":null,"
> dictionaries":{"TBL
> ...
>
> The 'last_build_job_id' is null.
> I want resume the job with restful API,so which field should I get?
>
> Best regards.
>
>
--
Best regards,
Shaofeng Shi 史少锋
mize
> some hive configuration options,but it didn't work.
> 2.Do i need to optimize hadoop configuration options?
> 3.Do i need to optimize the KYLIN_JVM_SETTINGS in setenv.sh?(I have already
> modified it,but it doesn't seem to work)
>
>
>
> 2017-08-28 21:11 GMT+08:00 ShaoFeng
g/docs21/howto/howto_optimize_build.html
2017-08-28 13:54 GMT+08:00 周湘伦 <jayzho...@gmail.com>:
> Sorry,i got these problems in the step 2:Redistribute Flat Hive
> Table,sometimes in the step 4:Build Dimension Dictionary,it is
> uncertain.But the step 2 occurs a little more
ark: 2.333/2.334 secs] [Times: user=2.37
> sys=0.01, real=2.34 secs]
> ...
>
> Maybe is the error of java Garbage Collection,so i how to solve the
> problem?(maybe modify the properties)
>
> Thanks a lot.
>
--
Best regards,
Shaofeng Shi 史少锋
ight.process(
> > AbstractProcessorLight.java:66)\n\tat
> > org.apache.coyote.AbstractProtocol$ConnectionH
> > andler.process(AbstractProtocol.java:789)\n\tat
> > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.
> > doRun(NioEndpoint.java:1437)\n\tat
> > org.apache.tomcat.util.net.SocketProcessorBase.run
> > (SocketProcessorBase.java:49)\n\tat
> > java.util.concurrent.ThreadPoolExecutor.runWorker(
> > ThreadPoolExecutor.java:1142)\n\tat
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecu
> > tor.java:617)\n\tat
> > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> > TaskThread.java:61)\n\tat
> > java.lang.Thread.run(Thread.java:745)\n","exception":"Query is not
> allowed
> > in w eb
> > mode.","url":"http://ascv102.prod.hnd1.bdd.local:7070/kylin/api/query"}
> > 14336 at
> > org.apache.kylin.jdbc.KylinClient.asIOException(KylinClient.java:416)
> > 14337 at
> > org.apache.kylin.jdbc.KylinClient.executeKylinQuery(KylinCli
> ent.java:376)
> > 14338 at
> > org.apache.kylin.jdbc.KylinClient.executeQuery(KylinClient.java:326)
> > 14339 at
> > org.apache.kylin.jdbc.KylinResultSet.execute(KylinResultSet.java:69)
> > 14340 ... 6 more
> > 14341 , Connection String:
> > DSN=KYLIN;JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/
> > install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL=
> > jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_mart_rat
> > _session_summary;UID=ADMIN;, Statement String: SELECT TOP 4 * FROM
> > SCV_WORK,
> > JdbcCallMade: MIX_JdbcStatement_execute
> > 14342 2017-08-22 18:03:52.544+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:2488064][Database
> > Classes][Error] JdbcStatementWrapper::ExecQuery failed.
> > 14343 Error type: Jdbc success with info. Jdbc operation attempted:
> > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] Connection String:
> > DSN=KYLIN;JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/
> > install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL=
> > jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_
> > mart_rat_session_summary;UID=ADMIN;.
> > SQL Statement: SELECT TOP 4 * FROM SCV_WORK.
> > 14344 2017-08-22 18:03:52.544+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:2488064][Database
> > Classes][Error] Query execution failed when importing data from database
> or
> > web service. Error message: JdbcStatementWrapper::ExecQuery failed.
> > 14345 Error type: Jdbc success with info. Jdbc operation attempted:
> > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] Connection String:
> > DSN=KYLIN;JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/
> > install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL=
> > jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_
> > mart_rat_session_summary;UID=ADMIN;.
> > SQL Statement: SELECT TOP 4 * FROM SCV_WORK..
> > 14346 2017-08-22 18:03:52.544+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:2488064][COM
> > Shared][Error][0x8004180E] Error in accessing information from the
> external
> > data source (Database Instance: (DataImport)[0], Error:
> > JdbcStatementWrapper::ExecQuery failed.
> > 14347 Error type: Jdbc success with info. Jdbc operation attempted:
> > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] )
> > 14348 2017-08-22 18:03:52.883+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:2086184704 <020%208618%204704>][COM
> > Shared][Error][0x8004180E] Error in accessing information from the
> externa
> > l data source (Database Instance: (DataImport)[0], Error:
> > JdbcStatementWrapper::ExecQuery failed.
> > 14349 Error type: Jdbc success with info. Jdbc operation attempted:
> > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] )
> >
> > 14320,51-58 99%
> >
> > olap
> >
> > There is an error on the server. Details
> > インデックスが、範囲外です。内部システム エラー: XMLRequest で例外を検出しました。 :: Execute。 Table
> pointer
> > is null. Cannot perform append operation.
> >
> > 2017-08-22 18:06:35.518+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:3803707136][Kernel][Info]
> > Contract Request Succeeded: Source=MDb::Table, Handle=1887, Size
> > =13303808, ContractedTotal=140668928, AvailableTotal=534490736306
> > 14351 2017-08-22 18:06:59.868+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:2050463488 <020%205046%203488>][Dimensional
> > Storage][Error] The locale for the dataset is 0 and the locale for
> > current server instance is 1033. But don't worry, by default we have
> fixed
> > it for you.
> > 14352 2017-08-22 18:06:59.869+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:2050463488 <020%205046%203488>][Dimensional
> > Storage][Error] The locale for the dataset is 0 and the locale for
> > current server instance is 1033. But don't worry, by default we have
> fixed
> > it for you.
> > 14353 2017-08-22 18:10:47.768+09:00
> > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:
> > 39561][THR:2111399680 <021%201139%209680>][Object
> > Server][Error][0x80041018] Index out of range
> >
> > ..
> >
> > --
> > View this message in context: http://apache-kylin.74782.x6.
> > nabble.com/Query-is-not-allowed-in-web-mode-tp8778.html
> > Sent from the Apache Kylin mailing list archive at Nabble.com.
> >
> >
>
--
Best regards,
Shaofeng Shi 史少锋
Change SPARK_HOME to $KYLIN_HOME/spark, or unset it before start Kylin
should solve the issue. Just take a try.
2017-08-24 9:13 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
> Please check whether your environment has SPARK_HOME variable pointing to
> another folder, which
pache.catalina.core.StandardEngineValve.invoke(
> > StandardEngineValve.java:116)
> > at
> > org.apache.catalina.connector.CoyoteAdapter.service(
> > CoyoteAdapter.java:436)
> > at
> > org.apache.coyote.http11.AbstractHttp11Processor.process(
> > AbstractHttp11Processor.java:1078)
> > at
> > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> > process(AbstractProtocol.java:625)
> > at
> > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> > run(JIoEndpoint.java:318)
> > 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)
> > Caused by: java.lang.NoClassDefFoundError:
> > org/apache/spark/api/java/function/PairFunction
> > at
> > org.apache.kylin.engine.spark.SparkBatchCubingJobBuilder2.
> > addLayerCubingSteps(SparkBatchCubingJobBuilder2.java:48)
> > at
> > org.apache.kylin.engine.mr.BatchCubingJobBuilder2.build(
> > BatchCubingJobBuilder2.java:66)
> > at
> > org.apache.kylin.engine.spark.SparkBatchCubingEngine2.
> > createBatchCubingJob(SparkBatchCubingEngine2.java:30)
> > at
> > org.apache.kylin.engine.EngineFactory.createBatchCubingJob(
> > EngineFactory.java:56)
> > at
> > org.apache.kylin.rest.service.JobService.submitJobInternal(
> > JobService.java:238)
> > at org.apache.kylin.rest.service.JobService.submitJob(
> > JobService.java:208)
> > at
> > org.apache.kylin.rest.service.JobService$$FastClassBySpringCGLIB$$
> > 83a44b2a.invoke()
> > at org.springframework.cglib.proxy.MethodProxy.invoke(
> > MethodProxy.java:204)
> > at
> > org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.
> > invokeJoinpoint(CglibAopProxy.java:720)
> > at
> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> > ReflectiveMethodInvocation.java:157)
> > at
> > org.springframework.security.access.intercept.aopalliance.
> > MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
> > at
> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> > ReflectiveMethodInvocation.java:179)
> > at
> > org.springframework.aop.framework.CglibAopProxy$
> DynamicAdvisedInterceptor.
> > intercept(CglibAopProxy.java:655)
> > at
> > org.apache.kylin.rest.service.JobService$$EnhancerBySpringCGLIB$$
> > 39b3ce22.submitJob()
> > at
> > org.apache.kylin.rest.controller.CubeController.
> > buildInternal(CubeController.java:302)
> > ... 77 more
> > Caused by: java.lang.ClassNotFoundException:
> > org.apache.spark.api.java.function.PairFunction
> > at
> > org.apache.catalina.loader.WebappClassLoaderBase.loadClass(
> > WebappClassLoaderBase.java:1858)
> > at
> > org.apache.catalina.loader.WebappClassLoaderBase.loadClass(
> > WebappClassLoaderBase.java:1701)
> > ... 92 more
> >
> > --
> > View this message in context: http://apache-kylin.74782.x6.
> > nabble.com/KYLIN2-1-tp8782.html
> > Sent from the Apache Kylin mailing list archive at Nabble.com.
> >
>
--
Best regards,
Shaofeng Shi 史少锋
> gridtable.GTScanRequest: pre aggregating results before returning
> > 2017-08-22 11:04:31,740 INFO [Query 25ed5aec-6a9b-4507-bed4-
> 198812cc25f0-194]
> > gridtable.GTAggregateScanner: GTAggregateScanner input rows: 0
> > 2017-08-22 11:04:31,740 INFO [Query 25ed5aec-6a9b-4507-bed4-
> 198812cc25f0-194]
> > endpoint.CubeVisitService: Total scanned 0 rows and 0 bytes
> > 2017-08-22 11:04:31,740 INFO [Query 25ed5aec-6a9b-4507-bed4-
> 198812cc25f0-194]
> > endpoint.CubeVisitService: Size of final result = 8 (0 before
> compressing)
> >
> > I guess maybe some rowkey rule is changed?
> >
> > Did anyone meet the problem? Thanks a lot.
> >
> >
>
--
Best regards,
Shaofeng Shi 史少锋
Shaofeng SHI created KYLIN-2803:
---
Summary: Should allow non "select" query when pushdown is enabled
Key: KYLIN-2803
URL: https://issues.apache.org/jira/browse/KYLIN-2803
Project: Kylin
ormation on how to report
> problems, and to get involved, visit the Apache Kylin website at
> https://kylin.apache.org/
>
> Thanks,
> Dong Li
>
--
Best regards,
Shaofeng Shi 史少锋
Shaofeng SHI created KYLIN-2797:
---
Summary: Remove MR engine V1
Key: KYLIN-2797
URL: https://issues.apache.org/jira/browse/KYLIN-2797
Project: Kylin
Issue Type: Task
Components: Job
Shaofeng SHI created KYLIN-2796:
---
Summary: Remove the legacy "statisticsenabled" codes in
FactDistinctColumnsJob
Key: KYLIN-2796
URL: https://issues.apache.org/jira/browse/KYLIN-2796
Proj
to the 2.1.0 release.
We welcome your help and feedback. For more information on how to
report problems, and to get involved, visit the project website at
https://kylin.apache.org/
--
Best regards,
Shaofeng Shi 史少锋
Thanks to everyone who has tested the release candidate and given
their comments and votes.
The tally is as follows.
3 binding +1s:
Shaofeng Shi
Dong Li
Luke Han
6 non-binding +1s:
Billy Liu
Cheng Wang
Roger Shi
George Ni
Kaisen Kang
Yu Feng
No 0s or -1s.
Therefore I am delighted
e names you want to load from hive,
> separated
> > with comma.
> > project - required String the project which the tables will be loaded
> into.
> >
> >
> >
> > apache_...@163.com
> >
> > From: ShaoFeng Shi
> > Date: 2017-08-13 14:23
> &
Shaofeng SHI created KYLIN-2786:
---
Summary: Miss "org.apache.kylin.source.kafka.DateTimeParser"
Key: KYLIN-2786
URL: https://issues.apache.org/jira/browse/KYLIN-2786
Project: Kylin
are cast.
[ ] +1 Release this package as Apache Kylin 2.1.0
[ ] 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)
--
Best regards,
Shaofeng Shi 史少锋
Besides, can you sync the table from Kylin GUI? If GUI doesn't work either,
that should be env problem. Otherwise it would be API usage mistake.
2017-08-13 14:22 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
> Any message in tomcat/logs/* or logs/kylin.out?
>
> 2017-08-13
onse code: 500 for URL:
> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>
> but no relevant logs in kylin.log
>
>
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-12 14:59
> To: dev
> Subject: Re: kylin load hive table re
Check this:
https://community.hortonworks.com/questions/93060/kylin-home-page-not-loading.html
2017-08-12 22:34 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
> Are you running it in HDP 2.5 sandbox vm? I remember someone encountered
> this in the sandbox, the reason is HD
-bin/logs/kylin.log
> Web UI is at http://:7070/kylin
>
>
> but i cant view the web when i inpurt http://myip:7070/kylin
> how can i resove this problem?
> thx 4 u help!!
>
--
Best regards,
Shaofeng Shi 史少锋
t; at org.springframework.context.support.AbstractApplicationContext.
> finishBeanFactoryInitialization(AbstractApplicationContext.java:938)
> at org.springframework.context.support.AbstractApplicationContext.
> refresh(AbstractApplicationContext.java:479)
> at org.springframework.web.context.ContextLoader.
> configureAndRefreshWebApplicationContext(ContextLoader.java:410)
> at org.springframework.web.context.ContextLoader.
> initWebApplicationContext(ContextLoad
--
Best regards,
Shaofeng Shi 史少锋
}}</pre>
> </div>
>
>
> <div class="callout callout-info">
> <p>{{text}}</p>
> </div>
>
>
>
> <div class="callout">
> <h4>Error Message</h4>
> <p>{{text}}</p>
> </div>
> <div class="callout callout-danger">
> <h4>Streaming Schema</h4>
> <pre>{{streamingSchema}}</pre>
> </div>
> <div class="callout callout-danger">
> <h4>Kafka Schema</h4>
> <pre>{{kfkSchema}}</pre>
> </div>
>
>
> <div class="callout callout-info">
> <p>{{text}}</p>
> </div>
>
>
>
>
>
>
>
>
>
>
> apache_...@163.com
>
--
Best regards,
Shaofeng Shi 史少锋
> > > OpenJDK Runtime Environment (rhel-2.6.4.0.el6_7-x86_64 u95-b00)
> > > OpenJDK 64-Bit Server VM (build 24.95-b01, mixed mode)
> > >
> > >
> > >
> > > On Sat, Aug 5, 2017 at 6:37 PM, ShaoFeng Shi <shaofeng...@apache.org>
> > > wrote:
> >
4782.x6.nabble.com/file/n8640/%E5%B1%
> 8F%E5%B9%95%E5%BF%AB%E7%85%A7_2017-08-05_%E4%B8%8B%E5%8D%883.png>
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Kylin-tp8640.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi 史少锋
found at -- /dict/", is there any chance this occur because of
> timeout error?
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Timeout-when-refreshing-a-cube-tp8658.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi 史少锋
As titled.
--
Best regards,
Shaofeng Shi 史少锋
I need revoke this vote because KYLIN-2535 wasn't finished yet (it was
missed previously as not properly set the fixed version).
RC2 will be sent out later. Thanks for your attention!
2017-08-05 18:37 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>:
> Hi all,
>
> I have
Shaofeng SHI created KYLIN-2778:
---
Summary: Sample cube doesn't have ACL info
Key: KYLIN-2778
URL: https://issues.apache.org/jira/browse/KYLIN-2778
Project: Kylin
Issue Type: Bug
Affects
al or entity to
> whom they are addressed. If you have received this message in error, any
> unauthorized review, use, disclosure, distribution or copying of this
> message is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail and destroy all copies of the original
> message. Unless expressly stated in this e-mail, nothing in this message
> should be construed as a digital or electronic signature or writing.
>
--
Best regards,
Shaofeng Shi 史少锋
as Apache Kylin 2.1.0
[ ] 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)
--
Best regards,
Shaofeng Shi 史少锋
w this message in context: http://apache-kylin.74782.x6.
> nabble.com/How-to-migrate-cube-from-one-Kylin-to-
> another-for-example-Kylin-QA-to-Kylin-Production-within-
> the-dir-tp8628.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi 史少锋
wkey比较多,导致kylin直接对表进行全部扫描,如果想不管rowkey多少,
> 始终想通过rowkey进行查询该如何做?
>
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/sql-in-tp8630.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi 史少锋
t; Oh my God, probably I have to change Hive tables...
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Multiple-keys-tp8616p8624.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi 史少锋
Shaofeng SHI created KYLIN-2769:
---
Summary: Non-partitioned cube doesn't need show start/end time
Key: KYLIN-2769
URL: https://issues.apache.org/jira/browse/KYLIN-2769
Project: Kylin
Issue Type
Shaofeng SHI created KYLIN-2767:
---
Summary: 404 error on click "System" tab
Key: KYLIN-2767
URL: https://issues.apache.org/jira/browse/KYLIN-2767
Project: Kylin
Issue
Shaofeng SHI created KYLIN-2766:
---
Summary: Kylin uses default FS to put the coprocessor jar, instead
of the working dir
Key: KYLIN-2766
URL: https://issues.apache.org/jira/browse/KYLIN-2766
Project
601 - 700 of 1287 matches
Mail list logo