Re: 【问题求助】kylin在build时报Counters为0错误

Hi Huan: Can you describe the construction details, such as dimension tables and fact tables? In my opinion, it may be that dimension tables and fact tables do not have qualified columns in the join process, which results in counters being zero when cuboid is built. You can check your table

Re: Details about “Extract Fact Table Distinct Columns and Build Dimension Dictionary”

Hi Johnson: In this step, kylin calculates the cardinality of the dimension column and builds a dictionary for the dimension column. In order to save space and improve efficiency, kylin encodes and compresses dimensions, and adopts dictionary coding technology by default.

Re: fail to open web -- exception class path resource [ehcache-test.xml] cannot be opened because it does not exist

Hi： According to the content you provided, it seems that the changes you made are not the contents of the kylin. properties file. Can you tell us the purpose of the changes you made? Maybe this article can help you:http://kylin.apache.org/docs/install/configuration.html > On Sep 3, 2019, at

Re: apache-kylin-3.0.0-alpha2-bin-hbase1x Issue

Hi 张飞： I reproduced the problem you encountered. In kylin, the query results of a SQL similar to "select *, case when then from table" do not meet expectations, but a SQL like "select sum (name), case when then from table group by 2" is no problem. So I think you are right.Kylin’s parsing of

Re: 数据源字段变化引发异常

Hi Shen june: If you change the field name of the data source, you need to delete the model and cube used in the field to reload the table, otherwise there will be a conflict. In general, after designing the model and cube, we do not recommend any changes to the table structure, especially the

Re: 重启kylin server突然报找不到tomcat的相关Class

Hi 邵志鹏： You can provide your Kylin version and more details so that someone can help you. > On Sep 12, 2019, at 6:01 PM, 邵志鹏 wrote: > > Hi all, > > 重启后： > SEVERE: ContainerBase.addChild: start: > org.apache.catalina.LifecycleException: Failed to start component >

Re: cube build

Hi weilen, Maybe you can check the contents of kylin. log for more detailed information.kylin.log is in the logs\ directory. If still can't solve this problem, you can provide us with screenshots of kylin.log. > On Jul 31, 2019, at 7:19 PM, wangweilin wrote: > > Hi， > When I built cube,the

Re: cube build

Kylin. log doesn't seem to provide more information.Could you provide your environment information(hadoop environment,kylin version etc) for us ? > On Jul 31, 2019, at 7:19 PM, wangweilin wrote: > > Hi， > When I built cube,the third step went wrong. > Here is my screenshots. >

Re: cube build

0cfe6377531ec0cf4.jpg=%5B%22sdnuwangweilin%40163.com%22%5D> > 签名由 网易邮箱大师 <https://mail.163.com/dashi/dlpro.html?from=mail81> 定制 > On 8/1/2019 14:39，Yaqian Zhang > <mailto:yaqian_zh...@126.com> wrote： > Kylin. log doesn't seem to provide more information.Could you provide yo

Re: No registered coprocessor service found for name CubeVisitService in region

Hi: Can you provide the Kylin version and hbase version? It seems that Hbase have some problem. But I’m not sure. > 在 2019年11月5日，11:05，1510603449 写道： > > Hi， > > when I test my kylin use "Quick Start with Sample Cube" , the following > error occurred > > >

Re: cube problem

Hi sir: This article on the official website mentions the problem you have encountered. http://kylin.apache.org/blog/2016/06/10/standalone-hbase-cluster/ . You can try again in the following way. > 在 2019年11月6日，09:22，王文辉

Re: The results return some fields empty. But when I tried in hive with the same query, I got what I wanted to get.

Hi: Did you add SHOP_NAME to the dimension when you create cube? If not, kylin will not save the details of the original table when building the cube, and will return null when querying the column. > 在 2019年11月13日，14:01，梅秋莹 <3281438...@qq.com> 写道： > > 1. Environment: > kylin 2.6.3 > > 2.

Re: No registered coprocessor service found for name CubeVisitService in region

Hello: We have tested that kylin works well in this environment. You can check the region server log to see if the Hbase coprocessor is loaded successfully. > 在 2019年11月5日，11:05，1510603449 写道： > > No registered coprocessor service found for

Re: how to config the ipc timeout

