You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2018/01/26 14:02:05 UTC

svn commit: r1822299 [2/10] - in /kylin/site: ./ cn/docs21/ cn/docs21/howto/ cn/docs21/install/ cn/docs21/tutorial/ docs21/ docs21/gettingstarted/ docs21/howto/ docs21/install/ docs21/tutorial/

Added: kylin/site/cn/docs21/howto/howto_jdbc.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/howto/howto_jdbc.html?rev=1822299&view=auto
==============================================================================
--- kylin/site/cn/docs21/howto/howto_jdbc.html (added)
+++ kylin/site/cn/docs21/howto/howto_jdbc.html Fri Jan 26 14:02:04 2018
@@ -0,0 +1,1829 @@
+<!--
+* 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 | Kylin JDBC Driver</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="canonical" href="http://kylin.apache.org/cn/docs21/howto/howto_jdbc.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">
+    <!-- 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="/cn">首页</a></li>
+          <li><a href="/cn/docs21" >文档</a></li>
+          <li><a href="/cn/download">下载</li>
+          <li><a href="/community" >社区</a></li>
+          <li><a href="/development" >开发</a></li>
+          <li><a href="/blog">博客</li>
+          <li><a href="/" >English</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="#title开始" data-toggle="collapse" id="navtitle">开始</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/index.html" class="list-group-item-lay pjaxlink" id="navlist">概述</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title安装" data-toggle="collapse" id="navtitle">安装</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">手动安装指南</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title教程" data-toggle="collapse" id="navtitle">教程</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 创建教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建立和Job监控教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 权限授予教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin网页版教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软Excel及Power BI教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱动程序教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">与Qlik Sense集成</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title帮助" data-toggle="collapse" id="navtitle">帮助</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">备份元数据</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">用API构建cube</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">清理存储</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">优化cube构建</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">Kylin JDBC Driver</h1>
+							<article class="post-content" >
+							<h3 id="section">认证</h3>
+
+<h6 id="apache-kylinrestful">基于Apache Kylin认证RESTFUL服务。支持的参数：</h6>
+<ul>
+  <li>user : 用户名</li>
+  <li>password : 密码</li>
+  <li>ssl: true或false。 默认为flas；如果为true，所有的服务调用都会使用https。</li>
+</ul>
+
+<h3 id="url">连接url格式：</h3>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">jdbc:kylin://&lt;hostname&gt;:&lt;port&gt;/&lt;kylin_project_name&gt;</code></pre></div>
+
+<ul>
+  <li>如果“ssl”为true，“port”应该是Kylin server的HTTPS端口。</li>
+  <li>如果“port”未被指定，driver会使用默认的端口：HTTP 80，HTTPS 443。</li>
+  <li>必须指定“kylin_project_name”并且用户需要确保它在Kylin server上存在。</li>
+</ul>
+
+<h3 id="statement">1. 使用Statement查询</h3>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
+
+Properties info = new Properties();
+info.put("user", "ADMIN");
+info.put("password", "KYLIN");
+Connection conn = driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
+Statement state = conn.createStatement();
+ResultSet resultSet = state.executeQuery("select * from test_table");
+
+while (resultSet.next()) {
+    assertEquals("foo", resultSet.getString(1));
+    assertEquals("bar", resultSet.getString(2));
+    assertEquals("tool", resultSet.getString(3));
+}</code></pre></div>
+
+<h3 id="preparedstatementv">2. 使用PreparedStatementv查询</h3>
+
+<h6 id="preparedstatement">支持的PreparedStatement参数：</h6>
+<ul>
+  <li>setString</li>
+  <li>setInt</li>
+  <li>setShort</li>
+  <li>setLong</li>
+  <li>setFloat</li>
+  <li>setDouble</li>
+  <li>setBoolean</li>
+  <li>setByte</li>
+  <li>setDate</li>
+  <li>setTime</li>
+  <li>setTimestamp</li>
+</ul>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
+Properties info = new Properties();
+info.put("user", "ADMIN");
+info.put("password", "KYLIN");
+Connection conn = driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
+PreparedStatement state = conn.prepareStatement("select * from test_table where id=?");
+state.setInt(1, 10);
+ResultSet resultSet = state.executeQuery();
+
+while (resultSet.next()) {
+    assertEquals("foo", resultSet.getString(1));
+    assertEquals("bar", resultSet.getString(2));
+    assertEquals("tool", resultSet.getString(3));
+}</code></pre></div>
+
+<h3 id="section-1">3. 获取查询结果元数据</h3>
+<p>Kylin jdbc driver支持元数据列表方法：<br />
+通过sql模式过滤器（比如 %）列出catalog、schema、table和column。</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
+Properties info = new Properties();
+info.put("user", "ADMIN");
+info.put("password", "KYLIN");
+Connection conn = driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
+Statement state = conn.createStatement();
+ResultSet resultSet = state.executeQuery("select * from test_table");
+
+ResultSet tables = conn.getMetaData().getTables(null, null, "dummy", null);
+while (tables.next()) {
+    for (int i = 0; i &lt; 10; i++) {
+        assertEquals("dummy", tables.getString(i + 1));
+    }
+}</code></pre></div>
+
+
+							</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>

