Re: kylin query question
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.
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
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
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
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
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)