Hi： You can try to adjust "kylin.metadata.hbase-rpc-timeout" to a larger value in kylin.properties, its default is 5000ms. And then run metadata/StorageCleanup. > 在 2019年11月6日，16:16，lk_hadoop 写道： > > hi,all: > I'm using apache-kylin-2.6.3-bin-cdh57 ,I meet CallTimeoutException: >

Re: kylin构建的cube无法自动合并

pgrade to 2.3.0 or the latest version. > 在 2019年12月9日，15:49，王文辉 写道： > > kylin version: 2.2.0 > hadoop version: 2.6.0 > CDH: 5.8.0 > > > > -- 原始邮件 -- > 发件人: "Yaqian Zhang"; > 发送时间: 2019年12月9日(星期一) 下午3:41 > 收件人: "user

Re: kylin构建的cube无法自动合并

Hi wenhui: It’s a strange problem. Can you provide your Kylin version and Hadoop enviornment? I will try to reproduce this. > 在 2019年12月9日，14:59，王文辉 写道： > > I know your meaning ,the number of READY segments met the conditions of auto > merge, but auto merge was not triggered, the picture

Re: kylin构建的cube无法自动合并

Hi: The mechanism of auto-merge is as follows: If your READY segment time range reaches 7 days but does not reach 28, the first step of automatic merging will be triggered, and the 7-day segment will be merged into a segment; if the range reach 28 days further, the 28 day segment will be

Re: when query with database name predix in kylin, the results returned failed occasionally.

Hi qiuying： As far as I know, kylin support input database name as prefix in query, but there maybe have bug in some scenarios, such as you're seeing right now. So It is best not to do that. The following article may be helpful to know the kylin query mechanism.

Re: Huge number of dimensions

Hi Noureddine: The max physical dimension number (exclude derived column in lookup tables) in a cube is 63; If you can normalize some dimensions to lookup tables, with derived dimensions, you can create a cube with more than 100 dimensions. But a cube with > 30 physical

Re: kylin以phoenix作为数据源抽取数据中，遇到char','的问题怎么解决？

Hi gaofeng: You can try to set 'kylin.source.hive.quote-enabled=false’ and restart Kylin. > 在 2019年12月15日，15:27，gaofeng5...@capinfo.com.cn 写道： > > 我的kylin.properties的配置： > > > 通过sqoop抽取数据时的报错： > 1， > > > 2， > > 3， > > 4， > > > 烦请官方给出一个解决的办法 > gaofeng5...@capinfo.com.cn

Re: need help

Hi FengTeng: Can you provide more details such as Kylin version and Hadoop version? > 在 2019年10月28日，11:07，冯腾 写道： > > java.io.FileNotFoundException: File does not exist: > /kylin/kylin_metadata/kylin-6de0c22d-9bca-51ed-a321-a9f621283175/kylin_intermediate_q_65639922_e70a_236b_3de3_4be81ca0cc1d

Re: kylin 配置后仍无法通过hue访问

Hi qmw: Is there have some error log in kylin.log? Could you provide your kylin version and hue version? Whether the corresponding version of JDBC jar package is used？ > 在 2019年11月26日，18:36，qmw 写道： > > 在参考http://kylin.apache.org/docs21/tutorial/hue.html >

Re: kylin 配置后仍无法通过hue访问

Theoretically, the server where hue is located can access kylin's server is OK. Maybe official website documents is too old, you can refer to this document for help: https://www.jianshu.com/p/7ca176b19e35 > 在 2019年11月26日，18:36，qmw 写道： > >

Re: [ANNOUNCE] Please welcome Chunen Ni to the Apache Kylin PMC

Congratulations! > 在 2019年12月1日，14:45，Xiaoyuan Gu 写道： > > Big congrats to Chunen! > > Best, > Xiaoyuan > > > xiaoyuan.gu > 邮箱：xiaoyuan...@kyligence.io > >

Re: 启动kylin

Hi: After kylin starts successfully, it will generate kylin.log on ${KYLIN_HOME}/logs/kylin.log，you can check log’s content to find root cause. > 在 2019年11月29日，16:13，肖培栋 写道： > > > > > 肖培栋 > 邮箱：xiaopeidong1...@163.com > >

Re: kafak数据老孺到kylin，采用spark引擎进行计算存在问题