Added: kylin/site/cn/docs21/howto/howto_optimize_build.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/howto/howto_optimize_build.html?rev=1822299&view=auto
==============================================================================
--- kylin/site/cn/docs21/howto/howto_optimize_build.html (added)
+++ kylin/site/cn/docs21/howto/howto_optimize_build.html Fri Jan 26 14:02:04 2018
@@ -0,0 +1,1904 @@
+<!--
+* 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 | 优化cube构建</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="canonical" href="http://kylin.apache.org/cn/docs21/howto/howto_optimize_build.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">
+    <!-- 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="/cn">首页</a></li>
+          <li><a href="/cn/docs21" >文档</a></li>
+          <li><a href="/cn/download">下载</li>
+          <li><a href="/community" >社区</a></li>
+          <li><a href="/development" >开发</a></li>
+          <li><a href="/blog">博客</li>
+          <li><a href="/" >English</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="#title开始" data-toggle="collapse" id="navtitle">开始</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/index.html" class="list-group-item-lay pjaxlink" id="navlist">概述</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title安装" data-toggle="collapse" id="navtitle">安装</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">手动安装指南</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title教程" data-toggle="collapse" id="navtitle">教程</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 创建教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建立和Job监控教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 权限授予教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin网页版教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软Excel及Power BI教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱动程序教程</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">与Qlik Sense集成</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title帮助" data-toggle="collapse" id="navtitle">帮助</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">备份元数据</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">用API构建cube</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">清理存储</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">优化cube构建</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">优化cube构建</h1>
+							<article class="post-content" >
+							<p>Kylin将Cube构建任务分解为几个依次执行的步骤，这些步骤包括Hive操作、MapReduce操作和其他类型的操作。如果你有很多Cube构建任务需要每天运行，那么你肯定想要减少其中消耗的时间。下文按照Cube构建步骤顺序提供了一些优化经验。</p>
+
+<h2 id="hive">创建Hive的中间平表</h2>
+
+<p>这一步将数据从源Hive表提取出来(和所有join的表一起)并插入到一个中间平表。如果Cube是分区的，Kylin会加上一个时间条件以确保只有在时间范围内的数据才会被提取。你可以在这个步骤的log查看相关的Hive命令，比如：</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>hive -e "USE default;
+DROP TABLE IF EXISTS kylin_intermediate_airline_cube_v3610f668a3cdb437e8373c034430f6c34;
+
+CREATE EXTERNAL TABLE IF NOT EXISTS kylin_intermediate_airline_cube_v3610f668a3cdb437e8373c034430f6c34
+(AIRLINE_FLIGHTDATE date,AIRLINE_YEAR int,AIRLINE_QUARTER int,...,AIRLINE_ARRDELAYMINUTES int)
+STORED AS SEQUENCEFILE
+LOCATION 'hdfs:///kylin/kylin200instance/kylin-0a8d71e8-df77-495f-b501-03c06f785b6c/kylin_intermediate_airline_cube_v3610f668a3cdb437e8373c034430f6c34';
+
+SET dfs.replication=2;
+SET hive.exec.compress.output=true;
+SET hive.auto.convert.join.noconditionaltask=true;
+SET hive.auto.convert.join.noconditionaltask.size=100000000;
+SET mapreduce.job.split.metainfo.maxsize=-1;
+
+INSERT OVERWRITE TABLE kylin_intermediate_airline_cube_v3610f668a3cdb437e8373c034430f6c34 SELECT
+AIRLINE.FLIGHTDATE
+,AIRLINE.YEAR
+,AIRLINE.QUARTER
+,...
+,AIRLINE.ARRDELAYMINUTES
+FROM AIRLINE.AIRLINE as AIRLINE
+WHERE (AIRLINE.FLIGHTDATE &gt;= '1987-10-01' AND AIRLINE.FLIGHTDATE &lt; '2017-01-01');
+
+</code></pre>
+</div>
+
+<p>在Hive命令运行时，Kylin会用<code class="highlighter-rouge">conf/kylin_hive_conf.properties</code>里的配置，比如保留更少的冗余备份和启用Hive的mapper side join。需要的话可以根据集群的具体情况增加其他配置。</p>
+
+<p>如果cube的分区列(在这个案例中是”FIGHTDATE”)与Hive表的分区列相同，那么根据它过滤数据能让Hive聪明地跳过不匹配的分区。因此强烈建议用Hive的分区列（如果它是日期列）作为cube的分区列。这对于那些数据量很大的表来说几乎是必须的，否则Hive不得不每次在这步扫描全部文件，消耗非常长的时间。</p>
+
+<p>如果启用了Hive的文件合并，你可以在<code class="highlighter-rouge">conf/kylin_hive_conf.xml</code>里关闭它，因为Kylin有自己合并文件的方法(下一节)：</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>&lt;property&gt;
+    &lt;name&gt;hive.merge.mapfiles&lt;/name&gt;
+    &lt;value&gt;false&lt;/value&gt;
+    &lt;description&gt;Disable Hive's auto merge&lt;/description&gt;
+&lt;/property&gt;
+</code></pre>
+</div>
+
+<h2 id="section">重新分发中间表</h2>
+
+<p>在之前的一步之后，Hive在HDFS上的目录里生成了数据文件：有些是大文件，有些是小文件甚至空文件。这种不平衡的文件分布会导致之后的MR任务出现数据倾斜的问题：有些mapper完成得很快，但其他的就很慢。针对这个问题，Kylin增加了这一个步骤来“重新分发”数据，这是示例输出:</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>total input rows = 159869711
+expected input rows per mapper = 1000000
+num reducers for RedistributeFlatHiveTableStep = 160
+
+</code></pre>
+</div>
+
+<p>重新分发表的命令：</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>hive -e "USE default;
+SET dfs.replication=2;
+SET hive.exec.compress.output=true;
+SET hive.auto.convert.join.noconditionaltask=true;
+SET hive.auto.convert.join.noconditionaltask.size=100000000;
+SET mapreduce.job.split.metainfo.maxsize=-1;
+set mapreduce.job.reduces=160;
+set hive.merge.mapredfiles=false;
+
+INSERT OVERWRITE TABLE kylin_intermediate_airline_cube_v3610f668a3cdb437e8373c034430f6c34 SELECT * FROM kylin_intermediate_airline_cube_v3610f668a3cdb437e8373c034430f6c34 DISTRIBUTE BY RAND();
+"
+</code></pre>
+</div>
+
+<p>首先，Kylin计算出中间表的行数，然后基于行数的大小算出重新分发数据需要的文件数。默认情况下,Kylin为每一百万行分配一个文件。在这个例子中，有1.6亿行和160个reducer，每个reducer会写一个文件。在接下来对这张表进行的MR步骤里，Hadoop会启动和文件相同数量的mapper来处理数据(通常一百万行数据比一个HDFS数据块要小)。如果你的日常数据量没有这么大或者Hadoop集群有足够的资源，你或许想要更�
 �¤šçš„并发数，这时可以将<code class="highlighter-rouge">conf/kylin.properties</code>里的<code class="highlighter-rouge">kylin.job.mapreduce.mapper.input.rows</code>设为小一点的数值，比如:</p>
