You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by lu...@apache.org on 2015/10/21 15:46:39 UTC
[2/3] incubator-kylin git commit: publish kylin meetup blog
publish kylin meetup blog
Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/fb972d17
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/fb972d17
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/fb972d17
Branch: refs/heads/1.x-staging
Commit: fb972d1734045df141290ce53e0ab99fe78f4fbd
Parents: f02563b
Author: Luke Han <lu...@apache.org>
Authored: Wed Oct 21 21:40:08 2015 +0800
Committer: Luke Han <lu...@apache.org>
Committed: Wed Oct 21 21:40:08 2015 +0800
----------------------------------------------------------------------
website/_docs/gettingstarted/faq.md | 32 +++++++++++++++++++-
.../blog/2015-10-14-Apache-Kylin-Meetup.md | 22 ++++++--------
2 files changed, 41 insertions(+), 13 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fb972d17/website/_docs/gettingstarted/faq.md
----------------------------------------------------------------------
diff --git a/website/_docs/gettingstarted/faq.md b/website/_docs/gettingstarted/faq.md
index dae206a..b4697e8 100644
--- a/website/_docs/gettingstarted/faq.md
+++ b/website/_docs/gettingstarted/faq.md
@@ -55,4 +55,34 @@ Kylin web's security is implemented with Spring security framework, where the ky
${KYLIN_HOME}/tomcat/webapps/kylin/WEB-INF/classes/kylinSecurity.xml
{% endhighlight %}
The password hash for pre-defined test users can be found in the profile "sandbox,testing" part; To change the default password, you need generate a new hash and then update it here, please refer to the code snippet in: [https://stackoverflow.com/questions/25844419/spring-bcryptpasswordencoder-generate-different-password-for-same-input](https://stackoverflow.com/questions/25844419/spring-bcryptpasswordencoder-generate-different-password-for-same-input)
-When you deploy Kylin for more users, switch to LDAP authentication is recommended; To enable LDAP authentication, update "kylin.sandbox" in conf/kylin.properties to false, and also configure the ldap.* properties in ${KYLIN_HOME}/conf/kylin.properties
\ No newline at end of file
+When you deploy Kylin for more users, switch to LDAP authentication is recommended; To enable LDAP authentication, update "kylin.sandbox" in conf/kylin.properties to false, and also configure the ldap.* properties in ${KYLIN_HOME}/conf/kylin.properties
+
+#### Using sub-query for un-supported SQL
+
+`` Original SQL:
+select fact.slr_sgmt,
+sum(case when cal.RTL_WEEK_BEG_DT = '2015-09-06' then gmv else 0 end) as W36,
+sum(case when cal.RTL_WEEK_BEG_DT = '2015-08-30' then gmv else 0 end) as W35
+from ih_daily_fact fact
+inner join dw_cal_dt cal on fact.cal_dt = cal.cal_dt
+group by fact.slr_sgmt
+``
+
+``Using sub-query
+select a.slr_sgmt,
+sum(case when a.RTL_WEEK_BEG_DT = '2015-09-06' then gmv else 0 end) as W36,
+sum(case when a.RTL_WEEK_BEG_DT = '2015-08-30' then gmv else 0 end) as W35
+from (
+ select fact.slr_sgmt as slr_sgmt,
+ cal.RTL_WEEK_BEG_DT as RTL_WEEK_BEG_DT,
+ sum(gmv) as gmv36,
+ sum(gmv) as gmv35
+ from ih_daily_fact fact
+ inner join dw_cal_dt cal on fact.cal_dt = cal.cal_dt
+ group by fact.slr_sgmt, cal.RTL_WEEK_BEG_DT
+) a
+group by a.slr_sgmt
+``
+
+
+
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fb972d17/website/_posts/blog/2015-10-14-Apache-Kylin-Meetup.md
----------------------------------------------------------------------
diff --git a/website/_posts/blog/2015-10-14-Apache-Kylin-Meetup.md b/website/_posts/blog/2015-10-14-Apache-Kylin-Meetup.md
index 59ef967..12d46d6 100644
--- a/website/_posts/blog/2015-10-14-Apache-Kylin-Meetup.md
+++ b/website/_posts/blog/2015-10-14-Apache-Kylin-Meetup.md
@@ -1,6 +1,6 @@
---
layout: post-blog
-title: "The successful hosting of Apache Kylin Meetup@Shanghai"
+title: Apache Kylin Meetup @Shanghai Oct 10, 2015
date: 2015-10-14 17:00:00
author: Luke Han
categories: blog
@@ -10,44 +10,44 @@ categories: blog
-Oct.10th, 2015, Apache Kylin Meetup was successfully held in German Centre, Shanghai. It was the first Kylin offline meetup held in Shanghai (the third time worldwide, the first in Silicon Valley, the second in Beijing). Mr. Chad Chun, Director of eBay ADI CCOE made a welcome speech to the meetup. After that, members of Kylin core development team, Kylin’s user in eBay, Apache Tez Committer, Apache Zeppelin Committer and Tech partner of MiningLAMP shared rich topics in turn, offering a technology feast of big data to more than 100 attendees.
+On Oct 10th, 2015, Apache Kylin Meetup was successfully held in German Centre, Shanghai. It was the first Kylin meetup held in Shanghai (the third time worldwide, the first in Silicon Valley, the second in Beijing). Mr. Chad Chun, Director of eBay ADI CCOE made a welcome speech to the meetup. After that, members of Kylin core development team, Kylin’s users in eBay, Apache Tez Committer, Apache Zeppelin Committer and technology partner of MiningLAMP shared rich topics in turn, offering a technology feast of big data to more than 100 attendees.
{:.center}
## 1. Apache Kylin Tech Deep Dive - Streaming and Plugin Architecture
--Yang Li, eBay ADI Sr. Architect, Kylin Tech Leader, introduced the detail design and implementation of Plugin architecture, Streaming Cubing, Fast Cubing, TopN, etc. in Kylin 2 which will be released this year. Some new coming features were also mentioned.
+-Yang Li, Sr. Architect eBay ADI, Apache Kylin Tech Leader, PMC member, introduced the detail design and implementation of Plugin architecture, Streaming Cubing, Fast Cubing, TopN, etc. in Kylin2 which will be released this year. Some new coming features were also mentioned.
{:.center}
## 2. How Kylin help eCG to analysis Google Analytics Data
--Naiqin Wu, eBay Classifieds Group Sr. PM, described the difficulties and challenges encountered during the use of Google Analytics by eCG. Then she introduced how to download and organize Google Analytics Data into eBay internal Hadoop Cluster and then build analysis tools for business analysts using Kylin. She also showed the comparison of performance between Kylin and Google BigQuery.
+-Naiqin Wu, Sr. PM of eBay Classifieds Group, described the difficulties and challenges encountered during the use of Google Analytics by eCG. Then she introduced how to download and organize Google Analytics Data into eBay internal Hadoop Cluster and then build analysis tools for business analysts using Kylin.
{:.center}
## 3. Apache Tez - Next Gen Execute Engine on Hadoop
--Jeff Zhang, Hortonworks Sr. Engineer, Apache Tez committer, introduced the detail architecture and design of Apache Tez, comparison between Tez and MapReduce, community development and roadmap etc.
+-Jeff Zhang, Sr. Engineer of Hortonworks, Apache Tez committer, introduced the detail architecture and design of Apache Tez, comparison between Tez and MapReduce, community development and roadmap etc.
{:.center}
-## 4. Building data products with Apache Zeppelin
--Alexander Bezzubov, NFLabs Sr. Engineer from Korea, Apache Zeppelin committer & PMC member, presented the method of how to leverage Zeppelin to build data product based on github open source. In the end he introduced Zeppelin’s Apache Kylin Intepreter.
+## 4. Building Data Products with Apache Zeppelin
+-Alexander Bezzubov, Sr. Engineer NFLabs (from Korea), Apache Zeppelin committer & PMC member, presented the method of how to leverage Zeppelin to build data product based on github open source. In the end he introduced Zeppelin’s Apache Kylin Intepreter.
{:.center}
-## 5. Kylin use case from finance
--Hua Huang, Tech partner of MiningLAMP, Apache Kylin committer, showed the result of the MiningLAMP’s recent research over big data, especially from finance field. He then introduced how MiningLAMP offer big data analysis product to its customers using Kylin. The product has been deployed and launched among its finance customers, supporting report and OLAP analysis capability based on more than 100 Kylin Cubes and dozens of TBs’ data.
+## 5. Kylin Use Case from Finance
+-Hua Huang, technology partner of MiningLAMP, Apache Kylin committer, showed the result of the MiningLAMP’s recent research over big data, especially from finance field. He then introduced how MiningLAMP offer big data analysis product to its customers using Kylin. The product has been deployed and launched among its finance customers, supporting report and OLAP analysis capability based on more than 100 Kylin Cubes and dozens of TBs’ data.
{:.center}
## 6. Apache Kylin Roadmap and open source community
--Luke Han, eBay ADI Product Lead, Apache Kylin Lead, introduced the development history of Apache Kylin and the future Roadmap, especially the upcoming release of StreamingOLAP and the correlated properties and release plan of RealtimeOLAP. The condition of community development since Kylin became open source was also referred, including newly added Committers (from eBay, Meituan, MiningLAMP), version release etc. Luke made a special mention that Apache Kylin has finished its first round voting, which means it is about to graduate from Apache Incubator and promoted as Apache top-level project.
+-Luke Han, Lead Product Manager of eBay ADI, Apache Kylin Product Lead, PMC member, introduced the development history of Apache Kylin and the future Roadmap, especially the upcoming release of StreamingOLAP and the correlated properties and release plan. The condition of community development since Kylin became open source was also referred, including newly added Committers (from eBay, Meituan, MiningLAMP), version release etc. Luke made a special mention that Apache Kylin has finished its first round voting, which means it is about to graduate from Apache Incubator and promoted as Apache top-level project soon.
{:.center}
@@ -56,5 +56,3 @@ Finally, thanks the staffs from eBay and girls from Fudan University ;-)
{:.center}
-
-**Related PPT will be released next week after organize, please focus ApacheKylin’s Wechat public account for news.**
\ No newline at end of file