Author: lidong Date: Tue May 8 14:04:11 2018 New Revision: 1831188 URL: http://svn.apache.org/viewvc?rev=1831188&view=rev Log: add redash-kylin plugin from strikingly
Added: kylin/site/blog/2018/05/ kylin/site/blog/2018/05/08/ kylin/site/blog/2018/05/08/redash-kylin-plugin-strikingly/ kylin/site/blog/2018/05/08/redash-kylin-plugin-strikingly/index.html kylin/site/images/blog/redash/ kylin/site/images/blog/redash/redash_1.jpeg (with props) kylin/site/images/blog/redash/redash_2.jpeg (with props) kylin/site/images/blog/redash/redash_3.jpeg (with props) kylin/site/images/blog/redash/redash_4.jpeg (with props) Modified: kylin/site/blog/index.html kylin/site/feed.xml Added: kylin/site/blog/2018/05/08/redash-kylin-plugin-strikingly/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/2018/05/08/redash-kylin-plugin-strikingly/index.html?rev=1831188&view=auto ============================================================================== --- kylin/site/blog/2018/05/08/redash-kylin-plugin-strikingly/index.html (added) +++ kylin/site/blog/2018/05/08/redash-kylin-plugin-strikingly/index.html Tue May 8 14:04:11 2018 @@ -0,0 +1,303 @@ +<!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> +<!doctype html> +<html> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<head> + <meta charset="utf-8"> + <meta http-equiv="X-UA-Compatible" content="IE=edge"> + <meta name="viewport" content="width=device-width, initial-scale=1"> + + <title>Apache Kylin | Redash-Kylin plugin from Strikingly</title> + <meta name="description" content="At strikingly, we are using Apache Kylin as our OLAP engine. Kylin is very powerful and it supports our big data business well. Weâve chosen Apache Kylin bec..."> + <meta name="author" content="Apache Kylin"> + <link rel="shortcut icon" href="fav.png" type="image/png"> + + + +<link rel="stylesheet" href="/assets/css/animate.css"> +<!-- Bootstrap --> +<link rel="stylesheet" href="/assets/css/bootstrap.min.css"> + +<!-- Fonts --> +<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> --> + +<!-- Icons --> +<link rel="stylesheet" href="/assets/css/font-awesome.min.css"> + + <!-- Custom styles --> + <link rel="stylesheet" href="/assets/css/styles.css"> + <link rel="stylesheet" href="/assets/css/docs.css"> + <link rel="stylesheet" href="/assets/css/pygments.css"> + + <link rel="canonical" href="http://kylin.apache.org/blog/2018/05/08/redash-kylin-plugin-strikingly/"> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml" /> + +<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]--> +<script> + (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ + (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), + m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) + })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); + + //oringal tracker for kylin.io + ga('create', 'UA-55534813-1', 'auto'); + //new tracker for kylin.apache.org + ga('create', 'UA-55534813-2', 'auto', {'name':'toplevel'}); + + ga('send', 'pageview'); + ga('toplevel.send', 'pageview'); + + +</script> +<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script> +<script type="text/javascript" src="/assets/js/nside.js"></script> </script> +<script type="text/javascript" src="/assets/js/nnav.js"></script> </script> +</head> + + <body> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<header id="header" > + + <div id="head" class="parallax" parallax-speed="3" > + <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="/assets/images/kylin_logo.jpg"> <span class="title" >Apache Kylinâ¢</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> + </div> + <div class="text-center" style=" + position: relative; + top: 66px; + width: 1080px; + margin: 0 auto; + z-index: 11; + margin-top: -253px; + text-align: right;" + > + <a href="http://apache.org/foundation/contributing.html" title="Support Apache" style="margin-left: 150px;"> + <img src="https://www.apache.org/images/SupportApache-small.png" style="height: 150px; width: 150px;"> + </a> + </div> + </div> + + + <!-- Main Menu --> + <nav class="navbar navbar-default" role="navigation" id="nav-wrapper"> + <div class="container-fluid" id="nav"> + <!-- + <img class="img-circle" width="40px" height="40px" id="circlelogo" src="/assets/images/kylin_logo.jpg"> + --> + <!-- Brand and toggle get grouped for better mobile display --> + <div class="navbar-header"> + <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"> + <span class="sr-only">Toggle navigation</span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + </button> + + </div> + + <!-- Collect the nav links, forms, and other content for toggling --> + <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"> + <ul class="nav navbar-nav"> + <li><a href="/">Home</a></li> + <li><a href="/docs23" >Docs</a></li> + <li><a href="/download">Download</li> + <li><a href="/community" >Community</a></li> + <li><a href="/development" >Development</a></li> + <li><a href="/blog">Blog</li> + <li><a href="/cn" >ä¸æç</a></li> + <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li> + <li><a href="https://github.com/apache/kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li> + <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li> + </ul> + </div><!-- /.navbar-collapse --> + </div><!-- /.container-fluid --> +</nav> + </header> + + <div class="page-content"> + <header style=" padding:2em 0 0 0"> + <div class="container" > + <h4 class="section-title"><span>Apache Kylin⢠Technical Blog</span></h4> + </div> + </div> + + <div class="container"> + <div> + <article class="post-content" > + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<div class="post" style=" padding:2em 4em 4em 4em"> + + <header class="post-header"> + <h1 class="post-title">Redash-Kylin plugin from Strikingly</h1> + <p class="post-meta" >May 8, 2018 ⢠Chase Zhang</p> + </header> + + <article class="post-content" > + <p>At strikingly, we are using Apache Kylin as our OLAP engine. Kylin is very powerful and it supports our big data business well. Weâve chosen Apache Kylin because it fits our demand: it handles a huge amount of data, undertakes multiple concurrent queries and has sub-second response time.</p> + +<p>Although we are mainly using Kylin to provide service to our customers, weâve decided to reuse the built result for internal purposes too. Kylin supports Business Intelligence tools like Apache Zeppelin and Tableau. With these BI tools we can provide insight and visualization about our data which will help making business decisions.</p> + +<p>Other than those BI tools mentioned above, weâre using another similar application named Redash because:</p> + +<ol> + <li> + <p>Weâve already had a deployment of redash for data analyzing upon traditional databases like PostgreSQL, etc</p> + </li> + <li> + <p>Redash is open source and easy to deploy, rich in visualization functions and has good integrations with other productivity tools we are using (like Slack).</p> + </li> +</ol> + +<p>Unfortunately, redash doesnât officially support Kylin as a data source for now. Thus we wrote a simple one to include it. The plugin has already been open sourced under BSD-2 license as a <a href="https://github.com/strikingly/redash-kylin">GitHub repository</a>.</p> + +<p>The redash-kylin plugin is just a single piece of python file which implements redashâs data source protocol. To install, retrieve the <code class="highlighter-rouge">kylin.py</code> file inside <code class="highlighter-rouge">redash/query_runner</code> folder of the pluginâs repository and place it under corresponding folder of redash.</p> + +<p><img src="/images/blog/redash/redash_1.jpeg" alt="" /></p> + +<p>Before you can use the plugin, you need to enable it first. Please modify the default enabled plugin list defined in <code class="highlighter-rouge">redash/settings.py</code>:</p> + +<p><img src="/images/blog/redash/redash_2.jpeg" alt="" /></p> + +<p>At last you have to rebuild the docker image (if you are using docker deployment) of redash and restart both server and worker of it. Currently, the redash-kylin plugin only supports the current stable version of redash (3.0.0) and 2.x version of Apache Kylin.</p> + +<p>Once installed successfully, youâll be able to find a KylinAPI data source type at the New Data Source page. To use it, just select that source type and fill in required fields. The redash-kylin plugin works by calling Kylinâs HTTP RESTful API, thus you should make sure your redash deployment has an access to your Kylin cluster (either job mode or query mode).</p> + +<p><img src="/images/blog/redash/redash_3.jpeg" alt="" /></p> + +<p>After a data source is setup and the connection is tested ok. You should be able to view schemas, run queries and make visualizations from tables in Kylin. Just type the SQL query in and get the result out. For more details about redashâs usage, please refer to <a href="https://redash.io/help/">redashâs documentation</a>.</p> + +<p><img src="/images/blog/redash/redash_4.jpeg" alt="" /></p> + +<p>You can also add multiple data sources by setting different project names or different API URLs. Itâs worth to mention that redash has an experiment function which supports making a query from former cached query results. Thus, once query results from different Kylin cluster has been imported, youâll be able to join them together for richer data processing.</p> + +<p>Wish you have a good time with Redash-Kylin!</p> + + </article> + +</div> + + + + + + </article> + </div> + </div> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<footer id="underfooter"> + <div class="container"> + <div class="row"> + <div class="col-md-12 widget"> + <div class="widget-body" style="text-align:center"> + <a href="http://www.apache.org"> + <img id="asf-logo" alt="Apache Software Foundation" src="/assets/images/feather-small.gif"> + </a> + + <div> + The contents of this website are © 2015 Apache Software Foundation under the terms of the <a + href="http://www.apache.org/licenses/LICENSE-2.0"> Apache License v2 </a>. Apache Kylin and + its logo are trademarks of the Apache Software Foundation. + </div> + + </div> + </div> + </div> + <!-- /row of widgets --> + + </div> + <div></div> + +</footer> + + <script src="/assets/js/jquery-1.9.1.min.js"></script> + <script src="/assets/js/bootstrap.min.js"></script> + <script src="/assets/js/main.js"></script> + </body> +</html> + + + + Modified: kylin/site/blog/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/index.html?rev=1831188&r1=1831187&r2=1831188&view=diff ============================================================================== --- kylin/site/blog/index.html (original) +++ kylin/site/blog/index.html Tue May 8 14:04:11 2018 @@ -187,6 +187,12 @@ <li> <h2 align="left" style="margin:0px"> + <a class="post-link" href="/blog/2018/05/08/redash-kylin-plugin-strikingly/">Redash-Kylin plugin from Strikingly</a></h2><div align="left" class="post-meta">posted: May 8, 2018</div> + + </li> + + <li> + <h2 align="left" style="margin:0px"> <a class="post-link" href="/blog/2018/03/04/release-v2.3.0/">Apache Kylin v2.3.0 Release Announcement</a></h2><div align="left" class="post-meta">posted: Mar 4, 2018</div> </li> @@ -331,13 +337,13 @@ <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/cn/blog/2016/03/17/release-v1.5.0/">Apache Kylin v1.5.0 æ£å¼åå¸</a></h2><div align="left" class="post-meta">posted: Mar 17, 2016</div> + <a class="post-link" href="/blog/2016/03/17/release-v1.5.0/">Apache Kylin v1.5.0 Release Announcement</a></h2><div align="left" class="post-meta">posted: Mar 17, 2016</div> </li> <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/blog/2016/03/17/release-v1.5.0/">Apache Kylin v1.5.0 Release Announcement</a></h2><div align="left" class="post-meta">posted: Mar 17, 2016</div> + <a class="post-link" href="/cn/blog/2016/03/17/release-v1.5.0/">Apache Kylin v1.5.0 æ£å¼åå¸</a></h2><div align="left" class="post-meta">posted: Mar 17, 2016</div> </li> @@ -367,37 +373,37 @@ <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/cn/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylinå¢å 对Tableau 9å微软Excel, Power BIçæ¯æ</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div> + <a class="post-link" href="/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylin supports Tableau 9 and MS Excel, Power BI now</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div> </li> <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylin supports Tableau 9 and MS Excel, Power BI now</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div> + <a class="post-link" href="/cn/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylinå¢å 对Tableau 9å微软Excel, Power BIçæ¯æ</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div> </li> <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/cn/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 æ£å¼åå¸</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div> + <a class="post-link" href="/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 Release Announcement</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div> </li> <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 Release Announcement</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div> + <a class="post-link" href="/cn/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 æ£å¼åå¸</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div> </li> <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/cn/blog/2015/10/25/release-v1.1-incubating/">Apache Kylin v1.1 (incubating) æ£å¼åå¸</a></h2><div align="left" class="post-meta">posted: Oct 25, 2015</div> + <a class="post-link" href="/blog/2015/10/25/release-v1.1-incubating/">Apache Kylin v1.1 (incubating) Release Announcement</a></h2><div align="left" class="post-meta">posted: Oct 25, 2015</div> </li> <li> <h2 align="left" style="margin:0px"> - <a class="post-link" href="/blog/2015/10/25/release-v1.1-incubating/">Apache Kylin v1.1 (incubating) Release Announcement</a></h2><div align="left" class="post-meta">posted: Oct 25, 2015</div> + <a class="post-link" href="/cn/blog/2015/10/25/release-v1.1-incubating/">Apache Kylin v1.1 (incubating) æ£å¼åå¸</a></h2><div align="left" class="post-meta">posted: Oct 25, 2015</div> </li> Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1831188&r1=1831187&r2=1831188&view=diff ============================================================================== --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Tue May 8 14:04:11 2018 @@ -19,11 +19,61 @@ <description>Apache Kylin Home</description> <link>http://kylin.apache.org/</link> <atom:link href="http://kylin.apache.org/feed.xml" rel="self" type="application/rss+xml"/> - <pubDate>Sun, 22 Apr 2018 06:59:09 -0700</pubDate> - <lastBuildDate>Sun, 22 Apr 2018 06:59:09 -0700</lastBuildDate> + <pubDate>Tue, 08 May 2018 06:59:30 -0700</pubDate> + <lastBuildDate>Tue, 08 May 2018 06:59:30 -0700</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item> + <title>Redash-Kylin plugin from Strikingly</title> + <description><p>At strikingly, we are using Apache Kylin as our OLAP engine. Kylin is very powerful and it supports our big data business well. Weâve chosen Apache Kylin because it fits our demand: it handles a huge amount of data, undertakes multiple concurrent queries and has sub-second response time.</p> + +<p>Although we are mainly using Kylin to provide service to our customers, weâve decided to reuse the built result for internal purposes too. Kylin supports Business Intelligence tools like Apache Zeppelin and Tableau. With these BI tools we can provide insight and visualization about our data which will help making business decisions.</p> + +<p>Other than those BI tools mentioned above, weâre using another similar application named Redash because:</p> + +<ol> + <li> + <p>Weâve already had a deployment of redash for data analyzing upon traditional databases like PostgreSQL, etc</p> + </li> + <li> + <p>Redash is open source and easy to deploy, rich in visualization functions and has good integrations with other productivity tools we are using (like Slack).</p> + </li> +</ol> + +<p>Unfortunately, redash doesnât officially support Kylin as a data source for now. Thus we wrote a simple one to include it. The plugin has already been open sourced under BSD-2 license as a <a href="https://github.com/strikingly/redash-kylin">GitHub repository</a>.</p> + +<p>The redash-kylin plugin is just a single piece of python file which implements redashâs data source protocol. To install, retrieve the <code class="highlighter-rouge">kylin.py</code> file inside <code class="highlighter-rouge">redash/query_runner</code> folder of the pluginâs repository and place it under corresponding folder of redash.</p> + +<p><img src="/images/blog/redash/redash_1.jpeg" alt="" /></p> + +<p>Before you can use the plugin, you need to enable it first. Please modify the default enabled plugin list defined in <code class="highlighter-rouge">redash/settings.py</code>:</p> + +<p><img src="/images/blog/redash/redash_2.jpeg" alt="" /></p> + +<p>At last you have to rebuild the docker image (if you are using docker deployment) of redash and restart both server and worker of it. Currently, the redash-kylin plugin only supports the current stable version of redash (3.0.0) and 2.x version of Apache Kylin.</p> + +<p>Once installed successfully, youâll be able to find a KylinAPI data source type at the New Data Source page. To use it, just select that source type and fill in required fields. The redash-kylin plugin works by calling Kylinâs HTTP RESTful API, thus you should make sure your redash deployment has an access to your Kylin cluster (either job mode or query mode).</p> + +<p><img src="/images/blog/redash/redash_3.jpeg" alt="" /></p> + +<p>After a data source is setup and the connection is tested ok. You should be able to view schemas, run queries and make visualizations from tables in Kylin. Just type the SQL query in and get the result out. For more details about redashâs usage, please refer to <a href="https://redash.io/help/">redashâs documentation</a>.</p> + +<p><img src="/images/blog/redash/redash_4.jpeg" alt="" /></p> + +<p>You can also add multiple data sources by setting different project names or different API URLs. Itâs worth to mention that redash has an experiment function which supports making a query from former cached query results. Thus, once query results from different Kylin cluster has been imported, youâll be able to join them together for richer data processing.</p> + +<p>Wish you have a good time with Redash-Kylin!</p> +</description> + <pubDate>Tue, 08 May 2018 13:00:00 -0700</pubDate> + <link>http://kylin.apache.org/blog/2018/05/08/redash-kylin-plugin-strikingly/</link> + <guid isPermaLink="true">http://kylin.apache.org/blog/2018/05/08/redash-kylin-plugin-strikingly/</guid> + + + <category>blog</category> + + </item> + + <item> <title>Apache Kylin v2.3.0 Release Announcement</title> <description><p>The Apache Kylin community is pleased to announce the release of Apache Kylin v2.3.0.</p> @@ -537,54 +587,54 @@ kylin.engine.spark.rdd-partition-cut-mb= </item> <item> - <title>Apache Kylin v2.0.0 Beta Announcement</title> - <description><p>The Apache Kylin community is pleased to announce the <a href="http://kylin.apache.org/download/">v2.0.0 beta package</a> is ready for download and test.</p> + <title>Apache Kylin v2.0.0 beta åå¸</title> + <description><p>Apache Kylin社åºé常é«å ´å°å®£å¸ <a href="http://kylin.apache.org/cn/download/">v2.0.0 beta package</a> å·²ç»å¯ä»¥ä¸è½½å¹¶æµè¯äºã</p> <ul> - <li>Download link: <a href="http://kylin.apache.org/download/">http://kylin.apache.org/download/</a></li> - <li>Source code: https://github.com/apache/kylin/tree/kylin-2.0.0-beta</li> + <li>ä¸è½½é¾æ¥: <a href="http://kylin.apache.org/cn/download/">http://kylin.apache.org/cn/download/</a></li> + <li>æºä»£ç : https://github.com/apache/kylin/tree/kylin-2.0.0-beta</li> </ul> -<p>It has been more than 2 month since the v1.6.0 release. The community has been working hard to deliver some long wanted features, hoping to move Apache Kylin to the next level.</p> +<p>èªä»v1.6.0çæ¬åå¸å·²ç»2个å¤æäºãè¿æ®µæ¶é´éï¼æ´ä¸ªç¤¾åºååå¼åå®æäºä¸ç³»åé大çåè½ï¼å¸æè½å°Apache Kylinæåå°ä¸ä¸ªæ°çé«åº¦ã</p> <ul> - <li>Support snowflake data model (<a href="https://issues.apache.org/jira/browse/KYLIN-1875">KYLIN-1875</a>)</li> - <li>Support TPC-H queries (<a href="https://issues.apache.org/jira/browse/KYLIN-2467">KYLIN-2467</a>)</li> - <li>Spark cubing engine (<a href="https://issues.apache.org/jira/browse/KYLIN-2331">KYLIN-2331</a>)</li> - <li>Job engine HA (<a href="https://issues.apache.org/jira/browse/KYLIN-2006">KYLIN-2006</a>)</li> - <li>Percentile measure (<a href="https://issues.apache.org/jira/browse/KYLIN-2396">KYLIN-2396</a>)</li> - <li>Cloud tested (<a href="https://issues.apache.org/jira/browse/KYLIN-2351">KYLIN-2351</a>)</li> + <li>æ¯æéªè±æ¨¡å (<a href="https://issues.apache.org/jira/browse/KYLIN-1875">KYLIN-1875</a>)</li> + <li>æ¯æ TPC-H æ¥è¯¢ (<a href="https://issues.apache.org/jira/browse/KYLIN-2467">KYLIN-2467</a>)</li> + <li>Spark æ建å¼æ (<a href="https://issues.apache.org/jira/browse/KYLIN-2331">KYLIN-2331</a>)</li> + <li>Job Engine é«å¯ç¨æ§ (<a href="https://issues.apache.org/jira/browse/KYLIN-2006">KYLIN-2006</a>)</li> + <li>Percentile 度é (<a href="https://issues.apache.org/jira/browse/KYLIN-2396">KYLIN-2396</a>)</li> + <li>å¨ Cloud ä¸éè¿æµè¯ (<a href="https://issues.apache.org/jira/browse/KYLIN-2351">KYLIN-2351</a>)</li> </ul> -<p>You are very welcome to give the v2.0.0 beta a try, and please do send feedbacks to <a href="&#109;&#097;&#105;&#108;&#116;&#111;:&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;">&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;</a>.</p> +<p>é常欢è¿å¤§å®¶ä¸è½½å¹¶æµè¯ v2.0.0 betaãæ¨çåé¦å¯¹æ们é常éè¦ï¼è¯·åé®ä»¶å° <a href="&#109;&#097;&#105;&#108;&#116;&#111;:&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;">&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;</a>ã</p> <hr /> -<h2 id="install">Install</h2> +<h2 id="section">å®è£ </h2> -<p>The v2.0.0 beta requires a refresh install at the moment. It cannot be upgraded from v1.6.0 due to the incompatible metadata. However the underlying cube is backward compatible. We are working on an upgrade tool to transform the metadata, so that a smooth upgrade will be possible.</p> +<p>ææ¶ v2.0.0 beta æ æ³ä» v1.6.0 ç´æ¥å级ï¼å¿ éå ¨æ°å®è£ ãè¿æ¯ç±äºæ°çæ¬çå æ°æ®å¹¶ä¸ååå ¼å®¹ãå¥½å¨ Cube æ°æ®æ¯ååå ¼å®¹çï¼å æ¤åªéè¦å¼åä¸ä¸ªå æ°æ®è½¬æ¢å·¥å ·ï¼å°±è½å¨ä¸ä¹ çå°æ¥å®ç°å¹³æ»å级ãæ们æ£å¨ä¸ºæ¤åªåã</p> <hr /> -<h2 id="run-tpc-h-benchmark">Run TPC-H Benchmark</h2> +<h2 id="tpc-h-">è¿è¡ TPC-H åºåæµè¯</h2> -<p>Steps to run TPC-H benchmark on Apache Kylin can be found here: <a href="https://github.com/Kyligence/kylin-tpch">https://github.com/Kyligence/kylin-tpch</a></p> +<p>å¨ Apache Kylin ä¸è¿è¡ TPC-H çå ·ä½æ¥éª¤: <a href="https://github.com/Kyligence/kylin-tpch">https://github.com/Kyligence/kylin-tpch</a></p> <hr /> -<h2 id="spark-cubing-engine">Spark Cubing Engine</h2> +<h2 id="spark-">Spark æ建å¼æ</h2> -<p>Apache Kylin v2.0.0 introduced a new cubing engine based on Apache Spark that can be selected to replace the original MR engine. Initial tests showed that the spark engine could cut the build time to 50% in most cases.</p> +<p>Apache Kylin v2.0.0 å¼å ¥äºä¸ä¸ªå ¨æ°çåºäº Apache Spark çæ建å¼æãå®å¯ç¨äºæ¿æ¢åæç MapReduce æ建å¼æãåæ¥æµè¯æ¾ç¤º Cube çæ建æ¶é´ä¸è¬è½ç¼©çå°åå ç 50% å·¦å³ã</p> -<p>To enable the Spark cubing engine, check <a href="/docs16/tutorial/cube_spark.html">this tutorial</a>.</p> +<p>å¯ç¨ Spark æ建å¼æï¼è¯·åè<a href="/docs16/tutorial/cube_spark.html">è¿ç¯ææ¡£</a>.</p> <hr /> -<p><em>Great thanks to everyone who contributed!</em></p> +<p><em>æè°¢æ¯ä¸ä½æåçåä¸åè´¡ç®!</em></p> </description> <pubDate>Sat, 25 Feb 2017 12:00:00 -0800</pubDate> - <link>http://kylin.apache.org/blog/2017/02/25/v2.0.0-beta-ready/</link> - <guid isPermaLink="true">http://kylin.apache.org/blog/2017/02/25/v2.0.0-beta-ready/</guid> + <link>http://kylin.apache.org/cn/blog/2017/02/25/v2.0.0-beta-ready/</link> + <guid isPermaLink="true">http://kylin.apache.org/cn/blog/2017/02/25/v2.0.0-beta-ready/</guid> <category>blog</category> @@ -592,54 +642,54 @@ kylin.engine.spark.rdd-partition-cut-mb= </item> <item> - <title>Apache Kylin v2.0.0 beta åå¸</title> - <description><p>Apache Kylin社åºé常é«å ´å°å®£å¸ <a href="http://kylin.apache.org/cn/download/">v2.0.0 beta package</a> å·²ç»å¯ä»¥ä¸è½½å¹¶æµè¯äºã</p> + <title>Apache Kylin v2.0.0 Beta Announcement</title> + <description><p>The Apache Kylin community is pleased to announce the <a href="http://kylin.apache.org/download/">v2.0.0 beta package</a> is ready for download and test.</p> <ul> - <li>ä¸è½½é¾æ¥: <a href="http://kylin.apache.org/cn/download/">http://kylin.apache.org/cn/download/</a></li> - <li>æºä»£ç : https://github.com/apache/kylin/tree/kylin-2.0.0-beta</li> + <li>Download link: <a href="http://kylin.apache.org/download/">http://kylin.apache.org/download/</a></li> + <li>Source code: https://github.com/apache/kylin/tree/kylin-2.0.0-beta</li> </ul> -<p>èªä»v1.6.0çæ¬åå¸å·²ç»2个å¤æäºãè¿æ®µæ¶é´éï¼æ´ä¸ªç¤¾åºååå¼åå®æäºä¸ç³»åé大çåè½ï¼å¸æè½å°Apache Kylinæåå°ä¸ä¸ªæ°çé«åº¦ã</p> +<p>It has been more than 2 month since the v1.6.0 release. The community has been working hard to deliver some long wanted features, hoping to move Apache Kylin to the next level.</p> <ul> - <li>æ¯æéªè±æ¨¡å (<a href="https://issues.apache.org/jira/browse/KYLIN-1875">KYLIN-1875</a>)</li> - <li>æ¯æ TPC-H æ¥è¯¢ (<a href="https://issues.apache.org/jira/browse/KYLIN-2467">KYLIN-2467</a>)</li> - <li>Spark æ建å¼æ (<a href="https://issues.apache.org/jira/browse/KYLIN-2331">KYLIN-2331</a>)</li> - <li>Job Engine é«å¯ç¨æ§ (<a href="https://issues.apache.org/jira/browse/KYLIN-2006">KYLIN-2006</a>)</li> - <li>Percentile 度é (<a href="https://issues.apache.org/jira/browse/KYLIN-2396">KYLIN-2396</a>)</li> - <li>å¨ Cloud ä¸éè¿æµè¯ (<a href="https://issues.apache.org/jira/browse/KYLIN-2351">KYLIN-2351</a>)</li> + <li>Support snowflake data model (<a href="https://issues.apache.org/jira/browse/KYLIN-1875">KYLIN-1875</a>)</li> + <li>Support TPC-H queries (<a href="https://issues.apache.org/jira/browse/KYLIN-2467">KYLIN-2467</a>)</li> + <li>Spark cubing engine (<a href="https://issues.apache.org/jira/browse/KYLIN-2331">KYLIN-2331</a>)</li> + <li>Job engine HA (<a href="https://issues.apache.org/jira/browse/KYLIN-2006">KYLIN-2006</a>)</li> + <li>Percentile measure (<a href="https://issues.apache.org/jira/browse/KYLIN-2396">KYLIN-2396</a>)</li> + <li>Cloud tested (<a href="https://issues.apache.org/jira/browse/KYLIN-2351">KYLIN-2351</a>)</li> </ul> -<p>é常欢è¿å¤§å®¶ä¸è½½å¹¶æµè¯ v2.0.0 betaãæ¨çåé¦å¯¹æ们é常éè¦ï¼è¯·åé®ä»¶å° <a href="&#109;&#097;&#105;&#108;&#116;&#111;:&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;">&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;</a>ã</p> +<p>You are very welcome to give the v2.0.0 beta a try, and please do send feedbacks to <a href="&#109;&#097;&#105;&#108;&#116;&#111;:&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;">&#100;&#101;&#118;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;</a>.</p> <hr /> -<h2 id="section">å®è£ </h2> +<h2 id="install">Install</h2> -<p>ææ¶ v2.0.0 beta æ æ³ä» v1.6.0 ç´æ¥å级ï¼å¿ éå ¨æ°å®è£ ãè¿æ¯ç±äºæ°çæ¬çå æ°æ®å¹¶ä¸ååå ¼å®¹ãå¥½å¨ Cube æ°æ®æ¯ååå ¼å®¹çï¼å æ¤åªéè¦å¼åä¸ä¸ªå æ°æ®è½¬æ¢å·¥å ·ï¼å°±è½å¨ä¸ä¹ çå°æ¥å®ç°å¹³æ»å级ãæ们æ£å¨ä¸ºæ¤åªåã</p> +<p>The v2.0.0 beta requires a refresh install at the moment. It cannot be upgraded from v1.6.0 due to the incompatible metadata. However the underlying cube is backward compatible. We are working on an upgrade tool to transform the metadata, so that a smooth upgrade will be possible.</p> <hr /> -<h2 id="tpc-h-">è¿è¡ TPC-H åºåæµè¯</h2> +<h2 id="run-tpc-h-benchmark">Run TPC-H Benchmark</h2> -<p>å¨ Apache Kylin ä¸è¿è¡ TPC-H çå ·ä½æ¥éª¤: <a href="https://github.com/Kyligence/kylin-tpch">https://github.com/Kyligence/kylin-tpch</a></p> +<p>Steps to run TPC-H benchmark on Apache Kylin can be found here: <a href="https://github.com/Kyligence/kylin-tpch">https://github.com/Kyligence/kylin-tpch</a></p> <hr /> -<h2 id="spark-">Spark æ建å¼æ</h2> +<h2 id="spark-cubing-engine">Spark Cubing Engine</h2> -<p>Apache Kylin v2.0.0 å¼å ¥äºä¸ä¸ªå ¨æ°çåºäº Apache Spark çæ建å¼æãå®å¯ç¨äºæ¿æ¢åæç MapReduce æ建å¼æãåæ¥æµè¯æ¾ç¤º Cube çæ建æ¶é´ä¸è¬è½ç¼©çå°åå ç 50% å·¦å³ã</p> +<p>Apache Kylin v2.0.0 introduced a new cubing engine based on Apache Spark that can be selected to replace the original MR engine. Initial tests showed that the spark engine could cut the build time to 50% in most cases.</p> -<p>å¯ç¨ Spark æ建å¼æï¼è¯·åè<a href="/docs16/tutorial/cube_spark.html">è¿ç¯ææ¡£</a>.</p> +<p>To enable the Spark cubing engine, check <a href="/docs16/tutorial/cube_spark.html">this tutorial</a>.</p> <hr /> -<p><em>æè°¢æ¯ä¸ä½æåçåä¸åè´¡ç®!</em></p> +<p><em>Great thanks to everyone who contributed!</em></p> </description> <pubDate>Sat, 25 Feb 2017 12:00:00 -0800</pubDate> - <link>http://kylin.apache.org/cn/blog/2017/02/25/v2.0.0-beta-ready/</link> - <guid isPermaLink="true">http://kylin.apache.org/cn/blog/2017/02/25/v2.0.0-beta-ready/</guid> + <link>http://kylin.apache.org/blog/2017/02/25/v2.0.0-beta-ready/</link> + <guid isPermaLink="true">http://kylin.apache.org/blog/2017/02/25/v2.0.0-beta-ready/</guid> <category>blog</category> @@ -802,68 +852,6 @@ send mail to Apache Kylin dev mailing li <category>blog</category> - - </item> - - <item> - <title>Retention Or Conversion Rate Analyze in Apache Kylin</title> - <description><p>Since v.1.6.0</p> - -<h2 id="background">Background</h2> -<p>Retention or conversion rate is important in data analysis. In general, the value can be calculated based on the intersection of two data sets (uuid etc.), with some same dimensions (city, category, etc.) and one variety dimension (date etc.).<br /> -Apache Kylin has support retention calculation based on the Bitmap and UDAF intersect_count. This article introduced how to use this feature.</p> - -<h2 id="usage">Usage</h2> -<p>To use retention calculation in Apache Kylin, must meet requirements as below:<br /> -* Only one dimension can be variety<br /> -* The measure to be calculated have defined precisely count distinct measure</p> - -<p>The intersect_count usage is described below:</p> - -<div class="highlighter-rouge"><pre class="highlight"><code>intersect_count(columnToCount, columnToFilter, filterValueList) -`columnToCount` the columnt to cacluate and distinct count -`columnToFilter` the variety dimension -`filterValueList` the values of variety dimension, should be array -</code></pre> -</div> - -<p>Hereâs some examples:</p> - -<div class="highlighter-rouge"><pre class="highlight"><code>intersect_count(uuid, dt, array['20161014', '20161015']) -The precisely distinct count of uuids shows up both in 20161014 and 20161015 - -intersect_count(uuid, dt, array['20161014', '20161015', '20161016']) -The precisely distinct count of uuids shows up all in 20161014, 20161015 and 20161016 - -intersect_count(uuid, dt, array['20161014']) -The precisely distinct count of uuids shows up in 20161014, equivalent to `count(distinct uuid)` -</code></pre> -</div> - -<p>A complete sql statement example:</p> - -<div class="highlighter-rouge"><pre class="highlight"><code>select city, version, -intersect_count(uuid, dt, array['20161014']) as first_day, -intersect_count(uuid, dt, array['20161015']) as second_day, -intersect_count(uuid, dt, array['20161016']) as third_day, -intersect_count(uuid, dt, array['20161014', '20161015']) as retention_oneday, -intersect_count(uuid, dt, array['20161014', '20161015', '20161016']) as retention_twoday -from visit_log -where dt in ('2016104', '20161015', '20161016') -group by city, version -</code></pre> -</div> - -<h2 id="conclusions">Conclusions</h2> -<p>Based on Bitmap and UDAF intersect_count, we can do fast and convenient retention analyze on Apache Kylin. Compared with the traditional way, SQL in Apache Kylin can be much more simple and clearly, and more efficient.</p> - -</description> - <pubDate>Mon, 28 Nov 2016 05:30:00 -0800</pubDate> - <link>http://kylin.apache.org/blog/2016/11/28/intersect-count/</link> - <guid isPermaLink="true">http://kylin.apache.org/blog/2016/11/28/intersect-count/</guid> - - - <category>blog</category> </item> Added: kylin/site/images/blog/redash/redash_1.jpeg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/redash/redash_1.jpeg?rev=1831188&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/redash/redash_1.jpeg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: kylin/site/images/blog/redash/redash_2.jpeg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/redash/redash_2.jpeg?rev=1831188&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/redash/redash_2.jpeg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: kylin/site/images/blog/redash/redash_3.jpeg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/redash/redash_3.jpeg?rev=1831188&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/redash/redash_3.jpeg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: kylin/site/images/blog/redash/redash_4.jpeg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/redash/redash_4.jpeg?rev=1831188&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/redash/redash_4.jpeg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream