Re: 你好，我在使用kylin中遇到了下面的问题，希望得到及时的反馈

[Guosheng Lu]

Hi, you can alter your SQL like the new SQL below. It can work around 
temporarily.  Maybe there was something limitation of the char type length in 
OLAP query expression.

   Select
 case substring(PRODUCT_PENETRANCE_LEVEL, 1)
when ‘1’ then ‘hello' when ‘2' then ‘Kylie' else ’sorry' end 
from TAGS_MBR_PRODUCTPENETRANCE_D
--
陆国圣 /  Guosheng Lu
软件工程师 / Software Engineer
http://kyligence.io <http://kyligence.io/>


在 2019/10/16 上午9:45，“Yaqian Zhang” 写入:

Hi ZhenDong:

I reproduced this error, and it’s likely with 
https://issues.apache.org/jira/browse/KYLIN-4166 
<https://issues.apache.org/jira/browse/KYLIN-4166>.

I think we should fix it in future version.

> 在 2019年10月15日，18:02，Zhen Dong  写道：
> 
> 当我采用以下标准sql在kylin执行时执行正确，sql如下：
> 
> select 
> 
> case 1 when 1 then 'hello'
> 
> when  2 then 'Kylie'
> 
> else 'sorry' end
> 
> from TAGS_MBR_PRODUCTPENETRANCE_D
> 
> 
> 
> 
> 基于这个case 
when条件判断特性，我们的TAGS_MBR_PRODUCTPENETRANCE_D库中有一个通过hive同步类型为varchar类型的字段PRODUCT_PENETRANCE_LEVEL，按照上面的流程，我们希望通过PRODUCT_PENETRANCE_LEVEL字段进行条件判断输出不同的值。
> 
> SQL改为下面情况
> 
> select 
> 
> case PRODUCT_PENETRANCE_LEVEL when '1' then ‘hello'
> 
> when  ‘2' then ‘Kylie'
> 
> else ’sorry' end
> 
> from TAGS_MBR_PRODUCTPENETRANCE_D
> 
> 在这种情况下，最坏的情况就是进入else块输出sorry。但是我们在web页面中得到的却是空值，就如下面的情况：
> 
> 
> 
> 
> 请问这是什么原因，实在摸不清头脑，kylin版本为：2.6.3

Re: [VOTE] Release apache-kylin-3.0.0-beta (RC1)

[Guosheng Lu]

+1

--
陆国圣 /  Guosheng Lu
软件工程师 / Software Engineer
电话 / Mobile: 13914708027
http://kyligence.io <http://kyligence.io/>


在 2019/9/27 上午10:13，“Temple Zhou” 写入:

+1

On Thu, Sep 26, 2019 at 4:42 PM ShaoFeng Shi  wrote:

> Hi all,
>
> I have created a build for Apache Kylin 3.0.0-beta, release candidate 1.
>
> Changes highlights:
> [KYLIN-4122] - Add Kylin user and group management modules
> [KYLIN-4167] - Refactor streaming coordinator
> [KYLIN-4114] - Provided a self-contained docker image for Kylin
> [KYLIN-4137] - Accelerate metadata reloading
>
> Thanks to everyone who has contributed to this release.
> Here’s the release notes:
>
> 
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12345686
>
> The commit to being voted upon:
>
> 
https://github.com/apache/kylin/commit/721be80866223fecad9a6231fa2427a847bc8f48
>
> Its hash is 721be80866223fecad9a6231fa2427a847bc8f48.
>
> The artifacts to be voted on, including the source package and two
> pre-compiled binary packages, are located here:
> https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-3.0.0-beta-rc1/
>
> The hash of the artifacts are as follows:
> apache-kylin-3.0.0-beta-source-release.zip.sha256
> 53547e8a94eb74cdcd329777ff03f1c79209020016c2f9a62351e8c73ac8e0bd
> apache-kylin-3.0.0-beta-bin-hbase1x.tar.gz.sha256
> 1d50348660899baa9005b78cf45243e0eb2495fa0403d6250b3439ff50bf1731
> apache-kylin-3.0.0-beta-bin-cdh57.tar.gz.sha256
> bc9e303154901d4061dbac3876157cb4be25f23307f4c709d083da70aa18524b
> apache-kylin-3.0.0-beta-bin-hadoop3.tar.gz.sha256
> 681452450248f56ebe107d278e3ccb1478e42137875a2dded953db8c03488f9a
> apache-kylin-3.0.0-beta-bin-cdh60.tar.gz.sha256
> 2f66497ed39d7d78ea5a634a8796ab408586dce369edc97ed9374ba90a88b03d
>
> A staged Maven repository is available for review at:
> https://repository.apache.org/content/repositories/orgapachekylin-1066/
>
> Release artifacts are signed with the following key:
> https://people.apache.org/keys/committer/shaofengshi.asc
>
> Please vote on releasing this package as Apache Kylin 3.0.0-beta.
>
> The vote is open for the next 72 hours and passes if a majority of
> at least three +1 PMC votes are cast.
>
> [ ] +1 Release this package as Apache Kylin 3.0.0-beta
> [ ]  0 I don't feel strongly about it, but I'm okay with the release
> [ ] -1 Do not release this package because...
>
> Best regards,
>
> Shaofeng Shi 史少锋
> Apache Kylin 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: dev-subscr...@kylin.apache.org
>

