kylin4.0.1邮件发送报错

kylin4.0.1配置完邮件告警，发送邮件时，总是报错，以下是异常日志。请问你有遇到过吗？我看了邮件模版，大概是因为拿不到参数${env_name}。 2024-04-11 13:46:35,024 INFO [http-bio-7070-exec-3] cube.PathManager:66 : Deleting segment parquet path

kylin4.0.1邮件告警发生异常

你好，kylin4.0.1任务构建完成以后，告警发送邮件发生异常，看日志原因是构建邮件模版信息时报错了，获取不到env_name，但是kylin.properties中的kylin.env=QA，请问如何解决？以下是报错日志： 2024-04-11 18:03:38,738 ERROR [Scheduler 1170635011 Job 43525ef8-d8ee-4b17-a326-a7e97fcad95f-86] freemarker.runtime:60 : Error executing FreeMarker template FreeMarker template

Re:来自suoli的邮件

在 2024-04-11 13:50:20，"suoli" 写道：

来自suoli的邮件

来自suoli的邮件

Participate in the ASF 25th Anniversary Campaign

Hi everyone, As part of The ASF’s 25th anniversary campaign[1], we will be celebrating projects and communities in multiple ways. We invite all projects and contributors to participate in the following ways: * Individuals - submit your first contribution:

Re: How to query the Cube via API and use the dataset for other purpose

Thank you very much for your response, I did ask a pro for help and below was the sample code on sample SSB project I would like to contribute to help someone who have same issue like me: == import org.apache.spark.sql.types.{StringType, StructField, StructType}

Re: How to query the Cube via API and use the dataset for other purpose

Dear Sirs/Madames Could anyone here help me to figureout the way to use scala to query an select SQL against kylin cube via API then turn that table result into a dataframe in scala for other purpose? Thank you so much for your time! Best regards On Fri, 29 Mar 2024 at 17:52 Nam Đỗ Duy wrote:

How to query the Cube via API and use the dataset for other purpose

Hi Xiaoxiang, Sir & Madames, I use the following code to query the cube via API but I cannot use the result as a dataframe, could you suggest a way to do that because it is very important for our project. Thanks and best regards === import

Community Over Code NA 2024 Travel Assistance Applications now open!