+
+<p><code class="highlighter-rouge">kylin.job.mapreduce.mapper.input.rows=500000</code></p>
+
+<p>其次，Kylin会运行 <em>“INSERT OVERWRITE TABLE … DISTRIBUTE BY “</em> 形式的HiveQL来分发数据到指定数量的reducer上。</p>
+
+<p>在很多情况下，Kylin请求Hive随机分发数据到reducer，然后得到大小相近的文件，分发的语句是”DISTRIBUTE BY RAND()”。</p>
+
+<p>如果你的cube指定了一个高基数的列，比如”USER_ID”，作为”分片”维度(在cube的“高级设置”页面)，Kylin会让Hive根据该列的值重新分发数据，那么在该列有着相同值的行将被分发到同一个文件。这比随机要分发要好得多，因为不仅重新分布了数据，并且在没有额外代价的情况下对数据进行了预先分类，如此一来接下来的cube build处理会从中受益。在典型的场景下，这样优化可以减少40%的buildæ
 —¶é•¿ã€‚在这个案例中分发的语句是”DISTRIBUTE BY USER_ID”：</p>
+
+<p>请注意: 1)“分片”列应该是高基数的维度列，并且它会出现在很多的cuboid中（不只是出现在少数的cuboid）。 使用它来合理进行分发可以在每个时间范围内的数据均匀分布，否则会造成数据倾斜，从而降低build效率。典型的正面例子是：“USER_ID”、“SELLER_ID”、“PRODUCT”、“CELL_NUMBER”等等，这些列的基数应该大于一千(远大于reducer的数量)。 2)”分片”对cube的存储同样有好处，不过这超出了本文的范å›
 ´ã€‚</p>
