You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2018/07/02 06:08:51 UTC
svn commit: r1834820 [22/48] - in /kylin/site: ./ about/ blog/
blog/2015/01/25/introduce-data-model/
blog/2015/06/10/release-v0.7.1-incubating/
blog/2015/08/13/kylin-dictionary/ blog/2015/08/15/fast-cubing/
blog/2015/09/06/release-v1.0-incubating/ blog...
Added: kylin/site/cn/docs23/tutorial/setup_systemcube.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/setup_systemcube.html?rev=1834820&view=auto
==============================================================================
--- kylin/site/cn/docs23/tutorial/setup_systemcube.html (added)
+++ kylin/site/cn/docs23/tutorial/setup_systemcube.html Mon Jul 2 06:08:48 2018
@@ -0,0 +1,4890 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<!doctype html>
+<html>
+ <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<head>
+ <meta charset="utf-8">
+ <meta http-equiv="X-UA-Compatible" content="IE=edge">
+ <meta name="viewport" content="width=device-width, initial-scale=1">
+
+ <title>Apache Kylin | 建ç«ç³»ç» Cube</title>
+ <meta name="description" content="Apache Kylin Home">
+ <meta name="author" content="Apache Kylin">
+ <link rel="shortcut icon" href="fav.png" type="image/png">
+
+
+
+<link rel="stylesheet" href="/assets/css/animate.css">
+<!-- Bootstrap -->
+<link rel="stylesheet" href="/assets/css/bootstrap.min.css">
+
+<!-- Fonts -->
+<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> -->
+
+<!-- Icons -->
+<link rel="stylesheet" href="/assets/css/font-awesome.min.css">
+
+ <!-- Custom styles -->
+ <link rel="stylesheet" href="/assets/css/styles.css">
+ <link rel="stylesheet" href="/assets/css/docs.css">
+
+ <link rel="canonical" href="http://kylin.apache.org/cn/docs23/tutorial/setup_systemcube.html">
+ <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml" />
+
+<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]-->
+<!-- Global site tag (gtag.js) - Google Analytics -->
+<script async src="https://www.googletagmanager.com/gtag/js?id=UA-120788561-1"></script>
+<script>
+ window.dataLayer = window.dataLayer || [];
+ function gtag(){dataLayer.push(arguments);}
+ gtag('js', new Date());
+
+ gtag('config', 'UA-120788561-1');
+</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>
+<script>
+var _hmt = _hmt || [];
+(function() {
+ var hm = document.createElement("script");
+ hm.src = "https://hm.baidu.com/hm.js?bdc5e03add430c0b72cc0eb91eabfa99";
+ var s = document.getElementsByTagName("script")[0];
+ s.parentNode.insertBefore(hm, s);
+})();
+</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" >
+ <!-- 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">
+ <img class="navbar-logo" width="46" src="/assets/images/kylin_logo.png "></img>
+
+ <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>
+ <ul class="nav icon-navbar">
+ <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li>
+ <li><a href="https://github.com/apache/kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li>
+ <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li>
+ </ul>
+ </div>
+
+ <!-- Collect the nav links, forms, and other content for toggling -->
+ <div class="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="/cn/download">ä¸è½½</a></li>
+ <li><a href="/community" >社åº</a></li>
+ <li><a href="/development" >å¼å</a></li>
+ <li><a href="/blog">å客</a></li>
+ <li><a href="/" >English</a></li>
+ </ul>
+
+
+ </div><!-- /.navbar-collapse -->
+ </div><!-- /.container-fluid -->
+ </nav>
+
+ <div id="head" class="parallax normal-header" >
+ <div class="text-center header-apache">
+ <a href="http://apache.org/foundation/contributing.html" title="Support Apache" style="margin-left: 150px;">
+ <div>
+ <img src="https://www.apache.org/images/SupportApache-small.png">
+ </div>
+ </a>
+ </div>
+ </div>
+
+ </header>
+
+
+ <div class="container">
+ <div class="row" style="clear:both;">
+ <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2" style="float:right;">
+ <div id="container" class="docs">
+ <div id="pjax">
+ <h1 class="post-title">建ç«ç³»ç» Cube</h1>
+ <article class="post-content" >
+ <blockquote>
+ <p>èª Apache Kylin v2.3.0 èµ·ææ</p>
+</blockquote>
+
+<h2 id="cube">ä»ä¹æ¯ç³»ç» Cube</h2>
+
+<p>为äºæ´å¥½çæ¯æèªæçæ§ï¼å¨ç³»ç» project ä¸å建ä¸ç»ç³»ç» Cubesï¼å«å âKYLIN_SYSTEMâãç°å¨ï¼è¿éæäºä¸ª Cubesãä¸ä¸ªç¨äºæ¥è¯¢ææ ï¼âMETRICS_QUERYâï¼âMETRICS_QUERY_CUBEâï¼âMETRICS_QUERY_RPCâãå¦å¤ä¸¤ä¸ªæ¯ job ææ ï¼âMETRICS_JOBâï¼âMETRICS_JOB_EXCEPTIONâã</p>
+
+<h2 id="cube-1">å¦ä½å»ºç«ç³»ç» Cube</h2>
+
+<h3 id="section">åå¤</h3>
+<p>å¨ KYLIN_HOME ç®å½ä¸å建ä¸ä¸ªé
ç½®æ件 SCSinkTools.jsonã</p>
+
+<p>ä¾å¦ï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>[
+ [
+ "org.apache.kylin.tool.metrics.systemcube.util.HiveSinkTool",
+ {
+ "storage_type": 2,
+ "cube_desc_override_properties": [
+ "java.util.HashMap",
+ {
+ "kylin.cube.algorithm": "INMEM",
+ "kylin.cube.max-building-segments": "1"
+ }
+ ]
+ }
+ ]
+]
+</code></pre>
+</div>
+
+<h3 id="metadata">1. çæ Metadata</h3>
+<p>å¨ KYLIN_HOME æ件夹ä¸è¿è¡ä¸ä¸å½ä»¤çæç¸å
³ç metadataï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>./bin/kylin.sh org.apache.kylin.tool.metrics.systemcube.SCCreator \
+-inputConfig SCSinkTools.json \
+-output <output_forder>
+</code></pre>
+</div>
+
+<p>éè¿è¿ä¸ªå½ä»¤ï¼ç¸å
³ç metadata å°ä¼çæä¸å
¶ä½ç½®ä½äº <code class="highlighter-rouge"><output_forder></code> ä¸ãç»èå¦ä¸ï¼system_cube å°±æ¯æ们ç <code class="highlighter-rouge"><output_forder></code>ï¼</p>
+
+<p><img src="/images/SystemCube/metadata.png" alt="metadata" /></p>
+
+<h3 id="section-1">2. 建ç«æ°æ®æº</h3>
+<p>è¿è¡ä¸åå½ä»¤çæ hive æºè¡¨ï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>hive -f <output_forder>/create_hive_tables_for_system_cubes.sql
+</code></pre>
+</div>
+
+<p>éè¿è¿ä¸ªå½ä»¤ï¼ç¸å
³ç hive 表å°ä¼è¢«å建ã</p>
+
+<p><img src="/images/SystemCube/hive_table.png" alt="hive_table" /></p>
+
+<h3 id="system-cubes--metadata">3. 为 System Cubes ä¸ä¼ Metadata</h3>
+<p>ç¶åæ们éè¦éè¿ä¸åå½ä»¤ä¸ä¼ metadata å° hbaseï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>./bin/metastore.sh restore <output_forder>
+</code></pre>
+</div>
+
+<h3 id="metadata-1">4. éè½½ Metadata</h3>
+<p>æç»ï¼æ们éè¦å¨ Kylin web UI éè½½ metadataã</p>
+
+<p>ç¶åï¼ä¸ç»ç³»ç» Cubes å°ä¼è¢«å建å¨ç³»ç» project ä¸ï¼ç§°ä¸º âKYLIN_SYSTEMâã</p>
+
+<h3 id="cube-build">5. ç³»ç» Cube build</h3>
+<p>å½ç³»ç» Cube 被å建ï¼æ们éè¦å®æ build Cubeã</p>
+
+<ol>
+ <li>
+ <p>å建ä¸ä¸ª shell èæ¬å
¶éè¿è°ç¨ org.apache.kylin.tool.job.CubeBuildingCLI æ¥ build ç³»ç» Cube</p>
+
+ <p>ä¾å¦:</p>
+ </li>
+</ol>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">#!/bin/bash
+
+dir=$(dirname ${0})
+export KYLIN_HOME=${dir}/../
+
+CUBE=$1
+INTERVAL=$2
+DELAY=$3
+CURRENT_TIME_IN_SECOND=`date +%s`
+CURRENT_TIME=$((CURRENT_TIME_IN_SECOND * 1000))
+END_TIME=$((CURRENT_TIME-DELAY))
+END=$((END_TIME - END_TIME%INTERVAL))
+
+ID="$END"
+echo "building for ${CUBE}_${ID}" >> ${KYLIN_HOME}/logs/build_trace.log
+sh ${KYLIN_HOME}/bin/kylin.sh org.apache.kylin.tool.job.CubeBuildingCLI --cube ${CUBE} --endTime ${END} > ${KYLIN_HOME}/logs/system_cube_${CUBE}_${END}.log 2>&1 &</code></pre></div>
+
+<ol>
+ <li>
+ <p>ç¶åå®æè¿è¡è¿ä¸ª shell èæ¬</p>
+
+ <p>ä¾å¦ï¼åæ¥ä¸æ¥è¿æ ·æ·»å ä¸ä¸ª cron jobï¼</p>
+ </li>
+</ol>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">0 */2 * * * sh ${KYLIN_HOME}/bin/system_cube_build.sh KYLIN_HIVE_METRICS_QUERY_QA 3600000 1200000
+
+20 */2 * * * sh ${KYLIN_HOME}/bin/system_cube_build.sh KYLIN_HIVE_METRICS_QUERY_CUBE_QA 3600000 1200000
+
+40 */4 * * * sh ${KYLIN_HOME}/bin/system_cube_build.sh KYLIN_HIVE_METRICS_QUERY_RPC_QA 3600000 1200000
+
+30 */4 * * * sh ${KYLIN_HOME}/bin/system_cube_build.sh KYLIN_HIVE_METRICS_JOB_QA 3600000 1200000
+
+50 */12 * * * sh ${KYLIN_HOME}/bin/system_cube_build.sh KYLIN_HIVE_METRICS_JOB_EXCEPTION_QA 3600000 12000</code></pre></div>
+
+<h2 id="cube-">ç³»ç» Cube çç»è</h2>
+
+<h3 id="dimension">æ®é Dimension</h3>
+<p>对äºè¿äº Cubeï¼admins è½å¤ç¨å个æ¶é´ç²åº¦æ¥è¯¢ãä»é«çº§å«å°ä½çº§å«ï¼å¦ä¸ï¼</p>
+
+<table>
+ <tr>
+ <td>KYEAR_BEGIN_DATE</td>
+ <td>year</td>
+ </tr>
+ <tr>
+ <td>KMONTH_BEGIN_DATE</td>
+ <td>month</td>
+ </tr>
+ <tr>
+ <td>KWEEK_BEGIN_DATE</td>
+ <td>week</td>
+ </tr>
+ <tr>
+ <td>KDAY_DATE</td>
+ <td>date</td>
+ </tr>
+</table>
+
+<h3 id="metricsquery">METRICS_QUERY</h3>
+<p>è¿ä¸ª Cube ç¨äºå¨æé«çº§å«æ¶éæ¥è¯¢ metricsãç»èå¦ä¸ï¼</p>
+
+<table>
+ <tr>
+ <th colspan="2">Dimension</th>
+ </tr>
+ <tr>
+ <td>HOST</td>
+ <td>the host of server for query engine</td>
+ </tr>
+ <tr>
+ <td>PROJECT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>REALIZATION</td>
+ <td>in Kylinï¼there are two OLAP realizations: Cubeï¼or Hybrid of Cubes</td>
+ </tr>
+ <tr>
+ <td>REALIZATION_TYPE</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>QUERY_TYPE</td>
+ <td>users can query on different data sourcesï¼CACHEï¼OLAPï¼LOOKUP_TABLEï¼HIVE</td>
+ </tr>
+ <tr>
+ <td>EXCEPTION</td>
+ <td>when doing queryï¼exceptions may happen. It's for classifying different exception types</td>
+ </tr>
+</table>
+
+<table>
+ <tr>
+ <th colspan="2">Measure</th>
+ </tr>
+ <tr>
+ <td>COUNT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>MINï¼MAXï¼SUM of QUERY_TIME_COST</td>
+ <td>the time cost for the whole query</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of CALCITE_SIZE_RETURN</td>
+ <td>the row count of the result Calcite returns</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_SIZE_RETURN</td>
+ <td>the row count of the input to Calcite</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of CALCITE_SIZE_AGGREGATE_FILTER</td>
+ <td>the row count of Calcite aggregates and filters</td>
+ </tr>
+ <tr>
+ <td>COUNT DISTINCT of QUERY_HASH_CODE</td>
+ <td>the number of different queries</td>
+ </tr>
+</table>
+
+<h3 id="metricsqueryrpc">METRICS_QUERY_RPC</h3>
+<p>è¿ä¸ª Cube ç¨äºå¨æä½çº§å«æ¶éæ¥è¯¢ metricsã对äºä¸ä¸ªæ¥è¯¢ï¼ç¸å
³ç aggregation å filter è½å¤ä¸æ¨å°æ¯ä¸ä¸ª rpc ç®æ æå¡å¨ãRpc ç®æ æå¡å¨çå¥å£®æ§æ¯æ´å¥½æ¥è¯¢æ§è½çåºç¡ãç»èå¦ä¸ï¼</p>
+
+<table>
+ <tr>
+ <th colspan="2">Dimension</th>
+ </tr>
+ <tr>
+ <td>HOST</td>
+ <td>the host of server for query engine</td>
+ </tr>
+ <tr>
+ <td>PROJECT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>REALIZATION</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>RPC_SERVER</td>
+ <td>the rpc related target server</td>
+ </tr>
+ <tr>
+ <td>EXCEPTION</td>
+ <td>the exception of a rpc call. If no exceptionï¼"NULL" is used</td>
+ </tr>
+</table>
+
+<table>
+ <tr>
+ <th colspan="2">Measure</th>
+ </tr>
+ <tr>
+ <td>COUNT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of CALL_TIME</td>
+ <td>the time cost of a rpc all</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of COUNT_SKIP</td>
+ <td>based on fuzzy filters or elseï¼a few rows will be skiped. This indicates the skipped row count</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of SIZE_SCAN</td>
+ <td>the row count actually scanned</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of SIZE_RETURN</td>
+ <td>the row count actually returned</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of SIZE_AGGREGATE</td>
+ <td>the row count actually aggregated</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of SIZE_AGGREGATE_FILTER</td>
+ <td>the row count actually aggregated and filteredï¼= SIZE_SCAN - SIZE_RETURN</td>
+ </tr>
+</table>
+
+<h3 id="metricsquerycube">METRICS_QUERY_CUBE</h3>
+<p>è¿ä¸ª Cube ç¨äºå¨ Cube 级å«æ¶éæ¥è¯¢ metricsãæéè¦çæ¯ cuboids ç¸å
³çï¼å
¶ä¸º Cube planner æä¾æå¡ãç»èå¦ä¸ï¼</p>
+
+<table>
+ <tr>
+ <th colspan="2">Dimension</th>
+ </tr>
+ <tr>
+ <td>CUBE_NAME</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>CUBOID_SOURCE</td>
+ <td>source cuboid parsed based on query and Cube design</td>
+ </tr>
+ <tr>
+ <td>CUBOID_TARGET</td>
+ <td>target cuboid already precalculated and served for source cuboid</td>
+ </tr>
+ <tr>
+ <td>IF_MATCH</td>
+ <td>whether source cuboid and target cuboid are equal</td>
+ </tr>
+ <tr>
+ <td>IF_SUCCESS</td>
+ <td>whether a query on this Cube is successful or not</td>
+ </tr>
+</table>
+
+<table>
+ <tr>
+ <th colspan="2">Measure</th>
+ </tr>
+ <tr>
+ <td>COUNT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_CALL_COUNT</td>
+ <td>the number of rpc calls for a query hit on this Cube</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_CALL_TIME_SUM</td>
+ <td>sum of time cost for the rpc calls of a query</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_CALL_TIME_MAX</td>
+ <td>max of time cost among the rpc calls of a query</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_COUNT_SKIP</td>
+ <td>the sum of row count skipped for the related rpc calls</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_SIZE_SCAN</td>
+ <td>the sum of row count scanned for the related rpc calls</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_SIZE_RETURN</td>
+ <td>the sum of row count returned for the related rpc calls</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_SIZE_AGGREGATE</td>
+ <td>the sum of row count aggregated for the related rpc calls</td>
+ </tr>
+ <tr>
+ <td>MAXï¼SUM of STORAGE_SIZE_AGGREGATE_FILTER</td>
+ <td>the sum of row count aggregated and filtered for the related rpc callsï¼= STORAGE_SIZE_SCAN - STORAGE_SIZE_RETURN</td>
+ </tr>
+</table>
+
+<h3 id="metricsjob">METRICS_JOB</h3>
+<p>å¨ Kylin ä¸ï¼ä¸»è¦æä¸ç§ç±»åç jobï¼<br />
+- âBUILDâï¼ä¸ºäºä» <strong>HIVE</strong> ä¸ building Cube segmentsã<br />
+- âMERGEâï¼ä¸ºäºå¨ <strong>HBASE</strong> ä¸ merging Cube segmentsã<br />
+- âOPTIMIZEâï¼ä¸ºäºå¨ <strong>HBASE</strong> ä¸åºäº <strong>base cuboid</strong> å¨æè°æ´é¢è®¡ç® cuboid treeã</p>
+
+<p>è¿ä¸ª Cube æ¯ç¨æ¥æ¶é job ææ ãç»èå¦ä¸ï¼</p>
+
+<table>
+ <tr>
+ <th colspan="2">Dimension</th>
+ </tr>
+ <tr>
+ <td>PROJECT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>CUBE_NAME</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>JOB_TYPE</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>CUBING_TYPE</td>
+ <td>in kylinï¼there are two cubing algorithmsï¼Layered & Fast(InMemory)</td>
+ </tr>
+</table>
+
+<table>
+ <tr>
+ <th colspan="2">Measure</th>
+ </tr>
+ <tr>
+ <td>COUNT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>MINï¼MAXï¼SUM of DURATION</td>
+ <td>the duration from a job start to finish</td>
+ </tr>
+ <tr>
+ <td>MINï¼MAXï¼SUM of TABLE_SIZE</td>
+ <td>the size of data source in bytes</td>
+ </tr>
+ <tr>
+ <td>MINï¼MAXï¼SUM of CUBE_SIZE</td>
+ <td>the size of created Cube segment in bytes</td>
+ </tr>
+ <tr>
+ <td>MINï¼MAXï¼SUM of PER_BYTES_TIME_COST</td>
+ <td>= DURATION / TABLE_SIZE</td>
+ </tr>
+ <tr>
+ <td>MINï¼MAXï¼SUM of WAIT_RESOURCE_TIME</td>
+ <td>a job may includes serveral MR(map reduce) jobs. Those MR jobs may wait because of lack of Hadoop resources.</td>
+ </tr>
+</table>
+
+<h3 id="metricsjobexception">METRICS_JOB_EXCEPTION</h3>
+<p>è¿ä¸ª Cube æ¯ç¨æ¥æ¶é job exception ææ ãç»èå¦ä¸ï¼</p>
+
+<table>
+ <tr>
+ <th colspan="2">Dimension</th>
+ </tr>
+ <tr>
+ <td>PROJECT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>CUBE_NAME</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>JOB_TYPE</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>CUBING_TYPE</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>EXCEPTION</td>
+ <td>when running a jobï¼exceptions may happen. It's for classifying different exception types</td>
+ </tr>
+</table>
+
+<table>
+ <tr>
+ <th>Measure</th>
+ </tr>
+ <tr>
+ <td>COUNT</td>
+ </tr>
+</table>
+
+ </article>
+ </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.
+-->
+
+<div class="col-md-4 col-lg-4 col-xs-12 col-sm-12 aside1 visible-sm visible-xs visible-md visible-lg" id="nside1" style="margin-top: 5em;float:right;">
+ <ul class="nav nav-pills nav-stacked">
+
+ <li><a href="#titleå¼å§" data-toggle="collapse" class="navtitle">å¼å§</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink ">æ¦è¿°</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleå®è£
" data-toggle="collapse" class="navtitle">å®è£
</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/index.html" class="list-group-item-lay pjaxlink ">å®è£
æå</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_cluster.html" class="list-group-item-lay pjaxlink ">Cluster 模å¼ä¸é¨ç½²</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/configuration.html" class="list-group-item-lay pjaxlink ">Kylin é
ç½®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/advance_settings.html" class="list-group-item-lay pjaxlink ">é«çº§è®¾ç½®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink ">å¨ AWS EMR ä¸ å®è£
Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_docker.html" class="list-group-item-lay pjaxlink ">ç¨ Docker è¿è¡ Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleæç¨" data-toggle="collapse" class="navtitle">æç¨</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink ">æ ·ä¾ Cube å¿«éå
¥é¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web çé¢</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube å建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube æ建å Job çæ§</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink ">Project Level ACL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink ">ç¨ Spark æ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink ">ä» Kafka æµæ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客æ·ç«¯</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink ">建ç«ç³»ç» Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Cube Planner</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Dashboard</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink ">å»ºç« JDBC æ°æ®æº</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleå·¥å
·éæ" data-toggle="collapse" class="navtitle">å·¥å
·éæ</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/jdbc.html" class="list-group-item-lay pjaxlink ">JDBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau 8</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">Excel å Power BI æç¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/squirrel.html" class="list-group-item-lay pjaxlink ">SQuirreL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink ">Qlik Sense éæ</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#title帮å©" data-toggle="collapse" class="navtitle">帮å©</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink ">Use RESTful API</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink ">ç¨ API æ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink ">ä¼å Cube 设计</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">å¤ä»½å
æ°æ®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">æ¸
çåå¨</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+
+ </ul>
+</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>
+ <div class="row">
+ <div class="col-md-12 widget">
+ <div class="widget-body">
+ <div class="footer-img">
+ <a href="http://www.apache.org">
+ <img id="asf-logo" height="78px" alt="Apache Software Foundation" src="/assets/images/apache_footer.png">
+ </a>
+ </div>
+ <p style="padding-top: 11px;">
+ The contents of this website are © 2015 Apache Software Foundation under the terms of the
+ <a href="http://www.apache.org/licenses/LICENSE-2.0"> Apache License v2 </a>.
+ </p>
+ <p style="margin-bottom: 11px;">
+ Apache Kylin and its logo are trademarks of the Apache Software Foundation.
+ </div>
+
+ </div>
+ </div>
+ </div>
+ <!-- /row of widgets -->
+
+ </div>
+ <div></div>
+
+</footer>
+
+ <script src="/assets/js/jquery-1.9.1.min.js"></script>
+ <script src="/assets/js/bootstrap.min.js"></script>
+ <script src="/assets/js/main.js"></script>
+ </body>
+</html>