Re: kylin query question

2019-11-19 Thread ShaoFeng Shi
hello hongxi,

After sending an email to dev-subscription, you should have received a
response email asking you to confirm. Just reply that email will finish the
subscription.

For your question, Kylin build the source data to OLAP cube, which only has
aggregated data, no detail data. So if you run a "select * from" query,
actually Kylin couldn't answer; As a workaround, Kylin uses the most-fine
granularity aggregation data answered the query, and for the measure, it
just uses null to represent. If you run an aggregation query (with group
by), it will work as expected.

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




li.hon...@coscoshipping.com  于2019年11月20日周三
下午1:17写道:

> Dear,
>When I query a Joined Fact table,its subtable's fields  shows
> null.I search more website,and don't solve.
> Please help!
>
> Cube output in Kylin:
>
> Subtable's Output in Hive:
>
>
>
> Thanks!
>
> --
> 此致
>
>
> 敬礼
>
> Best regards
>
>
> --
>
> 中远海运科技(北京)有限公司
> COSCO SHIPPING TECHNOLOGY (BEIJING)CO.,LTD
> 李红喜
> 北京市东城区朝阳门北大街8号富华大厦F座15A室 100027
> 北京市朝阳区八里庄北里220号中远物流大厦6层
> 电话:010-51568101
> Email:li.hon...@coscoshipping.com
>


S3 as kylin storage.

2019-11-19 Thread Tanmay Movva
Hello,

We have decided to use kylin to build our data warehouse and are going to
setup kylin on a cluster soon. We would like to know if S3 can be used as a
storage for apache kylin instead of Hbase as both are key-value stores and
query directly on S3.

>From what I understand I can only use hbase.storage_mode = s3 but not S3 as
a direct storage for kylin cubes. Please help me out here, Thanks.

-- 
Regards,
Tanmay Krishna Movva
Razorpay


kylin query question

2019-11-19 Thread li.hon...@coscoshipping.com
Dear,
   When I query a Joined Fact table,its subtable's fields  shows null.I 
search more website,and don't solve.
Please help!

Cube output in Kylin:

Subtable's Output in Hive:



Thanks!



此致


敬礼

Best regards





中远海运科技(北京)有限公司
COSCO SHIPPING TECHNOLOGY (BEIJING)CO.,LTD
李红喜
北京市东城区朝阳门北大街8号富华大厦F座15A室 100027
北京市朝阳区八里庄北里220号中远物流大厦6层 
电话:010-51568101
Email:li.hon...@coscoshipping.com


Re: New committer: Temple Zhou

2019-11-19 Thread Zhixiong Chen
Congratulations!

> On 16 Nov 2019, at 1:56 PM, ShaoFeng Shi  wrote:
> 
> Hi folks,
> 
> The Project Management Committee (PMC) for Apache Kylin
> has invited Temple Zhou to become a committer and we are pleased to
> announce that he has accepted.
> 
> Temple Zhou (周天鹏, email dba...@gmail.com) is one of the big data engineers
> from DXY.cn (丁香园); He maintained the Kylin cluster with more than 1000
> tableau reports for DXY since early of 2018. He gave many valuable
> feedbacks and enhancements to Kylin. Congratulations, Temple!
> 
> Let's warmly welcome Temple as the Kylin committer!
> 
> 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: New committer: Temple Zhou

2019-11-19 Thread JiaTao Tao
Congratulations


-- 

Regards!

Aron Tao

ShaoFeng Shi  于2019年11月16日周六 下午1:57写道:

> Hi folks,
>
> The Project Management Committee (PMC) for Apache Kylin
> has invited Temple Zhou to become a committer and we are pleased to
> announce that he has accepted.
>
> Temple Zhou (周天鹏, email dba...@gmail.com) is one of the big data engineers
> from DXY.cn (丁香园); He maintained the Kylin cluster with more than 1000
> tableau reports for DXY since early of 2018. He gave many valuable
> feedbacks and enhancements to Kylin. Congratulations, Temple!
>
> Let's warmly welcome Temple as the Kylin committer!
>
> 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-4264) Update Hadoop dependences from 2.X to 3.X

2019-11-19 Thread Xiaoyuan Gu (Jira)
Xiaoyuan Gu created KYLIN-4264:
--

 Summary: Update Hadoop dependences from 2.X to 3.X
 Key: KYLIN-4264
 URL: https://issues.apache.org/jira/browse/KYLIN-4264
 Project: Kylin
  Issue Type: Improvement
Reporter: Xiaoyuan Gu
 Fix For: Future






--
This message was sent by Atlassian Jira
(v8.3.4#803005)