+
+<h2 id="section-1">提取事实表的唯一列</h2>
+
+<p>在这一步骤Kylin运行MR任务来提取使用字典编码的维度列的唯一值。</p>
+
+<p>实际上这步另外还做了一些事情：通过HyperLogLog计数器收集cube的统计数据，用于估算每个cuboid的行数。如果你发现mapper运行得很慢，这通常表明cube的设计太过复杂，请参考<br />
+<a href="howto_optimize_cubes.html">优化cube设计</a>来简化cube。如果reducer出现了内存溢出错误，这表明cuboid组合真的太多了或者是YARN的内存分配满足不了需要。如果这一步从任何意义上讲不能在合理的时间内完成，你可以放弃任务并考虑重新设计cube，因为继续下去会花费更长的时间。</p>
+
+<p>你可以通过降低取样的比例（kylin.job.cubing.inmen.sampling.percent）来加速这个步骤，但是帮助可能不大而且影响了cube统计数据的准确性，所有我们并不推荐。</p>
+
+<h2 id="section-2">构建维度字典</h2>
+
+<p>有了前一步提取的维度列唯一值，Kylin会在内存里构建字典（在下个版本将改为MapReduce任务）。通常这一步比较快，但如果唯一值集合很大，Kylin可能会报出类似“字典不支持过高基数”。对于UHC类型的列，请使用其他编码方式，比如“fixed_length”、“integer”等等。</p>
+
+<h2 id="cuboid-htable">保存cuboid的统计数据和创建 HTable</h2>
+
+<p>这两步是轻量级和快速的。</p>
+
+<h2 id="cuboid">构建基础cuboid</h2>
+
+<p>这一步用Hive的中间表构建基础的cuboid，是“逐层”构建cube算法的第一轮MR计算。Mapper的数目与第二步的reducer数目相等；Reducer的数目是根据cube统计数据估算的：默认情况下每500MB输出使用一个reducer；如果观察到reducer的数量较少，你可以将kylin.properties里的“kylin.job.mapreduce.default.reduce.input.mb”设为小一点的数值以获得过多的资源，比如:</p>
+
+<p><code class="highlighter-rouge">kylin.job.mapreduce.default.reduce.input.mb=200</code></p>
+
+<h2 id="build-n-dimension-cuboid">Build N-Dimension Cuboid</h2>
+<p>## 构建N维cuboid</p>
+
+<p>这些步骤是“逐层”构建cube的过程，每一步以前一步的输出作为输入，然后去掉一个维度以聚合得到一个子cuboid。举个例子，cuboid ABCD去掉A得到BCD，去掉B得到ACD。</p>
+
+<p>有些cuboid可以从一个以上的父cuboid聚合得到，这种情况下，Kylin会选择最小的一个父cuboid。举例,AB可以从ABC(id:1110)和ABD(id:1101)生成，则ABD会被选中，因为它的比ABC要小。在这基础上，如果D的基数较小，聚合运算的成本就会比较低。所以，当设计rowkey序列的时候，请记得将基数较小的维度放在末尾。这样不仅有利于cube构建，而且有助于cube查询，因为预聚合也遵循相同的规则。</p>
+
+<p>通常来说，从N维到(N/2)维的构建比较慢，因为这是cuboid数量爆炸性增长的阶段：N维有1个cuboid，(N-1)维有N个cuboid，(N-2)维有N*(N-1)个cuboid，以此类推。经过(N/2)维构建的步骤，整个构建任务会逐渐变快。</p>
+
+<h2 id="cube">构建cube</h2>
+
+<p>这个步骤使用一个新的算法来构建cube：“逐片”构建（也称为“内存”构建）。它会使用一轮MR来计算所有的cuboids，但是比通常情况下更耗内存。配置文件”conf/kylin_job_inmem.xml”正是为这步而设。默认情况下它为每个mapper申请3GB内存。如果你的集群有充足的内存，你可以在上述配置文件中分配更多内存给mapper，这样它会用尽可能多的内存来缓存数据以获得更好的性能，比如：</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>&lt;property&gt;
+    &lt;name&gt;mapreduce.map.memory.mb&lt;/name&gt;
+    &lt;value&gt;6144&lt;/value&gt;
+    &lt;description&gt;&lt;/description&gt;
+&lt;/property&gt;
+
+&lt;property&gt;
+    &lt;name&gt;mapreduce.map.java.opts&lt;/name&gt;
+    &lt;value&gt;-Xmx5632m&lt;/value&gt;
+    &lt;description&gt;&lt;/description&gt;
+&lt;/property&gt;
+</code></pre>
+</div>
+
+<p>请注意，Kylin会根据数据分布（从cube的统计数据里获得）自动选择最优的算法，没有被选中的算法对应的步骤会被跳过。你不需要显式地选择构建算法。</p>
+
+<h2 id="cuboidhfile">将cuboid数据转换为HFile</h2>
+
+<p>这一步启动一个MR任务来讲cuboid文件（序列文件格式）转换为HBase的HFile格式。Kylin通过cube统计数据计算HBase的region数目，默认情况下每5GB数据对应一个region。Region越多，MR使用的reducer也会越多。如果你观察到reducer数目较小且性能较差，你可以将“conf/kylin.properties”里的以下参数设小一点，比如：</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>kylin.hbase.region.cut=2
+kylin.hbase.hfile.size.gb=1
+</code></pre>
+</div>
+
+<p>如果你不确定一个region应该是多大时，联系你的HBase管理员。</p>
+
+<h2 id="hfilehbase">将HFile导入HBase表</h2>
+
+<p>这一步使用HBase API来讲HFile导入region server，这是轻量级并快速的一步。</p>
+
+<h2 id="cube-1">更新cube信息</h2>
+
+<p>在导入数据到HBase后，Kylin在元数据中将对应的cube segment标记为ready。</p>
+
+<h2 id="section-3">清理资源</h2>
+
+<p>将中间宽表从Hive删除。这一步不会阻塞任何操作，因为在前一步segment已经被标记为ready。如果这一步发生错误，不用担心，垃圾回收工作可以晚些再通过Kylin的<a href="howto_cleanup_storage.html">StorageCleanupJob</a>完成。</p>
+
+<h2 id="section-4">总结</h2>
+<p>还有非常多其他提高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>
+
+							</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/cn/docs21/index.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/index.html?rev=1822299&r1=1822298&r2=1822299&view=diff
==============================================================================
--- kylin/site/cn/docs21/index.html (original)
+++ kylin/site/cn/docs21/index.html Fri Jan 26 14:02:04 2018
@@ -251,6 +251,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/cn/docs21/index.html" class="list-group-item-lay pjaxlink" id="navlist">概述</a></li>      
       
 
@@ -358,16 +368,37 @@
     
   
     
