Added: kylin/site/docs23/tutorial/web.html
URL: 
http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/web.html?rev=1822508&view=auto
==============================================================================
--- kylin/site/docs23/tutorial/web.html (added)
+++ kylin/site/docs23/tutorial/web.html Mon Jan 29 14:05:18 2018
@@ -0,0 +1,4285 @@
+<!--
+* 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 | Web Interface</title>
+  <meta name="description" content="Apache Kylin Home">
+  <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/docs23/tutorial/web.html";>
+  <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="/docs21" >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="container">
+                       <div class="row">
+                               <!--
+* 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="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" 
id="nside1" style=" padding-top: 2em">
+    <ul class="nav nav-pills nav-stacked">
+    
+    <li><a href="#titleGetting Started" data-toggle="collapse" 
id="navtitle">Getting Started</a></li>
+    <div class="collapse in">
+       <div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/index.html" class="list-group-item-lay pjaxlink" 
id="navlist">Overview</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/release_notes.html" class="list-group-item-lay 
pjaxlink" id="navlist">Release Notes</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+      <li><a href="/docs23/gettingstarted/concepts.html" 
class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li>   
   
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/gettingstarted/terminology.html" 
class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/gettingstarted/faq.html" class="list-group-item-lay 
pjaxlink" id="navlist">FAQ</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/gettingstarted/events.html" 
class="list-group-item-lay pjaxlink" id="navlist">Events and 
Conferences</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+      <li><a href="/docs23/gettingstarted/best_practices.html" 
class="list-group-item-lay pjaxlink" id="navlist">Community Best 
Practices</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#titleInstallation" data-toggle="collapse" 
id="navtitle">Installation</a></li>
+    <div class="collapse in">
+       <div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/install/index.html" class="list-group-item-lay 
pjaxlink" id="navlist">Installation Guide</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/install/hadoop_env.html" class="list-group-item-lay 
pjaxlink" id="navlist">Hadoop Environment</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/install/kylin_cluster.html" 
class="list-group-item-lay pjaxlink" id="navlist">Deploy in Cluster 
Mode</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/install/advance_settings.html" 
class="list-group-item-lay pjaxlink" id="navlist">Advanced Settings</a></li>    
  
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/install/kylin_docker.html" 
class="list-group-item-lay pjaxlink" id="navlist">Run Kylin with 
Docker</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/install/kylin_aws_emr.html" 
class="list-group-item-lay pjaxlink" id="navlist">Install Kylin on AWS 
EMR</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#titleTutorial" data-toggle="collapse" 
id="navtitle">Tutorial</a></li>
+    <div class="collapse in">
+       <div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/kylin_sample.html" 
class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample 
Cube</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/web.html" class="list-group-item-lay 
pjaxlink" id="navlist">Web Interface</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/create_cube.html" 
class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/cube_build_job.html" 
class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job 
Monitoring</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/acl.html" class="list-group-item-lay 
pjaxlink" id="navlist">Cube Permission (v2.1.x)</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/project_level_acl.html" 
class="list-group-item-lay pjaxlink" id="navlist">Project Level ACL</a></li>    
  
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/cube_spark.html" 
class="list-group-item-lay pjaxlink" id="navlist">Build Cube with 
Spark</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/cube_build_performance.html" 
class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</a></li>    
  
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#titleIntegration" data-toggle="collapse" 
id="navtitle">Integration</a></li>
+    <div class="collapse in">
+       <div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/odbc.html" class="list-group-item-lay 
pjaxlink" id="navlist">Kylin ODBC Driver</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/tableau.html" class="list-group-item-lay 
pjaxlink" id="navlist">Tableau 8</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/tableau_91.html" 
class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/powerbi.html" class="list-group-item-lay 
pjaxlink" id="navlist">MS Excel and Power BI</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/microstrategy.html" 
class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/squirrel.html" class="list-group-item-lay 
pjaxlink" id="navlist">SQuirreL</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/flink.html" class="list-group-item-lay 
pjaxlink" id="navlist">Apache Flink</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/hue.html" class="list-group-item-lay 
pjaxlink" id="navlist">Apache Hue</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/tutorial/Qlik.html" class="list-group-item-lay 
pjaxlink" id="navlist">Qlik Sense</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#titleHow To" data-toggle="collapse" id="navtitle">How 
To</a></li>
+    <div class="collapse in">
+       <div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_use_restapi.html" 
class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_build_cube_with_restapi.html" 
class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li>  
    
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_optimize_cubes.html" 
class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Design</a></li> 
     
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_optimize_build.html" 
class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Build</a></li>  
    
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_backup_metadata.html" 
class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_cleanup_storage.html" 
class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_jdbc.html" class="list-group-item-lay 
pjaxlink" id="navlist">Kylin JDBC Driver</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_upgrade.html" 
class="list-group-item-lay pjaxlink" id="navlist">Upgrade From Old 
Versions</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_ldap_and_sso.html" 
class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and 
SSO</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_use_beeline.html" 
class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> 
     
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_update_coprocessor.html" 
class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li>   
   
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_install_ranger_kylin_plugin.html" 
class="list-group-item-lay pjaxlink" id="navlist">The Ranger Kylin Plugin 
Installation Guide</a></li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_enable_zookeeper_acl.html" 
class="list-group-item-lay pjaxlink" id="navlist">Enable zookeeper acl</a></li> 
     
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_setup_systemcube.html" 
class="list-group-item-lay pjaxlink" id="navlist">Set Up System Cube</a></li>   
   
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_use_cube_planner.html" 
class="list-group-item-lay pjaxlink" id="navlist">Use Cube Planner</a></li>     
 
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/docs23/howto/howto_use_dashboard.html" 
class="list-group-item-lay pjaxlink" id="navlist">Use Dashboard</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+
+    </ul>
+</div>
+
+                               <div class="col-md-9 col-lg-9 col-xs-14 aside2">
+                                       <div id="container">
+                                               <div id="pjax">
+                                                       <h1 
class="post-title">Web Interface</h1>
+                                                       
+                                                       
+                                                       <article 
class="post-content" > 
+                                                       <blockquote>
+  <p><strong>Supported Browsers</strong><br />
+Windows: Google Chrome, FireFox<br />
+Mac: Google Chrome, FireFox, Safari</p>
+</blockquote>
+
+<h2 id="access--login">1. Access &amp; Login</h2>
+<p>Host to access: http://hostname:7070<br />
+Login with username/password: ADMIN/KYLIN</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/1 login.png" alt="" /></p>
+
+<h2 id="sync-hive-table-into-kylin">2. Sync Hive Table into Kylin</h2>
+<p>Although Kylin will using SQL as query interface and leverage Hive 
metadata, kylin will not enable user to query all hive tables since it’s a 
pre-build OLAP (MOLAP) system so far. To enable Table in Kylin, it will be easy 
to using “Sync” function to sync up tables from Hive.</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/2 tables.png" alt="" 
/></p>
+
+<h2 id="kylin-olap-cube">3. Kylin OLAP Cube</h2>
+<p>Kylin’s OLAP Cubes are pre-calculation datasets from star schema tables, 
Here’s the web interface for user to explorer, manage all cubes. Go to <code 
class="highlighter-rouge">Model</code> menu, it will list all cubes available 
in system:</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/3 cubes.png" alt="" /></p>
+
+<p>To explore more detail about the Cube</p>
+
+<ul>
+  <li>
+    <p>Form View:</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/4 form-view.png" 
alt="" /></p>
+  </li>
+  <li>
+    <p>SQL View (Hive Query to read data to generate the cube):</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/5 sql-view.png" 
alt="" /></p>
+  </li>
+  <li>
+    <p>Access (Grant user/role privileges, grant operation only open to 
Admin):</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/7 access.png" alt="" 
/></p>
+  </li>
+</ul>
+
+<h2 id="write-and-execute-sql-on-web">4. Write and Execute SQL on web</h2>
+<p>Kylin’s web offer a simple query tool for user to run SQL to explorer 
existing cube, verify result and explorer the result set using #5’s Pivot 
analysis and visualization</p>
+
+<blockquote>
+  <p><strong>Query Limit</strong></p>
+
+  <ol>
+    <li>
+      <p>Only SELECT query be supported</p>
+    </li>
+    <li>
+      <p>SQL will not be redirect to Hive</p>
+    </li>
+  </ol>
+</blockquote>
+
+<p>Go to “Insight” menu:</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/8 query.png" alt="" /></p>
+
+<ul>
+  <li>
+    <p>Source Tables:</p>
+
+    <p>Browser current available tables (same structure and metadata as 
Hive):</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/9 query-table.png" 
alt="" /></p>
+  </li>
+  <li>
+    <p>New Query:</p>
+
+    <p>You can write and execute your query and explorer the result.</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/10 query-result.png" 
alt="" /></p>
+  </li>
+  <li>
+    <p>Saved Query (only work after enable LDAP security):</p>
+
+    <p>Associate with user account, you can get saved query from different 
browsers even machines.<br />
+ Click “Save” in Result area, it will popup for name and description to 
save current query:</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/11 save-query.png" 
alt="" /></p>
+
+    <p>Click “Saved Queries” to browser all your saved queries, you could 
direct submit it or remove it.</p>
+  </li>
+  <li>
+    <p>Query History:</p>
+
+    <p>Only keep the current user’s query history in current bowser, it will 
require cookie enabled and will lost if you clean up bowser’s cache. Click 
“Query History” tab, you could directly resubmit any of them to execute 
again.</p>
+  </li>
+</ul>
+
+<h2 id="pivot-analysis-and-visualization">5. Pivot Analysis and 
Visualization</h2>
+<p>There’s one simple pivot and visualization analysis tool in Kylin’s web 
for user to explore their query result:</p>
+
+<ul>
+  <li>
+    <p>General Information:</p>
+
+    <p>When the query execute success, it will present a success indictor and 
also a cube’s name which be hit. <br />
+ Also it will present how long this query be executed in backend engine (not 
cover network traffic from Kylin server to browser):</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/12 general.png" 
alt="" /></p>
+  </li>
+  <li>
+    <p>Query Result:</p>
+
+    <p>It’s easy to order on one column.</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/13 results.png" 
alt="" /></p>
+  </li>
+  <li>
+    <p>Export to CSV File</p>
+
+    <p>Click “Export” button to save current result as CSV file.</p>
+  </li>
+  <li>
+    <p>Pivot Table:</p>
+
+    <p>Drag and drop one or more columns into the header, the result will 
grouping by such column’s value:</p>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/14 drag.png" alt="" 
/></p>
+  </li>
+  <li>
+    <p>Visualization:</p>
+
+    <p>Also, the result set will be easy to show with different charts in 
“Visualization”:</p>
+
+    <p>note: line chart only available when there’s at least one dimension 
with real “Date” data type of column from Hive Table.</p>
+
+    <ul>
+      <li>Bar Chart:</li>
+    </ul>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/15 bar-chart.png" 
alt="" /></p>
+
+    <ul>
+      <li>Pie Chart:</li>
+    </ul>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/16 pie-chart.png" 
alt="" /></p>
+
+    <ul>
+      <li>Line Chart</li>
+    </ul>
+
+    <p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/17 line-chart.png" 
alt="" /></p>
+  </li>
+</ul>
+
+
+                                                       </article>
+                                               </div>
+                                       </div>
+                               </div>
+                       </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/feed.xml
URL: 
http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1822508&r1=1822507&r2=1822508&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Mon Jan 29 14:05:18 2018
@@ -19,11 +19,280 @@
     <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, 26 Jan 2018 05:59:17 -0800</pubDate>