Hi: The figure 1 does not seem to reflect any error information, could you provide more error log? And which step this error occur? > 在 2019年11月21日，00:27，gaofeng5...@capinfo.com.cn 写道： > > > > > > > > > 以上的spark的配置在cube构建的时候采用官方的kafka数据到kylin，总是存在图一的问题，这个怎么解决，谢谢。 >

Re: kylin_cube_error: java.lang.NullPointerException

Hi: It seems that Oozie’s error, You can check that Oozie works normally and integrates properly with kylin. > 在 2019年11月12日，13:55，王文辉 写道： > > job's start time is not reached yet

Re: Error when building cube

Hi: Can you provide the detailed error log information and your hive-site.xml? The reason mabe is that hive.metastore.uris property is not set in hive-site.xml. > 在 2019年9月25日，15:54，伍明 写道： > > Hello all, > Env information is as follows: >AWS emr-5.26.0 >

Re: kylin构建cube过程中，连接hbase超时问题

Hi Johnson: You can set the parameters “kylin.metadata.hbase-rpc-timeout” to modify the timeout, the default value is 5000ms. > 在 2019年10月10日，15:10，Johnson 写道： > > kylin：2.6.2，HBase 1.2.0-cdh5.15.0 > The error occurred in #3 Step Name: Extract Fact Table Distinct Columns > error log： >

Re: how to create cube or model with RESTful API

Hi： Sorry for the Kylin.apache.org web didn’t provide how to create cube or model with RESTful API. Actually, you can create model and cube with RESTful API as follow: 1、Create a cube with RESTful API: POST http://host:port/kylin/api/cubes

Re: how to create cube or model with RESTful API

, I don’t want to do it on UI. > For example : how to post “dimensions, measures, aggregation groups, > mandatory dimensions and so on… ”, > > Thanks, > Qiuyu > > 发送自 Windows 10 版邮件 <https://go.microsoft.com/fwlink/?LinkId=550986>应用 > > 发件人: Yaqian Zhang <mailto:

Re: The latest snapshot was not generated

Hi: Sorry for that reusing dimension table snapshots does have the problems you describe. We have fixed it in the upcoming version Kylin 2.6.4. For more information, please refer to https://issues.apache.org/jira/browse/KYLIN-3628 . > 在

Re: Build Cube FAILD on Step3 (Extract Fact Table Distinct Columns)

Hi： Maybe you can upgrade kylin version and try again. Kylin 2.1.0 is too old. > 在 2020年2月25日，23:32，陈名扬 <375886...@qq.com> 写道： > > Dear everyone > > I'm a kylin user. > The versions are as follows： > hadoop > 2.6.0-cdh5.11.1 > hive > 1.1.0-cdh5.11.1 > hbase > 1.2.0-cdh5.11.1 > kylin >

Re: [Discuss] Add webhook to Kylin

Agree with xiaoxiang’s solution. I'm looking forward to this feature. > 在 2020年2月6日，18:49，weibin zhu 写道： > > Thanks for the reply, if everyone agrees with this solution, I can create a > jira and implement the code. I suggest that can define the interface and > framework code first. If you

Re: Couldn't locate hcatalog installation, please make sure it is installed and set HCAT_HOME to the path.

orrectly. > hive sql query is ok. > > At 2020-02-18 17:10:23, "Yaqian Zhang" wrote: > > Hi sir: > > What's your version of hive? > > Kylin support hive 0.13 - 1.2.1+. > > As far as I know, Hive version 0.11.0 is the first version to include > hc

Re: Couldn't locate hcatalog installation, please make sure it is installed and set HCAT_HOME to the path.

Hi sir: What's your version of hive? Kylin support hive 0.13 - 1.2.1+. As far as I know, Hive version 0.11.0 is the first version to include hcatalog. (installed with hive). You can check your hive version and make sure it is installed correctly. > 在 2020年2月18日，16:55，于留东 写道： > > hello,

Re: Kylin 2.6.3 Dashboard no data

Hi: Is there any data in the corresponding hive table? > 在 2020年1月8日，18:55，柯 <123033...@qq.com> 写道： > > Dear all: >kylin 2.6.3. >I have already set kylin dashboard by reference to this page > http://kylin.apache.org/docs/tutorial/use_dashboard.html >

Re: Execution Error, return code 30041

