Author: lukehan
Date: Fri Dec 25 16:35:37 2015
New Revision: 1721682
URL: http://svn.apache.org/viewvc?rev=1721682&view=rev
Log:
add blog
Added:
kylin/site/blog/2015/12/25/
kylin/site/blog/2015/12/25/support-powerbi-tableau9/
kylin/site/blog/2015/12/25/support-powerbi-tableau9/index.html
kylin/site/cn/blog/2015/12/25/
kylin/site/cn/blog/2015/12/25/support-powerbi-tableau9/
kylin/site/cn/blog/2015/12/25/support-powerbi-tableau9/index.html
Modified:
kylin/site/blog/index.html
kylin/site/cn/docs/tutorial/tableau_91.html
kylin/site/community/index.html
kylin/site/feed.xml
Added: kylin/site/blog/2015/12/25/support-powerbi-tableau9/index.html
URL:
http://svn.apache.org/viewvc/kylin/site/blog/2015/12/25/support-powerbi-tableau9/index.html?rev=1721682&view=auto
==============================================================================
--- kylin/site/blog/2015/12/25/support-powerbi-tableau9/index.html (added)
+++ kylin/site/blog/2015/12/25/support-powerbi-tableau9/index.html Fri Dec 25
16:35:37 2015
@@ -0,0 +1,272 @@
+<!--
+* 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 | Apache Kylin supports Tableau 9 and MS Excel, Power BI
now</title>
+ <meta name="description" content="Apache Kylin Community has rolled out an
updated ODBC Driver (v1.2), which enforced more support for Business
Intelligence clients, including Microsoft Excel...">
+ <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/2015/12/25/support-powerbi-tableau9/">
+ <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>
+
+
+ <!-- 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="/docs" >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">Apache Kylin supports Tableau 9 and MS Excel, Power
BI now</h1>
+ <p class="post-meta" >Dec 25, 2015 ⢠Luke Han</p>
+ </header>
+
+ <article class="post-content" >
+ <p>Apache Kylin Community has rolled out an updated ODBC Driver (v1.2),
which enforced more support for Business Intelligence clients, including
Microsoft Excel, Microsoft Power BI and Tableau 9. This update did bring more
convenience and selectivity for analysts and end users.</p>
+
+<h3 id="ms-excel-and-power-bi">MS Excel and Power BI</h3>
+<p>Microsoft Excel is one of the most famous data tool on Windows platform,
and has plenty of data analyzing functions. With Power Query installed as
plug-in, excel can easily read data from ODBC data source and fill
spreadsheets.</p>
+
+<p>Microsoft Power BI is a business intelligence tool providing rich
functionality and experience for data visualization and processing to user.</p>
+
+<h3 id="tableau-9">Tableau 9</h3>
+<p>Tableau is one of the most famous business intelligence software on Windows
platform. With simple operation and powerful functionality, users can easily
drag and drop to visualize data in large scale. Besides, Tableau supports
reading ODBC data sources, in a Live connection mode. In latest version 9.1,
user experience gets better improved very much.</p>
+
+<h3 id="support-from-kylin-community">Support from Kylin community</h3>
+<p>There are many requirements from eBay and other users who are using Kylin
today, especially from analysts who using these tools everyday. The slow query
performance of interactive with big data on Hadoop through other tool, like
Hive, brings big chellenge for them.<br />
+With sub-seconds query latency feature of Apache Kylin platform, analysts are
able to run interactive query agaisting billions rows data in seconds, with
these fancy reporting and visualization tools.</p>
+
+<h3 id="tutorial">Tutorial</h3>
+<p>Canât wait to try? Please refer to following tutorials: <br />
+* <a href="/docs/tutorial/powerbi.html">MS Excel and Power BI Tutorial</a> <br
/>
+* <a href="/docs/tutorial/tableau_91.html">Tableau 9 Tutorial</a></p>
+
+<p>Enjoy!</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=1721682&r1=1721681&r2=1721682&view=diff
==============================================================================
--- kylin/site/blog/index.html (original)
+++ kylin/site/blog/index.html Fri Dec 25 16:35:37 2015
@@ -174,6 +174,18 @@
<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>
+
+ </li>
+
+ <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>
+
+ </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>
</li>
Added: kylin/site/cn/blog/2015/12/25/support-powerbi-tableau9/index.html
URL:
http://svn.apache.org/viewvc/kylin/site/cn/blog/2015/12/25/support-powerbi-tableau9/index.html?rev=1721682&view=auto
==============================================================================
--- kylin/site/cn/blog/2015/12/25/support-powerbi-tableau9/index.html (added)
+++ kylin/site/cn/blog/2015/12/25/support-powerbi-tableau9/index.html Fri Dec
25 16:35:37 2015
@@ -0,0 +1,272 @@
+<!--
+* 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 | Apache Kylinå¢å 对Tableau 9å微软Excel, Power
BIçæ¯æ</title>
+ <meta name="description" content="Apache Kylinç¤¾åºæ´æ°äºææ°çODBC
Driver(v1.2)ï¼å®ç°äºä¸Tableau9.1ãMicrosoft ExcelãMicrosoft Power BI
ç常ç¨åä¸åæè½¯ä»¶çéæãè¿æ¬¡çæ´æ°ä¸ºå¹¿å¤§æ°æ®åæå·¥ä½è
带æ¥äºæ´å¤çéæ©">
+ <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/cn/blog/2015/12/25/support-powerbi-tableau9/">
+ <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>
+
+
+ <!-- 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="/docs" >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">Apache Kylinå¢å 对Tableau 9å微软Excel, Power
BIçæ¯æ</h1>
+ <p class="post-meta" >Dec 25, 2015 ⢠Luke Han</p>
+ </header>
+
+ <article class="post-content" >
+ <p>Apache Kylinç¤¾åºæ´æ°äºææ°çODBC
Driver(v1.2)ï¼å®ç°äºä¸Tableau9.1ãMicrosoft ExcelãMicrosoft Power BI
ç常ç¨åä¸åæè½¯ä»¶çéæãè¿æ¬¡çæ´æ°ä¸ºå¹¿å¤§æ°æ®åæå·¥ä½è
带æ¥äºæ´å¤çéæ©</p>
+
+<h3 id="excel--power-bi">微软Excel å Power BI</h3>
+<p>Microsoft
Excelæ¯å½ä»Windowså¹³å°ä¸ææµè¡çæ°æ®å¤ç软件ä¹ä¸ï¼æ¯æå¤ç§æ°æ®å¤çåè½ï¼å¯ä»¥å©ç¨Power
Queryä»ODBCæ°æ®æºè¯»åæ°æ®å¹¶è¿åå°æ°æ®è¡¨ä¸ã</p>
+
+<p>Microsoft Power BIæ¯ç±å¾®è½¯æ¨åºçå䏿ºè½çä¸ä¸åæå·¥å
·ï¼ç»ç¨æ·æä¾ç®åä¸ä¸°å¯çæ°æ®å¯è§åååæåè½ã</p>
+
+<h3 id="tableau-9">Tableau 9</h3>
+<p>Tableauæ¯Windowså¹³å°ä¸ææµè¡çå䏿ºè½å·¥å
·ä¹ä¸ï¼å®æä½ç®æ´ãåè½å¼ºå¤§ï¼éè¿ç®åå°ææ½å°±å¯ä»¥å°å¤§éæ°æ®ä½ç°å¨å¯è§åå¾è¡¨ä¸ï¼å¨ææ°ç9.1çæ¬ä¸ï¼ç¨æ·ä½éªå¾å°äºæ´è¿ä¸æ¥çæå</p>
+
+<h3 id="kylin">Kylinçæ¯æ</h3>
+<p>ä»eBayåå
¶ä»æ£å¨ä½¿ç¨Kylinçç¨æ·ä¸æå¾å¼ºççéæ±å¸ææ¯æè¿å 个工å
·ï¼ç¹å«æ¯æ¯å¤©ä½¿ç¨è¿äºå·¥å
·çåæå¸ä»¬ã å¨Hadoopä¸éè¿å
¶ä»å·¥å
·ï¼ä¾å¦Hiveï¼å¯¹å¤§æ°æ®è¿è¡äº¤äºå¼åæç»ä»ä»¬å¸¦æ¥äºå·¨å¤§çææãéè¿Apache
Kylinçäºç§çº§æ¥è¯¢å»¶è¿ç¹æ§ï¼åè¿äºæ¼äº®çæ¥è¡¨åå¯è§åå·¥å
·ä½¿å¾åæå¸è½å¤å¨å亿以ä¸è§æ¨¡æ°æ®ä¸è½å¤ä»¥ç§çº§å»¶è¿è¿è¡äº¤äºå¼åæã</p>
+
+<h3 id="section">æç¨</h3>
+<p>è¿«ä¸åå¾
çæ³è¯è¯? 请åè以䏿ç¨: <br />
+* <a href="ï¼cn/docs/tutorial/powerbi.html">微软ExcelåPower BIæç¨</a>
<br />
+* <a href="/cn/docs/tutorial/tableau_91.html">Tableau 9 æç¨</a></p>
+
+<p>Enjoy!</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/cn/docs/tutorial/tableau_91.html
URL:
http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/tableau_91.html?rev=1721682&r1=1721681&r2=1721682&view=diff
==============================================================================
--- kylin/site/cn/docs/tutorial/tableau_91.html (original)
+++ kylin/site/cn/docs/tutorial/tableau_91.html Fri Dec 25 16:35:37 2015
@@ -1057,7 +1057,7 @@
<div id="pjax">
<h1
class="post-title">Tableau 9 æç¨</h1>
<article
class="post-content" >
- <p>Tableau
9å·²ç»åå¸ä¸æ®µæ¶é´äºï¼ç¤¾åºæå¾å¤ç¨æ·å¸æApache
Kylinè½è¿ä¸æ¥æ¯æè¯¥çæ¬ãç°å¨ä½ å¯ä»¥éè¿æ´æ°Kylin
ODBC驱å¨ä»¥ä½¿ç¨Tableau 9æ¥ä¸Kylinæå¡è¿è¡äº¤äºã</p>
+ <p>Tableau
9å·²ç»åå¸ä¸æ®µæ¶é´äºï¼ç¤¾åºæå¾å¤ç¨æ·å¸æApache
Kylinè½è¿ä¸æ¥æ¯æè¯¥çæ¬ãç°å¨å¯ä»¥éè¿æ´æ°Kylin
ODBC驱å¨ä»¥ä½¿ç¨Tableau 9æ¥ä¸Kylinæå¡è¿è¡äº¤äºã</p>
<blockquote>
<p>Apache
Kylinç®åçæ¬ä¸æ¯æåå§æ°æ®çæ¥è¯¢ï¼é¨åæ¥è¯¢ä¼å
æ¤å¤±è´¥ï¼å¯¼è´åºç¨ç¨åºåçå¼å¸¸ï¼å»ºè®®æä¸KYLIN-1075è¡¥ä¸å
以ä¼åæ¥è¯¢ç»æçæ¾ç¤ºã</p>
Modified: kylin/site/community/index.html
URL:
http://svn.apache.org/viewvc/kylin/site/community/index.html?rev=1721682&r1=1721681&r2=1721682&view=diff
==============================================================================
--- kylin/site/community/index.html (original)
+++ kylin/site/community/index.html Fri Dec 25 16:35:37 2015
@@ -398,6 +398,7 @@
<ul>
<li>Thanks <a href="https://www.ebayinc.com/">eBay Inc.</a> to donated this
project to open source community, first announement at <a
href="http://www.ebaytechblog.com/2014/10/20/announcing-kylin-extreme-olap-engine-for-big-data/">eBay
Techblog</a>.</li>
<li>Thanks <a href="https://www.jetbrains.com/">JetBrains</a> for providing
us a free license of <a href="https://www.jetbrains.com/idea/">IntelliJ
IDEA</a>.</li>
+ <li>Thanks to <a href="[email protected]">Vikash Agarwal</a>, his
artical <strong><a
href="http://www.drdobbs.com/windows/odbc-driver-development/184416434?pgno=5">ODBC
Driver Development</a></strong> and sample code introdued the basic idea about
how to write an ODBC driver from scratch.</li>
</ul>
Modified: kylin/site/feed.xml
URL:
http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1721682&r1=1721681&r2=1721682&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Fri Dec 25 16:35:37 2015
@@ -19,11 +19,75 @@
<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>Fri, 25 Dec 2015 07:20:59 -0800</pubDate>
- <lastBuildDate>Fri, 25 Dec 2015 07:20:59 -0800</lastBuildDate>
+ <pubDate>Fri, 25 Dec 2015 08:34:08 -0800</pubDate>
+ <lastBuildDate>Fri, 25 Dec 2015 08:34:08 -0800</lastBuildDate>
<generator>Jekyll v2.5.3</generator>
<item>
+ <title>Apache Kylin supports Tableau 9 and MS Excel, Power BI
now</title>
+ <description><p>Apache Kylin Community has rolled out an updated
ODBC Driver (v1.2), which enforced more support for Business Intelligence
clients, including Microsoft Excel, Microsoft Power BI and Tableau 9. This
update did bring more convenience and selectivity for analysts and end
users.</p>
+
+<h3 id="ms-excel-and-power-bi">MS Excel and Power BI</h3>
+<p>Microsoft Excel is one of the most famous data tool on Windows
platform, and has plenty of data analyzing functions. With Power Query
installed as plug-in, excel can easily read data from ODBC data source and fill
spreadsheets.</p>
+
+<p>Microsoft Power BI is a business intelligence tool providing rich
functionality and experience for data visualization and processing to
user.</p>
+
+<h3 id="tableau-9">Tableau 9</h3>
+<p>Tableau is one of the most famous business intelligence software on
Windows platform. With simple operation and powerful functionality, users can
easily drag and drop to visualize data in large scale. Besides, Tableau
supports reading ODBC data sources, in a Live connection mode. In latest
version 9.1, user experience gets better improved very much.</p>
+
+<h3 id="support-from-kylin-community">Support from Kylin
community</h3>
+<p>There are many requirements from eBay and other users who are using
Kylin today, especially from analysts who using these tools everyday. The slow
query performance of interactive with big data on Hadoop through other tool,
like Hive, brings big chellenge for them.<br />
+With sub-seconds query latency feature of Apache Kylin platform, analysts are
able to run interactive query agaisting billions rows data in seconds, with
these fancy reporting and visualization tools.</p>
+
+<h3 id="tutorial">Tutorial</h3>
+<p>Canât wait to try? Please refer to following tutorials: <br
/>
+* <a href="/docs/tutorial/powerbi.html">MS Excel and Power BI
Tutorial</a> <br />
+* <a href="/docs/tutorial/tableau_91.html">Tableau 9
Tutorial</a></p>
+
+<p>Enjoy!</p>
+</description>
+ <pubDate>Fri, 25 Dec 2015 15:23:00 -0800</pubDate>
+
<link>http://kylin.apache.org/blog/2015/12/25/support-powerbi-tableau9/</link>
+ <guid
isPermaLink="true">http://kylin.apache.org/blog/2015/12/25/support-powerbi-tableau9/</guid>
+
+
+ <category>blog</category>
+
+ </item>
+
+ <item>
+ <title>Apache Kylinå¢å 对Tableau 9å微软Excel, Power
BIçæ¯æ</title>
+ <description><p>Apache Kylinç¤¾åºæ´æ°äºææ°çODBC
Driver(v1.2)ï¼å®ç°äºä¸Tableau9.1ãMicrosoft ExcelãMicrosoft Power BI
ç常ç¨åä¸åæè½¯ä»¶çéæãè¿æ¬¡çæ´æ°ä¸ºå¹¿å¤§æ°æ®åæå·¥ä½è
带æ¥äºæ´å¤çéæ©</p>
+
+<h3 id="excel--power-bi">微软Excel å Power BI</h3>
+<p>Microsoft
Excelæ¯å½ä»Windowså¹³å°ä¸ææµè¡çæ°æ®å¤ç软件ä¹ä¸ï¼æ¯æå¤ç§æ°æ®å¤çåè½ï¼å¯ä»¥å©ç¨Power
Queryä»ODBCæ°æ®æºè¯»åæ°æ®å¹¶è¿åå°æ°æ®è¡¨ä¸ã</p>
+
+<p>Microsoft Power
BIæ¯ç±å¾®è½¯æ¨åºçå䏿ºè½çä¸ä¸åæå·¥å
·ï¼ç»ç¨æ·æä¾ç®åä¸ä¸°å¯çæ°æ®å¯è§åååæåè½ã</p>
+
+<h3 id="tableau-9">Tableau 9</h3>
+<p>Tableauæ¯Windowså¹³å°ä¸ææµè¡çå䏿ºè½å·¥å
·ä¹ä¸ï¼å®æä½ç®æ´ãåè½å¼ºå¤§ï¼éè¿ç®åå°ææ½å°±å¯ä»¥å°å¤§éæ°æ®ä½ç°å¨å¯è§åå¾è¡¨ä¸ï¼å¨ææ°ç9.1çæ¬ä¸ï¼ç¨æ·ä½éªå¾å°äºæ´è¿ä¸æ¥çæå</p>
+
+<h3 id="kylin">Kylinçæ¯æ</h3>
+<p>ä»eBayåå
¶ä»æ£å¨ä½¿ç¨Kylinçç¨æ·ä¸æå¾å¼ºççéæ±å¸ææ¯æè¿å 个工å
·ï¼ç¹å«æ¯æ¯å¤©ä½¿ç¨è¿äºå·¥å
·çåæå¸ä»¬ã å¨Hadoopä¸éè¿å
¶ä»å·¥å
·ï¼ä¾å¦Hiveï¼å¯¹å¤§æ°æ®è¿è¡äº¤äºå¼åæç»ä»ä»¬å¸¦æ¥äºå·¨å¤§çææãéè¿Apache
Kylinçäºç§çº§æ¥è¯¢å»¶è¿ç¹æ§ï¼åè¿äºæ¼äº®çæ¥è¡¨åå¯è§åå·¥å
·ä½¿å¾åæå¸è½å¤å¨å亿以ä¸è§æ¨¡æ°æ®ä¸è½å¤ä»¥ç§çº§å»¶è¿è¿è¡äº¤äºå¼åæã</p>
+
+<h3 id="section">æç¨</h3>
+<p>è¿«ä¸åå¾
çæ³è¯è¯? 请åè以䏿ç¨: <br />
+* <a
href="ï¼cn/docs/tutorial/powerbi.html">微软ExcelåPower
BIæç¨</a> <br />
+* <a href="/cn/docs/tutorial/tableau_91.html">Tableau 9
æç¨</a></p>
+
+<p>Enjoy!</p>
+
+</description>
+ <pubDate>Fri, 25 Dec 2015 15:23:00 -0800</pubDate>
+
<link>http://kylin.apache.org/cn/blog/2015/12/25/support-powerbi-tableau9/</link>
+ <guid
isPermaLink="true">http://kylin.apache.org/cn/blog/2015/12/25/support-powerbi-tableau9/</guid>
+
+
+ <category>blog</category>
+
+ </item>
+
+ <item>
<title>Apache Kylin v1.2 Release Announcement</title>
<description><p>The Apache Kylin community is pleased to
announce the release of Apache Kylin v1.2, the first release after
graduation.</p>
@@ -146,66 +210,6 @@ send mail to Apache Kylin dev mailing li
</item>
<item>
- <title>Apache Kylin v1.1 (incubating) æ£å¼åå¸</title>
- <description><p>Apache Kylin社åºé常é«å
´å®£å¸Apache Kylin
v1.1 (incubating)æ£å¼åå¸.</p>
-
-<p>Apache
Kylinä¸ä¸ªå¼æºçåå¸å¼åæå¼æï¼æä¾Hadoopä¹ä¸çSQLæ¥è¯¢æ¥å£åå¤ç»´åæï¼OLAPï¼è½åä»¥æ¯æè¶
å¤§è§æ¨¡æ°æ®ï¼æåç±eBay Inc.
å¼åå¹¶è´¡ç®è³å¼æºç¤¾åºã</p>
-
-<p>ä¸è½½Apache Kylin v1.1 (incubating) æºä»£ç åäºè¿å¶å®è£
å
ï¼ <br />
-请访é®<a
href="http://kylin.apache.org/cn/download/">ä¸è½½</a>页é¢.</p>
-
-<p>è¿æ¯ä¸ä¸ªä¸»è¦ççæ¬åå¸å¸¦æ¥äºæ´ç¨³å®ï¼å¥å£®åæ´å¥½ç®¡çççæ¬ï¼Apache
Kylin社åºè§£å³äº56个issueï¼å
æ¬Bugä¿®å¤ï¼åè½å¢å¼ºåä¸äºæ°ç¹æ§çã</p>
-
-<h2 id="section">主è¦åå</h2>
-
-<p><strong>Kylin æ ¸å¿åè½å¢å¼º</strong></p>
-
-<ul>
- <li>æ¯æCubeæ°æ®ä¿çæ¶é´è®¾ç½® <a
href="https://issues.apache.org/jira/browse/KYLIN-906">KYLIN-906</a></li>
- <li>å级Apache Calciteè³1.4 <a
href="https://issues.apache.org/jira/browse/KYLIN-1047">KYLIN-1047</a></li>
- <li>å¨Cubeæå»ºæå忏
çHiveä¸é´æä»¶ <a
href="https://issues.apache.org/jira/browse/KYLIN-589">KYLIN-589</a></li>
- <li>å½Hiveè¿åç©ºå¼æ¶ç»§ç»Cubeæå»ºä»»å¡ <a
href="https://issues.apache.org/jira/browse/KYLIN-772">KYLIN-772</a></li>
- <li>æ¯æå¯é
ç½®HBaseåç¼©ç®æ³ï¼å
æ¬SnappyåGZip <a
href="https://issues.apache.org/jira/browse/KYLIN-956">KYLIN-956</a></li>
- <li>æ¯æå°Cubeæ°æ®å¯¼å
¥å°ç¬ç«çHBaseé群 <a
href="https://issues.apache.org/jira/browse/KYLIN-957">KYLIN-957</a></li>
- <li>å°Roaring bitmapså¼å
¥InvertedIndex模å <a
href="https://issues.apache.org/jira/browse/KYLIN-1034">KYLIN-1034</a></li>
-</ul>
-
-<p><strong>主è¦Bugä¿®å¤</strong></p>
-
-<ul>
- <li>彿å¤ä¸ªINæ¡ä»¶æ¶SQLæ§è¡ç¼æ
¢ <a
href="https://issues.apache.org/jira/browse/KYLIN-740">KYLIN-740</a></li>
- <li>Jobs页é¢å è½½Bug <a
href="https://issues.apache.org/jira/browse/KYLIN-950">KYLIN-950</a></li>
- <li>æ¥è¯¢ç¼å没æéå
æ°æ®æ´æ°èå·æ° <a
href="https://issues.apache.org/jira/browse/KYLIN-771">KYLIN-771</a></li>
- <li>å¨äºå®è¡¨ä¸æ§è¡âselect * from factâä¸å·¥ä½ <a
href="https://issues.apache.org/jira/browse/KYLIN-847">KYLIN-847</a></li>
- <li>SQLæ§è¡æ¶æ¥Float ä¸è½è½¬æ¢æä¸ºDoubleå¼å¸¸ <a
href="https://issues.apache.org/jira/browse/KYLIN-918">KYLIN-918</a></li>
- <li>æ´æ°Cubeæ°æ®æ¨¡å失败åå
æ°æ®ç¶æä¸ä¸è´ <a
href="https://issues.apache.org/jira/browse/KYLIN-958">KYLIN-958</a></li>
- <li>SQLä¸å
³é®åâoffsetâçBug <a
href="https://issues.apache.org/jira/browse/KYLIN-983">KYLIN-983</a></li>
- <li>å¹³åå¼å½æ°AVGä¸å·¥ä½ <a
href="https://issues.apache.org/jira/browse/KYLIN-985">KYLIN-985</a></li>
- <li>åå
¸ä¸ç©ºå¼ââ导è´Cubeå并失败 <a
href="https://issues.apache.org/jira/browse/KYLIN-1004">KYLIN-1004</a></li>
-</ul>
-
-<p><strong>å级</strong> <br />
-æä»¬å»ºè®®ä»v0.7.xåv1.0åçº§å°æ¤çæ¬å·²è·å¾æ´å¥½çæ§è½ï¼ç¨³å®æ§åBugä¿®å¤çã<br
/>
-å¹¶ä¸ä¸ç¤¾åºææ°ç¹æ§åæ¯æä¿æåæ¥ã</p>
-
-<p><strong>æ¯æ</strong> <br />
-å级å使ç¨è¿ç¨ä¸æä»»ä½é®é¢ï¼è¯·ï¼ <br />
-æäº¤è³KylinçJIRA: <a
href="https://issues.apache.org/jira/browse/KYLIN/">https://issues.apache.org/jira/browse/KYLIN/</a>
<br />
-æè
<br />
-åéé®ä»¶å°Apache Kyliné®ä»¶å表: <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><em>æè°¢åä½çè´¡ç®!</em></p>
-</description>
- <pubDate>Sun, 25 Oct 2015 10:28:00 -0700</pubDate>
-
<link>http://kylin.apache.org/cn/blog/2015/10/25/release-v1.1-incubating/</link>
- <guid
isPermaLink="true">http://kylin.apache.org/cn/blog/2015/10/25/release-v1.1-incubating/</guid>
-
-
- <category>blog</category>
-
- </item>
-
- <item>
<title>Apache Kylin v1.1 (incubating) Release Announcement</title>
<description><p>The Apache Kylin community is pleased to
announce the release of Apache Kylin v1.1 (incubating).</p>
@@ -266,6 +270,66 @@ send mail to Apache Kylin dev mailing li
</item>
<item>
+ <title>Apache Kylin v1.1 (incubating) æ£å¼åå¸</title>
+ <description><p>Apache Kylin社åºé常é«å
´å®£å¸Apache Kylin
v1.1 (incubating)æ£å¼åå¸.</p>
+
+<p>Apache
Kylinä¸ä¸ªå¼æºçåå¸å¼åæå¼æï¼æä¾Hadoopä¹ä¸çSQLæ¥è¯¢æ¥å£åå¤ç»´åæï¼OLAPï¼è½åä»¥æ¯æè¶
å¤§è§æ¨¡æ°æ®ï¼æåç±eBay Inc.
å¼åå¹¶è´¡ç®è³å¼æºç¤¾åºã</p>
+
+<p>ä¸è½½Apache Kylin v1.1 (incubating) æºä»£ç åäºè¿å¶å®è£
å
ï¼ <br />
+请访é®<a
href="http://kylin.apache.org/cn/download/">ä¸è½½</a>页é¢.</p>
+
+<p>è¿æ¯ä¸ä¸ªä¸»è¦ççæ¬åå¸å¸¦æ¥äºæ´ç¨³å®ï¼å¥å£®åæ´å¥½ç®¡çççæ¬ï¼Apache
Kylin社åºè§£å³äº56个issueï¼å
æ¬Bugä¿®å¤ï¼åè½å¢å¼ºåä¸äºæ°ç¹æ§çã</p>
+
+<h2 id="section">主è¦åå</h2>
+
+<p><strong>Kylin æ ¸å¿åè½å¢å¼º</strong></p>
+
+<ul>
+ <li>æ¯æCubeæ°æ®ä¿çæ¶é´è®¾ç½® <a
href="https://issues.apache.org/jira/browse/KYLIN-906">KYLIN-906</a></li>
+ <li>å级Apache Calciteè³1.4 <a
href="https://issues.apache.org/jira/browse/KYLIN-1047">KYLIN-1047</a></li>
+ <li>å¨Cubeæå»ºæå忏
çHiveä¸é´æä»¶ <a
href="https://issues.apache.org/jira/browse/KYLIN-589">KYLIN-589</a></li>
+ <li>å½Hiveè¿åç©ºå¼æ¶ç»§ç»Cubeæå»ºä»»å¡ <a
href="https://issues.apache.org/jira/browse/KYLIN-772">KYLIN-772</a></li>
+ <li>æ¯æå¯é
ç½®HBaseåç¼©ç®æ³ï¼å
æ¬SnappyåGZip <a
href="https://issues.apache.org/jira/browse/KYLIN-956">KYLIN-956</a></li>
+ <li>æ¯æå°Cubeæ°æ®å¯¼å
¥å°ç¬ç«çHBaseé群 <a
href="https://issues.apache.org/jira/browse/KYLIN-957">KYLIN-957</a></li>
+ <li>å°Roaring bitmapså¼å
¥InvertedIndex模å <a
href="https://issues.apache.org/jira/browse/KYLIN-1034">KYLIN-1034</a></li>
+</ul>
+
+<p><strong>主è¦Bugä¿®å¤</strong></p>
+
+<ul>
+ <li>彿å¤ä¸ªINæ¡ä»¶æ¶SQLæ§è¡ç¼æ
¢ <a
href="https://issues.apache.org/jira/browse/KYLIN-740">KYLIN-740</a></li>
+ <li>Jobs页é¢å è½½Bug <a
href="https://issues.apache.org/jira/browse/KYLIN-950">KYLIN-950</a></li>
+ <li>æ¥è¯¢ç¼å没æéå
æ°æ®æ´æ°èå·æ° <a
href="https://issues.apache.org/jira/browse/KYLIN-771">KYLIN-771</a></li>
+ <li>å¨äºå®è¡¨ä¸æ§è¡âselect * from factâä¸å·¥ä½ <a
href="https://issues.apache.org/jira/browse/KYLIN-847">KYLIN-847</a></li>
+ <li>SQLæ§è¡æ¶æ¥Float ä¸è½è½¬æ¢æä¸ºDoubleå¼å¸¸ <a
href="https://issues.apache.org/jira/browse/KYLIN-918">KYLIN-918</a></li>
+ <li>æ´æ°Cubeæ°æ®æ¨¡å失败åå
æ°æ®ç¶æä¸ä¸è´ <a
href="https://issues.apache.org/jira/browse/KYLIN-958">KYLIN-958</a></li>
+ <li>SQLä¸å
³é®åâoffsetâçBug <a
href="https://issues.apache.org/jira/browse/KYLIN-983">KYLIN-983</a></li>
+ <li>å¹³åå¼å½æ°AVGä¸å·¥ä½ <a
href="https://issues.apache.org/jira/browse/KYLIN-985">KYLIN-985</a></li>
+ <li>åå
¸ä¸ç©ºå¼ââ导è´Cubeå并失败 <a
href="https://issues.apache.org/jira/browse/KYLIN-1004">KYLIN-1004</a></li>
+</ul>
+
+<p><strong>å级</strong> <br />
+æä»¬å»ºè®®ä»v0.7.xåv1.0åçº§å°æ¤çæ¬å·²è·å¾æ´å¥½çæ§è½ï¼ç¨³å®æ§åBugä¿®å¤çã<br
/>
+å¹¶ä¸ä¸ç¤¾åºææ°ç¹æ§åæ¯æä¿æåæ¥ã</p>
+
+<p><strong>æ¯æ</strong> <br />
+å级å使ç¨è¿ç¨ä¸æä»»ä½é®é¢ï¼è¯·ï¼ <br />
+æäº¤è³KylinçJIRA: <a
href="https://issues.apache.org/jira/browse/KYLIN/">https://issues.apache.org/jira/browse/KYLIN/</a>
<br />
+æè
<br />
+åéé®ä»¶å°Apache Kyliné®ä»¶å表: <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><em>æè°¢åä½çè´¡ç®!</em></p>
+</description>
+ <pubDate>Sun, 25 Oct 2015 10:28:00 -0700</pubDate>
+
<link>http://kylin.apache.org/cn/blog/2015/10/25/release-v1.1-incubating/</link>
+ <guid
isPermaLink="true">http://kylin.apache.org/cn/blog/2015/10/25/release-v1.1-incubating/</guid>
+
+
+ <category>blog</category>
+
+ </item>
+
+ <item>
<title>Apache Kylin Meetup @Shanghai Oct 10, 2015</title>
<description><p class="center"><img
src="/images/blog/meetup_1.jpeg" alt="" /></p>
@@ -640,284 +704,6 @@ Any issue or question during upgrade, pl
<category>blog</category>
-
- </item>
-
- <item>
- <title>Fast Cubing Algorithm in Apache Kylin: Concept</title>
- <description><p>This article is the first post of a series
document that introducing the fast cubing algorithm in Apache Kylin; The new
algorithm will be released in the future release; Now it is under internal
testing and pilot; All the source code has been published in Kylinâs Git
repository <a
href="https://github.com/apache/kylin/">https://github.com/apache/kylin/</a>
on 0.8 branch.</p>
-
-<h2 id="by-layer-cubing-algorithm">By Layer Cubing
Algorithm</h2>
-<p>Before introduce the fast cubing, Iâd like to make a brief
introduction on the as-is cubing algorithm, which is called âby layer
cubingâ;</p>
-
-<p>As its name indicates, a full cube is calculated by layer:
N-dimension, N-1 dimension, N-2 dimension, ⦠until 0 dimension; Each
layerâs calculation is based on its parent layer (except the first, which
base on source data); So this algorithm need N rounds of MapReduce running in
sequence;</p>
-
-<p>In the MapReduce, the key is the composite of the dimensions, the
value is the composite of the measures; When the mapper reads a key-value pair,
it calculates its possible child cuboids; for each child cuboid, remove 1
dimension from the key, and then output the new key and value to the
reducer;</p>
-
-<p>The reducer gets the values grouped by key; it aggregates the
measures, and then output to HDFS; one layerâs MR is finished;</p>
-
-<p>When all layers are finished, the cube is calculated;</p>
-
-<p>Figure 1 describes the flow:</p>
-
-<p><img src="/images/blog/by-layer-cubing.png"
alt="" /><br />
-Figure 1: By layer cubing</p>
-
-<p><strong>Advantage</strong></p>
-
-<ul>
- <li>This algorithm is clear as it mostly leverage the capability of
Hadoop MapReduce; The sorting, grouping and shuffling are all taken care by
MapReduce, developer just focus on the cubing logic;</li>
- <li>Benefiting from Hadoopâs maturity, this algorithm is very
stable; In our experience there is seldom case that the mapper or reducer could
fail; Even if your Hadoop cluster is small or is busy, it can finish in the
end;</li>
-</ul>
-
-<p><strong>Disadvantage</strong></p>
-
-<ul>
- <li>If the cube has many dimensions, it need the same number of MR
jobs; As each Hadoop job scheduling need extra resource, the overhead cost to
Hadoop is considerable;</li>
- <li>This algorithm causes too much shuffling to Hadoop; The mapper
doesnât do aggregation, all the records that having same dimension values in
next layer will be omitted to Hadoop, and then aggregated by combiner and
reducer;</li>
- <li>Many reads/writes on HDFS: each layerâs cubing need write its
output to HDFS for next layer MR to consume; In the end, Kylin need another
round MR to convert these output files to HBase HFile for bulk load; These jobs
generates many intermediate files in HDFS;</li>
- <li>All in all: the performance is not good, especially when the cube
has many dimensions;</li>
-</ul>
-
-<h2 id="fast-cubing-algorithm">Fast Cubing Algorithm</h2>
-<p>The fast cubing algorithm is also called âby segment cubingâ; The
core idea is, each mapper calculates the feed data block into a small cube
segment (with all cuboids), and then output all key/values to reducer; The
reducer aggregates them into one big cube segment, finishing the cubing; Figure
2 illustrates the flow;</p>
-
-<p><img src="/images/blog/by-segment-cubing.png"
alt="" /><br />
-Figure 2: By segment cubing</p>
-
-<h3 id="pre-aggregation-in-mapper">Pre-aggregation in
Mapper</h3>
-<p>Compared with the origin algorithm, the fast cubing has two main
differences:</p>
-
-<ul>
- <li>The mapper will do pre-aggregation, this will reduce the number of
records that the mapper output to Hadoop, and also reduce the number that
reducer need to aggregate;</li>
- <li>One round MR can calculate all cuboids;</li>
-</ul>
-
-<p>Let take an example: a cube has 4 dimensions: A, B, C, D; Each mapper
has 1 million source records to process; The column cardinality in the mapper
is Car(A), Car(B), Car(C) and Car(D);</p>
-
-<ul>
- <li>
- <p>When aggregate the source records to base cuboid (1111), with the
old âby layerâ algorithm, the mapper will output 1 million records to
Hadoop; With the fast cubing algorithm, after the pre-aggregation, it only
outputs the number of [distinct A, B, C, D] records to Hadoop, which is
certainly smaller than source data; In a normal case, it can be 1/10 to 1/1000
of the source records size;</p>
- </li>
- <li>
- <p>When aggregate from parent to a child cuboid, say from base
cuboid (1111) to 3-dimension cuboid 0111, the dimension A will be aggregated;
We assume the dimension A is independent with other dimensions, after
aggregation, the cuboid 0111âs size will be about 1/Card(A) of the base
cuboid; So the output will be reduced to 1/Card(A) of the original one in this
step.</p>
- </li>
-</ul>
-
-<p>Totally, assume the average cardinality of the dimensions is Card(N),
the records that written from mapper to reducer can be reduced to 1/Card(N) of
origin size; The less output to Hadoop, the less I/O and computing, the better
performance.</p>
-
-<h3 id="cuboid-spanning-tree">Cuboid spanning tree</h3>
-<p>Inner the mapper, there is another change in the cuboid spanning tree
visiting order; In origin cubing, Kylin calculates the cuboids with Broad First
Search order; In the fast cubing, it uses Depth First Search order, to reduce
the cuboids that need be cached in memory.</p>
-
-<p>Letâs look at the figure 3, which is a full spanning tree of a
4-dimension cube: before 0-Dimenson cuboid â*â be aggregated, cuboid
âABCDâ, âBCDâ, âCDâ and âDâ will be cached in memory; As
â*â has no child, it will be outputted once be calculated, then comes
âDâ; After âCâ be outputted, âCDâ will be outputted as all of its
children has finished; The memory for a cuboid can be released once it be
outputted; The base cuboid ABCD will be the last one to output.</p>
-
-<p><img src="/images/blog/cube-spanning-tree.png"
alt="" /><br />
-Figure 3: Cuboid spanning tree</p>
-
-<p>With the DFS visiting order, the output from a mapper is fully sorted
(except some special cases), as the cuboid ID is at the beginning position of
row key, and inner a cuboid the rows are already sorted:</p>
-
-<div class="highlighter-rouge"><pre
class="highlight"><code>0000
-0001[D0]
-0001[D1]
-....
-0010[C0]
-0010[C1]
-....
-0011[C0][D0]
-0011[C0][D1]
-....
-....
-1111[A0][B0][C0][D0]
-....
-</code></pre>
-</div>
-<p>Since the outputs from mapper are already sorted, Hadoopâs sort
would be more efficient;</p>
-
-<p>Besides, mapperâs pre-aggregation happens in memory, this avoids
unnecessary disk and network I/O, and the overhead to Hadoop is
reduced;</p>
-
-<p>###OutOfMemory error<br />
-During the development phase, we encountered the OutOfMemory error in mappers;
this could happen when:</p>
-
-<div class="highlighter-rouge"><pre
class="highlight"><code>a) The mapper's JVM heap size is
small;
-b) "Distinct count" measure is used (HyperLogLog is space consuming)
-c) The spanning tree is too deep (too many dimensions);
-d) The data blog feed to a mapper is too big;
-</code></pre>
-</div>
-
-<p>We realized that Kylin couldnât assume the mappers always have
enough memory; The cubing algorithm need be self-adapting to various
situations; A lot of efforts were put on optimizing the memory use and spilling
data to disk when proactively detects an OutOfMemory error; The result is
promising, the OOM error is rare to occur now;</p>
-
-<p>Here letâs do a summary on the fast cubing algorithm;</p>
-
-<p><strong>Advantage</strong></p>
-
-<ul>
- <li>It is faster than the old method; can reduce 30% to 50% overall
building time from our comparison test;</li>
- <li>It produces less work load on Hadoop, and leaves less intermediate
files on HDFS;</li>
- <li>The cubing code can be easily reused by other cubing engines like
Streaming and Spark;</li>
-</ul>
-
-<p><strong>Disadvantage</strong></p>
-
-<ul>
- <li>The algorithm is a little complicated; This adds the maintenance
effort;</li>
- <li>Although the algorithm can spill data to disk automatically, it
still wish the mapper has enough memory to gain best performance; User need
more knowledge to tune the cubing; (this can be discussed in detail
later)</li>
-</ul>
-
-<h2 id="other-enhancements-in-fast-cubing">Other Enhancements
in Fast Cubing</h2>
-
-<p>Together with the fast cubing algorithm, we also introduced several
other enhancements in the cube build flow, like estimating the region splits by
sampling, directly outputting HFile, and merging Cube over HBase Table, etc;
Iâd like to elaborate in the next articles, please keep posted here; If you
have interest on Apache Kylin, welcome to visit our home page <a
href="http://kylin.apache.org/">http://kylin.apache.org/</a>
and subscribe our development mailing list at <a
href="&#109;&#097;&#105;&#108;&#116;&#111;:&#100;&#101;&#118;&#045;&#115;&#117;&#098;&#115;&#099;&#114;&#105;&#098;&#101;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;">&#100;&#101;&#118;&#045;&#115;&#117;&#098;&#115;&#099;&#114;
&#105;&#098;&#101;&#064;&#107;&#121;&#108;&#105;&#110;&#046;&#097;&#112;&#097;&#099;&#104;&#101;&#046;&#111;&#114;&#103;</a></p>
-</description>
- <pubDate>Sat, 15 Aug 2015 05:28:00 -0700</pubDate>
- <link>http://kylin.apache.org/blog/2015/08/15/fast-cubing/</link>
- <guid
isPermaLink="true">http://kylin.apache.org/blog/2015/08/15/fast-cubing/</guid>
-
-
- <category>blog</category>
-
- </item>
-
- <item>
- <title>Dictionary in Kylin</title>
- <description><h3 id="purpose-of-dictionary">Purpose of
Dictionary</h3>
-
-<p>Dictionary is a <a
href="https://en.wikipedia.org/wiki/Dictionary_coder">classic
compression technique</a> that can greatly reduce the size of data. Kylin
apply dictionary to all dimension values stored in cube.</p>
-
-<p>Kylinâs requirement to dictionary:</p>
-
-<ul>
- <li>Compress cube size by storing IDs instead of real values</li>
- <li>Bi-way mapping of dimension values from/to IDs</li>
- <li>Preserving order to facilitate range query</li>
- <li>Minimal memory &amp; storage footprint</li>
-</ul>
-
-<h3 id="dictionary-design">Dictionary Design</h3>
-
-<p>Dictionary is implemented as a <a
href="https://en.wikipedia.org/wiki/Trie">trie</a> data
structure. Dictionary ID (or âseq. noâ below) is chosen in a way to
preserve value order. Then at query time, predicate filters can be pushed down
to storage and be evaluated on the IDs.</p>
-
-<ul>
- <li>Trie node are labeled by 1) number of values underneath; 2) is end
of value or not</li>
- <li>Bi-way lookup between âvalueâ &lt;==&gt; âseq. noâ
by top-down navigate</li>
- <li>The âseq. noâ preserves value order and is a minimal integer
for space advantage</li>
- <li>O(L) lookup time, where L=max(value length)</li>
-</ul>
-
-<p>An example of a trie dictionary.</p>
-
-<p><img src="/images/develop/dictionary-trie-sample.png"
alt="" /></p>
-
-<h3 id="memory-structure">Memory structure</h3>
-
-<p>Once built, the dictionary is serialized into a chunk of bytes. This
is how it stays in memory and also in file.</p>
-
-<ul>
- <li>Head
- <ul>
- <li>magic, head len, body len, child_offset size, seq_no size,
base ID, max value len, bytes converter</li>
- </ul>
- </li>
- <li>Body
- <ul>
- <li>a flattened trie, where each node is
- <ul>
- <li>child offset (size specified in head)
- <ul>
- <li>1st MSB: isLastChild</li>
- <li>2nd MSB: isEndOfValue</li>
- </ul>
- </li>
- <li>no. values beneath (size specified in head)</li>
- <li>value len (1 byte unsigned)</li>
- <li>value bytes</li>
- </ul>
- </li>
- </ul>
- </li>
-</ul>
-
-<p><img src="/images/develop/dictionary-bytes-format.png"
alt="" /></p>
-
-<h3 id="benchmark-result">Benchmark result</h3>
-
-<p>We compared dictionaryâs size and performance with HashMap and ID
Based Array. Itâs memory footprint is an order less and the throughput is
very stable accross scales.</p>
-
-<table>
- <thead>
- <tr>
- <th>Â </th>
- <th>HashMap (value=&gt;id)</th>
- <th>Dictionary (value=&gt;id)</th>
- <th>IdArray (id=&gt;value)</th>
- <th>Dictionary (id=&gt;value)</th>
- <th>Â </th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>150K eng words footprint (bytes)</td>
- <td>18.8M</td>
- <td><em>1.7M</em></td>
- <td>11.1M</td>
- <td><em>1.7M</em></td>
- <td>1.4M raw size</td>
- </tr>
- <tr>
- <td>150K eng words throughput (acc/s)</td>
- <td>13M</td>
- <td>1.9M</td>
- <td>150M</td>
- <td>1.96M</td>
- <td>31 max value len</td>
- </tr>
- <tr>
- <td>6.6K categories footprint (bytes)</td>
- <td>0.94M</td>
- <td>0.13M</td>
- <td>0.58M</td>
- <td>0.12M</td>
- <td>0.1M raw size</td>
- </tr>
- <tr>
- <td>6.6K categories throughput (acc/s)</td>
- <td>26M</td>
- <td>2.0M</td>
- <td>98M</td>
- <td>2.0M</td>
- <td>30 max value len</td>
- </tr>
- <tr>
- <td>6 words footprint (bytes)</td>
- <td>792B</td>
- <td>168B</td>
- <td>416B</td>
- <td>168B</td>
- <td>33B raw size</td>
- </tr>
- <tr>
- <td>6 works throughput (acc/s)</td>
- <td>68.5M</td>
- <td>14.7M</td>
- <td>714M</td>
- <td>11.1M</td>
- <td>9 max value len</td>
- </tr>
- </tbody>
-</table>
-
-<h3 id="cache-layer">Cache layer</h3>
-
-<p>To achieve maximum lookup throughput, a cache layer (HashMap or
IdArray) sits on top of dictionary using weak reference. The cache could be
gone when memory runs short, then dictionary will be hit directly.</p>
-
-<p><img src="/images/develop/dictionary-cache-layer.png"
alt="" /></p>
-
-</description>
- <pubDate>Thu, 13 Aug 2015 07:37:00 -0700</pubDate>
- <link>http://kylin.apache.org/blog/2015/08/13/kylin-dictionary/</link>
- <guid
isPermaLink="true">http://kylin.apache.org/blog/2015/08/13/kylin-dictionary/</guid>
-
-
- <category>blog</category>
</item>