-    <lastBuildDate>Fri, 26 Jan 2018 05:59:17 -0800</lastBuildDate>
+    <pubDate>Mon, 29 Jan 2018 06:00:48 -0800</pubDate>
+    <lastBuildDate>Mon, 29 Jan 2018 06:00:48 -0800</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>
+        <title>Get Your Interactive Analytics Superpower, with Apache Kylin 
and Apache Superset</title>
+        <description>&lt;h2 id=&quot;challenge-of-big-data&quot;&gt;Challenge 
of Big Data&lt;/h2&gt;
+
+&lt;p&gt;In the big data era, all enterprises’ face the growing demand and 
challenge of processing large volumes of data—workloads that traditional 
legacy systems can no longer satisfy. With the emergence of Artificial 
Intelligence (AI) and Internet-of-Things (IoT) technology, it has become 
mission-critical for businesses to accelerate their pace of discovering 
valuable insights from their massive and ever-growing datasets. Thus, large 
companies are constantly searching for a solution, often turning to open source 
technologies.  We will introduce two open source technologies that, when 
combined together, can meet these pressing big data demands for large 
enterprises.&lt;/p&gt;
+
+&lt;h2 
id=&quot;apache-kylin-a-leading-opensource-olap-on-hadoop&quot;&gt;Apache 
Kylin: a Leading OpenSource OLAP-on-Hadoop&lt;/h2&gt;
+&lt;p&gt;Modern organizations have had a long history of applying Online 
Analytical Processing (OLAP) technology to analyze data and uncover business 
insights. These insights help businesses make informed decisions and improve 
their service and product. With the emergence of the Hadoop ecosystem, OLAP has 
also embraced new technologies in the big data era.&lt;/p&gt;
+
+&lt;p&gt;Apache Kylin is one such technology that directly addresses the 
challenge of conducting analytical workloads on massive datasets. It is already 
widely adopted by enterprises around the world. With powerful pre-calculation 
technology, Apache Kylin enables sub-second query latency over petabyte-scale 
datasets. The innovative and intricate design of Apache Kylin allows it to 
seamlessly consume data from any Hadoop-based data source, as well as other 
relational database management system (RDBMS). Analysts can use Apache Kylin 
using standard SQL through ODBC, JDBC, and Restful API, which enables the 
platform to integrate with any third-party applications.&lt;br /&gt;
+&lt;img src=&quot;/images/Kylin-and-Superset/png/1. kylin_diagram.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 1: Apache Kylin Architecture&lt;/p&gt;
+
+&lt;p&gt;In a fast-paced and rapidly-changing business environment, business 
users and analysts are expected to uncover insights with speed of thoughts. 
They can meet this expectation with Apache Kylin, and no longer subjected to 
the predicament of waiting for hours for one single query to return results. 
Such a powerful data processing engine empowers the data scientists, engineers, 
and business analysts of any enterprise to find insights to help reach critical 
business decisions. However, business decisions cannot be made without rich 
data visualization. To address this last-mile challenge of big data analytics, 
Apache Superset comes into the picture.&lt;/p&gt;
+
+&lt;h2 
id=&quot;apache-superset-modern-enterprise-ready-business-intelligence-platform&quot;&gt;Apache
 Superset: Modern, Enterprise-ready Business Intelligence Platform&lt;/h2&gt;
+
+&lt;p&gt;Apache Superset is a data exploration and visualization platform 
designed to be visual, intuitive, and interactive. A user can access data in 
the following two ways:&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;
+    &lt;p&gt;Access data from the following commonly used data sources one 
table at a time: Kylin, Presto, Hive, Impala, SparkSQL, MySQL, Postgres, 
Oracle, Redshift, SQL Server, Druid.&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Use a rich SQL Interactive Development Environment (IDE) called 
SQL Lab that is designed for power users with the ability to write SQL queries 
to analyze multiple tables.&lt;/p&gt;
+  &lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;Users can immediately analyze and visualize their query results using 
Apache Superset ‘s rich visualization and reporting features.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/2. 
superset_logo.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 2&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/3. 
Superset_screen_shot.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 3: Apache Superset Visualization Interface&lt;/p&gt;
+
+&lt;h2 
id=&quot;integrating-apache-kylin-and-apache-superset-to-boost-your-productivity&quot;&gt;Integrating
 Apache Kylin and Apache Superset to Boost Your Productivity&lt;/h2&gt;
+
+&lt;p&gt;Both Apache Kylin and Apache Superset are built to provide fast and 
interactive analytics for their users. The combination of these two open source 
projects can bring that goal to reality on petabyte-scale datasets, thanks to 
pre-calculated Kylin Cube.&lt;/p&gt;
+
+&lt;p&gt;The Kyligence Data Science team has recently open sourced kylinpy, a 
project that makes this combination possible. Kylinpy is a Python-based Apache 
Kylin client library. Any application that uses SQLAlchemy can now query Apache 
Kylin with this library installed, specifically Apache Superset. Below is a 
brief tutorial that shows how to integrate Apache Kylin and Apache 
Superset.&lt;/p&gt;
+
+&lt;h2 id=&quot;prerequisite&quot;&gt;Prerequisite&lt;/h2&gt;
+&lt;ol&gt;
+  &lt;li&gt;Install Apache Kylin&lt;br /&gt;
+Please refer to this installation tutorial.&lt;/li&gt;
+  &lt;li&gt;Apache Kylin provides a script for you to create a sample Cube. 
After you successfully installed Apache Kylin, you can run the below script 
under Apache Kylin installation directory to generate sample project and Cube. 
&lt;br /&gt;
+  ./${KYLIN_HOME}/bin/sample.sh&lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;When the script finishes running, log onto Apache Kylin web with 
default user ADMIN/KYLIN; in the system page click “Reload Metadata,” then 
you will see a sample project called “Learn Kylin.”&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;Select the sample cube “kylin_sales_cube”, click “Actions” 
-&amp;gt; “Build”, pick a date later than 2014-01-01 (to cover all 10000 
sample records);&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/4. 
build_cube.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 4: Build Cube in Apache Kylin&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Check the build progress in “Monitor” tab until it reaches 
100%;&lt;/li&gt;
+  &lt;li&gt;Execute SQL in the “Insight” tab, for example:&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;div class=&quot;highlighter-rouge&quot;&gt;&lt;pre 
class=&quot;highlight&quot;&gt;&lt;code&gt;  select part_dt,
+         sum(price) as total_selled,
+         count(distinct seller_id) as sellers
+  from kylin_sales
+  group by part_dt
+  order by part_dt
+-- #This query will hit on the newly built Cube “Kylin_sales_cube”.
+&lt;/code&gt;&lt;/pre&gt;
+&lt;/div&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Next, we will install Apache Superset and initialize it.&lt;br 
/&gt;
+  You may refer to Apache Superset official website instruction to install and 
initialize.&lt;/li&gt;
+  &lt;li&gt;Install kylinpy&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;div class=&quot;highlighter-rouge&quot;&gt;&lt;pre 
class=&quot;highlight&quot;&gt;&lt;code&gt;   $ pip install kylinpy
+&lt;/code&gt;&lt;/pre&gt;
+&lt;/div&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Verify your installation, if everything goes well, Apache Superset 
daemon should be up and running.&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;div class=&quot;highlighter-rouge&quot;&gt;&lt;pre 
class=&quot;highlight&quot;&gt;&lt;code&gt;$ superset runserver -d
+Starting server with command:
+gunicorn -w 2 --timeout 60 -b  0.0.0.0:8088 --limit-request-line 0 
--limit-request-field_size 0 superset:app
+
+[2018-01-03 15:54:03 +0800] [73673] [INFO] Starting gunicorn 19.7.1
+[2018-01-03 15:54:03 +0800] [73673] [INFO] Listening at: http://0.0.0.0:8088 
(73673)
+[2018-01-03 15:54:03 +0800] [73673] [INFO] Using worker: sync
+[2018-01-03 15:54:03 +0800] [73676] [INFO] Booting worker with pid: 73676
+[2018-01-03 15:54:03 +0800] [73679] [INFO] Booting worker with pid: 73679
+&lt;/code&gt;&lt;/pre&gt;
+&lt;/div&gt;
+
+&lt;h2 id=&quot;connect-apache-kylin-from-apachesuperset&quot;&gt;Connect 
Apache Kylin from ApacheSuperset&lt;/h2&gt;
+
+&lt;p&gt;Now everything you need is installed and ready to go. Let’s try to 
create an Apache Kylin data source in Apache Superset.&lt;br /&gt;
+1. Open up http://localhost:8088 in your web browser with the credential you 
set during Apache Superset installation.&lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/5. superset_1.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 5: Apache Superset Login Page&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Go to Source -&amp;gt; Datasource to configure a new data source.
+    &lt;ul&gt;
+      &lt;li&gt;SQLAlchemy URI pattern is : 
kylin://&lt;username&gt;:&lt;password&gt;@&lt;hostname&gt;:&lt;port&gt;/&lt;project
 