-  
+      <li><a href="/cn/docs21/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">手动安装指南</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
     
-  
+    <li><a href="#title教程" data-toggle="collapse" id="navtitle">教程</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
     
+
+
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -411,18 +442,8 @@
   
     
   
-
-
-
-  
-
-  
     
   
-
-
-
-  
     
   
     
@@ -466,12 +487,19 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 创建教程</a></li>      
+      
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -488,38 +516,9 @@
     
   
     
-      <li><a href="/cn/docs21/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">手动安装指南</a></li>      
-      
-
-
-
-
-
-
-
-        <ul>
-  </div>
-</div>
-    
-    <li><a href="#title教程" data-toggle="collapse" id="navtitle">教程</a></li>
-    <div class="collapse in">
-  	<div class="list-group" id="list1">
-    <ul style="list-style-type:disc">
-    
-
-
-
-
-
-  
-
   
     
   
-
-
-
-  
     
   
     
@@ -593,9 +592,20 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建立和Job监控教程</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -648,17 +658,13 @@
   
     
   
-
-
-
+    
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -683,9 +689,20 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 权限授予教程</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -741,19 +758,12 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建立和Job监控教程</a></li>      
-      
-
-
-
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -828,7 +838,7 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 权限授予教程</a></li>      
+      <li><a href="/cn/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin网页版教程</a></li>      
       
 
 