Hi: You can paste the hive command from kylin log into the command line for execution, and observe whether there is an error. > 在 2020年4月12日，17:42，xujian...@seassoon.com 写道： > > Hi, > This exception often occurs when Create Intermediate Flat Hive Table of Buid > cube,What's the reason? > >

Re: When build streaming cube in kylin, I got an error tip.

Hi： Is Kafka home set before kylin is started？If not, you can set KAFKA_HOME and restart kylin. If you still encounter this problem after setting KAFKA_HOME, and your hadoop environment is hdp3.0, you can take a look at this issue https://issues.apache.org/jira/browse/KYLIN-3970

Re: Streaming Table kafka parsing, parsing json string

Hi: You can try add streaming table from this json in kylin, and you can see the parse result. I paste this JSON to add streaming table in kylin, but modify format: "extension":"{"channel":"XXX","message":"?","sex":0,"target_uid":XXX,"version":"XXX"}”, to

Re: Is there any way to kill a running query?

rowse/KYLIN-1872> >Can I stop the coprocessor running in the region through the rest api? > > ------ 原始邮件 -- > 发件人: "Yaqian Zhang"; > 发送时间: 2020年4月24日(星期五) 下午4:33 > 收件人: "user"; > 主题: Re: Is there any way to kill a runn

Re: Is there any way to kill a running query?

Hi: If you are operating on kylin web UI, when you leave the insight page, the page will prompt you "You've executing query in current page, are you sure to leave this page?”. Click Yes and the query will be terminated automatically. If you operate through REST API, you can use `http:

Re: Is there any way to kill a running query?

ink above is not comprehensive. > > > -- 原始邮件 -- > 发件人: "Yaqian Zhang"; > 发送时间: 2020年4月24日(星期五) 下午4:58 > 收件人: "user"; > 主题: Re: Is there any way to kill a running query? > > Yes, I think you can terminate all threads re

Re: 问题咨询

Hi harry: Maybe you can turn to the Sqoop community for help. > 在 2020年5月15日，15:31，harry 写道： > > 你好，我在用kylin连接sql server数据库时遇到这样一错误： > 20/05/15 07:20:55 ERROR manager.SqlManager: Error executing statement: > com.microsoft.sqlserver.jdbc.SQLServerException: Setting IsolationLevel to >

Re: 关于union all之后，字段数值会产生null值的问题

Hi sir: I have reproduced the problem you described in my environment. It may be a bug. I will try to find out the root cause. You can open an issue in JIRA to track this. > 在 2020年5月7日，15:44，欧秋斌 写道： > > 您好！ > > 我的工作中，由于订单类型的维度标准不是确定的，所以需要在SQL语句中进行定义（如下方第一个公用表达式）。 > 在下面的语句中，进行union

Re: "Unable to find valid certification path" error when trying to enable LDAP

Hi Preeti: Have you read this blog? https://kylin.apache.org/docs/howto/howto_ldap_and_sso.html It mentions a configuration item called 'kylin.security.ldap.connection-truststore’, when you use the customized CA certificate

Re: kyligence 提供的odbc连接不上kylin

Hi harry： This is a known bug, and we are repairing it. A new ODBC driver will be released on kyligence website recently. If you want to use it now, you can use kylin 3.0 alpha 2 and earlier to connect. > 在 2020年5月21日，14:35，harry 写道： > > > HELLO： >我在使用kyligence官方提供的odbc驱动连接时，报一下错误：

Re: "Unable to find valid certification path" error when trying to enable LDAP

pends on how you installed it or what the type of JVM your used. You should know in advance what this path is. In addition, you should provide your certificate name and path to replace and <~/.cer>. > 在 2020年5月21日，09:59，Yaqian Zhang 写道： > > Hi Preeti: > >

Re: kylin 1.6 Not sorted! last error when sending select query on ui

Hi: You can setting the encoding type to ‘dict’ and rebuild this cube. Then try this SQL again. > 在 2020年9月2日，15:35，nice 写道： > > Hi, my cube set column REPORT_DATE as time encoding when setting rowkeys. > And it was built sucessfully. > > But when i query on ui, it throws error "Not sorted!

Re: Kylin and Yarn configuration

Hi: Maybe you should config yarn memory in kylin.properties and you can refer to doc http://kylin.apache.org/docs/install/configuration.html . > 在 2020年10月9日，03:03，eran grin 写道： > > Hi, > I run dbgen tool on a scale of 100. > I saw