name=&quot;&quot;&gt;&lt;/project&gt;&lt;/port&gt;&lt;/hostname&gt;&lt;/password&gt;&lt;/username&gt;&lt;/li&gt;
+      &lt;li&gt;Check “Expose in SQL Lab” if you want to expose this data 
source in SQL Lab.&lt;/li&gt;
+      &lt;li&gt;Click “Test Connection” to see if the URI is working 
properly.&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/6. 
superset_2.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 6: Create an Apache Kylin data source&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/7. 
superset_3.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 7: Test Connection to Apache Kylin&lt;/p&gt;
+
+&lt;p&gt;If the connection to Apache Kylin is successful, you will see all the 
tables from Learn_kylin project show up at the bottom of the connection 
page.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/8. 
superset_4.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 8: Tables will show up if connection is successful&lt;/p&gt;
+
+&lt;h3 id=&quot;query-kylin-table&quot;&gt;Query Kylin Table&lt;/h3&gt;
+&lt;ol&gt;
+  &lt;li&gt;Go to Source -&amp;gt; Tables to add a new table, type in a table 
name from “Learn_kylin” project, for example, “Kylin_sales”.&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/9. 
superset_5.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 9 Add Kylin Table in Apache Superset&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Click on the table you created. Now you are ready to analyze your 
data from Apache Kylin.&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/10. 
superset_6.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 10 Query single table from Apache Kylin&lt;/p&gt;
+
+&lt;h3 id=&quot;query-multiple-tables-from-kylin-using-sql-lab&quot;&gt;Query 
Multiple Tables from Kylin Using SQL Lab.&lt;/h3&gt;
+&lt;p&gt;Kylin Cube is usually based on a data model joined by multiples 
tables. Thus, it is quite common to query multiple tables at the same time 
using Apache Kylin. In Apache Superset, you can use SQL Lab to join your data 
across tables by composing SQL queries. We will use a query that can hit on the 
sample cube “kylin_sales_cube” as an example. &lt;br /&gt;
+When you run your query in SQL Lab, the result will come from the data source, 
in this case, Apache Kylin.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/11. 
SQL_Lab.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 11 Query multiple tables from Apache Kylin using SQL Lab&lt;/p&gt;
+
+&lt;p&gt;When the query returns results, you may immediately visualize them by 
clicking on the “Visualize” button.&lt;br /&gt;
+&lt;img src=&quot;/images/Kylin-and-Superset/png/12. SQL_Lab_2.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 12 Define your query and visualize it immediately&lt;/p&gt;
+
+&lt;p&gt;You may copy the entire SQL below to experience how you can query 
Kylin Cube in SQL Lab. &lt;br /&gt;
+&lt;code class=&quot;highlighter-rouge&quot;&gt;
+select
+YEAR_BEG_DT,
+MONTH_BEG_DT,
+WEEK_BEG_DT,
+META_CATEG_NAME,
+CATEG_LVL2_NAME,
+CATEG_LVL3_NAME,
+OPS_REGION,
+NAME as BUYER_COUNTRY_NAME,
+sum(PRICE) as GMV,
+sum(ACCOUNT_BUYER_LEVEL) ACCOUNT_BUYER_LEVEL,
+count(*) as CNT
+from KYLIN_SALES
+join KYLIN_CAL_DT on CAL_DT=PART_DT
+join KYLIN_CATEGORY_GROUPINGS on SITE_ID=LSTG_SITE_ID and 
KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID=KYLIN_SALES.LEAF_CATEG_ID
+join KYLIN_ACCOUNT on ACCOUNT_ID=BUYER_ID
+join KYLIN_COUNTRY on ACCOUNT_COUNTRY=COUNTRY
+group by YEAR_BEG_DT, 
MONTH_BEG_DT,WEEK_BEG_DT,META_CATEG_NAME,CATEG_LVL2_NAME, 
CATEG_LVL3_NAME, OPS_REGION, NAME
+&lt;/code&gt;&lt;br /&gt;
+## Experience All Features in Apache Superset with Apache Kylin&lt;/p&gt;
+
+&lt;p&gt;Most of the common reporting features are available in Apache 
Superset. Now let’s see how we can use those features to analyze data from 
Apache Kylin.&lt;/p&gt;
+
+&lt;h3 id=&quot;sorting&quot;&gt;Sorting&lt;/h3&gt;
+&lt;p&gt;You may sort by a measure regardless of how it is 
visualized.&lt;/p&gt;
+
+&lt;p&gt;You may specify a “Sort By” measure or sort the measure on the 
visualization after the query returns.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/13. sort.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+Figure 13 Sort by&lt;/p&gt;
+
+&lt;h3 id=&quot;filtering&quot;&gt;Filtering&lt;/h3&gt;
+&lt;p&gt;There are multiple ways you may filter data from Apache Kylin.&lt;br 
/&gt;
+1. Date Filter&lt;br /&gt;
+  You may filter date and time dimension with the calendar filter. &lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/14. time_filter.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 14  Filtering time&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;
+    &lt;p&gt;Dimension Filter&lt;br /&gt;
+  For other dimensions, you may filter it with SQL conditions like “in, not 
in, equal to, not equal to, greater than and equal to, smaller than and equal 
to, greater than, smaller than, like”.&lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/15. 
dimension_filter.png&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 15 Filtering dimension&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Search Box&lt;br /&gt;
+  In some visualizations, it is also possible to further narrow down your 
result set after the query is returned from the data source using the “Search 
Box”. &lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/16. search_box.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 16 Search Box&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Filtering the measure&lt;br /&gt;
+  Apache Superset allows you to write a “having clause” to filtering the 
measure. &lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/17. having.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 17 Filtering measure&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Filter Box&lt;br /&gt;
+  The filter box visualization allows you to create a drop-down style filter 
that can filter all slices on a dashboard dynamically &lt;br /&gt;
+  As the screenshot below shows, if you filter the CATE_LVL2_NAME dimension 
from the filter box, all the visualizations on this dashboard will be filtered 
based on your selection. &lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/18. filter_box.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 18 The filter box visualization&lt;/p&gt;
+  &lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;h3 id=&quot;top-n&quot;&gt;Top-N&lt;/h3&gt;
+&lt;p&gt;To provide higher performance in query time for Top N query, Apache 
Kylin provides approximate Top N measure to pre-calculate the top records. In 
Apache Superset, you may use both “Sort By” and “Row Limit” feature to 
make sure your query can utilize the Top N pre-calculation from Kylin Cube. 
&lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/19. top10.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 19 use both “Sort By” and “Row Limit” to get Top 10&lt;/p&gt;
+
+&lt;h3 id=&quot;page-length&quot;&gt;Page Length&lt;/h3&gt;
+&lt;p&gt;Apache Kylin users usually need to deal with high cardinality 
dimension. When displaying a high cardinality dimension, the visualization will 
display too many distinct values, taking a long time to render. In that case, 
it is nice that Apache Superset provides the page length feature to limit the 
number of rows per page. This way the up-front rendering effort can be reduced. 
&lt;br /&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/20. page_length.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 20 Limit page length&lt;/p&gt;
+
+&lt;h3 id=&quot;visualizations&quot;&gt;Visualizations&lt;/h3&gt;
+&lt;p&gt;Apache Superset provides a rich and extensive set of visualizations. 
From basic charts like a pie chart, bar chart, line chart to advanced 
visualizations, like a sunburst, heatmap, world map, Sankey diagram. &lt;br 
/&gt;
+  &lt;img src=&quot;/images/Kylin-and-Superset/png/21. viz.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 21&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/22. viz_2.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 22&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/23. map.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 23 World map visualization&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Superset/png/24. bubble.png&quot; 
alt=&quot;&quot; /&gt;&lt;br /&gt;
+  Figure 24 bubble chart&lt;/p&gt;
+
+&lt;h3 id=&quot;other-functionalities&quot;&gt;Other functionalities&lt;/h3&gt;
+&lt;p&gt;Apache Superset also supports exporting to CSV, sharing, and viewing 
SQL query.&lt;/p&gt;
+
+&lt;h2 id=&quot;summary&quot;&gt;Summary&lt;/h2&gt;
+&lt;p&gt;With the right technical synergy of open source projects, you can 
achieve amazing results, more than the sum of its parts.  The pre-calculation 
technology of Apache Kylin accelerates visualization performance. The rich 
functionality of Apache Superset enables all Kylin Cube features to be fully 
utilized. When you marry the two, you get the superpower of accelerated 
interactive analytics.&lt;/p&gt;
+
+&lt;h2 id=&quot;references&quot;&gt;References&lt;/h2&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;&lt;a href=&quot;http://kylin.apache.org&quot;&gt;Apache 
Kylin&lt;/a&gt;&lt;/li&gt;
+  &lt;li&gt;&lt;a 
href=&quot;https://github.com/Kyligence/kylinpy&quot;&gt;kylinpy on 
Github&lt;/a&gt;&lt;/li&gt;
+  &lt;li&gt;&lt;a 
href=&quot;https://medium.com/airbnb-engineering/caravel-airbnb-s-data-exploration-platform-15a72aa610e5&quot;&gt;Superset:Airbnb’s
 data exploration platform&lt;/a&gt;&lt;/li&gt;