Hello to all users, contributors and Committers! [ You are receiving this email as a subscriber to one or more ASF project dev or user mailing lists and is not being sent to you directly. It is important that we reach all of our users and contributors/committers so that they may get a chance

Re: Pinot/Kylin/Druid quick comparision

Thank you Li Yang, I think the development of version 5 would be hard work for you but the impact is big so please keep me posted! All the best On Thu, Mar 14, 2024 at 10:51 AM Li Yang wrote: > Nam, > > We are planning to release a kylin5-beta around March or April. The GA of > kylin5 would be

Re: Pinot/Kylin/Druid quick comparision

Nam, We are planning to release a kylin5-beta around March or April. The GA of kylin5 would be around July this year if everything goes well. Cheers Yang On Tue, Mar 5, 2024 at 6:54 PM Nam Đỗ Duy wrote: > Hello Xiaoxiang, > > How are you, my boss is very interested in Kylin 5. so he would

Re: Pinot/Kylin/Druid quick comparision

Hello Xiaoxiang, How are you, my boss is very interested in Kylin 5. so he would like to know when Kylin 5 will be released...could you please provide an estimation? Thank you very much and best regards On Thu, 18 Jan 2024 at 10:05 Nam Đỗ Duy wrote: > Good morning Xiaoxiang, hope you are

Community Over Code Asia 2024 Travel Assistance Applications now open!

Hello to all users, contributors and Committers! The Travel Assistance Committee (TAC) are pleased to announce that travel assistance applications for Community over Code Asia 2024 are now open! We will be supporting Community over Code Asia, Hangzhou, China July 26th - 28th, 2024. TAC exists

Re: kylin4_on_cloud deployment errors

I followed the troubleshooting instructions at: https://github.com/apache/kylin/blob/kylin4_on_cloud/readme/trouble_shooting.md#kylin-can-not-access-and-exception-session-0x0-for-server-null-unexpected-error-closing-socket-connection-and-attempting-reconnect-is-in-kylinlog When logging into the

kylin4_on_cloud deployment errors

Hi, I'm having problems deploying the kylin4_on_cloud project located at: https://github.com/apache/kylin/tree/kylin4_on_cloud I've also been following the instructions here https://www.youtube.com/watch?v=5kKXEMjO1Sc_channel=Kyligence I used windows to git clone the repo and set up the venv

Community over Code EU 2024 Travel Assistance Applications now open!

Hello to all users, contributors and Committers! The Travel Assistance Committee (TAC) are pleased to announce that travel assistance applications for Community over Code EU 2024 are now open! We will be supporting Community over Code EU, Bratislava, Slovakia, June 3th - 5th, 2024. TAC exists

[no subject]

Hello to all users, contributors and Committers! The Travel Assistance Committee (TAC) are pleased to announce that travel assistance applications for Community over Code EU 2024 are now open! We will be supporting Community over Code EU, Bratislava, Slovakia, June 3th - 5th, 2024. TAC exists

CVE-2023-29055: Apache Kylin: Insufficiently protected credentials in config file

Severity: low Affected versions: - Apache Kylin 2.0.0 through 4.0.3 Description: In Apache Kylin version 2.0.0 to 4.0.3, there is a Server Config web interface that displays the content of file 'kylin.properties', that may contain serverside credentials. When the kylin service runs over HTTP

[Announce] Apache Kylin 4.0.4 released

The Apache Kylin team is pleased to announce the immediate availability of the 4.0.4 release. This is a minor release with 5 small improvements. All of the changes in this release can be found in: https://kylin.apache.org/docs/release_notes.html You can download the source release and binary

退订

退订

回复: 退订

退订 提示信息：

退订

退订

Re: Pinot/Kylin/Druid quick comparision

Good morning Xiaoxiang, hope you are well 1. JDBC source is a feature which in development, it will be supported later. === May I know when will the JDBC be available? as well as is there any change in Kylin 5 release date Thank you and best regards On Mon, Dec 11, 2023 at 2:15 

退订

退订 2415370...@qq.com 发件人： lee 发送时间： 2023-12-06 08:33 收件人： user 主题： Re: kylin4.0.3构建数据时报错 退订 2023年12月5日 19:33，李甜彪 写道： 构建时报错，数据在hive中是没有问题的，空数据构建时可以成功，反思有可能是数据问题，自己手写几条数据，构建时又同样的错误，证明不是原来的数据的问题。 页面的看到的报错信息如下： java.io.IOException: OS command error exit with return code: 1, error message:

Re: 退订

退订 > 2023年12月17日 16:48，怪侠一枝梅 写道： > > 退订

????

Re: 退订

退订 313463...@qq.com <313463...@qq.com> 于2023年12月13日周三 17:01写道： > 退订 > > -- > 313463...@qq.com > 313463...@qq.com > >

??????????

313463...@qq.com 313463...@qq.com ---- ??: "user"

????

回复: 退订

退订 From: guowj Date: 2023-12-13 16:54 To: user CC: dev Subject: 退订 退订 提示信息：

????

Re: ACID with Hive/Kylin

Thank you both of you for your valuable information. I will test and revert soon. Best regards On Tue, Dec 12, 2023 at 2:39 PM Xiaoxiang Yu wrote: > I don't know GDPR very well. Here is my understanding. > > For hive and hdfs, you can consider using these techniques which support > ACID in

Re: ACID with Hive/Kylin

I don't know GDPR very well. Here is my understanding. For hive and hdfs, you can consider using these techniques which support ACID in Spark and Hive(I recommend first one): 1) Delta Lake, https://docs.databricks.com/en/security/privacy/gdpr-delta.html 2) Hive ACID table, here is a link,

Re: ACID with Hive/Kylin

Hi Nam, As Kylin is used to store the aggregated data, there should be no PII information. (if you use Kylin to manage person level data, that is not a good case). If you do need to delete certain personal data, refresh the whole index or some partitions is what we can do. Best regards,

ACID with Hive/Kylin

Dear Xiaoxiang, Sirs/Madams I face an issue with deleting data of user according to GPDR-like policy which means when user send request to delete their personal data, we need to delete it from all system, that means to delete data: 1- from Kylin index (cube) 2- from Hive 3- from HDFS Have you

Re: Pinot/Kylin/Druid quick comparision

Thank you very much, please kindly start kylin-kerberos document and JDBC connectivity, we will be actively participating in testing that JDBC when it is available so please let us know. Best regards On Mon, Dec 11, 2023 at 2:15 PM Xiaoxiang Yu wrote: > 1. JDBC source is a feature which in

Re: Pinot/Kylin/Druid quick comparision

1. JDBC source is a feature which in development, it will be supported later. 2. Kylin supports kerberos now, I will write a doc as soon as possible. (I will let you know.) 3. I think ranger and Kerberos are not doing the same things, one for authentication, one for authorization. So they cannot

Re: Pinot/Kylin/Druid quick comparision

Thank you Xiaoxiang for your reply - Do you have any suggestions/wishes for kylin 5(except real-time feature)? - Yes: please answer to help me clear this headache: 1. Can Kylin access the existing star schema in Oracle datawarehouse ? If not then do we have any work

Re: Pinot/Kylin/Druid quick comparision

I guess the release date should be 2024/01 . Do you have any suggestions/wishes for kylin 5(except real-time feature)? With warm regard Xiaoxiang Yu On Thu, Dec 7, 2023 at 3:44 PM Nam Đỗ Duy wrote: > Thank you very much xiaoxiang, I did the presentation this morning

Re: Pinot/Kylin/Druid quick comparision

Thank you very much xiaoxiang, I did the presentation this morning already so there is no time for you to comment. Next time I will send you in advance. The meeting result was that we will implement both druid and kylin in the next couple of projects because of its realtime feature. Hope that

confirm unsubscribe

confirm unsubscribe chinacsj 15180809...@139.com 15180809092 电子名片新出VIP模板啦，快来体验>> 扫一扫, 快速添加名片到手机

Re: Pinot/Kylin/Druid quick comparision

Since 2018 there are a lot of new features and code refactor. If you like, you can share your ppt to me privately, maybe I can give some comments. Here is the reference of advantages of Kylin since 2018: - https://kylin.apache.org/blog/2022/01/12/The-Future-Of-Kylin/ -

confirm unsubscribe

confirm unsubscribe chinacsj 15180809...@139.com 15180809092 电子名片新出VIP模板啦，快来体验>> 扫一扫, 快速添加名片到手机

Re: Pinot/Kylin/Druid quick comparision

Hi Xiaoxiang, tomorrow is the main presentation between Kylin and Druid in my team. I found this article and would like you to update me the advantages of Kylin since 2018 until now (especially with version 5 to be released) Apache Kylin | Why did Meituan develop Kylin On Druid (part 1 of 2)?

Re: Pinot/Kylin/Druid quick comparision

Thank you very much for your prompt response, I still have several questions to seek for your help later. Best regards and have a good day On Wed, Dec 6, 2023 at 9:11 AM Xiaoxiang Yu wrote: > Done. Github branch changed to kylin5. > > > With warm regard > Xiaoxiang

Re: Pinot/Kylin/Druid quick comparision

Done. Github branch changed to kylin5. With warm regard Xiaoxiang Yu On Tue, Dec 5, 2023 at 11:13 AM Xiaoxiang Yu wrote: > A JIRA ticket has been opened, waiting for INFRA : > https://issues.apache.org/jira/browse/INFRA-25238 . > > With warm

Re: kylin4.0.3构建数据时报错

退订 > 2023年12月5日 19:33，李甜彪 写道： > > 构建时报错，数据在hive中是没有问题的，空数据构建时可以成功，反思有可能是数据问题，自己手写几条数据，构建时又同样的错误，证明不是原来的数据的问题。 > 页面的看到的报错信息如下： > java.io.IOException: OS command error exit with return code: 1, error > message: che.spark.rdd.RDD.iterator(RDD.scala:337) > at

kylin4.0.3构建数据时报错

构建时报错，数据在hive中是没有问题的，空数据构建时可以成功，反思有可能是数据问题，自己手写几条数据，构建时又同样的错误，证明不是原来的数据的问题。 页面的看到的报错信息如下： java.io.IOException: OS command error exit with return code: 1, error message: che.spark.rdd.RDD.iterator(RDD.scala:337) at org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:52) at

