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/05/27 12:12:09 UTC
svn commit: r1860125 [1/2] - in /kylin/site: ./ blog/ blog/2019/05/
blog/2019/05/23/ blog/2019/05/23/saiku-kylin-molap/ images/blog/saiku/
Author: lidong
Date: Mon May 27 12:12:08 2019
New Revision: 1860125
URL: http://svn.apache.org/viewvc?rev=1860125&view=rev
Log:
Add a blog about building MOLAP with saiku+kylin
Added:
kylin/site/blog/2019/05/
kylin/site/blog/2019/05/23/
kylin/site/blog/2019/05/23/saiku-kylin-molap/
kylin/site/blog/2019/05/23/saiku-kylin-molap/index.html
kylin/site/images/blog/saiku/
kylin/site/images/blog/saiku/add_schema.png (with props)
kylin/site/images/blog/saiku/home.png (with props)
kylin/site/images/blog/saiku/license.png (with props)
kylin/site/images/blog/saiku/mul_datasets.png (with props)
kylin/site/images/blog/saiku/query_result.png (with props)
kylin/site/images/blog/saiku/start.png (with props)
Modified:
kylin/site/blog/index.html
kylin/site/feed.xml
Added: kylin/site/blog/2019/05/23/saiku-kylin-molap/index.html
URL: http://svn.apache.org/viewvc/kylin/site/blog/2019/05/23/saiku-kylin-molap/index.html?rev=1860125&view=auto
==============================================================================
--- kylin/site/blog/2019/05/23/saiku-kylin-molap/index.html (added)
+++ kylin/site/blog/2019/05/23/saiku-kylin-molap/index.html Mon May 27 12:12:08 2019
@@ -0,0 +1,6589 @@
+<!--
+* 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 | Saiku + Kylin æ建å¤ç»´ OLAP å¹³å°</title>
+ <meta name="description" content="éçæ°æ®éçæ¿å¢ï¼ä¼ ç»ç OLTP å¹³å°å·²æ æ³æ»¡è¶³ç¨æ·çåæéæ±ãOLAP å¹³å°åºè¿èçï¼OLAP å¹³å°éå¸¸ç± OLAP Engine ä¸ç¨æ·æä½åæ页é¢ç»æãæ¬æå°ä¼ä»¥ Saiku + Kylin çç»åæ¹å¼è®²è§£å¤ç»´ OLAP å¹³å°çæ建ã">
+ <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/05/23/saiku-kylin-molap/">
+ <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_level_acl.html" class="list-group-item-lay pjaxlink">Project 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">Saiku + Kylin æ建å¤ç»´ OLAP å¹³å°</h1>
+ <p class="post-meta" >May 23, 2019 ⢠Gina Zhai</p>
+ </header>
+
+ <article class="post-content" >
+ <p>éçæ°æ®éçæ¿å¢ï¼ä¼ ç»ç OLTP å¹³å°å·²æ æ³æ»¡è¶³ç¨æ·çåæéæ±ãOLAP å¹³å°åºè¿èçï¼OLAP å¹³å°éå¸¸ç± OLAP Engine ä¸ç¨æ·æä½åæ页é¢ç»æãæ¬æå°ä¼ä»¥ Saiku + Kylin çç»åæ¹å¼è®²è§£å¤ç»´ OLAP å¹³å°çæ建ã</p>
+
+<h3 id="saiku-">Saiku ç®ä»</h3>
+<p>Saiku æ¯ä¸ä¸ªç¨äº OLAP åæçå¥ä»¶ãç¨æ·å¯å¨æµè§å¨ä¸éè¿ææ½çæ¹å¼è¿è¡åæãéä½äºä½¿ç¨è
çå¦ä¹ ææ¬ãå®è½å¤è¿æ¥å¤ç§æ°æ®æºï¼å¦ Microsoft SQL Server, Oracle Database, MySQL, MongoDB çã<br />
+Saiku æ¯æ两ç§è¿æ¥æ¹å¼ï¼ä¸æ¯ Mondrianï¼äºæ¯ XMLAã<br />
+Mondrian æ¯ä¸ä¸ªå¼æºçåå¡åæå¼æãä½¿ç¨ MDX(MultiDimensionalExpressions) å®æå¤ç»´æ¥è¯¢ã<br />
+XMLAï¼XML for Analysisï¼æ¯ä¸ç§åºäºç®å对象访é®åè®®ï¼SOAPï¼ç XML åè®®ã</p>
+
+<h3 id="kylin-">Kylin ç®ä»</h3>
+<p>Kylin æ¯ä¸ä¸ªåºäº Hadoop ç OLAP å¼æï¼å¯æ¥è¯¢åæåå²ä¸å®æ¶æ°æ®ï¼å¹¶å¨äºç§çº§è¿åæ¥è¯¢ç»æã</p>
+
+<h3 id="section">åæåå¤</h3>
+<ul>
+ <li>å®è£
JAVA 并设置 JAVA_HOME</li>
+ <li>ä» <a href="https://community.meteorite.bi/">Saiku 社åº</a>ä¸è½½ Saiku ææ°çæ¬</li>
+ <li>ä» <a href="http://kylin.apache.org/download/">Kylin å®ç½</a>ä¸è½½ Kylin ææ°çæ¬ï¼å³ 2.6.2</li>
+ <li>å¨ Kylin v2.6.2 ä¸æ建ä¸ä¸ª Cube</li>
+</ul>
+
+<h3 id="saiku--kylin">è¿æ¥ Saiku å° Kylin</h3>
+<p>1.æ§è¡ <code class="highlighter-rouge">unzip saiku-latest.zip</code> 解åä¸è½½å¥½ç Saiku å
ï¼åæ¢è³ saiku-server æ件夹ã解åä¸è½½å¥½ç Kylin å
ï¼è¿å
¥è§£ååæ件夹ï¼å° lib/kylin-jdbc-<version>.jar æ·è´è³ saiku-server/tomcat/webapps/saiku/WEB-INF/lib</version></p>
+
+<p>2.å¨ saiku-server æ件夹ä¸æ§è¡ <code class="highlighter-rouge">./start-saiku.sh</code> å½ä»¤å¯å¨ Saikuï¼å¯å¨åå¯å¨æµè§å¨ä¸è¾å
¥ http://localhost:8080 è®¿é® Saiku 页é¢ãé»è®¤ç«¯å£ä¸º 8080ï¼å¯å¨ saiku-server/tomcat/conf/server.xml ä¸è¿è¡ä¿®æ¹ã<br />
+<img src="/images/blog/saiku/start.png" alt="" /></p>
+
+<p>3.è®¿é® https://licensing.meteorite.bi/login è¿è¡æ³¨å并ç»å½ã</p>
+
+<p>4.ç»å½åï¼å
å建å
¬å¸ï¼å¿
é¡»ï¼ï¼åå建 Licenseï¼Hostname 为å¯å¨ Saiku çæºå¨ IPãå建å®æåï¼ä¸è½½ License å°æ¬å°ã<br />
+<img src="/images/blog/saiku/license.png" alt="" /></p>
+
+<p>5.è®¿é® http://localhost:8080/upload.html ä¸ä¼ Licenseãä¸ä¼ æéç¨æ·åä¸å¯ç å为 admin</p>
+
+<p>6.è®¿é® http://localhost:8080 è¿è¡ç»å½ï¼ç¨æ·åå¯ç å为 adminãå¦æä¸æ§è¡ä¸è¿° 3-5 æ¥éª¤ï¼ç´æ¥ç»å½å°ä¼æ¥å¦ä¸éã</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>Error fetching license. Get a free license from http://licensing.meteorite.bi. You can upload it at /upload.html
+</code></pre>
+</div>
+
+<p>7.ç»å½åï¼ç¹å»ç®¡çæ§å¶å°ï¼å³é¡¶é¨å¯¼èªæ æå³è¾¹å
å« A çå¾æ ãç¶åç¹å» Add Schemaï¼æ·»å Mondrian Schema ç XML æ件å Schema Nameï¼æåç¹å» Upload æé®ï¼æ¾ç¤º Upload Successful! å³å¯ãXML æ件ç±èªå·±ç¼åï¼å®æ¹æä¾ä¸¤ä¸ªåèæ ·ä¾ Earthquakes.xml å FoodMart4.xmlï¼å¨ saiku-server/data ç®å½ä¸ãå
·ä½è¯æ³å¯åè<a href="https://mondrian.pentaho.com/documentation/schema.php">è¿ä¸ªç½ç«</a><br />
+<img src="/images/blog/saiku/add_schema.png" alt="" /><br />
+å¦ä¸ä¸ºæ¬æ¬¡ä½¿ç¨çç¤ºä¾ XML æ件ãå
¶ä¸å
å«ä¸å¼ å为 KYLIN_SALES ç表ï¼å
å« TRANS_IDï¼PART_DTï¼LSTG_FORMAT_NAME è¿ 3 个维度å 1 个 SUM(PRICE) 度éã<br />
+<em>注æ</em>ï¼è¡¨ï¼åï¼å大å°åææï¼éä¸ Kylin ä¸å è½½çæ°æ®æºè¡¨ï¼åï¼å称对åº</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="cp"><?xml version='1.0'?></span>
+<span class="nt"><Schema</span> <span class="na">name=</span><span class="s">'default'</span> <span class="na">metamodelVersion=</span><span class="s">'4.0'</span><span class="nt">></span>
+ <span class="nt"><PhysicalSchema></span>
+ <span class="nt"><Table</span> <span class="na">name=</span><span class="s">'KYLIN_SALES'</span><span class="nt">></span>
+ <span class="nt"></Table></span>
+ <span class="nt"></PhysicalSchema></span>
+ <span class="nt"><Cube</span> <span class="na">name=</span><span class="s">'kylin_sales_cube'</span> <span class="na">defaultMeasure=</span><span class="s">'Sum PRICE'</span><span class="nt">></span>
+ <span class="nt"><Dimensions></span>
+ <span class="nt"><Dimension</span> <span class="na">name=</span><span class="s">'Trans_id'</span> <span class="na">table=</span><span class="s">'KYLIN_SALES'</span><span class="nt">></span>
+ <span class="nt"><Attributes></span>
+ <span class="nt"><Attribute</span> <span class="na">name=</span><span class="s">'Trans_id'</span> <span class="na">keyColumn=</span><span class="s">'TRANS_ID'</span> <span class="na">hasHierarchy=</span><span class="s">'true'</span><span class="nt">/></span>
+ <span class="nt"></Attributes></span>
+ <span class="nt"></Dimension></span>
+ <span class="nt"><Dimension</span> <span class="na">name=</span><span class="s">"Date"</span> <span class="na">table=</span><span class="s">'KYLIN_SALES'</span><span class="nt">></span>
+ <span class="nt"><Attributes></span>
+ <span class="nt"><Attribute</span> <span class="na">name=</span><span class="s">'Order_date'</span> <span class="na">keyColumn=</span><span class="s">'PART_DT'</span> <span class="na">hasHierarchy=</span><span class="s">'true'</span><span class="nt">/></span>
+ <span class="nt"></Attributes></span>
+ <span class="nt"></Dimension></span>
+ <span class="nt"><Dimension</span> <span class="na">name=</span><span class="s">'Trans_type'</span> <span class="na">table=</span><span class="s">'KYLIN_SALES'</span><span class="nt">></span>
+ <span class="nt"><Attributes></span>
+ <span class="nt"><Attribute</span> <span class="na">name=</span><span class="s">'Trans_type'</span> <span class="na">keyColumn=</span><span class="s">'LSTG_FORMAT_NAME'</span> <span class="na">hasHierarchy=</span><span class="s">'true'</span><span class="nt">/></span>
+ <span class="nt"></Attributes></span>
+ <span class="nt"></Dimension></span>
+ <span class="nt"></Dimensions></span>
+ <span class="nt"><MeasureGroups></span>
+ <span class="nt"><MeasureGroup</span> <span class="na">name=</span><span class="s">'SUM'</span> <span class="na">table=</span><span class="s">'KYLIN_SALES'</span><span class="nt">></span>
+ <span class="nt"><Measures></span>
+ <span class="nt"><Measure</span> <span class="na">name=</span><span class="s">'Sum PRICE'</span> <span class="na">column=</span><span class="s">'PRICE'</span> <span class="na">aggregator=</span><span class="s">'sum'</span> <span class="na">formatString=</span><span class="s">'Standard'</span><span class="nt">/></span>
+ <span class="nt"></Measures></span>
+ <span class="nt"><DimensionLinks></span>
+ <span class="nt"><FactLink</span> <span class="na">dimension=</span><span class="s">'Trans_id'</span><span class="nt">/></span>
+ <span class="nt"><FactLink</span> <span class="na">dimension=</span><span class="s">'Date'</span><span class="nt">/></span>
+ <span class="nt"><FactLink</span> <span class="na">dimension=</span><span class="s">'Trans_type'</span><span class="nt">/></span>
+ <span class="nt"></DimensionLinks></span>
+ <span class="nt"></MeasureGroup></span>
+ <span class="nt"></MeasureGroups></span>
+<span class="nt"></Cube></span>
+<span class="nt"></Schema></span>
+</code></pre>
+</div>
+
+<p>8.ç¹å» Add Data Sourceï¼å¡«åå¦ä¸åæ°ã</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>Name: Kylin_Demo
+Connection Type: Mondrian
+URL: jdbc:kylin://localhost:7070/{project_name}
+Schema: {mondrian_schema}
+JDBC Driver: org.apache.kylin.jdbc.Driver
+Username: {kylin_username} (Default: ADMIN)
+Password: {kylin_password} (Default: KYLIN)
+Security: (depend on your security setting)
+</code></pre>
+</div>
+<p>ç¹å» Save æé®ä¿åã</p>
+
+<p>9.ç¹å» Home Tabï¼ç¹å» Create a new query è¿å
¥æ¥è¯¢åæ页é¢ã<br />
+<img src="/images/blog/saiku/home.png" alt="" /></p>
+
+<p>10.ç¹å»éæ©å¤ç»´æ°æ®éä¸ææ¡ï¼éæ©ååå建好ç Kylin æ°æ®æºã<br />
+<img src="/images/blog/saiku/mul_datasets.png" alt="" /></p>
+
+<p>11.éè¿ææ½çæ¹å¼éæ©ç»´åº¦å度éè¿è¡åæãç»æä»¥è¡¨æ ¼å½¢å¼å±ç¤ºï¼å¯å¨é¡µé¢å³è¾¹åæ¢å¾è¡¨æ¨¡å¼ã<br />
+<img src="/images/blog/saiku/query_result.png" alt="" /><br />
+ä¸å¾æ示ææ½æ¹å¼ä¼é¦å
转æ¢ä¸º MDX åéç» Mondrianï¼Mondrian ä¼å°å
¶è½¬æ¢ä¸º SQL åéç» Kylinï¼Kylin æ¥æ¾å¯åç该 SQL è¯å¥ç Cubeï¼å°æ¥è¯¢ç»æè¿åç» Mondrianï¼åç± Mondrian è¿åç» Saiku è¿è¡å±ç¤ºãä¸å¾æ示æ¹å¼çæç SQL è¯å¥å¦ä¸ï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>select "KYLIN_SALES"."TRANS_ID" as "c0", "KYLIN_SALES"."LSTG_FORMAT_NAME" as "c1", sum("KYLIN_SALES"."PRICE") as "m0" from "KYLIN_SALES" as "KYLIN_SALES" group by "KYLIN_SALES"."TRANS_ID", "KYLIN_SALES"."LSTG_FORMAT_NAME"
+</code></pre>
+</div>
+
+<h3 id="section-1">常è§é®é¢</h3>
+<ol>
+ <li>
+ <p>tomcat å¯å¨æ¥éãjava.lang.IllegalStateException: Unable to complete the scan for annotations for web application [] due to a StackOverflowError. Possible root causes include a too low setting for -Xss and illegal cyclic inheritance dependencies. The class hierarchy being processed was [org.bouncycastle.asn1.ASN1EncodableVector->org.bouncycastle.asn1.DEREncodableVector->org.bouncycastle.asn1.ASN1EncodableVector]<br />
+解å³æ¹æ¡ï¼å¨ saiku-server/tomcat/conf/catalina.properties ä¸ç tomcat.util.scan.DefaultJarScanner.jarsToSkip=\ åå ,*</p>
+ </li>
+ <li>
+ <p>éæ© schema åï¼ææ å维度ä¸æ¾ç¤ºãæ¥å¿ä¸æ¥å¦ä¸éï¼java.lang.NoClassDefFoundError: mondrian/olap/LevelType<br />
+解å³æ¹æ¡ï¼è§£å saiku-server/tomcat/webapps/saiku/WEB-INF/lib ä¸ç saiku-query-0.4-SNAPSHOT.jarï¼å é¤ mondrain æ件夹åéæ°æå
ï¼å¹¶æ¿æ¢åæ jar å
ã</p>
+ </li>
+</ol>
+
+<h3 id="section-2">åèæç®</h3>
+<ul>
+ <li>https://saiku-documentation.readthedocs.io/en/latest/</li>
+ <li>https://baike.baidu.com/item/XMLA/8711067</li>
+ <li>https://community.hitachivantara.com/docs/DOC-1009853</li>
+ <li>https://www.jianshu.com/p/14b57d000fe5</li>
+ <li>https://blog.csdn.net/csdn_g_y/article/details/78184747</li>
+ <li>https://blog.csdn.net/qq_28725695/article/details/84322821</li>
+</ul>
+
+ </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=1860125&r1=1860124&r2=1860125&view=diff
==============================================================================
--- kylin/site/blog/index.html (original)
+++ kylin/site/blog/index.html Mon May 27 12:12:08 2019
@@ -6367,12 +6367,12 @@ var _hmt = _hmt || [];
<div class="col-md-6 col-lg-6 col-xs-12">
- <a class="blog-card" href="/blog/2019/04/19/release-v3.0.0-alpha/">
+ <a class="blog-card" href="/blog/2019/05/23/saiku-kylin-molap/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
</div>
- <p class="blog-title">Apache Kylin v3.0.0-alpha Release Announcement</p>
- <p align="left" class="post-meta">posted: Apr 19, 2019</p>
+ <p class="blog-title">Saiku + Kylin æ建å¤ç»´ OLAP å¹³å°</p>
+ <p align="left" class="post-meta">posted: May 23, 2019</p>
</a>
</div>
@@ -6387,6 +6387,16 @@ var _hmt = _hmt || [];
</div>
<div class="col-md-6 col-lg-6 col-xs-12">
+ <a class="blog-card" href="/blog/2019/04/19/release-v3.0.0-alpha/">
+ <div class="blog-pic">
+ <img width="20" src="../assets/images/icon_blog_w.png" />
+ </div>
+ <p class="blog-title">Apache Kylin v3.0.0-alpha Release Announcement</p>
+ <p align="left" class="post-meta">posted: Apr 19, 2019</p>
+ </a>
+ </div>
+
+ <div class="col-md-6 col-lg-6 col-xs-12">
<a class="blog-card" href="/blog/2019/04/12/rt-streaming-design/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
@@ -6397,21 +6407,21 @@ var _hmt = _hmt || [];
</div>
<div class="col-md-6 col-lg-6 col-xs-12">
- <a class="blog-card" href="/blog/2019/01/18/release-v2.6.0/">
+ <a class="blog-card" href="/cn/blog/2019/01/18/release-v2.6.0/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
</div>
- <p class="blog-title">Apache Kylin v2.6.0 Release Announcement</p>
+ <p class="blog-title">Apache Kylin v2.6.0 æ£å¼åå¸</p>
<p align="left" class="post-meta">posted: Jan 18, 2019</p>
</a>
</div>
<div class="col-md-6 col-lg-6 col-xs-12">
- <a class="blog-card" href="/cn/blog/2019/01/18/release-v2.6.0/">
+ <a class="blog-card" href="/blog/2019/01/18/release-v2.6.0/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
</div>
- <p class="blog-title">Apache Kylin v2.6.0 æ£å¼åå¸</p>
+ <p class="blog-title">Apache Kylin v2.6.0 Release Announcement</p>
<p align="left" class="post-meta">posted: Jan 18, 2019</p>
</a>
</div>
@@ -6697,21 +6707,21 @@ var _hmt = _hmt || [];
</div>
<div class="col-md-6 col-lg-6 col-xs-12">
- <a class="blog-card" href="/blog/2016/04/12/release-v1.5.1/">
+ <a class="blog-card" href="/cn/blog/2016/04/12/release-v1.5.1/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
</div>
- <p class="blog-title">Apache Kylin v1.5.1 Release Announcement</p>
+ <p class="blog-title">Apache Kylin v1.5.1 æ£å¼åå¸</p>
<p align="left" class="post-meta">posted: Apr 12, 2016</p>
</a>
</div>
<div class="col-md-6 col-lg-6 col-xs-12">
- <a class="blog-card" href="/cn/blog/2016/04/12/release-v1.5.1/">
+ <a class="blog-card" href="/blog/2016/04/12/release-v1.5.1/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
</div>
- <p class="blog-title">Apache Kylin v1.5.1 æ£å¼åå¸</p>
+ <p class="blog-title">Apache Kylin v1.5.1 Release Announcement</p>
<p align="left" class="post-meta">posted: Apr 12, 2016</p>
</a>
</div>
@@ -6727,21 +6737,21 @@ var _hmt = _hmt || [];
</div>
<div class="col-md-6 col-lg-6 col-xs-12">
- <a class="blog-card" href="/blog/2016/03/17/release-v1.5.0/">
+ <a class="blog-card" href="/cn/blog/2016/03/17/release-v1.5.0/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
</div>
- <p class="blog-title">Apache Kylin v1.5.0 Release Announcement</p>
+ <p class="blog-title">Apache Kylin v1.5.0 æ£å¼åå¸</p>
<p align="left" class="post-meta">posted: Mar 17, 2016</p>
</a>
</div>
<div class="col-md-6 col-lg-6 col-xs-12">
- <a class="blog-card" href="/cn/blog/2016/03/17/release-v1.5.0/">
+ <a class="blog-card" href="/blog/2016/03/17/release-v1.5.0/">
<div class="blog-pic">
<img width="20" src="../assets/images/icon_blog_w.png" />
</div>
- <p class="blog-title">Apache Kylin v1.5.0 æ£å¼åå¸</p>
+ <p class="blog-title">Apache Kylin v1.5.0 Release Announcement</p>
<p align="left" class="post-meta">posted: Mar 17, 2016</p>
</a>
</div>