@@ -967,7 +977,9 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin网页版教程</a></li>      
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau教程</a></li>      
       
 
 
@@ -1098,7 +1110,21 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau教程</a></li>      
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 教程</a></li>      
       
 
 
@@ -1227,13 +1253,7 @@
     
   
     
-  
-    
-  
-    
-  
-    
-      <li><a href="/cn/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 教程</a></li>      
+      <li><a href="/cn/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软Excel及Power BI教程</a></li>      
       
 
 
@@ -1352,7 +1372,13 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软Excel及Power BI教程</a></li>      
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱动程序教程</a></li>      
       
 
 
@@ -1445,9 +1471,38 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">与Qlik Sense集成</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title帮助" data-toggle="collapse" id="navtitle">帮助</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1459,15 +1514,36 @@
     
   
     
+      <li><a href="/cn/docs21/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">备份元数据</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
   
     
-      <li><a href="/cn/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱动程序教程</a></li>      
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">用API构建cube</a></li>      
       
 
 
@@ -1500,9 +1576,20 @@
     
   
     
+      <li><a href="/cn/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">清理存储</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1530,9 +1617,20 @@
     
   
     
+      <li><a href="/cn/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1550,7 +1648,23 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">与Qlik Sense集成</a></li>      
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">优化cube构建</a></li>      
       
 
 