Re: Pinot/Kylin/Druid quick comparision

A JIRA ticket has been opened, waiting for INFRA : https://issues.apache.org/jira/browse/INFRA-25238 . With warm regard Xiaoxiang Yu On Tue, Dec 5, 2023 at 10:30 AM Nam Đỗ Duy wrote: > Thank you Xiaoxiang, please update me when you have changed your default > branch.

Re: Pinot/Kylin/Druid quick comparision

I think so. Response time is not the only factor to make a decision. Kylin could be cheaper when the query pattern is suitable for the Kylin model, and Kylin can guarantee reasonable query latency. Clickhouse will be quicker in an ad hoc query scenario. By the way, Youzan and Kyligence combine

Re: Pinot/Kylin/Druid quick comparision

Hi Xiaoxiang, thank you In case my client uses cloud computing service like gcp or aws, which will cost more: precalculation feature of kylin or clickhouse (incase of kylin, I have a thought that the query execution has been done once and stored in cube to be used many times so kylin uses less

Re: Pinot/Kylin/Druid quick comparision

Following text is part of an article(https://zhuanlan.zhihu.com/p/343394287) . === Kylin is suitable for aggregation queries with fixed modes because of its pre-calculated technology, for example, join, group by, and

Re: Pinot/Kylin/Druid quick comparision

Thank you Xiaoxiang for the near real time streaming feature. That's great. This morning there has been a new challenge to my team: clickhouse offered us the speed of calculating 8 billion rows in millisecond which is faster than my demonstration (I used Kylin to do calculating 1 billion rows in

Re: Pinot/Kylin/Druid quick comparision

1. "In this important scenario of realtime analytics, the reason here is that kylin has lag time due to model update of new segment build, is that correct?" You are correct. 2. "If that is true, then can you suggest a work-around of combination of ... " Kylin is planning to introduce NRT

Re: Pinot/Kylin/Druid quick comparision

Druid is better in - Have a real-time datasource like Kafka etc. == Hi Xiaoxiang, thank you for your response. In this important scenario of realtime alalytics, the reason here is that kylin has lag time due to model update of new segment build, is that correct? If that

Re: Pinot/Kylin/Druid quick comparision

I researched and tested Druid two years ago(I don't know too much about the change of Druid in these two years. New features that I know are : new UI, fully on K8s etc). Here are some cases you should consider using Druid other than Kylin at the moment (using Kylin 5.0-beta to compare the Druid

Pinot/Kylin/Druid quick comparision

Dear Xiaoxiang, Sirs/Madams, May I post my boss's question: What are the pros and cons of the OLAP platform Kylin compared to Pinot and Druid? Please kindly let me know Thank you very much and best regards

Re: How to use measure of Kylin in query

Your summary "I write query normally to query the desired column and Kylin uses the index mechanism to accelerate query" is almost right. And I cannot understand exactly what your question is. With warm regard Xiaoxiang Yu On Wed, Nov 22, 2023 at 5:32 PM Nam Đỗ Duy

How to use measure of Kylin in query

Dear Sir / Madam I've searched the web but cannot find the way to use measures of Kylin, for example, with this quote from the URL of document, it seems that the measure's magic is as follows: "I write query normally to query the desired colummn and Kylin uses the index mechanism to accelerate

Re: Kylin real usecase on AI/ML (data science) project

Yes, you are right. -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-11-13 17:57:59, "Nam Đỗ Duy via user" wrote: Thank you Xiaoxiang, 1. For my question of near real time data: this scenario is not about querying the cube (index), I am mentioning the query against the Hive table

Re: Kylin real usecase on AI/ML (data science) project

Thank you Xiaoxiang, 1. For my question of near real time data: this scenario is not about querying the cube (index), I am mentioning the query against the Hive table only: is that possible to instantly querying the non_cube data if the data is already in Hive? Best regards On Mon, Nov 13, 2023

Re: Kylin real usecase on AI/ML (data science) project

1. Query them instantly is not possible, you need to trigger a build job and wait it completed, it will cost about 5-30 mintues in most cases. So the delay caused by Kylin is 5-30 minites. 2. DS/AI can send SQL query using Python and get the result(if kylinpy works well), just like you do in

Re: Kylin real usecase on AI/ML (data science) project

Thank you Xiaoxiang for answering my previous question 1. For previous question 1, if I can ingest data near real-time into Hive table, can that near realtime data be queried in Kylin insights windows by SQL query almost instantly? If not then how can I reflect near realtime data in (Kylin

Re: Kylin real usecase on AI/ML (data science) project

Hi, Question 1: You are almost right. If the Cube not ready, Kylin will use SparkSQL to execute query directly on original tables. Question 2: It is possible but very hard. The index data are saved in Parquet format, it is possible to read them by Spark, but the columns' name are encoded so

Re: Kylin real usecase on AI/ML (data science) project

Hi Xiaoxiang, Basically you can imagine the scenario that there will be3 teams who will be using Kylin's Cube: a) Data analyst team (DA) who is using PowerBI (via ODBC or mez), superset to access kylin Cube as well. b) Data science team (DS) who is using Pyspark, SparkML currently assessing HDFS

Re:Kylin real usecase on AI/ML (data science) project

I'm just curious. How much does MDX and AI/ML influenced your company's decision to use Kylin 5? Is it a nice-to-have requirement or a must-have requirement? Thanks. -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-11-13 15:38:17, "Xiaoxiang Yu" wrote: Do you have any specific

Re:Has anyone used MDX in Kylin 5.0 ?

Currently I think there is no such use case. -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-11-13 11:33:13, "Nam Đỗ Duy via user" wrote: Dear Sir/Madam I found document on MDX on Kylin 4.0 but still not found MDX on document of 5.0 Has anyone been using MDX on Kylin 5.0 and

Re:Kylin real usecase on AI/ML (data science) project

Do you have any specific business scenario? Looks like there is not such real usecase at the moment. -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-11-13 11:36:35, "Nam Đỗ Duy via user" wrote: Dear Sir/Madam I am persuading my company to use kylin as olap platform so please

Kylin real usecase on AI/ML (data science) project

Dear Sir/Madam I am persuading my company to use kylin as olap platform so please kindly share with me (inbox me if you hesitate to share publicly) your real use-cases to help me answer our boss’s question: 1. Which companies are using kylin now 2. How do you use kylin’s capabilities in your

Has anyone used MDX in Kylin 5.0 ?

Dear Sir/Madam I found document on MDX on Kylin 4.0 but still not found MDX on document of 5.0 Has anyone been using MDX on Kylin 5.0 and kindly provide me some feed back on this topic Thank you very much and best regards

Integrate Kylin with Power BI report server

Dear Sir/Madam We are using PowerBI report server on premise. Please kindly advise me the integration guidelines in two scenarios: 1. POC period: Power BI report server: Windows 10 Kylin 5.0 in docker file downloaded from official kylin website 2. Development period: Power BI report server:

Re: 如何设置树形层级结构维度

It is not supported I think. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC, Apache Incubator PMC, Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscr...@kylin.apache.org Join Kylin dev mail group:

回复：如何设置树形层级结构维度

hi 雨后初晴 现在应该是有一张以orgId 为主键的事实表，和一张包含组织关系的维度表。我想到的一个办法是可以通过 etl 的手段将维度表中的树形关系展开，增加一个 leafOrgId 字段，维度表以 orgID 和 leafOrgId 作为联合主键内容包含节点到其所有叶子节点的数据。在 Kylin 将事实表的 orgID 与维度表的 leafOrgId 进行关联，查询以维度表中的 orgId 字段作为聚合物即可。 ---原始邮件--- 发件人: "雨后初晴"<745579...@qq.com 发送时间: 2023年10月25日(周三) 凌晨0:49 收件人: "user"

????????????????????????

??orgId,parentOrgId,orgName,isLeaf??id??id idkylin

Re: 退订

退订 > 2023年10月11日 13:07，许颖众 写道： > > > > 发件人: hit_la...@126.com > 代表 Xiaoxiang Yu > 发送时间: 2023年8月2日 17:39 > 收件人: user@kylin.apache.org ; leil...@zqykj.com > ; 1163629...@qq.com

退订

发件人: hit_la...@126.com 代表 Xiaoxiang Yu 发送时间: 2023年8月2日 17:39 收件人: user@kylin.apache.org; leil...@zqykj.com; 1163629...@qq.com 主题: Re:退订 Hey, to unsubscribe user mailling list, please follow these steps: First, you need to send any text to

Docker Image for Kylin 5.0-beta is available now

Following is the command to preview Kylin 5 really quickly.: docker run -d \ --name Kylin5-Machine \ --hostname Kylin5-Machine \ -m 8G \ -p 7070:7070 \ -p 8088:8088 \ -p 9870:9870 \ -p 8032:8032 \ -p 8042:8042 \ -p 2181:2181 \

Re: Kylin defaut storage system is HDFS?

Hi Yu, This link *https://kylin.apache.org/docs31/tutorial/setup_jdbc_datasource.html * suggests that "*Since v2.3.0 Apache Kylin starts to support JDBC as the third type of data source (after Hive, Kafka)"* So My question of

[Announce] Apache Kylin 5.0.0-beta released

The Apache Kylin team is pleased to announce the immediate availability of the 5.0.0-beta release. This is the second release for Kylin 5, with 62 new features/improvements and 124 bug fixes. You can download the source release and binary packages from Apache Kylin's download page:

退订

退订 回复的原邮件 发件人 李甜彪 发送日期 2023年7月31日 17:52 收件人 user@kylin.apache.org 主题 kylin使用过程中出现的问题

退订

退订 回复的原邮件 | 发件人 | 李甜彪 | | 发送日期 | 2023年7月31日 17:52 | | 收件人 | user@kylin.apache.org | | 主题 | kylin使用过程中出现的问题 | 在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 | | 李甜彪 | | ltb1...@163.com |

Registration open for Community Over Code North America

Hello! Registration is still open for the upcoming Community Over Code NA event in Halifax, NS! We invite you to register for the event https://communityovercode.org/registration/ Apache Committers, note that you have a special discounted rate for the conference at US$250. To take advantage of

Re: Kylin defaut storage system is HDFS?

Hi, For Kylin 5, you have to use a distributed storage, and the default choice is HDFS, and alternative choice is Cloud Storage(like S3), you can NOT deploy and run Kylin without a distributed storage. Besides, you need a RDBMS as a metastore, Zookeeper as service discovery, a Spark

Kylin defaut storage system is HDFS?

Hello, I have few questions regarding storage mean for Kylin: I was wondering if Kylin would work normally if I don't configure it to work with any storage tool (as MySQL with Sqoop Or with Hive)? It would then automatically use HDFS ? Also is configuring HBASE necessary? Could I use Kylin

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

Do you mean extract data from the fact table? Define a model based on this table, and dimensions & this measure, then create an aggregation group with these dimensions and measure, build to get the data you preferred. Or do you mean the metadata file? Just query the database or dump metadata to

?????? measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

?? ---- ??: "marc nicole"

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

the dataset (csv) is in this form att1 att2 count_measure str1 str2 int1 ... How to extract from it fact table (the count_measure column) and the dimensions ? in the datasource / model definition in Kylin? Le mer. 2 août 2023 à 13:32, marc nicole a écrit : > in the model the measure

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

in the model the measure definition is as follows (I don't understand chinese) { "name": "COUNT1", "function": { "expression": "COUNT", "parameter": { "type": "column", "value": "attributeName.COUNT1" }, "returntype": "bigint"

Re:退订

Hey, to unsubscribe user mailling list, please follow these steps: First, you need to send any text to user-unsubscr...@kylin.apache.org . And you will receive a confirm email with title "confirm unsubscribe from user@kylin.apache.org " in several minutes. Then, you have to reply (with any

退订

退订 你好，由于工作原因退订所有相关的邮件。 谢谢！

?????? measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

---- ??: "??"

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

I guessed Shaofeng has answered your question in wechat group. Following is his answer: 把维度表中的字段，做成“normal”维度，这样这些字段的数据，就会被持久化到cube中；构建新的segment的时候，也不会改变过去构建的结果了 如果不是“normal”维度，就会存在于维度表的快照中，所以维度表快照被刷新后数据也就变了 请问你为什么不考虑使用一般维度呢（因为设置为一般维度后，就不会生成维度表快照了）？ -- Best wishes to you ! From

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

问题就是，维度数据每构建一次就需要变动一次，导致了前面构建的也用了最新的维度数据，但是构建时间跨天就不会有这种问题，还是维度快照的更新机制问题，怎么能解决维度数据变了，前面已经构建过的关联的维表还是当时的那种状态呢？ | | 李甜彪 | | ltb1...@163.com | Replied Message | From | P.F. ZHAN | | Date | 8/2/2023 15:34 | | To | | | Subject | Re: measure column showing 1 as values instead of the actual

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

这种你不是应该将需要查询的列设置成维度，然后预计算存储到cube么？cube的维度数据，如果不做刷新，那么就不会变化。 On Wed, Aug 2, 2023 at 11:35 李甜彪 wrote: > 大神，能帮我解决一下我碰到的问题吗？维度表的快照怎么能不让取最新的， > 在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 > 李甜彪 >

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

大神，能帮我解决一下我碰到的问题吗？维度表的快照怎么能不让取最新的，在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 | | 李甜彪 | | ltb1...@163.com | Replied Message | From | Xiaoxiang Yu | | Date | 8/2/2023 11:31 | | To | , | | Subject

Re:measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

Do you check the answer by Hive/SparkSQL, do Hive/SparkSQL give the expected answer? If you have checked, I think you can give us you cube defination(CubeDesc in Json) and the SQL statement you queried, so we can discuss in detail? -- Best wishes to you ! From ：Xiaoxiang Yu At

measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

The measure is of type column (not constant) and is bigint. I selected the measure from the dropdown corretly as well. measure column returns 1 for all column values instead of actual values when querying the cube. What could be the underlying problem? cube or model defining? or maybe data source

kylin使用过程中出现的问题

在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 | | 李甜彪 | | ltb1...@163.com |

kylin使用中的问题

在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 | | 李甜彪 | | ltb1...@163.com |

  1   2   3   4   5   6   7   8   9   10   >