Re: How solve many cube use same UHC dimension?

[Guosheng Lu]

https://mp.weixin.qq.com/s/DKMKTUV1xgrpbFau5L4baw   
this may be useful for resolve your question

在 2019/9/9 上午9:48，“wonder87” 写入:

I have mutiple cubes which contains some same dimension  such as  date
dimension and user dimension , user dimension is very large dimension  which
contains 1600 records.When I build cube ,this step( Build Dimension
Dictionary ) would cost a very long time . could it be possible to build one
time, so that other cube could use it directly rather than build after
build.


Another question is when the user dimension changes, each cube would be
modified,it cost a lot,any suggestion ?


--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: Plan to host the first "Kylin Data Summit" event

[Guosheng Lu]

Looking forward to it!  +1


--
陆国圣 /  Guosheng Lu
前端工程师 / Software Engineer

电话 / Mobile: 13914708027
http://kyligence.io<http://kyligence.io/>
[cid:image001.png@01D517B8.BF173C50]

发件人: JiaTao Tao 
答复: "u...@kylin.apache.org" 
日期: 2019年5月30日 星期四 下午7:32
收件人: dev 
抄送: user 
主题: Re: Plan to host the first "Kylin Data Summit" event

Looking forward to it!


--

Regards!
Aron Tao

ShaoFeng Shi mailto:shaofeng...@apache.org>> 
于2019年5月30日周四 上午6:29写道：
Hello Kylin developers and users,



We (Kyligence Inc) planned to host the first "Kylin Data Summit" event at
Shanghai, China. This event is going to provide a place to share, discuss
the technology and trends in Big Data domain. The presentors and target
audiences are big data engineers, data analysts and others who are
interested in the data analysis domain. I’m writing to the community for
the approval of using Apache Kylin trademark on such an event. After
getting Kylin PMC approval, we will submit the request to the VP of ASF
band management. The process is from
https://www.apache.org/foundation/marks/events.html#approval



The information about this event is as follows:

   - *What is the topic focus of the event*

Big Data, OLAP, Apache Kylin and other big data technologies like Apache
Hadoop, Apache Spark, etc.

   - *Who is organising the event*

Kyligence Inc. and InfoQ China

   - *When is the event*

12th, July.

   - *How many attendees are expected*

500 expected attendees.

   - *How much PMC involvement is there already*

Some Apache Kylin’s PMC members are involved in the organization of Kylin
Data Summit, such as Billy Liu, Yang Li, Shaofeng Shi. Several PMC will
give speech on this event: Luke, Yanghong Zhong.



   - *Which marks are requested*

The name and logo of Apache Kylin, the Apache feather logo.

   - *How would you propose that the ASF will be listed as a community
   partner?*

Community Partner

   - *How will the event selection work?*

We have a selection group for this event, formed by the PMCs that will
attend the event. We will invite the community users to prepare proposal,
and then make a vote in the selection group

*Is this for profit or non-profit?*

Profit, with some free tickets to community contributors.

   - *The event’s related site and marketing materials*

They are still under construction.



Please share your comment or suggestions, thank you!


Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofeng...@apache.org<mailto:shaofeng...@apache.org>

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: 
user-subscr...@kylin.apache.org<mailto:user-subscr...@kylin.apache.org>
Join Kylin dev mail group: 
dev-subscr...@kylin.apache.org<mailto:dev-subscr...@kylin.apache.org>

Re: [VOTE] Migrate to gitbox

[Guosheng Lu]

+1



在 18/2/1 上午11:16，“Liukaige” 写入:

>+1
>Nice to give it a shot.
>
>2018-02-01 11:14 GMT+08:00 ShaoFeng Shi :
>
>> +1 [binding]
>>
>> 2018-02-01 11:11 GMT+08:00 Zhixiong Chen :
>>
>> > +1
>> >
>> > On 01/02/2018, 10:37 AM, "Billy Liu"  wrote:
>> >
>> > Hi all,
>> >
>> > I'm starting this vote to migrate Apache Kylin repository from
>> git-wip
>> > to gitbox. Gitbox allows deeper integration with Github, enables
>> > committers to merge, close or edit pull request in Github directly.
>> >
>> > More features:
>> > - Easier for code review compared to the Review Board
>> > - JIRA linking, which will automatically link a PR with its
>> > corresponding JIRA
>> > - Leverage Github ecosystem, such as web hooks for PR monitor, Code
>> > Static Analytics, Coverage Report.
>> >
>> > For Kylin committers, you need to do link your Github account with
>> ASF
>> > account through https://gitbox.apache.org/
>> >
>> > [ ] +1, Migrate Kylin repository to gitbox
>> > [ ]  -1,  Keep the current git-wip no change
>> >
>> >
>> > Regards,
>> > Billy Liu
>> >
>> >
>> >
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
>-- 
>Best regards,
>
>Kaige Liu(刘凯歌)
>
>*"Do small things with great love." *