Modified: kylin/site/cn/docs21/install/index.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/install/index.html?rev=1822299&r1=1822298&r2=1822299&view=diff
==============================================================================
--- kylin/site/cn/docs21/install/index.html (original)
+++ kylin/site/cn/docs21/install/index.html Fri Jan 26 14:02:04 2018
@@ -257,6 +257,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/index.html" class="list-group-item-lay pjaxlink" id="navlist">Overview</a></li>      
       
 
@@ -339,6 +349,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Release Notes</a></li>      
       
 
@@ -529,6 +549,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/install/index.html" class="list-group-item-lay pjaxlink" id="navlist">Installation Guide</a></li>      
       
 
@@ -597,6 +627,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/install/hadoop_env.html" class="list-group-item-lay pjaxlink" id="navlist">Hadoop Environment</a></li>      
       
 
@@ -740,6 +780,16 @@
   
     
   
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
 
 
 
@@ -814,6 +864,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/install/kylin_cluster.html" class="list-group-item-lay pjaxlink" id="navlist">Deploy in Cluster Mode</a></li>      
       
 
@@ -880,6 +940,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/install/advance_settings.html" class="list-group-item-lay pjaxlink" id="navlist">Advanced Settings</a></li>      
       
 
@@ -958,6 +1028,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">Run Kylin with Docker</a></li>      
       
 
@@ -1032,6 +1112,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink" id="navlist">Install Kylin on AWS EMR</a></li>      
       
 
@@ -1162,6 +1252,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>      
       
 
@@ -1304,6 +1404,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li>      
       
 
@@ -1398,6 +1508,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li>      
       
 
@@ -1496,6 +1616,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li>      
       
 
@@ -1586,6 +1716,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission (v2.1.x)</a></li>      
       
 
@@ -1710,6 +1850,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink" id="navlist">Project Level ACL</a></li>      
       
 
@@ -1812,6 +1962,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark</a></li>      
       
 
@@ -1912,6 +2072,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</a></li>      
       
 
@@ -2048,6 +2218,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>      
       
 
@@ -2084,6 +2264,14 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li>      
       
 
@@ -2218,6 +2406,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>      
       
 
@@ -2356,6 +2554,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>      
       
 
@@ -2478,6 +2686,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>      
       
 
@@ -2592,6 +2810,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li>      
       
 
@@ -2722,6 +2950,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li>      
       
 
@@ -2828,6 +3066,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li>      
       
 
@@ -2936,6 +3184,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</a></li>      
       
 
@@ -3022,6 +3280,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li>      
       
 
@@ -3098,6 +3366,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>      
       
 
@@ -3126,6 +3404,10 @@
     
   
     
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li>      
       
 
@@ -3168,6 +3450,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Design</a></li>      
       
 
@@ -3208,6 +3500,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Build</a></li>      
       
 
@@ -3234,6 +3536,8 @@
     
   
     
+  
+    
       <li><a href="/docs21/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>      
       
 
@@ -3264,6 +3568,12 @@
     
   
     
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li>      
       
 
@@ -3300,6 +3610,14 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li>      
       
 
@@ -3348,6 +3666,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade From Old Versions</a></li>      
       
 
@@ -3386,6 +3714,14 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li>      
       
 
@@ -3436,6 +3772,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li>      
       
 
@@ -3482,6 +3828,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li>      
       
 
@@ -3516,6 +3872,12 @@
     
   
     
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_install_ranger_kylin_plugin.html" class="list-group-item-lay pjaxlink" id="navlist">The Ranger Kylin Plugin Installation Guide</a></li>      
       
 
@@ -3548,6 +3910,12 @@
     
   
     
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_enable_zookeeper_acl.html" class="list-group-item-lay pjaxlink" id="navlist">Enable zookeeper acl</a></li>      
       
 
@@ -3592,6 +3960,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_setup_systemcube.html" class="list-group-item-lay pjaxlink" id="navlist">Set Up System Cube</a></li>      
       
 
@@ -3644,6 +4022,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/docs21/howto/howto_use_cube_planner.html" class="list-group-item-lay pjaxlink" id="navlist">Use Cube Planner</a></li>      
       
 
@@ -3661,6 +4049,16 @@
   
     
   
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
     
   
     

