Added: kylin/site/docs23/tutorial/create_cube.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/create_cube.html?rev=1822508&view=auto ============================================================================== --- kylin/site/docs23/tutorial/create_cube.html (added) +++ kylin/site/docs23/tutorial/create_cube.html Mon Jan 29 14:05:18 2018 @@ -0,0 +1,4372 @@ +<!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<!doctype html> +<html> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<head> + <meta charset="utf-8"> + <meta http-equiv="X-UA-Compatible" content="IE=edge"> + <meta name="viewport" content="width=device-width, initial-scale=1"> + + <title>Apache Kylin | Cube Wizard</title> + <meta name="description" content="Apache Kylin Home"> + <meta name="author" content="Apache Kylin"> + <link rel="shortcut icon" href="fav.png" type="image/png"> + + + +<link rel="stylesheet" href="/assets/css/animate.css"> +<!-- Bootstrap --> +<link rel="stylesheet" href="/assets/css/bootstrap.min.css"> + +<!-- Fonts --> +<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> --> + +<!-- Icons --> +<link rel="stylesheet" href="/assets/css/font-awesome.min.css"> + + <!-- Custom styles --> + <link rel="stylesheet" href="/assets/css/styles.css"> + <link rel="stylesheet" href="/assets/css/docs.css"> + <link rel="stylesheet" href="/assets/css/pygments.css"> + + <link rel="canonical" href="http://kylin.apache.org/docs23/tutorial/create_cube.html";> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml"; /> + +<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]--> +<script> + (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ + (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), + m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) + })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); + + //oringal tracker for kylin.io + ga('create', 'UA-55534813-1', 'auto'); + //new tracker for kylin.apache.org + ga('create', 'UA-55534813-2', 'auto', {'name':'toplevel'}); + + ga('send', 'pageview'); + ga('toplevel.send', 'pageview'); + + +</script> +<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script> +<script type="text/javascript" src="/assets/js/nside.js"></script> </script> +<script type="text/javascript" src="/assets/js/nnav.js"></script> </script> +</head> + + <body> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<header id="header" > + + <div id="head" class="parallax" parallax-speed="3" > + <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="/assets/images/kylin_logo.jpg"> <span class="title" >Apache Kylinâ¢</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> + </div> + <div class="text-center" style=" + position: relative; + top: 66px; + width: 1080px; + margin: 0 auto; + z-index: 11; + margin-top: -253px; + text-align: right;" + > + <a href="http://apache.org/foundation/contributing.html"; title="Support Apache" style="margin-left: 150px;"> + <img src="https://www.apache.org/images/SupportApache-small.png"; style="height: 150px; width: 150px;"> + </a> + </div> + </div> + + + <!-- 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"> + <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"> + <span class="sr-only">Toggle navigation</span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + </button> + + </div> + + <!-- Collect the nav links, forms, and other content for toggling --> + <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"> + <ul class="nav navbar-nav"> + <li><a href="/">Home</a></li> + <li><a href="/docs21" >Docs</a></li> + <li><a href="/download">Download</li> + <li><a href="/community" >Community</a></li> + <li><a href="/development" >Development</a></li> + <li><a href="/blog">Blog</li> + <li><a href="/cn" >ä¸æç</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><!-- /.navbar-collapse --> + </div><!-- /.container-fluid --> +</nav> + </header> + + + <div class="container"> + <div class="row"> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<div class="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" id="nside1" style=" padding-top: 2em"> + <ul class="nav nav-pills nav-stacked"> + + <li><a href="#titleGetting Started" data-toggle="collapse" id="navtitle">Getting Started</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/index.html" class="list-group-item-lay pjaxlink" id="navlist">Overview</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Release Notes</a></li> + + + + + + + + + + + + + + + + + + <li><a href="/docs23/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> + + + + + + + + + + + + + + + + <li><a href="/docs23/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleInstallation" data-toggle="collapse" id="navtitle">Installation</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/install/index.html" class="list-group-item-lay pjaxlink" id="navlist">Installation Guide</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/install/hadoop_env.html" class="list-group-item-lay pjaxlink" id="navlist">Hadoop Environment</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/install/kylin_cluster.html" class="list-group-item-lay pjaxlink" id="navlist">Deploy in Cluster Mode</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/install/advance_settings.html" class="list-group-item-lay pjaxlink" id="navlist">Advanced Settings</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">Run Kylin with Docker</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink" id="navlist">Install Kylin on AWS EMR</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleTutorial" data-toggle="collapse" id="navtitle">Tutorial</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission (v2.1.x)</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink" id="navlist">Project Level ACL</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleIntegration" data-toggle="collapse" id="navtitle">Integration</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleHow To" data-toggle="collapse" id="navtitle">How To</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Design</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Build</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade From Old Versions</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_install_ranger_kylin_plugin.html" class="list-group-item-lay pjaxlink" id="navlist">The Ranger Kylin Plugin Installation Guide</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_enable_zookeeper_acl.html" class="list-group-item-lay pjaxlink" id="navlist">Enable zookeeper acl</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_setup_systemcube.html" class="list-group-item-lay pjaxlink" id="navlist">Set Up System Cube</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_use_cube_planner.html" class="list-group-item-lay pjaxlink" id="navlist">Use Cube Planner</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs23/howto/howto_use_dashboard.html" class="list-group-item-lay pjaxlink" id="navlist">Use Dashboard</a></li> + + + + + + + + + <ul> + </div> +</div> + + + </ul> +</div> + + <div class="col-md-9 col-lg-9 col-xs-14 aside2"> + <div id="container"> + <div id="pjax"> + <h1 class="post-title">Cube Wizard</h1> + + + <article class="post-content" > + <p>This tutorial will guide you to create a cube. It need you have at least 1 sample table in Hive. If you donât have, you can follow this to create some data.</p> + +<h3 id="i-create-a-project">I. Create a Project</h3> +<ol> + <li> + <p>Go to <code class="highlighter-rouge">Query</code> page in top menu bar, then click <code class="highlighter-rouge">Manage Projects</code>.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/1 manage-prject.png" alt="" /></p> + </li> + <li> + <p>Click the <code class="highlighter-rouge">+ Project</code> button to add a new project.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/2 +project.png" alt="" /></p> + </li> + <li> + <p>Enter a project name, e.g, âTutorialâ, with a description (optional), then click <code class="highlighter-rouge">submit</code> button to send the request.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3 new-project.png" alt="" /></p> + </li> + <li> + <p>After success, the project will show in the table.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3.1 pj-created.png" alt="" /></p> + </li> +</ol> + +<h3 id="ii-sync-up-hive-table">II. Sync up Hive Table</h3> +<ol> + <li> + <p>Click <code class="highlighter-rouge">Model</code> in top bar and then click <code class="highlighter-rouge">Data Source</code> tab in the left part, it lists all the tables loaded into Kylin; click <code class="highlighter-rouge">Load Hive Table</code> button.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table.png" alt="" /></p> + </li> + <li> + <p>Enter the hive table names, separated with commad, and then click <code class="highlighter-rouge">Sync</code> to send the request.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table.png" alt="" /></p> + </li> + <li> + <p>[Optional] If you want to browser the hive database to pick tables, click the <code class="highlighter-rouge">Load Hive Table From Tree</code> button.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table-tree.png" alt="" /></p> + </li> + <li> + <p>[Optional] Expand the database node, click to select the table to load, and then click <code class="highlighter-rouge">Sync</code>.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-tree.png" alt="" /></p> + </li> + <li> + <p>A success message will pop up. In the left <code class="highlighter-rouge">Tables</code> section, the newly loaded table is added. Click the table name will expand the columns.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-info.png" alt="" /></p> + </li> + <li> + <p>In the background, Kylin will run a MapReduce job to calculate the approximate cardinality for the newly synced table. After the job be finished, refresh web page and then click the table name, the cardinality will be shown in the table info.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-cardinality.png" alt="" /></p> + </li> +</ol> + +<h3 id="iii-create-data-model">III. Create Data Model</h3> +<p>Before create a cube, need define a data model. The data model defines the star schema. One data model can be reused in multiple cubes.</p> + +<ol> + <li> + <p>Click <code class="highlighter-rouge">Model</code> in top bar, and then click <code class="highlighter-rouge">Models</code> tab. Click <code class="highlighter-rouge">+New</code> button, in the drop-down list select <code class="highlighter-rouge">New Model</code>.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 +model.png" alt="" /></p> + </li> + <li> + <p>Enter a name for the model, with an optional description.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-name.png" alt="" /></p> + </li> + <li> + <p>In the <code class="highlighter-rouge">Fact Table</code> box, select the fact table of this data model.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-fact-table.png" alt="" /></p> + </li> + <li> + <p>[Optional] Click <code class="highlighter-rouge">Add Lookup Table</code> button to add a lookup table. Select the table name and join type (inner or left).</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-lookup-table.png" alt="" /></p> + </li> + <li> + <p>[Optional] Click <code class="highlighter-rouge">New Join Condition</code> button, select the FK column of fact table in the left, and select the PK column of lookup table in the right side. Repeat this if have more than one join columns.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-join-condition.png" alt="" /></p> + </li> + <li> + <p>Click âOKâ, repeat step 4 and 5 to add more lookup tables if any. After finished, click âNextâ.</p> + </li> + <li> + <p>The âDimensionsâ page allows to select the columns that will be used as dimension in the child cubes. Click the <code class="highlighter-rouge">Columns</code> cell of a table, in the drop-down list select the column to the list.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-dimensions.png" alt="" /></p> + </li> + <li> + <p>Click âNextâ go to the âMeasuresâ page, select the columns that will be used in measure/metrics. The measure column can only from fact table.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-measures.png" alt="" /></p> + </li> + <li> + <p>Click âNextâ to the âSettingsâ page. If the data in fact table increases by day, select the corresponding date column in the <code class="highlighter-rouge">Partition Date Column</code>, and select the date format, otherwise leave it as blank.</p> + </li> + <li> + <p>[Optional] Select <code class="highlighter-rouge">Cube Size</code>, which is an indicator on the scale of the cube, by default it is <code class="highlighter-rouge">MEDIUM</code>.</p> + </li> + <li> + <p>[Optional] If some records want to excluded from the cube, like dirty data, you can input the condition in <code class="highlighter-rouge">Filter</code>.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-partition-column.png" alt="" /></p> + </li> + <li> + <p>Click <code class="highlighter-rouge">Save</code> and then select <code class="highlighter-rouge">Yes</code> to save the data model. After created, the data model will be shown in the left <code class="highlighter-rouge">Models</code> list.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-created.png" alt="" /></p> + </li> +</ol> + +<h3 id="iv-create-cube">IV. Create Cube</h3> +<p>After the data model be created, you can start to create cube.</p> + +<p>Click <code class="highlighter-rouge">Model</code> in top bar, and then click <code class="highlighter-rouge">Models</code> tab. Click <code class="highlighter-rouge">+New</code> button, in the drop-down list select <code class="highlighter-rouge">New Cube</code>.<br /> + <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 new-cube.png" alt="" /></p> + +<p><strong>Step 1. Cube Info</strong></p> + +<p>Select the data model, enter the cube name; Click <code class="highlighter-rouge">Next</code> to enter the next step.</p> + +<p>You can use letters, numbers and â_â to name your cube (blank space in name is not allowed). <code class="highlighter-rouge">Notification List</code> is a list of email addresses which be notified on cube job success/failure.<br /> + <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-info.png" alt="" /></p> + +<p><strong>Step 2. Dimensions</strong></p> + +<ol> + <li> + <p>Click <code class="highlighter-rouge">Add Dimension</code>, it popups two option: âNormalâ and âDerivedâ: âNormalâ is to add a normal independent dimension column, âDerivedâ is to add a derived dimension column. Read more in <a href="/docs15/howto/howto_optimize_cubes.html">How to optimize cubes</a>.</p> + </li> + <li> + <p>Click âNormalâ and then select a dimension column, give it a meaningful name.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-normal.png" alt="" /></p> + </li> + <li> + <p>[Optional] Click âDerivedâ and then pickup 1 more multiple columns on lookup table, give them a meaningful name.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-derived.png" alt="" /></p> + </li> + <li> + <p>Repeate 2 and 3 to add all dimension columns; you can do this in batch for âNormalâ dimension with the button <code class="highlighter-rouge">Auto Generator</code>.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-batch.png" alt="" /></p> + </li> + <li> + <p>Click âNextâ after select all dimensions.</p> + </li> +</ol> + +<p><strong>Step 3. Measures</strong></p> + +<ol> + <li> + <p>Click the <code class="highlighter-rouge">+Measure</code> to add a new measure.<br /> +<img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 meas-+meas.png" alt="" /></p> + </li> + <li> + <p>There are 6 types of measure according to its expression: <code class="highlighter-rouge">SUM</code>, <code class="highlighter-rouge">MAX</code>, <code class="highlighter-rouge">MIN</code>, <code class="highlighter-rouge">COUNT</code>, <code class="highlighter-rouge">COUNT_DISTINCT</code> and <code class="highlighter-rouge">TOP_N</code>. Properly select the return type for <code class="highlighter-rouge">COUNT_DISTINCT</code> and <code class="highlighter-rouge">TOP_N</code>, as it will impact on the cube size.</p> + <ul> + <li> + <p>SUM</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-sum.png" alt="" /></p> + </li> + <li> + <p>MIN</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-min.png" alt="" /></p> + </li> + <li> + <p>MAX</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-max.png" alt="" /></p> + </li> + <li> + <p>COUNT</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-count.png" alt="" /></p> + </li> + <li> + <p>DISTINCT_COUNT<br /> +This measure has two implementations: <br /> +a) approximate implementation with HyperLogLog, select an acceptable error rate, lower error rate will take more storage.<br /> +b) precise implementation with bitmap (see limitation in https://issues.apache.org/jira/browse/KYLIN-1186).</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-distinct.png" alt="" /></p> + </li> + </ul> + + <p>Pleaste note: distinct count is a very heavy data type, it is slower to build and query comparing to other measures.</p> + + <ul> + <li>TOP_N<br /> +Approximate TopN measure pre-calculates the top records in each dimension combination, it will provide higher performance in query time than no pre-calculation; Need specify two parameters here: the first is the column will be used as metrics for Top records (aggregated with SUM and then sorted in descending order); the second is the literal ID, represents the record like seller_id;</li> + </ul> + + <p>Properly select the return type, depends on how many top records to inspect: top 10, top 100 or top 1000.</p> + + <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-topn.png" alt="" /></p> + </li> +</ol> + +<p><strong>Step 4. Refresh Setting</strong></p> + +<p>This step is designed for incremental cube build.</p> + +<p><code class="highlighter-rouge">Auto Merge Time Ranges (days)</code>: merge the small segments into medium and large segment automatically. If you donât want to auto merge, remove the default two ranges.</p> + +<p><code class="highlighter-rouge">Retention Range (days)</code>: only keep the segment whose data is in past given days in cube, the old segment will be automatically dropped from head; 0 means not enable this feature.</p> + +<p><code class="highlighter-rouge">Partition Start Date</code>: the start date of this cube.</p> + +<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/9 refresh-setting1.png" alt="" /></p> + +<p><strong>Step 5. Advanced Setting</strong></p> + +<p><code class="highlighter-rouge">Aggregation Groups</code>: by default Kylin put all dimensions into one aggregation group; you can create multiple aggregation groups by knowing well about your query patterns. For the concepts of âMandatory Dimensionsâ, âHierarchy Dimensionsâ and âJoint Dimensionsâ, read this blog: <a href="/blog/2016/02/18/new-aggregation-group/">New Aggregation Group</a></p> + +<p><code class="highlighter-rouge">Rowkeys</code>: the rowkeys are composed by the dimension encoded values. âDictionaryâ is the default encoding method; If a dimension is not fit with dictionary (e.g., cardinality > 10 million), select âfalseâ and then enter the fixed length for that dimension, usually that is the max. length of that column; if a value is longer than that size it will be truncated. Please note, without dictionary encoding, the cube size might be much bigger.</p> + +<p>You can drag & drop a dimension column to adjust its position in rowkey; Put the mandantory dimension at the begining, then followed the dimensions that heavily involved in filters (where condition). Put high cardinality dimensions ahead of low cardinality dimensions.</p> + +<p><strong>Step 6. Overview & Save</strong></p> + +<p>You can overview your cube and go back to previous step to modify it. Click the <code class="highlighter-rouge">Save</code> button to complete the cube creation.</p> + +<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/10 overview.png" alt="" /></p> + +<p>Cheers! now the cube is created, you can go ahead to build and play it.</p> + + </article> + </div> + </div> + </div> + </div> + </div> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<footer id="underfooter"> + <div class="container"> + <div class="row"> + <div class="col-md-12 widget"> + <div class="widget-body" style="text-align:center"> + <a href="http://www.apache.org";> + <img id="asf-logo" alt="Apache Software Foundation" src="/assets/images/feather-small.gif"> + </a> + + <div> + 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>. 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>
![https://www.apache.org/images/SupportApache-small.png"](https://www.apache.org/images/SupportApache-small.png"){kind=link}