Re: 【求助！】sql报错问题

Hi: It's a strange error that I haven't seen before, can you provide your Hadoop version and Kylin version to reproduce this error? And you mentioned using JDBC, is this error only encountered when executing through JDBC? > 在 2020年10月9日，10:07，guojial...@smartbi.com.cn 写道： > > 请问有没有哪位知道为什么呢？

Re: stay at second step,thanks

Hi: Is useful to discard the job and resubmit the build job? > 在 2020年10月12日，20:56，li_cong521 写道： > > hello,if any body miss this error,the table exists in the hive,but the error > stay at the second step say this table not exists. > I have seen a error which has puted by any other,but not

Re: 【求助！】sql报错问题

I can’t reproduce this error in my environment, Can you reproduce this in kylin_sales and provide the reproduce step? This can help us find the root cause. > 在 2020年9月29日，12:08，guojial...@smartbi.com.cn 写道： > > <报错信息.txt>

Re: kylin-3.1.0 webUI 报404错误，求助各位

Hi: Hadoop3.3 and hive3 is not supported. Maybe you can use Hadoop3.1+ and hive2.x to try again. > 在 2020年9月15日，17:35，杨建伟 <310209...@qq.com> 写道： > > > Hello，各位， 想问一下， 我安装的是 kylin-3.1.0 版本， 进程正常起来， 监听端口OK， 但是 访问webui 页面， 出现404 > 错误， 查看Kylin 和 tomcat 日志，并没有报错信息。 > > kylin版本如下： > for Hadoop

Re: cast string column to date in where clause

Hi: Can you provide the detail query log? SegmentPruner may prune the segment by mistake for some reason. > 在 2020年7月22日，19:54，skyyws 写道： > > Hello everyone, > Recently when I use Kylin to query like this: > select dt from table > where cast(dt as date) >= cast('2020-07-21' as date) and

Re: Measure column missing in Kylin 3.0 model

Hi: I test this in my env. I have create a model with a fact_table KYLIN_SALES and a lookup table KYLIN_CAL_DT, and the join condition is KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT, both columns are added to the list of dimensions in this model. Then I create a cube in this model, add

Re: Computing aggregate sum on a measurement with a filter

Hi Kirill: Would you want to optimize cube design or SQL statement? You can design cube according the SQL statement you want to query, such as add BATCH_ID and SEGMENT_SIZE to dimension, add sum(VALUE) as a measure. These can make your query faster. > 在 2020年7月29日，21:50，Kirill Bogdanov 写道：

Re: decimal（19，2） measure original value is loss

HI: Because kylin only stores the aggregated data, not the detailed information of the data source. If ‘entrust_balance’ be added to model as a dimension, you can query detail like select entrust_balance from table xx and get correct result. If you want to query SQL like ’Select * from table’ ,

Re: kylin-start

You can replacing localhost with the correct IP address and try again. > 在 2020年8月13日，09:16，sundywuyong 写道： > > 在服务器上部署的kylin,启动之后显示的ip地址是localhost，而不是服务器的ip地址，这个localhost地址在浏览器上打不开，请问这个如何解决，谢谢！详细信息如下图。 > > > > >

Re: 【Asking for help】how to build measures " sum(A+B)"

Hi： Kylin does not support precomputation between columns. If you want to perform aggregate operation (such as sum) on the results of adding two columns, you can define a column z = x * y in hive table, and then define sum (z) in kylin as a measure. If you don't want to add a column to the

Re: 问题

You can try execute ‘export SQOOP_HOME=/home/admin/sqoop-1.4.7.bin__hadoop-2.6.0/‘ and start kylin in the same shell. Then kylin will get $SQOOP_HOME from the environment variable, you can use this method replace that config kylin.source.jdbc.sqoop-home in kylin.properties. > 在

Re: RAM alloaction

Hi: Do you use this method to configure the yarn parameter in Kylin? > 在 2020年8月13日，19:55，Omid Vahdaty 写道： > > HI, > > Just installed kyling using docker. > > I performed a job and got a reduce error > > i have tried increasing the amount of RAM configuration for yarn get same > error > >

Re: 执行cube在第4步报错，提示“打开的文件过多” 是怎么回事？