+  &lt;li&gt;&lt;a 
href=&quot;https://github.com/apache/incubator-superset&quot;&gt;Apache 
Superset on Github&lt;/a&gt;&lt;/li&gt;
+&lt;/ol&gt;
+
+</description>
+        <pubDate>Mon, 01 Jan 2018 04:28:00 -0800</pubDate>
+        
<link>http://kylin.apache.org/blog/2018/01/01/kylin-and-superset/</link>
+        <guid 
isPermaLink="true">http://kylin.apache.org/blog/2018/01/01/kylin-and-superset/</guid>
+        
+        
+        <category>blog</category>
+        
+      </item>
+    
+      <item>
         <title>Improving Spark Cubing in Kylin 2.0</title>
         <description>&lt;p&gt;Apache Kylin is a OALP Engine that speeding up 
query by Cube precomputation. The Cube is multi-dimensional dataset which 
contain precomputed all measures in all dimension combinations. Before v2.0, 
Kylin uses MapReduce to build Cube. In order to get better performance, Kylin 
2.0 introduced the Spark Cubing. About the principle of Spark Cubing, please 
refer to the article &lt;a 
href=&quot;http://kylin.apache.org/blog/2017/02/23/by-layer-spark-cubing/&quot;&gt;By-layer
 Spark Cubing&lt;/a&gt;.&lt;/p&gt;
 
@@ -222,54 +491,54 @@ kylin.engine.spark.rdd-partition-cut-mb=
       </item>
     
       <item>
-        <title>Apache Kylin v2.0.0 beta 发布</title>
-        <description>&lt;p&gt;Apache Kylin社区非常高兴地宣布 &lt;a 
href=&quot;http://kylin.apache.org/cn/download/&quot;&gt;v2.0.0 beta 
package&lt;/a&gt; 已经可以下载并测试了。&lt;/p&gt;
+        <title>Apache Kylin v2.0.0 Beta Announcement</title>
+        <description>&lt;p&gt;The Apache Kylin community is pleased to 
announce the &lt;a href=&quot;http://kylin.apache.org/download/&quot;&gt;v2.0.0 
beta package&lt;/a&gt; is ready for download and test.&lt;/p&gt;
 
 &lt;ul&gt;
-  &lt;li&gt;下载链接: &lt;a 
href=&quot;http://kylin.apache.org/cn/download/&quot;&gt;http://kylin.apache.org/cn/download/&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;源代码: 
https://github.com/apache/kylin/tree/kylin-2.0.0-beta&lt;/li&gt;
+  &lt;li&gt;Download link: &lt;a 
href=&quot;http://kylin.apache.org/download/&quot;&gt;http://kylin.apache.org/download/&lt;/a&gt;&lt;/li&gt;
+  &lt;li&gt;Source code: 
https://github.com/apache/kylin/tree/kylin-2.0.0-beta&lt;/li&gt;
 &lt;/ul&gt;
 
-&lt;p&gt;自从v1.6.0版本发布已经2个多月了。这段时间里,整个社区协力开发完成了一系列重大的功能,希望能将Apache
 Kylin提升到一个新的高度。&lt;/p&gt;
+&lt;p&gt;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.&lt;/p&gt;
 
 &lt;ul&gt;
