You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by lu...@apache.org on 2015/06/05 03:34:08 UTC

svn commit: r1683654 [4/4] - in /incubator/kylin/site: 2014/ 2014/10/ 2014/10/24/ 2014/10/24/How-to-Contribute/ development/ development/2014/ development/2014/10/ development/2014/10/23/ development/2014/10/23/Kylin-web-front-end-summary/ development/...

Added: incubator/kylin/site/教程/2015/04/17/Kylin和Tableau教程/index.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/index.html?rev=1683654&view=auto
==============================================================================
--- incubator/kylin/site/教程/2015/04/17/Kylin和Tableau教程/index.html (added)
+++ incubator/kylin/site/教程/2015/04/17/Kylin和Tableau教程/index.html Fri Jun  5 01:34:07 2015
@@ -0,0 +1,529 @@
+<!--
+* 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和Tableau教程</title>
+  <meta name="description" content="  Kylin ODBC驱动程序与Tableau存在一些限制，请在尝试前仔细阅读本说明书。* 仅支持“managed”分析路径，Kylin引擎将对意外的维度或度量报错* 请始终优先选择事实表，然后使用正确的连接条件添加查找表（cube中已定义的连接类型）* 请勿尝试在多个事实表或多个查找表之间进行连接；* 你可以...">
+  <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://kyli.io/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/">
+  <link rel="alternate" type="application/rss+xml" title="kylin.io" href="http://kyli.io/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.incubator.apache.org
+  ga('create', 'UA-55534813-2', 'auto', {'name':'incubator'});
+
+  ga('send', 'pageview');
+  ga('incubator.send', 'pageview');
+
+
+</script>
+<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/assets/js/nside.js"></script> </script>
+<script type="text/javascript" src="/assets/js/nnav.js"></script> </script>
+</head>
+
+	<body>
+		<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<header id="header" >
+  <div id="head" class="parallax" parallax-speed="3" >
+    <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="/assets/images/kylin_logo.jpg"> <span class="title" >Apache Kylin</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> 
+    </div>
+  </div>
+
+  <!-- Main Menu -->
+  <nav class="navbar navbar-default" role="navigation" id="nav-wrapper">
+  <div class="container-fluid" id="nav">
+    <!-- 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/docs" >文档</a></li>
+          <li><a href="/community" >社区</a></li>
+          <li><a href="/blog">博客</li>
+          <li><a href="/download">下载</li>
+          <li><a href="/about" >关于</a></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/incubator-kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/incubator-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">
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+        
+
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        <li><a href="#安装" data-toggle="collapse" id="navtitle">安装</a></li>
+        <div class="collapse in" id="安装">
+            <div class="list-group" id="list2">
+                <ul style="list-style-type:disc">
+                    
+                    <li><a href="/%E5%AE%89%E8%A3%85/2015/01/22/Kylin%E6%89%8B%E5%8A%A8%E5%AE%89%E8%A3%85%E6%8C%87%E5%8D%97/" class="list-group-item-lay pjaxlink">Kylin手动安装指南</a></li>
+                    
+                    <ul>
+            </div>
+        </div>
+        
+        
+        
+        
+        
+        
+
+        
+        
+        
+        
+        
+        
+        <li><a href="#教程" data-toggle="collapse" id="navtitle">教程</a></li>
+        <div class="collapse in" id="教程">
+            <div class="list-group" id="list3">
+                <ul style="list-style-type:disc">
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin网页版教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin和Tableau教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/11/Kylin-Cube-%E6%9D%83%E9%99%90%E6%8E%88%E4%BA%88%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin Cube 权限授予教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/06/Kylin-Cube-%E5%BB%BA%E7%AB%8B%E5%92%8CJob%E7%9B%91%E6%8E%A7%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin Cube 建立和Job监控教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/05/kylin-cube-%E5%88%9B%E5%BB%BA%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin Cube 创建教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/05/Kylin-ODBC-%E9%A9%B1%E5%8A%A8%E7%A8%8B%E5%BA%8F%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin ODBC 驱动程序教程</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">
+							<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:1.5em 4em 4em 4em">
+
+  <header class="post-header">
+    <h1 class="post-title">Kylin和Tableau教程</h1>
+    <p class="post-meta" >Apr 17, 2015</p>
+  </header>
+
+  <article class="post-content" >
+    <blockquote>
+  <p>Kylin ODBC驱动程序与Tableau存在一些限制，请在尝试前仔细阅读本说明书。
+* 仅支持“managed”分析路径，Kylin引擎将对意外的维度或度量报错
+* 请始终优先选择事实表，然后使用正确的连接条件添加查找表（cube中已定义的连接类型）
+* 请勿尝试在多个事实表或多个查找表之间进行连接；
+* 你可以尝试使用类似Tableau过滤器中seller id这样的高基数维度，但引擎现在将只返回有限个Tableau过滤器中的seller id。</p>
+
+  <p>如需更多详细信息或有任何问题，请联系Kylin团队：<code>kylinolap@gmail.com</code></p>
+</blockquote>
+
+<h3 id="odbc">步骤1. 安装ODBC驱动程序</h3>
+<p>参见维基页面<a href="https://github.com/KylinOLAP/Kylin/wiki/Kylin-ODBC-Driver-Tutorial">Kylin ODBC Driver Tutorial</a>。</p>
+
+<h3 id="kylin">步骤2. 连接到Kylin服务器</h3>
+<blockquote>
+  <p>我们建议使用Connect Using Driver而不是Using DSN，因为Tableau团队将不会在Tableau服务器上管理你的DSN。</p>
+</blockquote>
+
+<p>Connect Using Driver: 选择左侧面板中的“Other Database(ODBC)”和弹出窗口的“KylinODBCDriver”。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/1 odbc.png" alt="" /></p>
+
+<p>输入你的服务器位置和证书：服务器主机，端口，用户名和密码。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/2 serverhost.jpg" alt="" /></p>
+
+<p>点击“Connect”获取你有权限访问的项目列表。有关权限的详细信息请参考<a href="https://github.com/KylinOLAP/Kylin/wiki/Kylin-Cube-Permission-Grant-Tutorial">Kylin Cube Permission Grant Tutorial</a>。然后在下拉列表中选择你想要连接的项目。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/3 project.jpg" alt="" /></p>
+
+<p>点击“Done”完成连接。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/4 done.jpg" alt="" /></p>
+
+<h3 id="section">步骤3. 使用单表或多表</h3>
+<blockquote>
+  <p>限制
+   * 必须首先选择事实表
+   * 请勿仅支持从查找表选择
+   * 连接条件必须与cube定义匹配</p>
+</blockquote>
+
+<p><strong>选择事实表</strong></p>
+
+<p>选择<code>Multiple Tables</code>。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/5 multipleTable.jpg" alt="" /></p>
+
+<p>然后点击<code>Add Table...</code>添加一张事实表。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/6 facttable.jpg" alt="" /></p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/6 facttable2.jpg" alt="" /></p>
+
+<p><strong>选择查找表</strong></p>
+
+<p>点击<code>Add Table...</code>添加一张查找表。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/7 lkptable.jpg" alt="" /></p>
+
+<p>仔细建立连接条款。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/8 join.jpg" alt="" /></p>
+
+<p>继续通过点击<code>Add Table...</code>添加表直到所有的查找表都被正确添加。命名此连接以在Tableau中使用。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/9 connName.jpg" alt="" /></p>
+
+<p><strong>使用Connect Live</strong></p>
+
+<p><code>Data Connection</code>共有三种类型。选择<code>Connect Live</code>选项。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/10 connectLive.jpg" alt="" /></p>
+
+<p>然后你就能够尽情使用Tableau进行分析。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/11 analysis.jpg" alt="" /></p>
+
+<p><strong>添加额外查找表</strong></p>
+
+<p>点击顶部菜单栏的<code>Data</code>，选择<code>Edit Tables...</code>更新查找表信息。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/12 edit tables.jpg" alt="" /></p>
+
+<h3 id="sql">步骤4. 使用自定义SQL</h3>
+<p>使用自定义SQL类似于使用单表/多表，但你需要在<code>Custom SQL</code>标签复制你的SQL后采取同上指令。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/19 custom.jpg" alt="" /></p>
+
+<h3 id="tableau">步骤5. 发布到Tableau服务器</h3>
+<p>如果你已经完成使用Tableau制作一个仪表板，你可以将它发布到Tableau服务器上。
+点击顶部菜单栏的<code>Server</code>，选择<code>Publish Workbook...</code>。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/14 publish.jpg" alt="" /></p>
+
+<p>然后登陆你的Tableau服务器并准备发布。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/16 prepare-publish.png" alt="" /></p>
+
+<p>如果你正在使用Connect Using Driver而不是DSN连接，你还将需要嵌入你的密码。点击左下方的<code>Authentication</code>按钮并选择<code>Embedded Password</code>。点击<code>Publish</code>然后你将看到结果。</p>
+
+<p><img src="/images/Kylin-and-Tableau-Tutorial/17 embedded-pwd.png" alt="" /></p>
+
+<h3 id="section-1">小贴士</h3>
+<ul>
+  <li>
+    <p>在Tableau中隐藏表名</p>
+
+    <ul>
+      <li>Tableau将会根据源表名分组显示列，但用户可能希望根据其他不同的安排组织列。使用Tableau中的”Group by Folder”并创建文件夹来对不同的列分组。</li>
+    </ul>
+
+    <p><img src="/images/Kylin-and-Tableau-Tutorial/18 groupby-folder.jpg" alt="" /></p>
+  </li>
+</ul>
+
+  </article>
+
+</div>
+
+
+
+
+
+						</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">
+          <div>
+          Apache Kylin is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.
+          </div>
+          <p style="text-align:center" > Apache Kylin is distributed under the <a href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank">Apache License v2.0. </a>
+          </p>
+        </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: incubator/kylin/site/教程/2015/04/17/Kylin网页版教程/index.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/index.html?rev=1683654&view=auto
==============================================================================
--- incubator/kylin/site/教程/2015/04/17/Kylin网页版教程/index.html (added)
+++ incubator/kylin/site/教程/2015/04/17/Kylin网页版教程/index.html Fri Jun  5 01:34:07 2015
@@ -0,0 +1,582 @@
+<!--
+* 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网页版教程</title>
+  <meta name="description" content="  支持的浏览器  Windows: Google Chrome, FireFox  Mac: Google Chrome, FireFox, Safari">
+  <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://kyli.io/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/">
+  <link rel="alternate" type="application/rss+xml" title="kylin.io" href="http://kyli.io/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.incubator.apache.org
+  ga('create', 'UA-55534813-2', 'auto', {'name':'incubator'});
+
+  ga('send', 'pageview');
+  ga('incubator.send', 'pageview');
+
+
+</script>
+<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/assets/js/nside.js"></script> </script>
+<script type="text/javascript" src="/assets/js/nnav.js"></script> </script>
+</head>
+
+	<body>
+		<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<header id="header" >
+  <div id="head" class="parallax" parallax-speed="3" >
+    <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="/assets/images/kylin_logo.jpg"> <span class="title" >Apache Kylin</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> 
+    </div>
+  </div>
+
+  <!-- Main Menu -->
+  <nav class="navbar navbar-default" role="navigation" id="nav-wrapper">
+  <div class="container-fluid" id="nav">
+    <!-- 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/docs" >文档</a></li>
+          <li><a href="/community" >社区</a></li>
+          <li><a href="/blog">博客</li>
+          <li><a href="/download">下载</li>
+          <li><a href="/about" >关于</a></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/incubator-kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/incubator-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">
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+             <!-- categories -->
+        
+        
+
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        
+        <li><a href="#安装" data-toggle="collapse" id="navtitle">安装</a></li>
+        <div class="collapse in" id="安装">
+            <div class="list-group" id="list2">
+                <ul style="list-style-type:disc">
+                    
+                    <li><a href="/%E5%AE%89%E8%A3%85/2015/01/22/Kylin%E6%89%8B%E5%8A%A8%E5%AE%89%E8%A3%85%E6%8C%87%E5%8D%97/" class="list-group-item-lay pjaxlink">Kylin手动安装指南</a></li>
+                    
+                    <ul>
+            </div>
+        </div>
+        
+        
+        
+        
+        
+        
+
+        
+        
+        
+        
+        
+        
+        <li><a href="#教程" data-toggle="collapse" id="navtitle">教程</a></li>
+        <div class="collapse in" id="教程">
+            <div class="list-group" id="list3">
+                <ul style="list-style-type:disc">
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin网页版教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin和Tableau教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/11/Kylin-Cube-%E6%9D%83%E9%99%90%E6%8E%88%E4%BA%88%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin Cube 权限授予教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/06/Kylin-Cube-%E5%BB%BA%E7%AB%8B%E5%92%8CJob%E7%9B%91%E6%8E%A7%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin Cube 建立和Job监控教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/05/kylin-cube-%E5%88%9B%E5%BB%BA%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin Cube 创建教程</a></li>
+                    
+                    <li><a href="/%E6%95%99%E7%A8%8B/2014/11/05/Kylin-ODBC-%E9%A9%B1%E5%8A%A8%E7%A8%8B%E5%BA%8F%E6%95%99%E7%A8%8B/" class="list-group-item-lay pjaxlink">Kylin ODBC 驱动程序教程</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">
+							<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:1.5em 4em 4em 4em">
+
+  <header class="post-header">
+    <h1 class="post-title">Kylin网页版教程</h1>
+    <p class="post-meta" >Apr 17, 2015</p>
+  </header>
+
+  <article class="post-content" >
+    <blockquote>
+  <p><strong>支持的浏览器</strong></p>
+
+  <p>Windows: Google Chrome, FireFox</p>
+
+  <p>Mac: Google Chrome, FireFox, Safari</p>
+</blockquote>
+
+<h2 id="section">1. 访问 &amp; 登陆</h2>
+<p>访问主机: http://your_sandbox_ip:9080
+使用用户名/密码登陆：ADMIN/KYLIN</p>
+
+<p><img src="/images/Kylin-Web-Tutorial/1 login.png" alt="" /></p>
+
+<h2 id="kylinhive">2. Kylin中可用的Hive表</h2>
+<p>虽然Kylin使用SQL作为查询接口并利用Hive元数据，Kylin不会让用户查询所有的hive表，因为到目前为止它是一个预构建OLAP(MOLAP)系统。为了使表在Kylin中可用，使用”Sync”方法能够方便地从Hive中同步表。</p>
+
+<p><img src="/images/Kylin-Web-Tutorial/2 tables.png" alt="" /></p>
+
+<h2 id="kylin-olap-cube">3. Kylin OLAP Cube</h2>
+<p>Kylin的OLAP Cube是从星型模式的Hive表中获取的预计算数据集，这是供用户探索、管理所有cube的网页管理页面。由菜单栏进入<code>Cubes</code>页面，系统中所有可用的cube将被列出。</p>
+
+<p><img src="/images/Kylin-Web-Tutorial/3 cubes.png" alt="" /></p>
+
+<p>探索更多关于Cube的详细信息</p>
+
+<ul>
+  <li>
+    <p>表格视图:</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/4 form-view.png" alt="" /></p>
+  </li>
+  <li>
+    <p>SQL 视图 (Hive查询读取数据以生成cube):</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/5 sql-view.png" alt="" /></p>
+  </li>
+  <li>
+    <p>可视化 (显示这个cube背后的星型模式):</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/6 visualization.png" alt="" /></p>
+  </li>
+  <li>
+    <p>访问 (授予用户/角色权限，beta版中授予权限操作仅对管理员开放):</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/7 access.png" alt="" /></p>
+  </li>
+</ul>
+
+<h2 id="sql">4. 在网页上编写和运行SQL</h2>
+<p>Kelin的网页版为用户提供了一个简单的查询工具来运行SQL以探索现存的cube，验证结果并探索使用#5中的Pivot analysis与可视化分析的结果集。</p>
+
+<blockquote>
+  <p><strong>查询限制</strong></p>
+
+  <ol>
+    <li>
+      <p>仅支持SELECT查询</p>
+    </li>
+    <li>
+      <p>为了避免从服务器到客户端产生巨大的网络流量，beta版中的扫描范围阀值被设置为1,000,000。</p>
+    </li>
+    <li>
+      <p>beta版中，SQL在cube中无法找到的数据将不会重定向到Hive</p>
+    </li>
+  </ol>
+</blockquote>
+
+<p>由菜单栏进入“Query”页面：</p>
+
+<p><img src="/images/Kylin-Web-Tutorial/8 query.png" alt="" /></p>
+
+<ul>
+  <li>
+    <p>源表：</p>
+
+    <p>浏览器当前可用表（与Hive相同的结构和元数据）：</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/9 query-table.png" alt="" /></p>
+  </li>
+  <li>
+    <p>新的查询：</p>
+
+    <p>你可以编写和运行你的查询并探索结果。这里提供一个查询供你参考：</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/10 query-result.png" alt="" /></p>
+  </li>
+  <li>
+    <p>已保存的查询：</p>
+
+    <p>与用户账号关联，你将能够从不同的浏览器甚至机器上获取已保存的查询。
+ 在结果区域点击“Save”，将会弹出名字和描述来保存当前查询：</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/11 save-query.png" alt="" /></p>
+
+    <p>点击“Saved Queries”探索所有已保存的查询，你可以直接重新提交它来运行或删除它：</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/11 save-query-2.png" alt="" /></p>
+  </li>
+  <li>
+    <p>查询历史：</p>
+
+    <p>仅保存当前用户在当前浏览器中的查询历史，这将需要启用cookie，并且如果你清理浏览器缓存将会丢失数据。点击“Query History”标签，你可以直接重新提交其中的任何一条并再次运行。</p>
+  </li>
+</ul>
+
+<h2 id="pivot-analysis">5. Pivot Analysis与可视化</h2>
+<p>Kylin的网页版提供一个简单的Pivot与可视化分析工具供用户探索他们的查询结果：</p>
+
+<ul>
+  <li>
+    <p>一般信息：</p>
+
+    <p>当查询运行成功后，它将呈现一个成功指标与被访问的cube名字。
+ 同时它将会呈现这个查询在后台引擎运行了多久（不包括从Kylin服务器到浏览器的网络通信）：</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/12 general.png" alt="" /></p>
+  </li>
+  <li>
+    <p>查询结果：</p>
+
+    <p>能够方便地在一个列上排序。</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/13 results.png" alt="" /></p>
+  </li>
+  <li>
+    <p>导出到CSV文件</p>
+
+    <p>点击“Export”按钮以CSV文件格式保存当前结果。</p>
+  </li>
+  <li>
+    <p>Pivot表：</p>
+
+    <p>将一个或多个列拖放到标头，结果将根据这些列的值分组：</p>
+
+    <p><img src="/images/Kylin-Web-Tutorial/14 drag.png" alt="" /></p>
+  </li>
+  <li>
+    <p>可视化：</p>
+
+    <p>同时，结果集将被方便地显示在“可视化”的不同图表中：</p>
+
+    <p>注意：线形图仅当至少一个从Hive表中获取的维度有真实的“Date”数据类型列时才是可用的。</p>
+
+    <ul>
+      <li>条形图：</li>
+    </ul>
+
+    <p><img src="/images/Kylin-Web-Tutorial/15 bar-chart.png" alt="" /></p>
+
+    <ul>
+      <li>饼图：</li>
+    </ul>
+
+    <p><img src="/images/Kylin-Web-Tutorial/16 pie-chart.png" alt="" /></p>
+
+    <ul>
+      <li>线形图：</li>
+    </ul>
+
+    <p><img src="/images/Kylin-Web-Tutorial/17 line-chart.png" alt="" /></p>
+  </li>
+</ul>
+
+<h2 id="cube-job">6. Cube建立 Job监控</h2>
+<p>监控和管理cube建立过程与诊断的详细信息，甚至直接连接到Hadoop的job信息：</p>
+
+<p><img src="/images/Kylin-Web-Tutorial/7 job-steps.png" alt="" /></p>
+
+  </article>
+
+</div>
+
+
+
+
+
+						</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">
+          <div>
+          Apache Kylin is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.
+          </div>
+          <p style="text-align:center" > Apache Kylin is distributed under the <a href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank">Apache License v2.0. </a>
+          </p>
+        </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>