Modified: kylin/site/cn/docs21/install/manual_install_guide.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/install/manual_install_guide.html?rev=1822299&r1=1822298&r2=1822299&view=diff
==============================================================================
--- kylin/site/cn/docs21/install/manual_install_guide.html (original)
+++ kylin/site/cn/docs21/install/manual_install_guide.html Fri Jan 26 14:02:04 2018
@@ -251,6 +251,16 @@
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li><a href="/cn/docs21/index.html" class="list-group-item-lay pjaxlink" id="navlist">概述</a></li>      
       
 
@@ -358,16 +368,37 @@
     
   
     
-  
+      <li><a href="/cn/docs21/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">手动安装指南</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
     
-  
+    <li><a href="#title教程" data-toggle="collapse" id="navtitle">教程</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
     
+
+
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -411,18 +442,8 @@
   
     
   
-
-
-
-  
-
-  
     
   
-
-
-
-  
     
   
     
@@ -466,12 +487,19 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 创建教程</a></li>      
+      
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -488,38 +516,9 @@
     
   
     
-      <li><a href="/cn/docs21/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">手动安装指南</a></li>      
-      
-
-
-
-
-
-
-
-        <ul>
-  </div>
-</div>
-    
-    <li><a href="#title教程" data-toggle="collapse" id="navtitle">教程</a></li>
-    <div class="collapse in">
-  	<div class="list-group" id="list1">
-    <ul style="list-style-type:disc">
-    
-
-
-
-
-
-  
-
   
     
   
-
-
-
-  
     
   
     
@@ -593,9 +592,20 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建立和Job监控教程</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -648,17 +658,13 @@
   
     
   
-
-
-
+    
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -683,9 +689,20 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 权限授予教程</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -741,19 +758,12 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建立和Job监控教程</a></li>      
-      
-
-
-
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -828,7 +838,7 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 权限授予教程</a></li>      
+      <li><a href="/cn/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin网页版教程</a></li>      
       
 
 
@@ -967,7 +977,9 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin网页版教程</a></li>      
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau教程</a></li>      
       
 
 
@@ -1098,7 +1110,21 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau教程</a></li>      
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 教程</a></li>      
       
 
 
@@ -1227,13 +1253,7 @@
     
   
     
-  
-    
-  
-    
-  
-    
-      <li><a href="/cn/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 教程</a></li>      
+      <li><a href="/cn/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软Excel及Power BI教程</a></li>      
       
 
 
@@ -1352,7 +1372,13 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软Excel及Power BI教程</a></li>      
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱动程序教程</a></li>      
       
 
 
@@ -1445,9 +1471,38 @@
     
   
     
+      <li><a href="/cn/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">与Qlik Sense集成</a></li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title帮助" data-toggle="collapse" id="navtitle">帮助</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    
+
+
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1459,15 +1514,36 @@
     
   
     
+      <li><a href="/cn/docs21/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">备份元数据</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
   
     
-      <li><a href="/cn/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱动程序教程</a></li>      
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">用API构建cube</a></li>      
       
 
 
@@ -1500,9 +1576,20 @@
     
   
     
+      <li><a href="/cn/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">清理存储</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1530,9 +1617,20 @@
     
   
     
+      <li><a href="/cn/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1550,7 +1648,23 @@
     
   
     
-      <li><a href="/cn/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">与Qlik Sense集成</a></li>      
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li><a href="/cn/docs21/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">优化cube构建</a></li>