-  &lt;li&gt;支持雪花模型 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-1875&quot;&gt;KYLIN-1875&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;支持 TPC-H 查询 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2467&quot;&gt;KYLIN-2467&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Spark 构建引擎 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2331&quot;&gt;KYLIN-2331&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Job Engine 高可用性 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2006&quot;&gt;KYLIN-2006&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Percentile 度量 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2396&quot;&gt;KYLIN-2396&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;在 Cloud 上通过测试 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2351&quot;&gt;KYLIN-2351&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Support snowflake data model (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-1875&quot;&gt;KYLIN-1875&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Support TPC-H queries (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2467&quot;&gt;KYLIN-2467&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Spark cubing engine (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2331&quot;&gt;KYLIN-2331&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Job engine HA (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2006&quot;&gt;KYLIN-2006&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Percentile measure (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2396&quot;&gt;KYLIN-2396&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Cloud tested (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2351&quot;&gt;KYLIN-2351&lt;/a&gt;)&lt;/li&gt;
 &lt;/ul&gt;
 
-&lt;p&gt;非常欢迎大家下载并测试 v2.0.0 
beta。您的反馈对我们非常重要,请发邮件到 &lt;a 
href=&quot;&amp;#109;&amp;#097;&amp;#105;&amp;#108;&amp;#116;&amp;#111;:&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&quot;&gt;&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&lt;/a&gt;。&lt;/p&gt;
+&lt;p&gt;You are very welcome to give the v2.0.0 beta a try, and please do 
send feedbacks to &lt;a 
href=&quot;&amp;#109;&amp;#097;&amp;#105;&amp;#108;&amp;#116;&amp;#111;:&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&quot;&gt;&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&lt;/a&gt;.&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;h2 id=&quot;section&quot;&gt;安装&lt;/h2&gt;
+&lt;h2 id=&quot;install&quot;&gt;Install&lt;/h2&gt;
 
-&lt;p&gt;暂时 v2.0.0 beta 无法从 v1.6.0 直接升级,必需全新安装
。这是由于新版本的元数据并不向前兼容。好在 Cube 
数据是向前兼容的,因此只需要开发一个元数据转换工å…
·ï¼Œå°±èƒ½åœ¨ä¸ä¹…
的将来实现平滑升级。我们正在为此努力。&lt;/p&gt;
+&lt;p&gt;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.&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;h2 id=&quot;tpc-h-&quot;&gt;运行 TPC-H 基准测试&lt;/h2&gt;
+&lt;h2 id=&quot;run-tpc-h-benchmark&quot;&gt;Run TPC-H Benchmark&lt;/h2&gt;
 
-&lt;p&gt;在 Apache Kylin 上运行 TPC-H 的具体步骤: &lt;a 
href=&quot;https://github.com/Kyligence/kylin-tpch&quot;&gt;https://github.com/Kyligence/kylin-tpch&lt;/a&gt;&lt;/p&gt;
+&lt;p&gt;Steps to run TPC-H benchmark on Apache Kylin can be found here: &lt;a 
href=&quot;https://github.com/Kyligence/kylin-tpch&quot;&gt;https://github.com/Kyligence/kylin-tpch&lt;/a&gt;&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;h2 id=&quot;spark-&quot;&gt;Spark 构建引擎&lt;/h2&gt;
+&lt;h2 id=&quot;spark-cubing-engine&quot;&gt;Spark Cubing Engine&lt;/h2&gt;
 
-&lt;p&gt;Apache Kylin v2.0.0 引入了一个全新的基于 Apache Spark 
的构建引擎。它可用于替换原有的 MapReduce 
构建引擎。初步测试显示 Cube 的构建时间一般能缩短到原å…
ˆçš„ 50% 左右。&lt;/p&gt;
+&lt;p&gt;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.&lt;/p&gt;
 
-&lt;p&gt;启用 Spark 构建引擎,请参考&lt;a 
href=&quot;/docs16/tutorial/cube_spark.html&quot;&gt;这篇文档&lt;/a&gt;.&lt;/p&gt;
+&lt;p&gt;To enable the Spark cubing engine, check &lt;a 
href=&quot;/docs16/tutorial/cube_spark.html&quot;&gt;this 
tutorial&lt;/a&gt;.&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;p&gt;&lt;em&gt;感谢每一位朋友的参与和贡献!&lt;/em&gt;&lt;/p&gt;
+&lt;p&gt;&lt;em&gt;Great thanks to everyone who 
contributed!&lt;/em&gt;&lt;/p&gt;
 </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>
@@ -277,54 +546,54 @@ kylin.engine.spark.rdd-partition-cut-mb=
       </item>
     
       <item>
-        <title>Apache Kylin v2.0.0 Beta Announcement</title>
-        <description>&lt;p&gt;The Apache Kylin community is pleased to 
announce the &lt;a href=&quot;http://kylin.apache.org/download/&quot;&gt;v2.0.0 
beta package&lt;/a&gt; is ready for download and test.&lt;/p&gt;
+        <title>Apache Kylin v2.0.0 beta 发布</title>
+        <description>&lt;p&gt;Apache Kylin社区非常高兴地宣布 &lt;a 
href=&quot;http://kylin.apache.org/cn/download/&quot;&gt;v2.0.0 beta 
package&lt;/a&gt; 已经可以下载并测试了。&lt;/p&gt;
 
 &lt;ul&gt;
-  &lt;li&gt;Download link: &lt;a 
href=&quot;http://kylin.apache.org/download/&quot;&gt;http://kylin.apache.org/download/&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Source code: 
https://github.com/apache/kylin/tree/kylin-2.0.0-beta&lt;/li&gt;
+  &lt;li&gt;下载链接: &lt;a 
href=&quot;http://kylin.apache.org/cn/download/&quot;&gt;http://kylin.apache.org/cn/download/&lt;/a&gt;&lt;/li&gt;
+  &lt;li&gt;源代码: 
https://github.com/apache/kylin/tree/kylin-2.0.0-beta&lt;/li&gt;
 &lt;/ul&gt;
 
-&lt;p&gt;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.&lt;/p&gt;
+&lt;p&gt;自从v1.6.0版本发布已经2个多月了。这段时间里,整个社区协力开发完成了一系列重大的功能,希望能将Apache
 Kylin提升到一个新的高度。&lt;/p&gt;
 
 &lt;ul&gt;
-  &lt;li&gt;Support snowflake data model (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-1875&quot;&gt;KYLIN-1875&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Support TPC-H queries (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2467&quot;&gt;KYLIN-2467&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Spark cubing engine (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2331&quot;&gt;KYLIN-2331&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Job engine HA (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2006&quot;&gt;KYLIN-2006&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Percentile measure (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2396&quot;&gt;KYLIN-2396&lt;/a&gt;)&lt;/li&gt;
-  &lt;li&gt;Cloud tested (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2351&quot;&gt;KYLIN-2351&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;支持雪花模型 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-1875&quot;&gt;KYLIN-1875&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;支持 TPC-H 查询 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2467&quot;&gt;KYLIN-2467&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Spark 构建引擎 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2331&quot;&gt;KYLIN-2331&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Job Engine 高可用性 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2006&quot;&gt;KYLIN-2006&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;Percentile 度量 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2396&quot;&gt;KYLIN-2396&lt;/a&gt;)&lt;/li&gt;
+  &lt;li&gt;在 Cloud 上通过测试 (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-2351&quot;&gt;KYLIN-2351&lt;/a&gt;)&lt;/li&gt;
 &lt;/ul&gt;
 
-&lt;p&gt;You are very welcome to give the v2.0.0 beta a try, and please do 
send feedbacks to &lt;a 
href=&quot;&amp;#109;&amp;#097;&amp;#105;&amp;#108;&amp;#116;&amp;#111;:&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&quot;&gt;&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&lt;/a&gt;.&lt;/p&gt;
+&lt;p&gt;非常欢迎大家下载并测试 v2.0.0 
beta。您的反馈对我们非常重要,请发邮件到 &lt;a 
href=&quot;&amp;#109;&amp;#097;&amp;#105;&amp;#108;&amp;#116;&amp;#111;:&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&quot;&gt;&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&lt;/a&gt;。&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;h2 id=&quot;install&quot;&gt;Install&lt;/h2&gt;
+&lt;h2 id=&quot;section&quot;&gt;安装&lt;/h2&gt;
 
-&lt;p&gt;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.&lt;/p&gt;
+&lt;p&gt;暂时 v2.0.0 beta 无法从 v1.6.0 直接升级,必需全新安装
。这是由于新版本的元数据并不向前兼容。好在 Cube 
数据是向前兼容的,因此只需要开发一个元数据转换工å…
·ï¼Œå°±èƒ½åœ¨ä¸ä¹…
的将来实现平滑升级。我们正在为此努力。&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;h2 id=&quot;run-tpc-h-benchmark&quot;&gt;Run TPC-H Benchmark&lt;/h2&gt;
+&lt;h2 id=&quot;tpc-h-&quot;&gt;运行 TPC-H 基准测试&lt;/h2&gt;
 
-&lt;p&gt;Steps to run TPC-H benchmark on Apache Kylin can be found here: &lt;a 
href=&quot;https://github.com/Kyligence/kylin-tpch&quot;&gt;https://github.com/Kyligence/kylin-tpch&lt;/a&gt;&lt;/p&gt;
+&lt;p&gt;在 Apache Kylin 上运行 TPC-H 的具体步骤: &lt;a 
href=&quot;https://github.com/Kyligence/kylin-tpch&quot;&gt;https://github.com/Kyligence/kylin-tpch&lt;/a&gt;&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;h2 id=&quot;spark-cubing-engine&quot;&gt;Spark Cubing Engine&lt;/h2&gt;
+&lt;h2 id=&quot;spark-&quot;&gt;Spark 构建引擎&lt;/h2&gt;
 
-&lt;p&gt;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.&lt;/p&gt;
+&lt;p&gt;Apache Kylin v2.0.0 引入了一个全新的基于 Apache Spark 
的构建引擎。它可用于替换原有的 MapReduce 
构建引擎。初步测试显示 Cube 的构建时间一般能缩短到原å…
ˆçš„ 50% 左右。&lt;/p&gt;
 
-&lt;p&gt;To enable the Spark cubing engine, check &lt;a 
href=&quot;/docs16/tutorial/cube_spark.html&quot;&gt;this 
tutorial&lt;/a&gt;.&lt;/p&gt;
+&lt;p&gt;启用 Spark 构建引擎,请参考&lt;a 
href=&quot;/docs16/tutorial/cube_spark.html&quot;&gt;这篇文档&lt;/a&gt;.&lt;/p&gt;
 
 &lt;hr /&gt;
 
-&lt;p&gt;&lt;em&gt;Great thanks to everyone who 
contributed!&lt;/em&gt;&lt;/p&gt;
+&lt;p&gt;&lt;em&gt;感谢每一位朋友的参与和贡献!&lt;/em&gt;&lt;/p&gt;
 </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>
@@ -673,80 +942,6 @@ group by grouping sets((dim1, dim2), (di
         
         
         <category>blog</category>
-        
-      </item>
-    
-      <item>
-        <title>New NRT Streaming in Apache Kylin</title>
-        <description>&lt;p&gt;In 1.5.0 Apache Kylin introduces the Streaming 
Cubing feature, which can consume data from Kafka topic directly. This &lt;a 
href=&quot;/blog/2016/02/03/streaming-cubing/&quot;&gt;blog&lt;/a&gt; 
introduces how that be implemented, and this &lt;a 
href=&quot;/docs15/tutorial/cube_streaming.html&quot;&gt;tutorial&lt;/a&gt; 
introduces how to use it.&lt;/p&gt;
-
-&lt;p&gt;While, that implementation was marked as “experimental” because 
it has the following limitations:&lt;/p&gt;
-
-&lt;ul&gt;
-  &lt;li&gt;
-    &lt;p&gt;Not scalable: it starts a Java process for a micro-batch cube 
building, instead of leveraging any computing framework; If too many messages 
arrive at one time, the build may fail with OutOfMemory error;&lt;/p&gt;
-  &lt;/li&gt;
-  &lt;li&gt;
-    &lt;p&gt;May loss data: it uses a time window to seek the approximate 
start/end offsets on Kafka topic, which means too late/early arrived messages 
will be skipped; Then the query couldn’t ensure 100% accuracy.&lt;/p&gt;
-  &lt;/li&gt;
-  &lt;li&gt;
-    &lt;p&gt;Difficult to monitor: the streaming cubing is out of the Job 
engine’s scope, user can not monitor the jobs with Web GUI or REST 
API.&lt;/p&gt;
-  &lt;/li&gt;
-  &lt;li&gt;
-    &lt;p&gt;Others: hard to recover from accident, difficult to maintain the 
code, etc.&lt;/p&gt;
-  &lt;/li&gt;
-&lt;/ul&gt;
-
-&lt;p&gt;To overcome these limitations, the Apache Kylin team developed the 
new streaming (&lt;a 
href=&quot;https://issues.apache.org/jira/browse/KYLIN-1726&quot;&gt;KYLIN-1726&lt;/a&gt;)
 with Kafka 0.10, it has been tested internally for some time, will release to 
public soon.&lt;/p&gt;
-
-&lt;p&gt;The new design is a perfect implementation under Kylin 1.5’s 
“plug-in” architecture: treat Kafka topic as a “Data Source” like Hive 
table, using an adapter to extract the data to HDFS; the next steps are almost 
the same as other cubes. Figure 1 is a high level architecture of the new 
design.&lt;/p&gt;
-
-&lt;p&gt;&lt;img src=&quot;/images/blog/new-streaming.png&quot; 
alt=&quot;Kylin New Streaming Framework Architecture&quot; /&gt;&lt;/p&gt;
-
-&lt;p&gt;The adapter to read Kafka messages is modified from &lt;a 
href=&quot;https://github.com/amient/kafka-hadoop-loader&quot;&gt;kafka-hadoop-loader&lt;/a&gt;,
 the author Michal Harish open sourced it under Apache License V2.0; it starts 
a mapper for each Kafka partition, reading and then saving the messages to 
HDFS; so Kylin will be able to leverage existing framework like MR to do the 
processing, this makes the solution scalable and fault-tolerant.&lt;/p&gt;
-
-&lt;p&gt;To overcome the “data loss” limitation, Kylin adds the start/end 
offset information on each Cube segment, and then use the offsets as the 
partition value (no overlap allowed); this ensures no data be lost and 1 
message be consumed at most once. To let the late/early message can be queried, 
Cube segments allow overlap for the partition time dimension: each segment has 
a “min” date/time and a “max” date/time; Kylin will scan all segments 
which matched with the queried time scope. Figure 2 illurates this.&lt;/p&gt;
-
-&lt;p&gt;&lt;img src=&quot;/images/blog/offset-as-partition-value.png&quot; 
alt=&quot;Use Offset to Cut Segments&quot; /&gt;&lt;/p&gt;
-
-&lt;p&gt;Other changes/enhancements are made in the new streaming:&lt;/p&gt;
-
-&lt;ul&gt;
-  &lt;li&gt;Allow multiple segments being built/merged concurrently&lt;/li&gt;
-  &lt;li&gt;Automatically seek start/end offsets (if user doesn’t specify) 
from previous segment or Kafka&lt;/li&gt;
-  &lt;li&gt;Support embeded properties in JSON message&lt;/li&gt;
-  &lt;li&gt;Add REST API to trigger streaming cube’s building&lt;/li&gt;
-  &lt;li&gt;Add REST API to check and fill the segment holes&lt;/li&gt;
-&lt;/ul&gt;
-
-&lt;p&gt;The integration test result is promising:&lt;/p&gt;
-
-&lt;ul&gt;
-  &lt;li&gt;Scalability: it can easily process up to hundreds of million 
records in one build;&lt;/li&gt;
-  &lt;li&gt;Flexibility: you can trigger the build at any time, with the 
frequency you want; for example: every 5 minutes in day time but every hour in 
night time, and even pause when you need do a maintenance; Kylin manages the 
offsets so it can automatically continue from the last position;&lt;/li&gt;
-  &lt;li&gt;Stability: pretty stable, no OutOfMemoryError;&lt;/li&gt;
-  &lt;li&gt;Management: user can check all jobs’ status through Kylin’s 
“Monitor” page or REST API;&lt;/li&gt;
-  &lt;li&gt;Build Performance: in a testing cluster (8 AWS instances to 
consume Twitter streams), 10 thousands arrives per second, define a 9-dimension 
cube with 3 measures; when build interval is 2 mintues, the job finishes in 
around 3 minutes; if change interval to 5 mintues, build finishes in around 4 
minutes;&lt;/li&gt;
-&lt;/ul&gt;
-
-&lt;p&gt;Here are a couple of screenshots in this test, we may compose it as a 
step-by-step tutorial in the future:&lt;br /&gt;
-&lt;img src=&quot;/images/blog/streaming-monitor.png&quot; alt=&quot;Streaming 
Job Monitoring&quot; /&gt;&lt;/p&gt;
-
-&lt;p&gt;&lt;img src=&quot;/images/blog/streaming-adapter.png&quot; 
alt=&quot;Streaming Adapter&quot; /&gt;&lt;/p&gt;
-
-&lt;p&gt;&lt;img src=&quot;/images/blog/streaming-twitter.png&quot; 
alt=&quot;Streaming Twitter Sample&quot; /&gt;&lt;/p&gt;
-
-&lt;p&gt;In short, this is a more robust Near Real Time Streaming OLAP 
solution compared with the previous version.&lt;/p&gt;
-
-&lt;p&gt;Now you can download a 1.6.0-SNAPSHOT build from Kylin’s download 
page, and then follow this &lt;a 
href=&quot;/docs16/tutorial/cube_streaming.html&quot;&gt;tutorial&lt;/a&gt; to 
build a sample streaming cube.&lt;/p&gt;
-
-</description>
-        <pubDate>Tue, 18 Oct 2016 10:30:00 -0700</pubDate>
-        <link>http://kylin.apache.org/blog/2016/10/18/new-nrt-streaming/</link>
-        <guid 
isPermaLink="true">http://kylin.apache.org/blog/2016/10/18/new-nrt-streaming/</guid>
-        
-        
-        <category>blog</category>
         
       </item>
     

Added: kylin/site/images/Kylin-and-Superset/gif/11. SQL_lab.gif
URL: 
http://svn.apache.org/viewvc/kylin/site/images/Kylin-and-Superset/gif/11.%20SQL_lab.gif?rev=1822508&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/Kylin-and-Superset/gif/11. SQL_lab.gif
------------------------------------------------------------------------------
    svn:executable = *

Propchange: kylin/site/images/Kylin-and-Superset/gif/11. SQL_lab.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/Kylin-and-Superset/gif/13-1. sort.gif
URL: 
http://svn.apache.org/viewvc/kylin/site/images/Kylin-and-Superset/gif/13-1.%20sort.gif?rev=1822508&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/Kylin-and-Superset/gif/13-1. sort.gif
------------------------------------------------------------------------------
    svn:executable = *

Propchange: kylin/site/images/Kylin-and-Superset/gif/13-1. sort.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/Kylin-and-Superset/gif/13-2. sort_on_viz.gif
URL: 
http://svn.apache.org/viewvc/kylin/site/images/Kylin-and-Superset/gif/13-2.%20sort_on_viz.gif?rev=1822508&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/Kylin-and-Superset/gif/13-2. sort_on_viz.gif
------------------------------------------------------------------------------
    svn:executable = *

Propchange: kylin/site/images/Kylin-and-Superset/gif/13-2. sort_on_viz.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/Kylin-and-Superset/gif/14. time_filter.gif
URL: 
http://svn.apache.org/viewvc/kylin/site/images/Kylin-and-Superset/gif/14.%20time_filter.gif?rev=1822508&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/Kylin-and-Superset/gif/14. time_filter.gif
------------------------------------------------------------------------------
    svn:executable = *

Propchange: kylin/site/images/Kylin-and-Superset/gif/14. time_filter.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/Kylin-and-Superset/gif/15. dimension_filter.gif
URL: 
http://svn.apache.org/viewvc/kylin/site/images/Kylin-and-Superset/gif/15.%20dimension_filter.gif?rev=1822508&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/Kylin-and-Superset/gif/15. dimension_filter.gif
------------------------------------------------------------------------------
    svn:executable = *

Propchange: kylin/site/images/Kylin-and-Superset/gif/15. dimension_filter.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/Kylin-and-Superset/gif/16. search_box.gif
URL: 
http://svn.apache.org/viewvc/kylin/site/images/Kylin-and-Superset/gif/16.%20search_box.gif?rev=1822508&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/Kylin-and-Superset/gif/16. search_box.gif
------------------------------------------------------------------------------
    svn:executable = *

Propchange: kylin/site/images/Kylin-and-Superset/gif/16. search_box.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream


Reply via email to