Hi: If it's useful to restart kylin or rebuild the job? > 在 2020年7月8日，11:16，梅秋莹 <3281438...@qq.com> 写道： > > > > > -- 原始邮件 -- > 发件人: "梅秋莹"<3281438...@qq.com>; > 发送时间: 2020年7月3日(星期五) 下午4:55 > 收件人: "user"; > 主题: When build cube in kylin, it failed at the 4th step

Re: Query latency information not see in Kylin Metrics cube

Hi Preeti: I believe you should understand kylin's precomputing features. Kylin does not save the table details. When you query the whole table, you can only see the details of the columns added as dimension. When you query the detailed values of metrics you want in KYLIN_SYSYTEM project,

Re: File does not exist

Hi liaifan: It seems to be the problem of MapReduce. You can submit MR tasks by copying the commands executed by kylin to the command line to verify whether your MR can work normally. > 在 2020年6月1日，18:30，liaifan 写道： > > Unable to parse prior job history, aborting recovery

Re: 下载Kylin源码放入idea中缺少Jar包

Hi: Is the error reported during the `mvn clean install -DskipTests’ or `mvn test`? Do you follow the document below? http://kylin.apache.org/cn/development/dev_env.html > 在 2020年6月10日，09:07，chris_cai <601285...@qq.com> 写道： > > 你好： > 从git上下载Kylin源码放入idea中报错，找不到以下的Jar包，可以提供一下帮助吗？？？ >

Re: About KYLIN-4289-java.lang.NoSuchMethodError: com.google.common.hash.Hasher.putString

Hi Discovery: The latest release 3.1.0 upgrade guava to 28-jre and use putUnencodeChars replaced putString. So I think KYLIN-4289 should has been fixed. You can try Kylin 3.1.0 on your environment. > 在 2020年7月23日，11:25，Discovery 写道： > > Hi Kylin Team, > >I run into

Re: About KYLIN-4289-java.lang.NoSuchMethodError: com.google.common.hash.Hasher.putString

Yes，so you may need to do something extra to make kylin run in Hadoop 3.1. You can try as below: Download guava 28.jar and put it to $KYLIN_HOME/tool and $KYLIN_HOME/tomcat/lib, and start kylin. > 在 2020年7月23日，16:11，Discovery 写道： > > Hi Yaqian, > I tried kylin 3.1.0 , it run

Re: Computing aggregate sum on a measurement with a filter

; best regards, > Kirill > > > > On Thu, 30 Jul 2020 at 05:06, Yaqian Zhang <mailto:yaqian_zh...@126.com>> wrote: > Hi Kirill: > > Would you want to optimize cube design or SQL statement? > > You can design cube according the SQL statement you wan

Re: Start Kylin Error

Hi： It looks like your HBase server failed. You can check the health of your Hadoop cluster. > 在 2020年11月22日，16:25，lxk2...@163.com 写道： > > Hey guys > Recently, there was an error when I started Kylin. The information is as > follows > > > > > > Have you ever been met this

Re: kylin cannt start

Hi: You can try this: Download guava 28.jar from https://repo1.maven.org/maven2/com/google/guava/guava/28.0-jre/guava-28.0-jre.jar and put the package into $KYLIN_HOME/tool/ and $KYLIN_HOME/tomcat/lib/, then

Re: Apache Kylin - Tableau connectivity with MacOS

Hi Priyanshu Kumar: Kylin ODBC driver does not support Mac. I don't think you can use Kyligence ODBC driver to replace it, because Apache kylin and kyligence Enterprise are different. If you want to use Tableau to connect to kylin on Mac, you can use kylin JDBC driver. Kylin 3.0.0 supports

Re: kylin sample cube build error

Hi; It looks like there's something wrong with your MapReduce configuration, you can check it. > 在 2020年12月21日，09:29，chengya...@idengyun.com 写道： > > Error: Error while processing statement: Cannot modify mapreduce.job.name at > runtime. It is not in list of params that are allowed to be

Re: confused by multi model and cube in a project

Hi： "There's only one table under the "DEFAULT” database” is normal，because the data source of two cubes is the same table. 1、"I found the first model and cube missing some demessions, so I create the second model and cube, add some demessions.” is correct. Or you can edit the original model

Re: Cube disappears during build

Hi: I can't understand the meaning of " the Cube will suddenly disappear during the build “. You mean that you can't see the submitted build job in kylin web monitor page? You can try to adjust the monitor page to show the jobs within one week, maybe the jobs you said are not in the selected

Re: Cube disappears during build

Hi: I checked the source code through the log you provided. This may be a bug. Could you open an issue on https://issues.apache.org/jira/projects/KYLIN/issues to trace this error? We'll try to fix it in next release. > 在 2021年2月3日，14:52， 写道： > > hi ALL： > > 今天又出现了在cube使用分布式构建过程中，cube

[New Blog] Why didi Youzan choose kylin4

ose-Kylin4/> A big thanks to Zheng Shengjun! Best Regards! Yaqian Zhang 张亚倩 Apache Kylin committer

Re: 子查询case when 问题

Hi： I can't understand the problem you described. Please clearly describe your SQL statement and provide a screenshot of the query when there is a problem and a comparison between the correct result and the wrong result. In addition, providing the kylin version you are using can help others

Re: Encountered a startup problem at kylin 4

Hi: Kylin-4.0.0-beta dose not support spark 3.1.1 and hive3.1.2. please refer to: http://kylin.apache.org/cn/download/ > 在 2021年5月11日，09:42，王杨 写道： > > > HI， guys > Encounting problem when first starting kylin, hadoop, hbase, hive, have been > intalled successfully. Need you help. > Thany

Re: a problem

Please check if there is a syntax error in your SQL. > 在 2021年5月11日，08:54，山有扶苏 <562343...@qq.com> 写道： > > i have a problem > > when i query , i got a problem: xx is not being grouped > > > > > > > 发自我的小米手机

Re: there is no related output for job id

Hi: "When I rebuild the cube, the cube is also pending。” There are some error log in Kylin.log after you rebuild the cube? And you can check the number and status of segments on the cube storage page. There should be some out of sync state in the metadata. > 在 2021年6月29日，19:43，shylinzhang

Re: Error: Could not find or load main class org.apache.hadoop.mapreduce.v2.app.MRAppMaster

Hi: You can check the content of $KYLIN_HOME/bin/cached-hadoop-conf-dir.sh to ensure that the ‘kylin_hadoop_conf_dir' be set to correct HADOOP_CONF path. If the path is not correct, you can delete the $KYLIN_HOME/bin/cached-hadoop-conf-dir.sh. Then manually configure

Re: Why Cube Size is diffrent with Storage?

or configuration. Is there any similar phenomenon in other cubes? > 在 2021年2月25日，14:25，fan_gw 写道： > > > kylin 3.1.1 > > >> 在 2021年2月25日，10:32，Yaqian Zhang 写道： >> >> Hi: >> Theoretically, Cube storage and Cube size should be consistent. Can you >> provide

Re: Why Cube Size is diffrent with Storage?

Hi: Theoretically, Cube storage and Cube size should be consistent. Can you provide the kylin version you use? which is convenient to reproduce the problem. > 在 2021年2月24日，15:10，fan_gw 写道： > > Hi > > I Build a Cube. Source Table Size is 274.68m, Cube storage is 594M. But Cube > Size is

Re: 来自li_cong521的邮件

Hi: Maybe you can try to set them as derived dimensions. This document can help you learn more: http://kylin.apache.org/cn/docs/howto/howto_optimize_cubes.html > 在 2021年4月7日，20:29，li_cong521 写道： > > hello: >

Re: 在docker上部署kylin

Hi: Yes, as long as you have docker installed on your machine, you can deploy Kylin with docker. Reference documents:http://kylin.apache.org/cn/docs/install/kylin_docker.html . In general, kylin deployed with docker is only for trial

Re: 用flink构建cube

Hi： Can you provide your Flink version? Kylin 3.1.0/3.1.1 support Flink 1.9.2. > 在 2021年4月20日，16:49，邓书青 写道： > > 请问我安装官网的步骤安装了flink，结果构建cube时出现如下错误是为什么呢？ > 2021-04-20 16:44:44,743 ERROR [http-bio-7070-exec-1] > controller.CubeController:434 : org/apache/flink/api/common/io/InputFormat >

Re: Kylin v4.0.0 GA on EMR 6.3.0 fail to start Sparder due to YARN staging files missing

ile:/home/hadoop/.sparkStaging/application_1631282030708_2945/…” and the > application will fail. > > I am able to set spark.yarn.stagingDir to an HDFS location in > /usr/local/kylin/spark/conf/spark-defaults.conf and spark-submit succeeds. > > However it seems Kylin

Re: Use Beeline for Hive on Apache Kylin 4.0.0 ?

Hi: Kylin4 use spark engine to build cube, and spark application are submitted through spark-submit, which has nothing to do with hive cli or beeline.. Therefore, this configuration of “kylin.source.hive.client" has no effect in kylin 4. > 在 2021年9月14日，下午11:29，MAMERI Jamal - externe >

[New Blog] Apache Kylin4 — A new storage and compute architecture

-architecture/ Thanks to Tao jiatao! Best Regards! Yaqian Zhang 张亚倩 Apache Kylin committer

[New Blog] How Meituan Dominates Online Shopping with Apache Kylin

://kylin.apache.org/blog/2021/08/03/How-Meituan-Dominates-Online-Shopping-with-Apache-Kylin/ <https://kylin.apache.org/blog/2021/08/03/How-Meituan-Dominates-Online-Shopping-with-Apache-Kylin/> Thanks to Wang Yueqing! Best Regards! Yaqian Zhang 张亚倩 Apache Kylin committer

Re: kylin的systemcube创建

Hi: After your command is completed, is the system cube successfully created in Kylin? If the creation is successful, you can temporarily ignore the error message, which has no impact. > 在 2021年9月23日，上午10:20，washyou112 写道： > > > > > washyou112 > washyou...@163.com > >

Re: kylin的systemcube创建

63.com/dashi/dlpro.html?from=mail81> 定制 > 在2021年9月23日 16:30，Yaqian Zhang > <mailto:yaqian_zh...@126.com> 写道： > Hi: > > After your command is completed, is the system cube successfully created in > Kylin? > > If the creation is successful, you can temporarily i

Re: kylin的systemcube创建

l-online.nosdn.127.net%2Fqiyelogo%2FdefaultAvatar.png=%5B%22washyou112%40163.com%22%5D> > 签名由 网易邮箱大师 <https://mail.163.com/dashi/dlpro.html?from=mail81> 定制 > 在2021年9月26日 09:39，Yaqian Zhang > <mailto:yaqian_zh...@126.com> 写道： > The dashboard needs to query the system cube, so the dashb

Re: kylin的systemcube创建

Hi: When you switch to the dashboard, you can go to $KYLIN_HOME/logs/kylin.log to see what kind of SQL is generated, and then you can manually execute the SQL in system cube project to see whether the query result is empty. And you can also execute SQL in hive to verify the query results in

Re: kylin使用

LIN_SALES_BUYER_ID这两个代表了什么含义呢？ > > > > > > At 2021-11-26 12:02:55, "Yaqian Zhang" wrote: > > Hi: > > You can also configure the related configuration of the cube that has built > the hive dictionary on the cube that needs to reuse the diction

Re: kylin使用

Hi: You can also configure the related configuration of the cube that has built the hive dictionary on the cube that needs to reuse the dictionary, and then add the configuration of “kylin.dictionary.mr-hive.ref.columns” on the basis of this configuration. Its use example is as follows:

[New Blog] Performance optimization of Kylin 4.0 in cloud: Local cache and soft affinity scheduling

Hi, We have released a new blog on Apache Kylin’s official website: Performance optimization of Kylin 4.0 in cloud -- local cache and soft affinity scheduling, which is shared by Yaqian Zhang, R engineer from Kyligence and Apache Kylin committer. This blog introduces how the kylin development

[Kylin Security Notice] Impact analysis of Apache Log4j2 Remote Code Execution Vulnerability

Hi all: This is a security notice about the impact analysis of Apache Log4j2 Remote Code Execution Vulnerability on Apache Kylin. Background Apache Log4j2 is a Java based logging tool, which is widely used in the industry. The recently discovered Remote Code Execution Vulnerability of Apache

Re: Kylin3.1.2启动，Caused by: java.lang.NoSuchMethodError: org.apache.jasper.xmlparser.ParserUtils: method ()V not found

Hi: The problem of error reporting looks like jar package conflict, It may be due to the inconsistency between the versions of the classes in MRS3.0.5 environment and the classes to be loaded by kylin. And we have not adapted to the cloud environment in China, class conflict should be a common

  1   2   >