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 2016/03/16 10:12:37 UTC
svn commit: r1735201 [6/7] - in /kylin/site: ./ cn/docs/install/
cn/docs/tutorial/ community/ docs/ docs/gettingstarted/ docs/howto/
docs/install/ docs/tutorial/ docs15/ docs15/gettingstarted/ docs15/howto/
docs15/install/ docs15/tutorial/ images/tutor...
Modified: kylin/site/docs15/tutorial/create_cube.html
URL: http://svn.apache.org/viewvc/kylin/site/docs15/tutorial/create_cube.html?rev=1735201&r1=1735200&r2=1735201&view=diff
==============================================================================
--- kylin/site/docs15/tutorial/create_cube.html (original)
+++ kylin/site/docs15/tutorial/create_cube.html Wed Mar 16 09:12:34 2016
@@ -41,7 +41,7 @@
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
- <title>Apache Kylin | Kylin Cube Creation Tutorial</title>
+ <title>Apache Kylin | Kylin Cube Creation</title>
<meta name="description" content="Apache Kylin Home">
<meta name="author" content="Apache Kylin">
<link rel="shortcut icon" href="fav.png" type="image/png">
@@ -278,10 +278,6 @@
-
-
-
-
<li><a href="/docs15/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Kylin⢠Release Notes</a></li>
@@ -530,8 +526,23 @@
- <li><a href="/docs15/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">Manual Installation Guide</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -682,8 +693,25 @@
- <li><a href="/docs15/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">On Hadoop Kylin installation using Docker</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -762,10 +790,6 @@
-
-
-
-
<li><a href="/docs15/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>
@@ -824,11 +848,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation Tutorial</a></li>
+ <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li>
@@ -888,11 +908,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+ <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li>
@@ -948,11 +964,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission Grant Tutorial</a></li>
+ <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li>
@@ -1024,11 +1036,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Tutorial</a></li>
+ <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li>
@@ -1096,11 +1104,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>
@@ -1170,11 +1174,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>
@@ -1240,11 +1240,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI Tutorial</a></li>
+ <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>
@@ -1308,11 +1304,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver Tutorial</a></li>
+ <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>
@@ -1358,7 +1350,7 @@
- <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Build Cube with Restful API</a></li>
+ <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li>
@@ -1400,7 +1392,7 @@
- <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API in Javascript</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li>
@@ -1440,7 +1432,7 @@
- <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>
@@ -1476,7 +1468,7 @@
- <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">How to Optimize Cubes</a></li>
+ <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube</a></li>
@@ -1502,7 +1494,7 @@
- <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">How to Backup Metadata</a></li>
+ <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>
@@ -1532,7 +1524,7 @@
- <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">How to Cleanup Storage (HDFS & HBase Tables)</a></li>
+ <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase Tables)</a></li>
@@ -1564,7 +1556,7 @@
- <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use kylin Remote JDBC Driver</a></li>
+ <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use kylin Remote JDBC Driver</a></li>
@@ -1602,7 +1594,7 @@
- <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">How to Upgrade</a></li>
+ <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade from old version</a></li>
@@ -1636,7 +1628,7 @@
- <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">How to Enable Security with LDAP and SSO</a></li>
+ <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li>
@@ -1656,101 +1648,172 @@
<div class="col-md-9 col-lg-9 col-xs-14 aside2">
<div id="container">
<div id="pjax">
- <h1 class="post-title">Kylin Cube Creation Tutorial</h1>
+ <h1 class="post-title">Kylin Cube Creation</h1>
<article class="post-content" >
- <h3 id="i-create-a-project">I. Create a Project</h3>
+ <p>This tutorial will guide you to create a cube. It need you have at least 1 sample table in Hive. If you donât have, you can follow this to create some data.</p>
+
+<h3 id="i-create-a-project">I. Create a Project</h3>
<ol>
<li>
<p>Go to <code class="highlighter-rouge">Query</code> page in top menu bar, then click <code class="highlighter-rouge">Manage Projects</code>.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/1 manage-prject.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/1 manage-prject.png" alt="" /></p>
</li>
<li>
<p>Click the <code class="highlighter-rouge">+ Project</code> button to add a new project.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/2 +project.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/2 +project.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Enter a project name, e.g, âTutorialâ, with a description (optional), then click <code class="highlighter-rouge">submit</code> button to send the request.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3 new-project.png" alt="" /></p>
+ </li>
+ <li>
+ <p>After success, the project will show in the table.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3.1 pj-created.png" alt="" /></p>
+ </li>
+</ol>
+
+<h3 id="ii-sync-up-hive-table">II. Sync up Hive Table</h3>
+<ol>
+ <li>
+ <p>Click <code class="highlighter-rouge">Model</code> in top bar and then click <code class="highlighter-rouge">Data Source</code> tab in the left part, it lists all the tables loaded into Kylin; click <code class="highlighter-rouge">Load Hive Table</code> button.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Enter the hive table names, separated with commad, and then click <code class="highlighter-rouge">Sync</code> to send the request.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>[Optional] If you want to browser the hive database to pick tables, click the <code class="highlighter-rouge">Load Hive Table From Tree</code> button.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table-tree.png" alt="" /></p>
</li>
<li>
- <p>Fulfill the following form and click <code class="highlighter-rouge">submit</code> button to send a request.</p>
+ <p>[Optional] Expand the database node, click to select the table to load, and then click <code class="highlighter-rouge">Sync</code>.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/3 new-project.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-tree.png" alt="" /></p>
</li>
<li>
- <p>After success, there will be a notification show in the bottom.</p>
+ <p>A success message will pop up. In the left <code class="highlighter-rouge">Tables</code> section, the newly loaded table is added. Click the table name will expand the columns.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/3.1 pj-created.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-info.png" alt="" /></p>
+ </li>
+ <li>
+ <p>In the background, Kylin will run a MapReduce job to calculate the approximate cardinality for the newly synced table. After the job be finished, refresh web page and then click the table name, the cardinality will be shown in the table info.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-cardinality.png" alt="" /></p>
</li>
</ol>
-<h3 id="ii-sync-up-a-table">II. Sync up a Table</h3>
+<h3 id="iii-create-data-model">III. Create Data Model</h3>
+<p>Before create a cube, need define a data model. The data model defines the star schema. One data model can be reused in multiple cubes.</p>
+
<ol>
<li>
- <p>Click <code class="highlighter-rouge">Tables</code> in top bar and then click the <code class="highlighter-rouge">+ Sync</code> button to load hive table metadata.</p>
+ <p>Click <code class="highlighter-rouge">Model</code> in top bar, and then click <code class="highlighter-rouge">Models</code> tab. Click <code class="highlighter-rouge">+New</code> button, in the drop-down list select <code class="highlighter-rouge">New Model</code>.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 +model.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Enter a name for the model, with an optional description.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-name.png" alt="" /></p>
+ </li>
+ <li>
+ <p>In the <code class="highlighter-rouge">Fact Table</code> box, select the fact table of this data model.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-fact-table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>[Optional] Click <code class="highlighter-rouge">Add Lookup Table</code> button to add a lookup table. Select the table name and join type (inner or left).</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-lookup-table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>[Optional] Click <code class="highlighter-rouge">New Join Condition</code> button, select the FK column of fact table in the left, and select the PK column of lookup table in the right side. Repeat this if have more than one join columns.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-join-condition.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Click âOKâ, repeat step 4 and 5 to add more lookup tables if any. After finished, click âNextâ.</p>
+ </li>
+ <li>
+ <p>The âDimensionsâ page allows to select the columns that will be used as dimension in the child cubes. Click the <code class="highlighter-rouge">Columns</code> cell of a table, in the drop-down list select the column to the list.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-dimensions.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Click âNextâ go to the âMeasuresâ page, select the columns that will be used in measure/metrics. The measure column can only from fact table.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/4 +table.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-measures.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Click âNextâ to the âSettingsâ page. If the data in fact table increases by day, select the corresponding date column in the <code class="highlighter-rouge">Partition Date Column</code>, and select the date format, otherwise leave it as blank.</p>
+ </li>
+ <li>
+ <p>[Optional] Select <code class="highlighter-rouge">Cube Size</code>, which is an indicator on the scale of the cube, by default it is <code class="highlighter-rouge">MEDIUM</code>.</p>
</li>
<li>
- <p>Enter the table names and click <code class="highlighter-rouge">Sync</code> to send a request.</p>
+ <p>[Optional] If some records want to excluded from the cube, like dirty data, you can input the condition in <code class="highlighter-rouge">Filter</code>.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/5 hive-table.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-partition-column.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Click <code class="highlighter-rouge">Save</code> and then select <code class="highlighter-rouge">Yes</code> to save the data model. After created, the data model will be shown in the left <code class="highlighter-rouge">Models</code> list.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-created.png" alt="" /></p>
</li>
</ol>
-<h3 id="iii-create-a-cube">III. Create a Cube</h3>
-<p>To start with, click <code class="highlighter-rouge">Cubes</code> in top bar.Then click <code class="highlighter-rouge">+Cube</code> button to enter the cube designer page.</p>
+<h3 id="iv-create-cube">IV. Create Cube</h3>
+<p>After the data model be created, you can start to create cube.</p>
-<p><img src="/images/Kylin-Cube-Creation-Tutorial/6 +cube.png" alt="" /></p>
+<p>Click <code class="highlighter-rouge">Model</code> in top bar, and then click <code class="highlighter-rouge">Models</code> tab. Click <code class="highlighter-rouge">+New</code> button, in the drop-down list select <code class="highlighter-rouge">New Cube</code>.</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>
+</code></pre>
+</div>
<p><strong>Step 1. Cube Info</strong></p>
-<p>Fill up the basic information of the cube. Click <code class="highlighter-rouge">Next</code> to enter the next step.</p>
+<p>Select the data model, enter the cube name; Click <code class="highlighter-rouge">Next</code> to enter the next step.</p>
-<p>You can use letters, numbers and â_â to name your cube (Notice that space in name is not allowed).</p>
+<p>You can use letters, numbers and â_â to name your cube (blank space in name is not allowed). <code class="highlighter-rouge">Notification List</code> is a list of email addresses which be notified on cube job success/failure.</p>
-<p><img src="/images/Kylin-Cube-Creation-Tutorial/7 cube-info.png" alt="" /></p>
+<div class="highlighter-rouge"><pre class="highlight"><code>
+</code></pre>
+</div>
<p><strong>Step 2. Dimensions</strong></p>
<ol>
<li>
- <p>Set up the fact table.</p>
-
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-factable.png" alt="" /></p>
+ <p>Click <code class="highlighter-rouge">Add Dimension</code>, it popups two option: âNormalâ and âDerivedâ: âNormalâ is to add a normal independent dimension column, âDerivedâ is to add a derived dimension column. Read more in <a href="/docs15/howto/howto_optimize_cubes.html">How to optimize cubes</a>.</p>
</li>
<li>
- <p>Click <code class="highlighter-rouge">+Dimension</code> to add a new dimension.</p>
+ <p>Click âNormalâ and then select a dimension column, give it a meaningful name.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-+dim.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-normal.png" alt="" /></p>
</li>
<li>
- <p>There are different types of dimensions that might be added to a cube. Here we list some of them for your reference.</p>
+ <p>[Optional] Click âDerivedâ and then pickup 1 more multiple columns on lookup table, give them a meaningful name.</p>
- <ul>
- <li>
- <p>Dimensions from fact table.<br />
- <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeA.png" alt="" /></p>
- </li>
- <li>
- <p>Dimensions from look up table.<br />
- <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeB-1.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-derived.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Repeate 2 and 3 to add all dimension columns; you can do this in batch for âNormalâ dimension with the button <code class="highlighter-rouge">Auto Generator</code>.</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeB-2.png" alt="" /></p>
- </li>
- <li>
- <p>Dimensions from look up table with hierarchy.<br />
- <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeC.png" alt="" /></p>
- </li>
- <li>
- <p>Dimensions from look up table with derived dimensions.<br />
- <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeD.png" alt="" /></p>
- </li>
- </ul>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-batch.png" alt="" /></p>
</li>
<li>
- <p>User can edit the dimension after saving it.<br />
-<img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-edit.png" alt="" /></p>
+ <p>Click âNextâ after select all dimensions.</p>
</li>
</ol>
@@ -1759,65 +1822,81 @@
<ol>
<li>
<p>Click the <code class="highlighter-rouge">+Measure</code> to add a new measure.<br />
-<img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-+meas.png" alt="" /></p>
+<img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 meas-+meas.png" alt="" /></p>
</li>
<li>
- <p>There are 5 different types of measure according to its expression: <code class="highlighter-rouge">SUM</code>, <code class="highlighter-rouge">MAX</code>, <code class="highlighter-rouge">MIN</code>, <code class="highlighter-rouge">COUNT</code> and <code class="highlighter-rouge">COUNT_DISTINCT</code>. Please be carefully to choose the return type, which is related to the error rate of the <code class="highlighter-rouge">COUNT(DISTINCT)</code>.</p>
+ <p>There are 6 types of measure according to its expression: <code class="highlighter-rouge">SUM</code>, <code class="highlighter-rouge">MAX</code>, <code class="highlighter-rouge">MIN</code>, <code class="highlighter-rouge">COUNT</code>, <code class="highlighter-rouge">COUNT_DISTINCT</code> and <code class="highlighter-rouge">TOP_N</code>. Properly select the return type for <code class="highlighter-rouge">COUNT_DISTINCT</code> and <code class="highlighter-rouge">TOP_N</code>, as it will impact on the cube size.</p>
<ul>
<li>
<p>SUM</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-sum.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-sum.png" alt="" /></p>
</li>
<li>
<p>MIN</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-min.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-min.png" alt="" /></p>
</li>
<li>
<p>MAX</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-max.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-max.png" alt="" /></p>
</li>
<li>
<p>COUNT</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-count.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-count.png" alt="" /></p>
</li>
<li>
- <p>DISTINCT_COUNT</p>
+ <p>DISTINCT_COUNT<br />
+This measure has two implementations: <br />
+a) approximate implementation with HyperLogLog, select an acceptable error rate, lower error rate will take more storage.<br />
+b) precise implementation with bitmap (see limitation in https://issues.apache.org/jira/browse/KYLIN-1186).</p>
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-distinct.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-distinct.png" alt="" /></p>
</li>
</ul>
+
+ <p>Pleaste note: distinct count is a very heavy data type, it is slower to build and query comparing to other measures.</p>
+
+ <ul>
+ <li>TOP_N<br />
+Approximate TopN measure pre-calculates the top records in each dimension combination, it will provide higher performance in query time than no pre-calculation; Need specify two parameters here: the first is the column will be used as metrics for Top records (aggregated with SUM and then sorted in descending order); the second is the literal ID, represents the record like seller_id;</li>
+ </ul>
+
+ <p>Properly select the return type, depends on how many top records to inspect: top 10, top 100 or top 1000.</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-topn.png" alt="" /></p>
</li>
</ol>
-<p><strong>Step 4. Filter</strong></p>
+<p><strong>Step 4. Refresh Setting</strong></p>
-<p>This step is optional. You can add some condition filter in <code class="highlighter-rouge">SQL</code> format.</p>
+<p>This step is designed for incremental cube build.</p>
-<p><img src="/images/Kylin-Cube-Creation-Tutorial/10 filter.png" alt="" /></p>
+<p><code class="highlighter-rouge">Auto Merge Time Ranges (days)</code>: merge the small segments into medium and large segment automatically. If you donât want to auto merge, remove the default two ranges.</p>
-<p><strong>Step 5. Refresh Setting</strong></p>
+<p><code class="highlighter-rouge">Retention Range (days)</code>: only keep the segment whose data is in past given days in cube, the old segment will be automatically dropped from head; 0 means not enable this feature.</p>
-<p>This step is designed for incremental cube build.</p>
+<p><code class="highlighter-rouge">Partition Start Date</code>: the start date of this cube.</p>
-<p><img src="/images/Kylin-Cube-Creation-Tutorial/11 refresh-setting1.png" alt="" /></p>
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/9 refresh-setting1.png" alt="" /></p>
-<p>Choose partition type, partition column and start date.</p>
+<p><strong>Step 5. Advanced Setting</strong></p>
-<p><img src="/images/Kylin-Cube-Creation-Tutorial/11 refresh-setting2.png" alt="" /></p>
+<p><code class="highlighter-rouge">Aggregation Groups</code>: by default Kylin put all dimensions into one aggregation group; you can create multiple aggregation groups by knowing well about your query patterns. For the concepts of âMandatory Dimensionsâ, âHierarchy Dimensionsâ and âJoint Dimensionsâ, read this blog: <a href="/blog/2016/02/18/new-aggregation-group/">New Aggregation Group</a></p>
-<p><strong>Step 6. Advanced Setting</strong></p>
+<p><code class="highlighter-rouge">Rowkeys</code>: the rowkeys are composed by the dimension encoded values. âDictionaryâ is the default encoding method; If a dimension is not fit with dictionary (e.g., cardinality > 10 million), select âfalseâ and then enter the fixed length for that dimension, usually that is the max. length of that column; if a value is longer than that size it will be truncated. Please note, without dictionary encoding, the cube size might be much bigger.</p>
-<p><img src="/images/Kylin-Cube-Creation-Tutorial/12 advanced.png" alt="" /></p>
+<p>You can drag & drop a dimension column to adjust its position in rowkey; Put the mandantory dimension at the begining, then followed the dimensions that heavily involved in filters (where condition). Put high cardinality dimensions ahead of low cardinality dimensions.</p>
-<p><strong>Step 7. Overview & Save</strong></p>
+<p><strong>Step 6. Overview & Save</strong></p>
<p>You can overview your cube and go back to previous step to modify it. Click the <code class="highlighter-rouge">Save</code> button to complete the cube creation.</p>
-<p><img src="/images/Kylin-Cube-Creation-Tutorial/13 overview.png" alt="" /></p>
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/10 overview.png" alt="" /></p>
+
+<p>Cheers! now the cube is created, you can go ahead to build and play it.</p>
</article>
</div>
Modified: kylin/site/docs15/tutorial/cube_build_job.html
URL: http://svn.apache.org/viewvc/kylin/site/docs15/tutorial/cube_build_job.html?rev=1735201&r1=1735200&r2=1735201&view=diff
==============================================================================
--- kylin/site/docs15/tutorial/cube_build_job.html (original)
+++ kylin/site/docs15/tutorial/cube_build_job.html Wed Mar 16 09:12:34 2016
@@ -41,7 +41,7 @@
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
- <title>Apache Kylin | Kylin Cube Build and Job Monitoring Tutorial</title>
+ <title>Apache Kylin | Kylin Cube Build and Job Monitoring</title>
<meta name="description" content="Apache Kylin Home">
<meta name="author" content="Apache Kylin">
<link rel="shortcut icon" href="fav.png" type="image/png">
@@ -278,10 +278,6 @@
-
-
-
-
<li><a href="/docs15/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Kylin⢠Release Notes</a></li>
@@ -530,8 +526,23 @@
- <li><a href="/docs15/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">Manual Installation Guide</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -682,8 +693,25 @@
- <li><a href="/docs15/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">On Hadoop Kylin installation using Docker</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -762,10 +790,6 @@
-
-
-
-
<li><a href="/docs15/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>
@@ -824,11 +848,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation Tutorial</a></li>
+ <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li>
@@ -888,11 +908,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+ <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li>
@@ -948,11 +964,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission Grant Tutorial</a></li>
+ <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li>
@@ -1024,11 +1036,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Tutorial</a></li>
+ <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li>
@@ -1096,11 +1104,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>
@@ -1170,11 +1174,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>
@@ -1240,11 +1240,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI Tutorial</a></li>
+ <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>
@@ -1308,11 +1304,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver Tutorial</a></li>
+ <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>
@@ -1358,7 +1350,7 @@
- <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Build Cube with Restful API</a></li>
+ <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li>
@@ -1400,7 +1392,7 @@
- <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API in Javascript</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li>
@@ -1440,7 +1432,7 @@
- <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>
@@ -1476,7 +1468,7 @@
- <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">How to Optimize Cubes</a></li>
+ <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube</a></li>
@@ -1502,7 +1494,7 @@
- <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">How to Backup Metadata</a></li>
+ <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>
@@ -1532,7 +1524,7 @@
- <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">How to Cleanup Storage (HDFS & HBase Tables)</a></li>
+ <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase Tables)</a></li>
@@ -1564,7 +1556,7 @@
- <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use kylin Remote JDBC Driver</a></li>
+ <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use kylin Remote JDBC Driver</a></li>
@@ -1602,7 +1594,7 @@
- <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">How to Upgrade</a></li>
+ <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade from old version</a></li>
@@ -1636,7 +1628,7 @@
- <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">How to Enable Security with LDAP and SSO</a></li>
+ <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li>
@@ -1656,7 +1648,7 @@
<div class="col-md-9 col-lg-9 col-xs-14 aside2">
<div id="container">
<div id="pjax">
- <h1 class="post-title">Kylin Cube Build and Job Monitoring Tutorial</h1>
+ <h1 class="post-title">Kylin Cube Build and Job Monitoring</h1>
<article class="post-content" >
@@ -1665,73 +1657,75 @@
<ol>
<li>
- <p>In <code class="highlighter-rouge">Cubes</code> page, click the <code class="highlighter-rouge">Action</code> drop down button in the right of a cube column and select operation <code class="highlighter-rouge">Build</code>.</p>
+ <p>In <code class="highlighter-rouge">Models</code> page, click the <code class="highlighter-rouge">Action</code> drop down button in the right of a cube column and select operation <code class="highlighter-rouge">Build</code>.</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/1 action-build.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/1 action-build.png" alt="" /></p>
</li>
<li>
- <p>There is a pop-up window after the selection.</p>
+ <p>There is a pop-up window after the selection, click <code class="highlighter-rouge">END DATE</code> input box to select end date of this incremental cube build.</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/2 pop-up.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/3 end-date.png" alt="" /></p>
</li>
<li>
- <p>Click <code class="highlighter-rouge">END DATE</code> input box to choose end date of this incremental cube build.</p>
+ <p>Click <code class="highlighter-rouge">Submit</code> to send the build request. After success, you will see the new job in the <code class="highlighter-rouge">Monitor</code> page.</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/3 end-date.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/4 jobs-page.png" alt="" /></p>
</li>
<li>
- <p>Click <code class="highlighter-rouge">Submit</code> to send request.</p>
-
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/4 submit.png" alt="" /></p>
+ <p>The new job is in âpendingâ status; after a while, it will be started to run and you will see the progress by refresh the web page or click the refresh button.</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/4.1 success.png" alt="" /></p>
-
- <p>After submit the request successfully, you will see the job just be created in the <code class="highlighter-rouge">Jobs</code> page.</p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/5 job-progress.png" alt="" /></p>
+ </li>
+ <li>
+ <p>Wait the job to finish. In the between if you want to discard it, click <code class="highlighter-rouge">Actions</code> -> <code class="highlighter-rouge">Discard</code> button.</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/5 jobs-page.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/6 discard.png" alt="" /></p>
</li>
<li>
- <p>To discard this job, just click the <code class="highlighter-rouge">Discard</code> button.</p>
+ <p>After the job is 100% finished, the cubeâs status becomes to âReadyâ, means it is ready to serve SQL queries. In the <code class="highlighter-rouge">Model</code> tab, find the cube, click cube name to expand the section, in the âHBaseâ tab, it will list the cube segments. Each segment has a start/end time; Its underlying HBase table information is also listed.</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/6 discard.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/10 cube-segment.png" alt="" /></p>
</li>
</ol>
+<p>If you have more source data, repeate the steps above to build them into the cube.</p>
+
<h3 id="job-monitoring">Job Monitoring</h3>
-<p>In the <code class="highlighter-rouge">Jobs</code> page, click the job detail button to see detail information show in the right side.</p>
+<p>In the <code class="highlighter-rouge">Monitor</code> page, click the job detail button to see detail information show in the right side.</p>
-<p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/7 job-steps.png" alt="" /></p>
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/7 job-steps.png" alt="" /></p>
<p>The detail information of a job provides a step-by-step record to trace a job. You can hover a step status icon to see the basic status and information.</p>
-<p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/8 hover-step.png" alt="" /></p>
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/8 hover-step.png" alt="" /></p>
-<p>Click the icon button show in each step to see the details: <code class="highlighter-rouge">Parameters</code>, <code class="highlighter-rouge">Log</code>, <code class="highlighter-rouge">MRJob</code>, <code class="highlighter-rouge">EagleMonitoring</code>.</p>
+<p>Click the icon buttons showing in each step to see the details: <code class="highlighter-rouge">Parameters</code>, <code class="highlighter-rouge">Log</code>, <code class="highlighter-rouge">MRJob</code>.</p>
<ul>
<li>
<p>Parameters</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters.png" alt="" /></p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters-d.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters-d.png" alt="" /></p>
</li>
<li>
<p>Log</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log.png" alt="" /></p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log-d.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log-d.png" alt="" /></p>
</li>
<li>
<p>MRJob(MapReduce Job)</p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob.png" alt="" /></p>
- <p><img src="/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob-d.png" alt="" /></p>
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob-d.png" alt="" /></p>
</li>
</ul>
+
</article>
</div>
</div>
Modified: kylin/site/docs15/tutorial/kylin_sample.html
URL: http://svn.apache.org/viewvc/kylin/site/docs15/tutorial/kylin_sample.html?rev=1735201&r1=1735200&r2=1735201&view=diff
==============================================================================
--- kylin/site/docs15/tutorial/kylin_sample.html (original)
+++ kylin/site/docs15/tutorial/kylin_sample.html Wed Mar 16 09:12:34 2016
@@ -278,10 +278,6 @@
-
-
-
-
<li><a href="/docs15/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Kylin⢠Release Notes</a></li>
@@ -530,8 +526,23 @@
- <li><a href="/docs15/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">Manual Installation Guide</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -682,8 +693,25 @@
- <li><a href="/docs15/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">On Hadoop Kylin installation using Docker</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -762,10 +790,6 @@
-
-
-
-
<li><a href="/docs15/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>
@@ -824,11 +848,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation Tutorial</a></li>
+ <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li>
@@ -888,11 +908,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+ <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li>
@@ -948,11 +964,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission Grant Tutorial</a></li>
+ <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li>
@@ -1024,11 +1036,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Tutorial</a></li>
+ <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li>
@@ -1096,11 +1104,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>
@@ -1170,11 +1174,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>
@@ -1240,11 +1240,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI Tutorial</a></li>
+ <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>
@@ -1308,11 +1304,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver Tutorial</a></li>
+ <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>
@@ -1358,7 +1350,7 @@
- <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Build Cube with Restful API</a></li>
+ <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li>
@@ -1400,7 +1392,7 @@
- <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API in Javascript</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li>
@@ -1440,7 +1432,7 @@
- <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>
@@ -1476,7 +1468,7 @@
- <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">How to Optimize Cubes</a></li>
+ <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube</a></li>
@@ -1502,7 +1494,7 @@
- <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">How to Backup Metadata</a></li>
+ <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>
@@ -1532,7 +1524,7 @@
- <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">How to Cleanup Storage (HDFS & HBase Tables)</a></li>
+ <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase Tables)</a></li>
@@ -1564,7 +1556,7 @@
- <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use kylin Remote JDBC Driver</a></li>
+ <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use kylin Remote JDBC Driver</a></li>
@@ -1602,7 +1594,7 @@
- <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">How to Upgrade</a></li>
+ <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade from old version</a></li>
@@ -1636,7 +1628,7 @@
- <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">How to Enable Security with LDAP and SSO</a></li>
+ <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li>
@@ -1664,17 +1656,17 @@
<ol>
<li>Run ${KYLIN_HOME}/bin/sample.sh ; Restart kylin server to flush the caches;</li>
- <li>Logon Kylin web, select project âlearn_kylinâ;</li>
+ <li>Logon Kylin web with default user ADMIN/KYLIN, select project âlearn_kylinâ in the project dropdown list (left upper corner);</li>
<li>Select the sample cube âkylin_sales_cubeâ, click âActionsâ -> âBuildâ, pick up a date later than 2014-01-01 (to cover all 10000 sample records);</li>
- <li>Check the build progress in âJobsâ tab, until 100%;</li>
- <li>Execute SQLs in the âQueryâ tab, for example:<br />
+ <li>Check the build progress in âMonitorâ tab, until 100%;</li>
+ <li>Execute SQLs in the âInsightâ tab, for example:<br />
select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt</li>
<li>You can verify the query result and compare the response time with hive;</li>
</ol>
<h2 id="whats-next">Whatâs next</h2>
-<p>After cube being built, please refer to other document of this tutorial for more detail information.</p>
+<p>You can create another cube with the sample tables, by following the tutorials.</p>
</article>
</div>
Modified: kylin/site/docs15/tutorial/odbc.html
URL: http://svn.apache.org/viewvc/kylin/site/docs15/tutorial/odbc.html?rev=1735201&r1=1735200&r2=1735201&view=diff
==============================================================================
--- kylin/site/docs15/tutorial/odbc.html (original)
+++ kylin/site/docs15/tutorial/odbc.html Wed Mar 16 09:12:34 2016
@@ -41,7 +41,7 @@
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
- <title>Apache Kylin | Kylin ODBC Driver Tutorial</title>
+ <title>Apache Kylin | Kylin ODBC 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">
@@ -278,10 +278,6 @@
-
-
-
-
<li><a href="/docs15/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Kylin⢠Release Notes</a></li>
@@ -530,8 +526,23 @@
- <li><a href="/docs15/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">Manual Installation Guide</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -682,8 +693,25 @@
- <li><a href="/docs15/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">On Hadoop Kylin installation using Docker</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -762,10 +790,6 @@
-
-
-
-
<li><a href="/docs15/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>
@@ -824,11 +848,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation Tutorial</a></li>
+ <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li>
@@ -888,11 +908,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+ <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li>
@@ -948,11 +964,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission Grant Tutorial</a></li>
+ <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li>
@@ -1024,11 +1036,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Tutorial</a></li>
+ <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li>
@@ -1096,11 +1104,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>
@@ -1170,11 +1174,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>
@@ -1240,11 +1240,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI Tutorial</a></li>
+ <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>
@@ -1308,11 +1304,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver Tutorial</a></li>
+ <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>
@@ -1358,7 +1350,7 @@
- <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Build Cube with Restful API</a></li>
+ <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li>
@@ -1400,7 +1392,7 @@
- <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API in Javascript</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li>
@@ -1440,7 +1432,7 @@
- <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>
@@ -1476,7 +1468,7 @@
- <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">How to Optimize Cubes</a></li>
+ <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube</a></li>
@@ -1502,7 +1494,7 @@
- <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">How to Backup Metadata</a></li>
+ <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>
@@ -1532,7 +1524,7 @@
- <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">How to Cleanup Storage (HDFS & HBase Tables)</a></li>
+ <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase Tables)</a></li>
@@ -1564,7 +1556,7 @@
- <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use kylin Remote JDBC Driver</a></li>
+ <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use kylin Remote JDBC Driver</a></li>
@@ -1602,7 +1594,7 @@
- <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">How to Upgrade</a></li>
+ <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade from old version</a></li>
@@ -1636,7 +1628,7 @@
- <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">How to Enable Security with LDAP and SSO</a></li>
+ <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li>
@@ -1656,7 +1648,7 @@
<div class="col-md-9 col-lg-9 col-xs-14 aside2">
<div id="container">
<div id="pjax">
- <h1 class="post-title">Kylin ODBC Driver Tutorial</h1>
+ <h1 class="post-title">Kylin ODBC Driver</h1>
<article class="post-content" >
Modified: kylin/site/docs15/tutorial/powerbi.html
URL: http://svn.apache.org/viewvc/kylin/site/docs15/tutorial/powerbi.html?rev=1735201&r1=1735200&r2=1735201&view=diff
==============================================================================
--- kylin/site/docs15/tutorial/powerbi.html (original)
+++ kylin/site/docs15/tutorial/powerbi.html Wed Mar 16 09:12:34 2016
@@ -41,7 +41,7 @@
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
- <title>Apache Kylin | MS Excel and Power BI Tutorial</title>
+ <title>Apache Kylin | MS Excel and Power BI</title>
<meta name="description" content="Apache Kylin Home">
<meta name="author" content="Apache Kylin">
<link rel="shortcut icon" href="fav.png" type="image/png">
@@ -278,10 +278,6 @@
-
-
-
-
<li><a href="/docs15/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Kylin⢠Release Notes</a></li>
@@ -530,8 +526,23 @@
- <li><a href="/docs15/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">Manual Installation Guide</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -682,8 +693,25 @@
- <li><a href="/docs15/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">On Hadoop Kylin installation using Docker</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -762,10 +790,6 @@
-
-
-
-
<li><a href="/docs15/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>
@@ -824,11 +848,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation Tutorial</a></li>
+ <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li>
@@ -888,11 +908,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+ <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li>
@@ -948,11 +964,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission Grant Tutorial</a></li>
+ <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li>
@@ -1024,11 +1036,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Tutorial</a></li>
+ <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li>
@@ -1096,11 +1104,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>
@@ -1170,11 +1174,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>
@@ -1240,11 +1240,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI Tutorial</a></li>
+ <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>
@@ -1308,11 +1304,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver Tutorial</a></li>
+ <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>
@@ -1358,7 +1350,7 @@
- <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Build Cube with Restful API</a></li>
+ <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li>
@@ -1400,7 +1392,7 @@
- <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API in Javascript</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li>
@@ -1440,7 +1432,7 @@
- <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>
@@ -1476,7 +1468,7 @@
- <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">How to Optimize Cubes</a></li>
+ <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube</a></li>
@@ -1502,7 +1494,7 @@
- <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">How to Backup Metadata</a></li>
+ <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>
@@ -1532,7 +1524,7 @@
- <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">How to Cleanup Storage (HDFS & HBase Tables)</a></li>
+ <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase Tables)</a></li>
@@ -1564,7 +1556,7 @@
- <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use kylin Remote JDBC Driver</a></li>
+ <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use kylin Remote JDBC Driver</a></li>
@@ -1602,7 +1594,7 @@
- <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">How to Upgrade</a></li>
+ <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade from old version</a></li>
@@ -1636,7 +1628,7 @@
- <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">How to Enable Security with LDAP and SSO</a></li>
+ <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li>
@@ -1656,7 +1648,7 @@
<div class="col-md-9 col-lg-9 col-xs-14 aside2">
<div id="container">
<div id="pjax">
- <h1 class="post-title">MS Excel and Power BI Tutorial</h1>
+ <h1 class="post-title">MS Excel and Power BI</h1>
<article class="post-content" >
Modified: kylin/site/docs15/tutorial/tableau.html
URL: http://svn.apache.org/viewvc/kylin/site/docs15/tutorial/tableau.html?rev=1735201&r1=1735200&r2=1735201&view=diff
==============================================================================
--- kylin/site/docs15/tutorial/tableau.html (original)
+++ kylin/site/docs15/tutorial/tableau.html Wed Mar 16 09:12:34 2016
@@ -41,7 +41,7 @@
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
- <title>Apache Kylin | Tableau Tutorial</title>
+ <title>Apache Kylin | Tableau 8</title>
<meta name="description" content="Apache Kylin Home">
<meta name="author" content="Apache Kylin">
<link rel="shortcut icon" href="fav.png" type="image/png">
@@ -278,10 +278,6 @@
-
-
-
-
<li><a href="/docs15/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Kylin⢠Release Notes</a></li>
@@ -530,8 +526,23 @@
- <li><a href="/docs15/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">Manual Installation Guide</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -682,8 +693,25 @@
- <li><a href="/docs15/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">On Hadoop Kylin installation using Docker</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -762,10 +790,6 @@
-
-
-
-
<li><a href="/docs15/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>
@@ -824,11 +848,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation Tutorial</a></li>
+ <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li>
@@ -888,11 +908,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+ <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li>
@@ -948,11 +964,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission Grant Tutorial</a></li>
+ <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li>
@@ -1024,11 +1036,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Tutorial</a></li>
+ <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li>
@@ -1096,11 +1104,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>
@@ -1170,11 +1174,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>
@@ -1240,11 +1240,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI Tutorial</a></li>
+ <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>
@@ -1308,11 +1304,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver Tutorial</a></li>
+ <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>
@@ -1358,7 +1350,7 @@
- <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Build Cube with Restful API</a></li>
+ <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li>
@@ -1400,7 +1392,7 @@
- <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API in Javascript</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li>
@@ -1440,7 +1432,7 @@
- <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>
@@ -1476,7 +1468,7 @@
- <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">How to Optimize Cubes</a></li>
+ <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube</a></li>
@@ -1502,7 +1494,7 @@
- <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">How to Backup Metadata</a></li>
+ <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>
@@ -1532,7 +1524,7 @@
- <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">How to Cleanup Storage (HDFS & HBase Tables)</a></li>
+ <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase Tables)</a></li>
@@ -1564,7 +1556,7 @@
- <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use kylin Remote JDBC Driver</a></li>
+ <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use kylin Remote JDBC Driver</a></li>
@@ -1602,7 +1594,7 @@
- <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">How to Upgrade</a></li>
+ <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade from old version</a></li>
@@ -1636,7 +1628,7 @@
- <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">How to Enable Security with LDAP and SSO</a></li>
+ <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li>
@@ -1656,7 +1648,7 @@
<div class="col-md-9 col-lg-9 col-xs-14 aside2">
<div id="container">
<div id="pjax">
- <h1 class="post-title">Tableau Tutorial</h1>
+ <h1 class="post-title">Tableau 8</h1>
<article class="post-content" >
Modified: kylin/site/docs15/tutorial/tableau_91.html
URL: http://svn.apache.org/viewvc/kylin/site/docs15/tutorial/tableau_91.html?rev=1735201&r1=1735200&r2=1735201&view=diff
==============================================================================
--- kylin/site/docs15/tutorial/tableau_91.html (original)
+++ kylin/site/docs15/tutorial/tableau_91.html Wed Mar 16 09:12:34 2016
@@ -41,7 +41,7 @@
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
- <title>Apache Kylin | Tableau 9 Tutorial</title>
+ <title>Apache Kylin | Tableau 9</title>
<meta name="description" content="Apache Kylin Home">
<meta name="author" content="Apache Kylin">
<link rel="shortcut icon" href="fav.png" type="image/png">
@@ -278,10 +278,6 @@
-
-
-
-
<li><a href="/docs15/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Kylin⢠Release Notes</a></li>
@@ -530,8 +526,23 @@
- <li><a href="/docs15/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">Manual Installation Guide</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -682,8 +693,25 @@
- <li><a href="/docs15/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">On Hadoop Kylin installation using Docker</a></li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -762,10 +790,6 @@
-
-
-
-
<li><a href="/docs15/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li>
@@ -824,11 +848,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation Tutorial</a></li>
+ <li><a href="/docs15/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li>
@@ -888,11 +908,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+ <li><a href="/docs15/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li>
@@ -948,11 +964,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission Grant Tutorial</a></li>
+ <li><a href="/docs15/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li>
@@ -1024,11 +1036,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Tutorial</a></li>
+ <li><a href="/docs15/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li>
@@ -1096,11 +1104,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li>
@@ -1170,11 +1174,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 Tutorial</a></li>
+ <li><a href="/docs15/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li>
@@ -1240,11 +1240,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI Tutorial</a></li>
+ <li><a href="/docs15/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li>
@@ -1308,11 +1304,7 @@
-
-
-
-
- <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver Tutorial</a></li>
+ <li><a href="/docs15/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li>
@@ -1358,7 +1350,7 @@
- <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Build Cube with Restful API</a></li>
+ <li><a href="/docs15/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li>
@@ -1400,7 +1392,7 @@
- <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API in Javascript</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li>
@@ -1440,7 +1432,7 @@
- <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use Restful API</a></li>
+ <li><a href="/docs15/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li>
@@ -1476,7 +1468,7 @@
- <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">How to Optimize Cubes</a></li>
+ <li><a href="/docs15/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube</a></li>
@@ -1502,7 +1494,7 @@
- <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">How to Backup Metadata</a></li>
+ <li><a href="/docs15/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li>
@@ -1532,7 +1524,7 @@
- <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">How to Cleanup Storage (HDFS & HBase Tables)</a></li>
+ <li><a href="/docs15/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase Tables)</a></li>
@@ -1564,7 +1556,7 @@
- <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">How to Use kylin Remote JDBC Driver</a></li>
+ <li><a href="/docs15/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use kylin Remote JDBC Driver</a></li>
@@ -1602,7 +1594,7 @@
- <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">How to Upgrade</a></li>
+ <li><a href="/docs15/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade from old version</a></li>
@@ -1636,7 +1628,7 @@
- <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">How to Enable Security with LDAP and SSO</a></li>
+ <li><a href="/docs15/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li>
@@ -1656,7 +1648,7 @@
<div class="col-md-9 col-lg-9 col-xs-14 aside2">
<div id="container">
<div id="pjax">
- <h1 class="post-title">Tableau 9 Tutorial</h1>
+ <h1 class="post-title">Tableau 9</h1>
<article class="post-content" >