You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by lu...@apache.org on 2015/05/27 13:45:06 UTC
svn commit: r1681993 - in /incubator/kylin/site/faq: ./ 2015/ 2015/05/
2015/05/18/ 2015/05/18/FAQ-on-Kylin-Installation-and-Usage/
2015/05/18/FAQ-on-Kylin-Installation-and-Usage/index.html
Author: lukehan
Date: Wed May 27 11:45:05 2015
New Revision: 1681993
URL: http://svn.apache.org/r1681993
Log:
KYLIN-789 update website docs structure and migrate wiki pages
Added:
incubator/kylin/site/faq/
incubator/kylin/site/faq/2015/
incubator/kylin/site/faq/2015/05/
incubator/kylin/site/faq/2015/05/18/
incubator/kylin/site/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/
incubator/kylin/site/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/index.html
Added: incubator/kylin/site/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/index.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/index.html?rev=1681993&view=auto
==============================================================================
--- incubator/kylin/site/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/index.html (added)
+++ incubator/kylin/site/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/index.html Wed May 27 11:45:05 2015
@@ -0,0 +1,496 @@
+<!--
+* 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 | FAQ on Kylin Installation and Usage</title>
+ <meta name="description" content="Some NPM error causes ERROR exit (ä¸å½å¤§éå°åºç¨æ·è¯·ç¹å«æ³¨ææ¤é®é¢)?Check out https://github.com/KylinOLAP/Kylin/issues/35">
+ <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://kyli.io/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/">
+ <link rel="alternate" type="application/rss+xml" title="kylin.io" href="http://kyli.io/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.incubator.apache.org
+ ga('create', 'UA-55534813-2', 'auto', {'name':'incubator'});
+
+ ga('send', 'pageview');
+ ga('incubator.send', 'pageview');
+
+
+</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>
+
+
+ <!-- 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="/"><b>Home</b></a></li>
+ <li><a href="/docs" >Docs</a></li>
+ <li><a href="/community" >Community</a></li>
+ <li><a href="/blog">Blog</li>
+ <li><a href="/download">Download</li>
+ <li><a href="/about" >About</a></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/incubator-kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/incubator-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="page-content">
+ <header style=" padding:2em 0 0 0">
+ <div class="container" >
+ <h4 class="section-title"><span>Kylin Docs</span></h4>
+ </div>
+ </div>
+ <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">
+ <ul class="nav nav-pills nav-stacked">
+ <!-- categories -->
+
+ <!-- categories -->
+
+ <!-- categories -->
+
+ <li><a href="#installation" data-toggle="collapse" >Installation</a></li>
+ <div class="collapse in" id="installation">
+ <div class="list-group">
+ <ul style="list-style-type:disc">
+
+ <li><a href="/installation/2015/03/13/On-Hadoop-CLI-installation/" class="list-group-item-lay pjaxlink">On Hadoop CLI installation</a></li>
+
+ <li><a href="/installation/2015/02/15/Off-Hadoop-CLI-Installation-(Dev-Env-Setup)/" class="list-group-item-lay pjaxlink">Off Hadoop CLI Installation (Dev Env Setup)</a></li>
+
+ <li><a href="/installation/2015/01/22/Kylin-Manual-Installation-Guide/" class="list-group-item-lay pjaxlink">Kylin Manual Installation Guide</a></li>
+
+ <li><a href="/installation/2015/01/22/Advance-settings-of-Kylin-environment/" class="list-group-item-lay pjaxlink">Advance settings of Kylin environment</a></li>
+
+ <li><a href="/installation/2014/12/05/On-Hadoop-Kylin-installation-using-Docker/" class="list-group-item-lay pjaxlink">On Hadoop Kylin installation using Docker</a></li>
+
+ <ul>
+ </div>
+ </div>
+
+ <!-- categories -->
+
+ <!-- categories -->
+
+ <!-- categories -->
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="#howto" data-toggle="collapse" >How to</a></li>
+ <div class="collapse in" id="howto">
+ <div class="list-group">
+ <ul style="list-style-type:disc">
+
+ <li><a href="/howto/2015/05/18/Export-Kylin-HBase-data/" class="list-group-item-lay pjaxlink">Export Kylin HBase data</a></li>
+
+ <li><a href="/howto/2015/03/18/How-to-use-kylin-remote-jdbc-driver/" class="list-group-item-lay pjaxlink">How to use kylin remote jdbc driver</a></li>
+
+ <li><a href="/howto/2015/03/05/Kylin-Metadata-Store/" class="list-group-item-lay pjaxlink">Kylin Metadata Store</a></li>
+
+ <li><a href="/howto/2015/03/03/How-to-consume-Kylin-REST-API-in-javascript/" class="list-group-item-lay pjaxlink">How to consume Kylin REST API in javascript</a></li>
+
+ <li><a href="/howto/2015/01/04/Run-Kylin-test-case-with-HBase-Mini-Cluster/" class="list-group-item-lay pjaxlink">Run Kylin test case with HBase Mini Cluster</a></li>
+
+ <li><a href="/howto/2014/12/09/New-meta-data-model-structure/" class="list-group-item-lay pjaxlink">New meta data model structure</a></li>
+
+ <li><a href="/howto/2014/11/14/How%20to%20install%20kylin%20in%20your%20Hadoop%20cluster/" class="list-group-item-lay pjaxlink">How to install kylin in your Hadoop cluster</a></li>
+
+ <li><a href="/howto/2014/10/24/How-to-Contribute/" class="list-group-item-lay pjaxlink">How to Contribute</a></li>
+
+ <li><a href="/howto/2014/10/23/Kylin-web-front-end-summary/" class="list-group-item-lay pjaxlink">Kylin web front end summary</a></li>
+
+ <ul>
+ </div>
+ </div>
+
+
+
+ <li><a href="#tutorial" data-toggle="collapse" >Tutorial</a></li>
+ <div class="collapse in" id="tutorial">
+ <div class="list-group">
+ <ul style="list-style-type:disc">
+
+ <li><a href="/tutorial/2015/04/17/Kylin-and-Tableau-Tutorial/" class="list-group-item-lay pjaxlink">Kylin and Tableau Tutorial</a></li>
+
+ <li><a href="/tutorial/2015/04/17/Kylin-Web-Tutorial/" class="list-group-item-lay pjaxlink">Kylin Web Tutorial</a></li>
+
+ <li><a href="/tutorial/2014/11/15/Kylin-Cube-Creation-Tutorial/" class="list-group-item-lay pjaxlink">Kylin Cube Creation Tutorial</a></li>
+
+ <li><a href="/tutorial/2014/11/11/Kylin-Cube-Permission-Grant-Tutorial/" class="list-group-item-lay pjaxlink">Kylin Cube Permission Grant Tutorial</a></li>
+
+ <li><a href="/tutorial/2014/11/06/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/" class="list-group-item-lay pjaxlink">Kylin Cube Build and Job Monitoring Tutorial</a></li>
+
+ <li><a href="/tutorial/2014/11/05/Kylin-ODBC-Driver-Tutorial/" class="list-group-item-lay pjaxlink">Kylin ODBC Driver Tutorial</a></li>
+
+ <ul>
+ </div>
+ </div>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="#api" data-toggle="collapse" >API</a></li>
+ <div class="collapse in" id="api">
+ <div class="list-group">
+ <ul style="list-style-type:disc">
+
+ <li><a href="/api/2015/03/18/Restful-Service-Doc/" class="list-group-item-lay pjaxlink">Restful Service Doc</a></li>
+
+ <li><a href="/api/2014/12/31/Build-Cube-with-Restful-API/" class="list-group-item-lay pjaxlink">Build Cube with Restful API</a></li>
+
+ <ul>
+ </div>
+ </div>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="#faq" data-toggle="collapse" >FAQ</a></li>
+ <div class="collapse in" id="faq">
+ <div class="list-group">
+ <ul style="list-style-type:disc">
+
+ <li><a href="/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/" class="list-group-item-lay pjaxlink">FAQ on Kylin Installation and Usage</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">
+ <!--
+* 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">FAQ on Kylin Installation and Usage</h1>
+ <p class="post-meta" >May 18, 2015 ⢠liyang-gmt8</p>
+ </header>
+
+ <article class="post-content" >
+ <h4 id="some-npm-error-causes-error-exit-">Some NPM error causes ERROR exit (ä¸å½å¤§éå°åºç¨æ·è¯·ç¹å«æ³¨ææ¤é®é¢)?</h4>
+<p>Check out <a href="https://github.com/KylinOLAP/Kylin/issues/35">https://github.com/KylinOLAP/Kylin/issues/35</a></p>
+
+<h4 id="cant-get-master-address-from-zookeeper-when-installing-kylin-on-hortonworks-sandbox">Canât get master address from ZooKeeperâ when installing Kylin on Hortonworks Sandbox</h4>
+<p>Check out <a href="https://github.com/KylinOLAP/Kylin/issues/9">https://github.com/KylinOLAP/Kylin/issues/9</a>.</p>
+
+<h4 id="install-scripted-finished-in-my-virtual-machine-but-cannot-visit-via-httplocalhost9080">Install scripted finished in my virtual machine, but cannot visit via http://localhost:9080</h4>
+<p>Check out <a href="https://github.com/KylinOLAP/Kylin/issues/12">https://github.com/KylinOLAP/Kylin/issues/12</a>.</p>
+
+<h4 id="map-reduce-job-information-cant-display-on-sandbox-deployment">Map Reduce Job information canât display on sandbox deployment</h4>
+<p>Check out <a href="https://github.com/KylinOLAP/Kylin/issues/40">https://github.com/KylinOLAP/Kylin/issues/40</a></p>
+
+<h4 id="install-kylin-on-cdh-52-or-hadoop-25x">Install Kylin on CDH 5.2 or Hadoop 2.5.x</h4>
+<p>Check out discussion: <a href="https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/kylin-olap/X0GZfsX1jLc/nzs6xAhNpLkJ">https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/kylin-olap/X0GZfsX1jLc/nzs6xAhNpLkJ</a></p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">I was able to deploy Kylin with following option in POM.
+<hadoop2.version>2.5.0</hadoop2.version>
+<yarn.version>2.5.0</yarn.version>
+<hbase-hadoop2.version>0.98.6-hadoop2</hbase-hadoop2.version>
+<zookeeper.version>3.4.5</zookeeper.version>
+<hive.version>0.13.1</hive.version>
+My Cluster is running on Cloudera Distribution CDH 5.2.0.</code></pre></div>
+
+<h4 id="unable-to-load-a-big-cube-as-htable-with-javalangoutofmemoryerror-unable-to-create-new-native-thread">Unable to load a big cube as HTable, with java.lang.OutOfMemoryError: unable to create new native thread</h4>
+<p>HBase (as of writing) allocates one thread per region when bulk loading a HTable. Try reduce the number of regions of your cube by setting its âcapacityâ to âMEDIUMâ or âLARGEâ. Also tweaks OS & JVM can allow more threads, for example see <a href="http://blog.egilh.com/2006/06/2811aspx.html">this article</a>.</p>
+
+<h4 id="failed-to-run-buildcubewithenginetest-saying-failed-to-connect-to-hbase-while-hbase-is-active">Failed to run BuildCubeWithEngineTest, saying failed to connect to hbase while hbase is active</h4>
+<p>User may get this error when first time run hbase client, please check the error trace to see whether there is an error saying couldnât access a folder like â/hadoop/hbase/local/jarsâ; If that folder doesnât exist, create it.</p>
+
+<h4 id="sumfield-returns-a-negtive-result-while-all-the-numbers-in-this-field-are--0">SUM(field) returns a negtive result while all the numbers in this field are > 0</h4>
+<p>If a column is declared as integer in Hive, the SQL engine (calcite) will use columnâs type (integer) as the data type for âSUM(field)â, while the aggregated value on this field may exceed the scope of integer; in that case the cast will cause a negtive value be returned; The workround is, alter that columnâs type to BIGINT in hive, and then sync the table schema to Kylin (the cube doesnât need rebuild); Keep in mind that, always declare as BIGINT in hive for an integer column which would be used as a measure in Kylin; See hive number types: <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-NumericTypes">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-NumericTypes</a></p>
+
+<h4 id="why-kylin-need-extract-the-distinct-columns-from-fact-table-before-building-cube">Why Kylin need extract the distinct columns from Fact Table before building cube?</h4>
+<p>Kylin uses dictionary to encode the values in each column, this greatly reduce the cubeâs storage size. To build the dictionary, Kylin need fetch the distinct values for each column.</p>
+
+<h4 id="why-kylin-calculate-the-hive-table-cardinality">Why Kylin calculate the HIVE table cardinality?</h4>
+<p>The cardinality of dimensions is an important measure of cube complexity. The higher the cardinality, the bigger the cube, and thus the longer to build and the slower to query. Cardinality > 1,000 is worth attention and > 1,000,000 should be avoided at best effort. For optimal cube performance, try reduce high cardinality by categorize values or derive features.</p>
+
+ </article>
+
+</div>
+
+
+
+
+
+ </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">
+ <div>
+ Apache Kylin is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.
+ </div>
+ <p style="text-align:center" > Apache Kylin is distributed under the <a href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank">Apache License v2.0. </a>
+ </p>
+ </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>