Re: Hive ORC tables and empty lookup tables in the cube

2019-06-04 Thread Xiaoxiang Yu
Hi Antsut,
  Sorry for my late reply. First let's make it clear, you have two cubes (let 
us call them cube1 and cube2), cube1 's lookup table is in ORC format and 
cube2's lookup table is in parquet format. Now you find that with the same sql 
query, result by cube1 is correct and result by cube2 is worry. 
  So, to eliminate cause from data source(external from Kylin), please enter 
the same sql query in Hive CLI, if you find the result from Kylin is different 
from what you see in Hive CLI, I guess it is a bug of Kylin. In that case, 
please report a JIRA in https://issues.apache.org/jira/projects/KYLIN, with 
some detail which help us to reproduce bug(version of Kylin you are using, 
version of Hive/Hadoop, DDL of lookup table, screenshot of query result from 
hive CLI and from Kylin).


Best wishes,
Xiaoxiang Yu 
 

在 2019/6/3 15:40,“Vadajer” 写入:

Hello Xiaoxiang Yu!

Thanks for reply!

1. I'm selecting in kylin insight gui from lookup table or from fact table
with join to lookup table. All values from lookup table are empty. 

 

2. I'm create in hive the same tables (name with prefix) with "STORED AS
PARQUET" and create another cube. 
(see attached pics)

 

WBR,
Vadym Antsut


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




Re: [ANNOUNCE] Gang Ma joins the Apache Kylin PMC

2019-06-04 Thread Liukaige
Congratulations Gang!

ShaoFeng Shi  于2019年6月3日周一 下午1:32写道:

> On behalf of the Apache Kylin PMC, I am pleased to announce that Gang Ma
> (马刚) has accepted our invitation to become a PMC member on the Apache Kylin
> project. We appreciate Gang stepping up to take more responsibility in the
> Kylin project.
>
> Please join me in welcoming Gang to the Kylin PMC!
>
> 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
>


-- 
Best regards,

Kaige Liu(刘凯歌)

*"Do small things with great love." *


Re: [ANNOUNCE] Gang Ma joins the Apache Kylin PMC

2019-06-04 Thread Xiaoxiang Yu
Thanks Gang Ma for his selfless help and encouragement in reviewing my code. I 
hope I can get more guidance from you in the future and make Kylin better. 
Congratulations!


Best wishes,
Xiaoxiang Yu 
 

在 2019/6/3 13:32,“ShaoFeng Shi” 写入:

On behalf of the Apache Kylin PMC, I am pleased to announce that Gang Ma
(马刚) has accepted our invitation to become a PMC member on the Apache Kylin
project. We appreciate Gang stepping up to take more responsibility in the
Kylin project.

Please join me in welcoming Gang to the Kylin PMC!

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




??????????: [Discussion]Does 'UNION ALL' support query on two fact table ?

2019-06-04 Thread ????
??


 
------
??: "yuzhang"
: 2019??3??22??(??) 11:20
??: "dev@kylin.apache.org";
: "dev@kylin.apache.org";
: ??: [Discussion]Does 'UNION ALL' support query on two fact table ?




Hi Na Zhai:
 thanks for you take time to reply. Yes, I test it and the query can hit 
two cube.


yuzhang
| |
yuzhang
|
|
shifengdefan...@163.com
|
??
??2019??3??21?? 22:44??Na Zhai ??
Hi, yuzhang.



There is one fact table in Cube A and one fact table in Cube B. I think ??union 
all?? supports query on these two fact tables.





?? Windows 10 ??




??: yuzhang 
: Tuesday, March 19, 2019 8:29:26 PM
??: dev@kylin.apache.org; u...@kylin.apache.org
: [Discussion]Does 'UNION ALL' support query on two fact table ?

Hi dear all:
Simple question as mail title desc.


Best regards
yuzhang


| |
yuzhang
|
|
shifengdefan...@163.com
|
??

Re: [ANNOUNCE] Gang Ma joins the Apache Kylin PMC

2019-06-04 Thread nichunen
Congrats!



Best regards,

 

Ni Chunen / George



On 06/5/2019 09:50,PENG Zhengshuai wrote:
Congratulations!

PENG Zhengshuai

On Jun 3, 2019, at 2:59 PM, Billy Liu  wrote:

Congrats, Gang.

With Warm regards

Billy Liu

ShaoFeng Shi  于2019年6月3日周一 下午1:32写道:

On behalf of the Apache Kylin PMC, I am pleased to announce that Gang Ma
(马刚) has accepted our invitation to become a PMC member on the Apache Kylin
project. We appreciate Gang stepping up to take more responsibility in the
Kylin project.

Please join me in welcoming Gang to the Kylin PMC!

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: [ANNOUNCE] Gang Ma joins the Apache Kylin PMC

2019-06-04 Thread PENG Zhengshuai
Congratulations!

PENG Zhengshuai

> On Jun 3, 2019, at 2:59 PM, Billy Liu  wrote:
> 
> Congrats, Gang.
> 
> With Warm regards
> 
> Billy Liu
> 
> ShaoFeng Shi  于2019年6月3日周一 下午1:32写道:
>> 
>> On behalf of the Apache Kylin PMC, I am pleased to announce that Gang Ma
>> (马刚) has accepted our invitation to become a PMC member on the Apache Kylin
>> project. We appreciate Gang stepping up to take more responsibility in the
>> Kylin project.
>> 
>> Please join me in welcoming Gang to the Kylin PMC!
>> 
>> 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



[jira] [Created] (KYLIN-4032) Add tools to show kylin instance which schedule the running job

2019-06-04 Thread Yuzhang QIU (JIRA)
Yuzhang QIU created KYLIN-4032:
--

 Summary: Add tools to show kylin instance which schedule the 
running job
 Key: KYLIN-4032
 URL: https://issues.apache.org/jira/browse/KYLIN-4032
 Project: Kylin
  Issue Type: Improvement
  Components: Job Engine
Affects Versions: v2.5.2
Reporter: Yuzhang QIU


Hi team:
 Sometime, the operator need to know the running/error job owner to trace 
the log file among the kylin cluster. A simple tool to show this may be helpful.
  

  Best regards

yuzhang




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)