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 2019/08/01 14:04:53 UTC
svn commit: r1864154 [1/17] - in /kylin/site: ./ blog/ blog/2019/07/30/
blog/2019/07/30/detailed-analysis-of-refine-query-cache/ cn/docs30/
cn/docs30/gettingstarted/ cn/docs30/howto/ cn/docs30/install/
cn/docs30/tutorial/ docs30/ docs30/gettingstarted/...
Author: lidong
Date: Thu Aug 1 14:04:52 2019
New Revision: 1864154
URL: http://svn.apache.org/viewvc?rev=1864154&view=rev
Log:
Add article of introducing KYLIN-2895
Added:
kylin/site/blog/2019/07/30/
kylin/site/blog/2019/07/30/detailed-analysis-of-refine-query-cache/
kylin/site/blog/2019/07/30/detailed-analysis-of-refine-query-cache/index.html
kylin/site/docs30/howto/howto_use_health_check_cli.html
kylin/site/docs30/howto/howto_use_hive_mr_dict.html
kylin/site/images/blog/refine-query-cache/
kylin/site/images/blog/refine-query-cache/cache-signature.png (with props)
kylin/site/images/blog/refine-query-cache/consistent-hashing.png (with props)
kylin/site/images/blog/refine-query-cache/l1-l2-cache.png (with props)
Modified:
kylin/site/blog/index.html
kylin/site/cn/docs30/gettingstarted/faq.html
kylin/site/cn/docs30/howto/howto_backup_metadata.html
kylin/site/cn/docs30/howto/howto_build_cube_with_restapi.html
kylin/site/cn/docs30/howto/howto_cleanup_storage.html
kylin/site/cn/docs30/howto/howto_jdbc.html
kylin/site/cn/docs30/howto/howto_optimize_build.html
kylin/site/cn/docs30/howto/howto_optimize_cubes.html
kylin/site/cn/docs30/howto/howto_use_cli.html
kylin/site/cn/docs30/howto/howto_use_restapi.html
kylin/site/cn/docs30/index.html
kylin/site/cn/docs30/install/advance_settings.html
kylin/site/cn/docs30/install/configuration.html
kylin/site/cn/docs30/install/index.html
kylin/site/cn/docs30/install/kylin_aws_emr.html
kylin/site/cn/docs30/install/kylin_cluster.html
kylin/site/cn/docs30/install/kylin_docker.html
kylin/site/cn/docs30/tutorial/Qlik.html
kylin/site/cn/docs30/tutorial/acl.html
kylin/site/cn/docs30/tutorial/create_cube.html
kylin/site/cn/docs30/tutorial/cube_build_job.html
kylin/site/cn/docs30/tutorial/cube_build_performance.html
kylin/site/cn/docs30/tutorial/cube_spark.html
kylin/site/cn/docs30/tutorial/cube_streaming.html
kylin/site/cn/docs30/tutorial/hybrid.html
kylin/site/cn/docs30/tutorial/jdbc.html
kylin/site/cn/docs30/tutorial/kylin_client_tool.html
kylin/site/cn/docs30/tutorial/kylin_sample.html
kylin/site/cn/docs30/tutorial/mysql_metastore.html
kylin/site/cn/docs30/tutorial/odbc.html
kylin/site/cn/docs30/tutorial/powerbi.html
kylin/site/cn/docs30/tutorial/project_level_acl.html
kylin/site/cn/docs30/tutorial/query_pushdown.html
kylin/site/cn/docs30/tutorial/setup_jdbc_datasource.html
kylin/site/cn/docs30/tutorial/setup_systemcube.html
kylin/site/cn/docs30/tutorial/spark.html
kylin/site/cn/docs30/tutorial/sql_reference.html
kylin/site/cn/docs30/tutorial/squirrel.html
kylin/site/cn/docs30/tutorial/superset.html
kylin/site/cn/docs30/tutorial/tableau.html
kylin/site/cn/docs30/tutorial/tableau_91.html
kylin/site/cn/docs30/tutorial/use_cube_planner.html
kylin/site/cn/docs30/tutorial/use_dashboard.html
kylin/site/cn/docs30/tutorial/web.html
kylin/site/docs30/gettingstarted/best_practices.html
kylin/site/docs30/gettingstarted/concepts.html
kylin/site/docs30/gettingstarted/events.html
kylin/site/docs30/gettingstarted/faq.html
kylin/site/docs30/gettingstarted/terminology.html
kylin/site/docs30/howto/howto_backup_metadata.html
kylin/site/docs30/howto/howto_build_cube_with_restapi.html
kylin/site/docs30/howto/howto_cleanup_storage.html
kylin/site/docs30/howto/howto_enable_zookeeper_acl.html
kylin/site/docs30/howto/howto_install_ranger_kylin_plugin.html
kylin/site/docs30/howto/howto_jdbc.html
kylin/site/docs30/howto/howto_ldap_and_sso.html
kylin/site/docs30/howto/howto_optimize_build.html
kylin/site/docs30/howto/howto_optimize_cubes.html
kylin/site/docs30/howto/howto_update_coprocessor.html
kylin/site/docs30/howto/howto_upgrade.html
kylin/site/docs30/howto/howto_use_beeline.html
kylin/site/docs30/howto/howto_use_cli.html
kylin/site/docs30/howto/howto_use_distributed_scheduler.html
kylin/site/docs30/howto/howto_use_restapi.html
kylin/site/docs30/howto/howto_use_restapi_in_js.html
kylin/site/docs30/index.html
kylin/site/docs30/install/advance_settings.html
kylin/site/docs30/install/configuration.html
kylin/site/docs30/install/index.html
kylin/site/docs30/install/kylin_aws_emr.html
kylin/site/docs30/install/kylin_cluster.html
kylin/site/docs30/install/kylin_docker.html
kylin/site/docs30/release_notes.html
kylin/site/docs30/tutorial/Qlik.html
kylin/site/docs30/tutorial/acl.html
kylin/site/docs30/tutorial/create_cube.html
kylin/site/docs30/tutorial/cube_build_job.html
kylin/site/docs30/tutorial/cube_build_performance.html
kylin/site/docs30/tutorial/cube_spark.html
kylin/site/docs30/tutorial/cube_streaming.html
kylin/site/docs30/tutorial/flink.html
kylin/site/docs30/tutorial/hue.html
kylin/site/docs30/tutorial/hybrid.html
kylin/site/docs30/tutorial/jdbc.html
kylin/site/docs30/tutorial/kylin_client_tool.html
kylin/site/docs30/tutorial/kylin_sample.html
kylin/site/docs30/tutorial/microstrategy.html
kylin/site/docs30/tutorial/mysql_metastore.html
kylin/site/docs30/tutorial/odbc.html
kylin/site/docs30/tutorial/powerbi.html
kylin/site/docs30/tutorial/project_level_acl.html
kylin/site/docs30/tutorial/query_pushdown.html
kylin/site/docs30/tutorial/realtime_olap.html
kylin/site/docs30/tutorial/setup_jdbc_datasource.html
kylin/site/docs30/tutorial/setup_systemcube.html
kylin/site/docs30/tutorial/spark.html
kylin/site/docs30/tutorial/sql_reference.html
kylin/site/docs30/tutorial/squirrel.html
kylin/site/docs30/tutorial/superset.html
kylin/site/docs30/tutorial/tableau.html
kylin/site/docs30/tutorial/tableau_91.html
kylin/site/docs30/tutorial/use_cube_planner.html
kylin/site/docs30/tutorial/use_dashboard.html
kylin/site/docs30/tutorial/web.html
kylin/site/feed.xml
Added: kylin/site/blog/2019/07/30/detailed-analysis-of-refine-query-cache/index.html
URL: http://svn.apache.org/viewvc/kylin/site/blog/2019/07/30/detailed-analysis-of-refine-query-cache/index.html?rev=1864154&view=auto
==============================================================================
--- kylin/site/blog/2019/07/30/detailed-analysis-of-refine-query-cache/index.html (added)
+++ kylin/site/blog/2019/07/30/detailed-analysis-of-refine-query-cache/index.html Thu Aug 1 14:04:52 2019
@@ -0,0 +1,6714 @@
+<!--
+* 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 | Detailed Analysis of refine query cache</title>
+ <meta name="description" content="">
+ <meta name="author" content="Apache Kylin">
+ <link rel="shortcut icon" href="fav.png" type="image/png">
+
+
+
+<link rel="stylesheet" href="/assets/css/animate.css">
+<!-- Bootstrap -->
+<link rel="stylesheet" href="/assets/css/bootstrap.min.css">
+
+<!-- Fonts -->
+<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> -->
+
+<!-- Icons -->
+<link rel="stylesheet" href="/assets/css/font-awesome.min.css">
+
+ <!-- Custom styles -->
+ <link rel="stylesheet" href="/assets/css/styles.css">
+ <link rel="stylesheet" href="/assets/css/docs.css">
+ <link rel="stylesheet" href="/assets/css/pygments.css">
+
+ <link rel="canonical" href="http://kylin.apache.org/blog/2019/07/30/detailed-analysis-of-refine-query-cache/">
+ <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">
+ <!--
+ <img class="img-circle" width="40px" height="40px" id="circlelogo" src="/assets/images/kylin_logo.jpg">
+ -->
+ <!-- Brand and toggle get grouped for better mobile display -->
+ <div class="navbar-header">
+ <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 class="li-search">
+ <div>
+ <form target="_blank" autocomplete="false" action="https://sematext.com/opensee/big-data">
+ <input type="hidden" name="project" value="kylin">
+ <div class="form-group search-container">
+ <input type="text" autocomplete="false" class="form-control" name="q" placeholder="Search...">
+ <div class="search fa fa-search fa-lg"></div>
+ </div>
+ </form>
+ </div>
+ <!-- <a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-search fa-lg" title="Search: @ApacheKylin" ></a> -->
+ </li>
+ <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li>
+ <li><a href="https://github.com/apache/kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li>
+ <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li>
+ </ul>
+ </div>
+
+ <!-- Collect the nav links, forms, and other content for toggling -->
+ <div class="navbar-collapse collapse" id="bs-example-navbar-collapse-1">
+
+ <ul class="nav navbar-nav">
+
+ <li><a href="/">Home</a></li>
+ <li>
+ <a href="/docs">Docs</a>
+<!--
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Docs</a>
+ <ul class="dropdown-menu">
+
+ <li class="dropdown-submenu"><a href="#titleGetting Started" data-toggle="collapse" class="navtitle">Getting Started</a>
+ <ul class="dropdown-menu">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/index.html" class="list-group-item-lay pjaxlink">Overview</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/release_notes.html" class="list-group-item-lay pjaxlink">Release Notes</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink">Technical Concepts</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink">Terminology</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/gettingstarted/faq.html" class="list-group-item-lay pjaxlink">FAQ</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/gettingstarted/events.html" class="list-group-item-lay pjaxlink">Events and Conferences</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink">Community Best Practices</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </li>
+
+ <li class="dropdown-submenu"><a href="#titleInstallation" data-toggle="collapse" class="navtitle">Installation</a>
+ <ul class="dropdown-menu">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/install/index.html" class="list-group-item-lay pjaxlink">Installation Guide</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/install/kylin_cluster.html" class="list-group-item-lay pjaxlink">Deploy in Cluster Mode</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/install/configuration.html" class="list-group-item-lay pjaxlink">Kylin Configuration</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink">Install Kylin on AWS EMR</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/install/kylin_docker.html" class="list-group-item-lay pjaxlink">Run Kylin with Docker</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </li>
+
+ <li class="dropdown-submenu"><a href="#titleTutorial" data-toggle="collapse" class="navtitle">Tutorial</a>
+ <ul class="dropdown-menu">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink">Quick Start with Sample Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web Interface</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/create_cube.html" class="list-group-item-lay pjaxlink">Cube Wizard</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink">Cube Build and Job Monitoring</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/project_table_level_acl.html" class="list-group-item-lay pjaxlink">Project And Table Level ACL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink">Build Cube with Spark</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink">Scalable Cubing from Kafka</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink">Cube Build Tuning</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink">Kylin Python Client</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink">Setup JDBC Data Source</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/hybrid.html" class="list-group-item-lay pjaxlink">Hybrid Model</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/mysql_metastore.html" class="list-group-item-lay pjaxlink">Use MySQL as Metastore</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </li>
+
+ <li class="dropdown-submenu"><a href="#titleIntegration" data-toggle="collapse" class="navtitle">Integration</a>
+ <ul class="dropdown-menu">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/odbc.html" class="list-group-item-lay pjaxlink">Kylin ODBC Driver</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/jdbc.html" class="list-group-item-lay pjaxlink">Kylin JDBC Driver</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/powerbi.html" class="list-group-item-lay pjaxlink">MS Excel and Power BI</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink">MicroStrategy</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/flink.html" class="list-group-item-lay pjaxlink">Apache Flink</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/spark.html" class="list-group-item-lay pjaxlink">Apache Spark</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/hue.html" class="list-group-item-lay pjaxlink">Hue</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/Qlik.html" class="list-group-item-lay pjaxlink">Qlik Sense</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </li>
+
+ <li class="dropdown-submenu"><a href="#titleHow To" data-toggle="collapse" class="navtitle">How To</a>
+ <ul class="dropdown-menu">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink">Use RESTful API</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink">Build Cube with API</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink">Optimize Cube Design</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink">Optimize Cube Build</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink">Backup Metadata</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink">Cleanup Storage</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink">Upgrade From Old Versions</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_use_cli.html" class="list-group-item-lay pjaxlink">Use Utility CLIs</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink">Secure with LDAP and SSO</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink">Use Beeline for Hive</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink">Update Coprocessor</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_install_ranger_kylin_plugin.html" class="list-group-item-lay pjaxlink">Install Ranger Plugin</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/docs/howto/howto_enable_zookeeper_acl.html" class="list-group-item-lay pjaxlink">Enable Zookeeper ACL</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </li>
+
+ </ul> -->
+ </li>
+ <li><a href="/download">Download</a></li>
+ <li><a href="/community" >Community</a></li>
+ <li><a href="/development" >Development</a></li>
+ <li><a href="/blog">Blog</a></li>
+ <li><a href="/cn" >ä¸æç</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="page-content main">
+ <header style=" padding:2em 0 0 ">
+ <div class="container" >
+ <div style=" padding:0 4em">
+ <div class="blog-icon">
+ <img width="30" src="/assets/images/icon_blog_w.png">
+ </div>
+ <h4 class="index-title" style=" float:left;"><span>Apache Kylin⢠Technical Blog</span></h4>
+ </div>
+ </div>
+ </div>
+
+ <div class="container blog">
+ <div>
+ <article class="post-content" >
+ <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:2em 4em 4em 4em">
+
+ <header class="post-header">
+ <h1 class="post-title">Detailed Analysis of refine query cache</h1>
+ <p class="post-meta" >Jul 30, 2019 ⢠Xiaoxiang Yu</p>
+ </header>
+
+ <article class="post-content" >
+ <hr />
+
+<h2 id="part-i-basic-introduction">Part-I Basic Introduction</h2>
+
+<h3 id="backgroud">Backgroud</h3>
+<p>In the past, query cache are not efficiently used in Kylin due to two aspects: <strong>coarse-grained cache expiration strategy</strong> and <strong>lack of external cache</strong>. Because of the aggressive cache expiration strategy, useful caches are often cleaned up unnecessarily. Because query caches are stored in local servers, they cannot be shared between servers. And because of the size limitation of local cache, not all useful query results can be cached.</p>
+
+<p>To deal with these shortcomings, we change the query cache expiration strategy by signature checking and introduce the memcached as Kylinâs distributed cache so that Kylin servers are able to share cache between servers. And itâs easy to add memcached servers to scale out distributed cache.</p>
+
+<p>These features is proposed and developed by eBay Kylin team. Thanks so much for their contribution.</p>
+
+<h3 id="related-jira">Related JIRA</h3>
+
+<ul>
+ <li><a href="https://issues.apache.org/jira/browse/KYLIN-2895">KYLIN-2895 Refine Query Cache</a>
+ <ul>
+ <li><a href="https://issues.apache.org/jira/browse/KYLIN-2899">KYLIN-2899 Introduce segment level query cache</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/KYLIN-2898">KYLIN-2898 Introduce memcached as a distributed cache for queries</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/KYLIN-2894">KYLIN-2894 Change the query cache expiration strategy by signature checking</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/KYLIN-2897">KYLIN-2897 Improve the query execution for a set of duplicate queries in a short period</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/KYLIN-2896">KYLIN-2896 Refine query exception cache</a></li>
+ </ul>
+ </li>
+</ul>
+
+<hr />
+
+<h2 id="part-ii-deep-dive">Part-II Deep Dive</h2>
+
+<ul>
+ <li>Introduce memcached as a Distributed Query Cache</li>
+ <li>Segment Level Cache</li>
+ <li>Query Cache Expiration Strategy by Signature Checking</li>
+ <li>Other Enhancement</li>
+</ul>
+
+<h3 id="introduce-memcached-as-a-distributed-query-cache">Introduce memcached as a Distributed Query Cache</h3>
+
+<p><strong>Memcached</strong> is a Free and open source, high-performance, distributed memory object caching system. It is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering. It is simple yet powerful. Its simple design promotes quick deployment, ease of development, and solves many problems facing large data caches. Its API is available for most popular languages.</p>
+
+<p>By KYLIN-2898, Kylin use <strong>Memcached</strong> as distributed cache service, and use <strong>EhCache</strong> as local cache service. When <code class="highlighter-rouge">RemoteLocalFailOverCacheManager</code> is configured in <code class="highlighter-rouge">applicationContext.xml</code>, for each cache put/get action, Kylin will first check if remote cache service is available, only if remote cache service is unavailable, local cache service will be used.</p>
+
+<p>Firstly, multi query server can share query cache. For each kylin server, less jvm memory will be occupied which help to reduce GC pressure. Secondly, since memcached is centralized so duplicated cache entry will avoid in serval Kylin process. Thirdly, memcached has larger size and easy to scale out, this will help to reduce the chance which useful cache entry have to be dropped due to limited memory capacity.</p>
+
+<p>To handle node failure and to scale out memcached cluster, author has introduced a consistent hash strategy to smoothly solve such problem. Ketama is an implementation of a consistent hashing algorithm, meaning you can add or remove servers from the memcached pool without causing a complete remap of all keys. Detail could be checked at <a href="https://www.last.fm/user/RJ/journal/2007/04/10/rz_libketama_-_a_consistent_hashing_algo_for_memcache_clients">Ketama consistent hash strategy</a>.</p>
+
+<p><img src="/images/blog/refine-query-cache/consistent-hashing.png" alt="consistent hashing" /></p>
+
+<h3 id="segment-level-cache">Segment level Cache</h3>
+
+<p>Currently Kylin use sql as the cache key, when sql comes, if result exists in the cache, it will directly returned the cached result and donât need to query hbase. When there is new segment build or existing segment refresh, all related cache result need to be evicted. For some frequently build cube such as streaming cube(NRT Streaming or Real-time OLAP), the cache miss will increase dramatically, that may decrease the query performance.</p>
+
+<p>Since for Kylin cube, most historical segments are immutable, the same query against historical segments should be always same, donât need to be evicted for new segment building. So we decide to implement the segment level cache, it is a complement of the existing front-end cache, the idea is similar as the level1/level2 cache in operating system.</p>
+
+<p><img src="/images/blog/refine-query-cache/l1-l2-cache.png" alt="l1-l2-cache" /></p>
+
+<h3 id="query-cache-expiration-strategy-by-signature-checking">Query Cache Expiration Strategy by Signature Checking</h3>
+
+<p>Currently, to invalid query cache, <code class="highlighter-rouge">CacheService</code> will either invoke <code class="highlighter-rouge">cleanDataCache</code> or <code class="highlighter-rouge">cleanAllDataCache</code>. Both methods will clear all of the query cache , which is very inefficient and unnecessary. In production environment, thereâs around hundreds of cubing jobs per day, which means the query cache will be cleared very several minutes. Then we introduced a signature to upgrade cache invalidation strategy.</p>
+
+<p>The basic idea is as follows:<br />
+When put SQLResponse into cache, we add signature for each SQLResponse. To calculate signature for SQLResponse, we choose the cube last build time and its segments to as input of <code class="highlighter-rouge">SignatureCalculator</code>.<br />
+When fetch <code class="highlighter-rouge">SQLResponse</code> for cache, first check whether the signature is consistent. If not, this cached value is overdue and will be invalidate.</p>
+
+<p>As for the calculation of signature is show as follows:<br />
+1. <code class="highlighter-rouge">toString</code> of <code class="highlighter-rouge">ComponentSignature</code> will concatenate member varible into a large String; if a <code class="highlighter-rouge">ComponentSignature</code> has other <code class="highlighter-rouge">ComponentSignature</code> as member, toString will be calculated recursively<br />
+2. return value of <code class="highlighter-rouge">toString</code> will be input of <code class="highlighter-rouge">SignatureCalculator</code>,<br />
+<code class="highlighter-rouge">SignatureCalculator</code> encode string using MD5 as identifer of signature of query cache</p>
+
+<p><img src="/images/blog/refine-query-cache/cache-signature.png" alt="cache-signature" /></p>
+
+<h3 id="other-enhancement">Other Enhancement</h3>
+
+<h4 id="improve-the-query-execution-for-a-set-of-duplicate-queries-in-a-short-period">Improve the query execution for a set of duplicate queries in a short period</h4>
+
+<p>If same query enter Kylin at the same time by different client, for each query they can not find query cache so they must be calculated respectively. And even wrose, if these query are complex, they usually cost a long duration so Kylin have less chance to utilize cache query; and them cost large computation resources that will make query server has poor performance has harm to HBase cluster.</p>
+
+<p>To reduce the impact of duplicated and complex query, it may be a good idea to block query which came later, wait to first one return result as far as possible. This lazy strategy is especially useful if you have duplicated complex query came in same time. To enbale it, you should set <code class="highlighter-rouge">kylin.query.lazy-query-enabled</code> to <code class="highlighter-rouge">true</code>. Optionlly, you may set <code class="highlighter-rouge">kylin.query.lazy-query-waiting-timeout-milliseconds</code> to what you think later duplicated query wait duration to meet your situation.</p>
+
+<h4 id="remove-exception-cache">Remove exception cache</h4>
+<p>Formerly, query cache has been divided into two part, one part for storing success query result, another for failed query result, and they are invalidated respectively. It looks like not a good classification criteria because it is not fine-grained enough. After query cache signature was introduced, we have no reason to take them apart, so exception cache was removed.</p>
+
+<hr />
+
+<h2 id="part-iii-how-to-use">Part-III How to Use</h2>
+
+<p>To get prepared, you need to install memcached, you may refer to https://github.com/memcached/memcached/wiki/Install. Then you should modify <code class="highlighter-rouge">kylin.properties</code> and <code class="highlighter-rouge">applicationContext.xml</code>.</p>
+
+<ul>
+ <li>kylin.properties</li>
+</ul>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">kylin.cache.memcached.hosts=10.1.2.42:11211
+kylin.query.cache-signature-enabled=true
+kylin.query.lazy-query-enabled=true
+kylin.metrics.memcached.enabled=true
+kylin.query.segment-cache-enabled=true</code></pre></div>
+
+<ul>
+ <li>applicationContext.xml</li>
+</ul>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff"><cache:annotation-driven/>
+
+<bean id="ehcache" class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean"
+ p:configLocation="classpath:ehcache-test.xml" p:shared="true"/>
+
+<bean id="remoteCacheManager" class="org.apache.kylin.cache.cachemanager.MemcachedCacheManager"/>
+<bean id="localCacheManager" class="org.apache.kylin.cache.cachemanager.InstrumentedEhCacheCacheManager"
+ p:cacheManager-ref="ehcache"/>
+<bean id="cacheManager" class="org.apache.kylin.cache.cachemanager.RemoteLocalFailOverCacheManager"/>
+
+<bean id="memcachedCacheConfig" class="org.apache.kylin.cache.memcached.MemcachedCacheConfig">
+ <property name="timeout" value="500"/>
+ <property name="hosts" value="${kylin.cache.memcached.hosts}"/>
+</bean></code></pre></div>
+
+<h3 id="configuration-for-query-cache">Configuration for query cache</h3>
+
+<h4 id="general-part">General part</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Conf Key</th>
+ <th style="text-align: left">Conf value</th>
+ <th style="text-align: left">Explanation</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">kylin.query.cache-enabled</td>
+ <td style="text-align: left">boolean, default true</td>
+ <td style="text-align: left">whether to enable query cache</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.cache-threshold-duration</td>
+ <td style="text-align: left">long, in milliseconds, default is 2000</td>
+ <td style="text-align: left">query duration threshold</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.cache-threshold-scan-count</td>
+ <td style="text-align: left">long, default is 10240</td>
+ <td style="text-align: left">query scan row count threshold</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.cache-threshold-scan-bytes</td>
+ <td style="text-align: left">long, default is 1024 * 1024 (1MB)</td>
+ <td style="text-align: left">query scan byte threshold</td>
+ </tr>
+ </tbody>
+</table>
+
+<h4 id="memcached-part">Memcached part</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Conf Key</th>
+ <th style="text-align: left">Conf value</th>
+ <th style="text-align: left">Explanation</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">kylin.cache.memcached.hosts</td>
+ <td style="text-align: left">host1:port1,host2:port2</td>
+ <td style="text-align: left">host list of memcached host</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.segment-cache-enabled</td>
+ <td style="text-align: left">default false</td>
+ <td style="text-align: left">wether to enable</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.segment-cache-timeout</td>
+ <td style="text-align: left">default 2000</td>
+ <td style="text-align: left">timeout of memcached</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.segment-cache-max-size</td>
+ <td style="text-align: left">200 (MB)</td>
+ <td style="text-align: left">max size put into memcached</td>
+ </tr>
+ </tbody>
+</table>
+
+<h4 id="cache-signature-part">Cache signature part</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Conf Key</th>
+ <th style="text-align: left">Conf value</th>
+ <th style="text-align: left">Explanation</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">kylin.query.cache-signature-enabled</td>
+ <td style="text-align: left">default false</td>
+ <td style="text-align: left">whether to use signature for query cache</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.signature-class</td>
+ <td style="text-align: left">default is org.apache.kylin.rest.signature.FactTableRealizationSetCalculator</td>
+ <td style="text-align: left">use which class to calculate signature of query cache</td>
+ </tr>
+ </tbody>
+</table>
+
+<h4 id="other-optimize-part">Other optimize part</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Conf Key</th>
+ <th style="text-align: left">Conf value</th>
+ <th style="text-align: left">Explanation</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">kylin.query.lazy-query-enabled</td>
+ <td style="text-align: left">default false</td>
+ <td style="text-align: left">whether to block duplicated sql query</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.query.lazy-query-waiting-timeout-milliseconds</td>
+ <td style="text-align: left">long , in milliseconds, default is 60000</td>
+ <td style="text-align: left">max druation for blocking duplicated sql query</td>
+ </tr>
+ </tbody>
+</table>
+
+<h4 id="metrics-part">Metrics part</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Conf Key</th>
+ <th style="text-align: left">Conf value</th>
+ <th style="text-align: left">Explanation</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">kylin.metrics.memcached.enabled</td>
+ <td style="text-align: left">true</td>
+ <td style="text-align: left">Enable memcached metrics in memcached.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">kylin.metrics.memcached.metricstype</td>
+ <td style="text-align: left">off/performance/debug</td>
+ <td style="text-align: left">refer to net.spy.memcached.metrics.MetricType</td>
+ </tr>
+ </tbody>
+</table>
+
+ </article>
+
+</div>
+
+
+
+
+
+ </article>
+ </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>
+
+
+
+
Modified: kylin/site/blog/index.html
URL: http://svn.apache.org/viewvc/kylin/site/blog/index.html?rev=1864154&r1=1864153&r2=1864154&view=diff
==============================================================================
--- kylin/site/blog/index.html (original)
+++ kylin/site/blog/index.html Thu Aug 1 14:04:52 2019
@@ -6367,6 +6367,16 @@ var _hmt = _hmt || [];
<div class="col-md-6 col-lg-6 col-xs-12">
+ <a class="blog-card" href="/blog/2019/07/30/detailed-analysis-of-refine-query-cache/">
+ <div class="blog-pic">
+ <img width="20" src="../assets/images/icon_blog_w.png" />
+ </div>
+ <p class="blog-title">Detailed Analysis of refine query cache</p>
+ <p align="left" class="post-meta">posted: Jul 30, 2019</p>
+ </a>
+ </div>
+
+ <div class="col-md-6 col-lg-6 col-xs-12">
<a class="blog-card" href="/blog/2019/07/01/deep-dive-real-time-olap/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
Modified: kylin/site/cn/docs30/gettingstarted/faq.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs30/gettingstarted/faq.html?rev=1864154&r1=1864153&r2=1864154&view=diff
==============================================================================
--- kylin/site/cn/docs30/gettingstarted/faq.html (original)
+++ kylin/site/cn/docs30/gettingstarted/faq.html Thu Aug 1 14:04:52 2019
@@ -499,6 +499,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/index.html" class="list-group-item-lay pjaxlink">æ¦è¿°</a>
</li>
@@ -629,6 +633,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/install/index.html" class="list-group-item-lay pjaxlink">å®è£
æå</a>
</li>
@@ -726,6 +734,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/install/kylin_cluster.html" class="list-group-item-lay pjaxlink">é群模å¼é¨ç½²</a>
</li>
@@ -811,6 +823,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/install/configuration.html" class="list-group-item-lay pjaxlink">Kylin é
ç½®</a>
</li>
@@ -904,6 +920,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink">å¨ AWS EMR ä¸å®è£
Kylin</a>
</li>
@@ -1005,6 +1025,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/install/kylin_docker.html" class="list-group-item-lay pjaxlink">ç¨ Docker è¿è¡ Kylin</a>
</li>
@@ -1174,6 +1198,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink">æ ·ä¾ Cube å¿«éå
¥é¨</a>
</li>
@@ -1393,6 +1421,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
</li>
@@ -1508,6 +1540,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/create_cube.html" class="list-group-item-lay pjaxlink">Cube å建</a>
</li>
@@ -1627,6 +1663,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink">Cube æ建å Job çæ§</a>
</li>
@@ -1818,6 +1858,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
</li>
@@ -1987,6 +2031,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a>
</li>
@@ -2114,6 +2162,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink">ç¨ Spark æ建 Cube</a>
</li>
@@ -2245,6 +2297,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink">ä» Kafka æµæ建 Cube</a>
</li>
@@ -2467,6 +2523,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
@@ -2586,6 +2646,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink">ä¼å Cube æ建</a>
</li>
@@ -2733,6 +2797,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink">Python 客æ·ç«¯</a>
</li>
@@ -2916,6 +2984,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
</li>
@@ -3127,6 +3199,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a>
</li>
@@ -3342,6 +3418,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
</li>
@@ -3521,6 +3601,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink">å»ºç« JDBC æ°æ®æº</a>
</li>
@@ -3660,6 +3744,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/hybrid.html" class="list-group-item-lay pjaxlink">Hybrid 模å</a>
</li>
@@ -3817,6 +3905,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/mysql_metastore.html" class="list-group-item-lay pjaxlink">åºäº MySQL ç Metastore é
ç½®</a>
</li>
@@ -3996,6 +4088,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/odbc.html" class="list-group-item-lay pjaxlink">ODBC 驱å¨</a>
</li>
@@ -4139,6 +4235,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/jdbc.html" class="list-group-item-lay pjaxlink">JDBC 驱å¨</a>
</li>
@@ -4342,6 +4442,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
</li>
@@ -4549,6 +4653,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
</li>
@@ -4714,6 +4822,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/powerbi.html" class="list-group-item-lay pjaxlink">Excel å Power BI æç¨</a>
</li>
@@ -4936,6 +5048,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
@@ -5127,6 +5243,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
</li>
@@ -5234,6 +5354,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/Qlik.html" class="list-group-item-lay pjaxlink">Qlik Sense éæ</a>
</li>
@@ -5433,6 +5557,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+
<li class="navlist">
<a href="/cn/docs30/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
</li>
@@ -5469,6 +5597,10 @@ vi $KYLIN_HOME/tomcat/webapps/kylin/WEB-
+
+
+
+