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:40:15 UTC
svn commit: r1681991 [4/8] - in /incubator/kylin/site: api/ api/2014/
api/2014/12/ api/2014/12/31/ api/2014/12/31/Build-Cube-with-Restful-API/
api/2015/ api/2015/03/ api/2015/03/18/ api/2015/03/18/Restful-Service-Doc/
howto/ howto/2014/ howto/2014/10/ ...
Added: incubator/kylin/site/howto/2015/01/04/Run-Kylin-test-case-with-HBase-Mini-Cluster/index.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/howto/2015/01/04/Run-Kylin-test-case-with-HBase-Mini-Cluster/index.html?rev=1681991&view=auto
==============================================================================
--- incubator/kylin/site/howto/2015/01/04/Run-Kylin-test-case-with-HBase-Mini-Cluster/index.html (added)
+++ incubator/kylin/site/howto/2015/01/04/Run-Kylin-test-case-with-HBase-Mini-Cluster/index.html Wed May 27 11:40:12 2015
@@ -0,0 +1,477 @@
+<!--
+* 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 | Run Kylin test case with HBase Mini Cluster</title>
+ <meta name="description" content="Run test case with HBase Mini Cluster">
+ <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/howto/2015/01/04/Run-Kylin-test-case-with-HBase-Mini-Cluster/">
+ <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">Run Kylin test case with HBase Mini Cluster</h1>
+ <p class="post-meta" >Jan 4, 2015 ⢠shaofengshi</p>
+ </header>
+
+ <article class="post-content" >
+ <h2 id="run-test-case-with-hbase-mini-cluster">Run test case with HBase Mini Cluster</h2>
+
+<p>Kylin is moving as many as possible unit test cases from sandbox to HBase mini cluster, so that user can run tests easily in local without a hadoop sandbox; Two maven profiles are created in the root pom.xml, âdefaultâ and âsandboxâ; The default profile will startup a HBase Mini Cluster to prepare the test data and run the unit tests (the test cases that are not supported by Mini cluster have been added in the âexcludeâ list); If you want to keep using Sandbox to run test, just run:
+mvn test -P sandbox</p>
+
+<h3 id="when-use-the-default-profile-kylin-will">When use the âdefaultâ profile, Kylin will:</h3>
+
+<ul>
+ <li>Startup a HBase minicluster and update KylinConfig with the dynamic HBase configurations;</li>
+ <li>Create Kylin metadata tables and import six example cube tables;</li>
+ <li>Import the hbase data from a tar ball from local: examples/test_case_data/minicluster/hbase-export.tar.gz (the hbase-export.tar.gz will be updated on complete of running BuildCubeWithEngineTestï¼</li>
+ <li>After all test cases be completed, shutdown minicluster and cleanup KylinConfig cache;</li>
+</ul>
+
+<h3 id="to-ensure-mini-cluster-can-run-successfully-you-need">To ensure Mini cluster can run successfully, you need:</h3>
+<ul>
+ <li>Make sure JAVA_HOME is properly set; </li>
+</ul>
+
+ </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>
Added: incubator/kylin/site/howto/2015/03/03/How-to-consume-Kylin-REST-API-in-javascript/index.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/howto/2015/03/03/How-to-consume-Kylin-REST-API-in-javascript/index.html?rev=1681991&view=auto
==============================================================================
--- incubator/kylin/site/howto/2015/03/03/How-to-consume-Kylin-REST-API-in-javascript/index.html (added)
+++ incubator/kylin/site/howto/2015/03/03/How-to-consume-Kylin-REST-API-in-javascript/index.html Wed May 27 11:40:12 2015
@@ -0,0 +1,498 @@
+<!--
+* 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 | How to consume Kylin REST API in javascript</title>
+ <meta name="description" content="Kypin securicty authorization is based on basic access authorization, so when you want to use API in your javascript,you need to involve the authorization in...">
+ <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/howto/2015/03/03/How-to-consume-Kylin-REST-API-in-javascript/">
+ <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">How to consume Kylin REST API in javascript</h1>
+ <p class="post-meta" >Mar 3, 2015 ⢠liyang-gmt8</p>
+ </header>
+
+ <article class="post-content" >
+ <p>Kypin securicty authorization is based on basic access authorization, so when you want to use API in your javascript,you need to involve the authorization info in http headers.</p>
+
+<h2 id="here-is-a-demo-show-how-to-use-kylin-query-api">Here is a demo show how to use Kylin Query API.</h2>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">$.ajaxSetup({
+ headers: { 'Authorization': "Basic eWFu**********X***ZA==", 'Content-Type': 'application/json;charset=utf-8' } // use your own authorization code here
+ });
+ var request = $.ajax({
+ url: "http://hostname/kylin/api/query",
+ type: "POST",
+ data: '{"sql":"select count(*) from SUMMARY;","offset":0,"limit":50000,"partial":true,"project":"test"}',
+ dataType: "json"
+ });
+ request.done(function( msg ) {
+ alert(msg);
+ });
+ request.fail(function( jqXHR, textStatus ) {
+ alert( "Request failed: " + textStatus );
+ });</code></pre></div>
+
+<p>For what is basic access authorization ,click here <a href="http://en.wikipedia.org/wiki/Basic_access_authentication">http://en.wikipedia.org/wiki/Basic_access_authentication</a></p>
+
+<h2 id="keypoint">Keypoint:</h2>
+<ol>
+ <li>add basic access authorization info in heders.</li>
+ <li>use right ajax type and right data synax</li>
+</ol>
+
+<p>How to generate your authorization code (download and import âjquery.base64.jsâ from <a href="https://github.com/yckart/jquery.base64.js">https://github.com/yckart/jquery.base64.js</a>)</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">var authorizationCode = $.base64('encode', 'NT_USERNAME' + ":" + 'NT_PASSWORD');
+
+$.ajaxSetup({
+ headers: {
+ 'Authorization': "Basic " + authorizationCode,
+ 'Content-Type': 'application/json;charset=utf-8'
+ }
+});</code></pre></div>
+
+
+ </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>
Added: incubator/kylin/site/howto/2015/03/05/Kylin-Metadata-Store/index.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/howto/2015/03/05/Kylin-Metadata-Store/index.html?rev=1681991&view=auto
==============================================================================
--- incubator/kylin/site/howto/2015/03/05/Kylin-Metadata-Store/index.html (added)
+++ incubator/kylin/site/howto/2015/03/05/Kylin-Metadata-Store/index.html Wed May 27 11:40:12 2015
@@ -0,0 +1,489 @@
+<!--
+* 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 | Kylin Metadata Store</title>
+ <meta name="description" content="Kylin organizes all of its metadata(including cube descriptions and instances, projects, inverted index description and instances, jobs, tables and dictionar...">
+ <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/howto/2015/03/05/Kylin-Metadata-Store/">
+ <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">Kylin Metadata Store</h1>
+ <p class="post-meta" >Mar 5, 2015 ⢠hongbin ma</p>
+ </header>
+
+ <article class="post-content" >
+ <p>Kylin organizes all of its metadata(including cube descriptions and instances, projects, inverted index description and instances, jobs, tables and dictionaries) as a hierarchy file system. However, Kylin uses hbase to store it, rather than normal file system. If you check your kylin configuration file(kylin.properties) you will find such a line:</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff"># The metadata store in hbase
+kylin.metadata.url=kylin_metadata_qa@hbase:sandbox.hortonworks.com:2181:/hbase-unsecure</code></pre></div>
+
+<p>This indicates that the metadata will be saved as a htable called <code>kylin_metadata_qa</code>. You can scan the htable in hbase shell to check it out.</p>
+
+<h1 id="backup-metadata-store">Backup Metadata Store</h1>
+
+<p>Sometimes you need to backup the Kylinâs Metadata Store from hbase to your disk file system.
+In such cases, assuming youâre on the hadoop CLI(or sandbox) where you deployed Kylin, you can use:</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">mkdir ~/meta_dump
+
+hbase org.apache.hadoop.util.RunJar PATH_TO_KYLIN_JOB_JAR_FOLDER/kylin-job-x.x.x-SNAPSHOT-job.jar com.kylinolap.common.persistence.ResourceTool copy PATH_TO_KYLIN_CONFIG/kylin.properties ~/meta_dump</code></pre></div>
+
+<p>to dump your metadata to your local folder ~/meta_dump.</p>
+
+<h1 id="restore-metadata-store">Restore Metadata Store</h1>
+
+<p>In case you find your metadata store messed up, and you want to restore to a previous backup:</p>
+
+<p>first clean up the metadata store:</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">hbase org.apache.hadoop.util.RunJar PATH_TO_KYLIN_JOB_JAR_FOLDER/kylin-job-x.x.x-SNAPSHOT-job.jar com.kylinolap.common.persistence.ResourceTool reset</code></pre></div>
+
+<p>then upload the backup metadata in ~/meta_dump to Kylinâs metadata store:</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">hbase org.apache.hadoop.util.RunJar PATH_TO_KYLIN_JOB_JAR_FOLDER/kylin-job-x.x.x-SNAPSHOT-job.jar com.kylinolap.common.persistence.ResourceTool copy ~/meta_dump PATH_TO_KYLIN_CONFIG/kylin.properties</code></pre></div>
+
+
+ </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>
Added: incubator/kylin/site/howto/2015/03/18/How-to-use-kylin-remote-jdbc-driver/index.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/howto/2015/03/18/How-to-use-kylin-remote-jdbc-driver/index.html?rev=1681991&view=auto
==============================================================================
--- incubator/kylin/site/howto/2015/03/18/How-to-use-kylin-remote-jdbc-driver/index.html (added)
+++ incubator/kylin/site/howto/2015/03/18/How-to-use-kylin-remote-jdbc-driver/index.html Wed May 27 11:40:12 2015
@@ -0,0 +1,546 @@
+<!--
+* 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 | How to use kylin remote jdbc driver</title>
+ <meta name="description" content="Authentication">
+ <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/howto/2015/03/18/How-to-use-kylin-remote-jdbc-driver/">
+ <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">How to use kylin remote jdbc driver</h1>
+ <p class="post-meta" >Mar 18, 2015 ⢠SHAOFENG SHI</p>
+ </header>
+
+ <article class="post-content" >
+ <h3 id="authentication">Authentication</h3>
+
+<h6 id="build-on-kylin-authentication-restful-service-supported-parameters">Build on kylin authentication restful service. Supported parameters:</h6>
+<ul>
+ <li>user : username </li>
+ <li>password : password</li>
+ <li>ssl: true/false. Default be false; If true, all the services call will use https.</li>
+</ul>
+
+<h3 id="connection-url-format">Connection URL format:</h3>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">jdbc:kylin://<hostname>:<port>/<kylin_project_name></code></pre></div>
+
+<ul>
+ <li>If âsslâ = true, the âportâ should be Kylin serverâs HTTPS port; </li>
+ <li>If âportâ is not specified, the driver will use default port: HTTP 80, HTTPS 443;</li>
+ <li>The âkylin_project_nameâ must be specified and user need ensure it exists in Kylin server;</li>
+</ul>
+
+<h3 id="query-with-statement">1. Query with Statement</h3>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
+
+ Properties info = new Properties();
+ info.put("user", "ADMIN");
+ info.put("password", "KYLIN");
+ Connection conn = driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
+ Statement state = conn.createStatement();
+ ResultSet resultSet = state.executeQuery("select * from test_table");
+
+ while (resultSet.next()) {
+ assertEquals("foo", resultSet.getString(1));
+ assertEquals("bar", resultSet.getString(2));
+ assertEquals("tool", resultSet.getString(3));
+ }</code></pre></div>
+
+<h3 id="query-with-preparedstatement">2. Query with PreparedStatement</h3>
+
+<h6 id="supported-prepared-statement-parameters">Supported prepared statement parameters:</h6>
+<ul>
+ <li>setString</li>
+ <li>setInt</li>
+ <li>setShort</li>
+ <li>setLong</li>
+ <li>setFloat</li>
+ <li>setDouble</li>
+ <li>setBoolean</li>
+ <li>setByte</li>
+ <li>setDate</li>
+ <li>setTime</li>
+ <li>setTimestamp</li>
+</ul>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
+ Properties info = new Properties();
+ info.put("user", "ADMIN");
+ info.put("password", "KYLIN");
+ Connection conn = driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
+ PreparedStatement state = conn.prepareStatement("select * from test_table where id=?");
+ state.setInt(1, 10);
+ ResultSet resultSet = state.executeQuery();
+
+ while (resultSet.next()) {
+ assertEquals("foo", resultSet.getString(1));
+ assertEquals("bar", resultSet.getString(2));
+ assertEquals("tool", resultSet.getString(3));
+ }</code></pre></div>
+
+<h3 id="get-query-result-metadata">3. Get query result metadata</h3>
+<p>Kylin jdbc driver supports metadata list methods:
+List catalog, schema, table and column with sql pattern filters(such as %).</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
+ Properties info = new Properties();
+ info.put("user", "ADMIN");
+ info.put("password", "KYLIN");
+ Connection conn = driver.connect("jdbc:kylin://localhost:7070/kylin_project_name", info);
+ Statement state = conn.createStatement();
+ ResultSet resultSet = state.executeQuery("select * from test_table");
+
+ ResultSet tables = conn.getMetaData().getTables(null, null, "dummy", null);
+ while (tables.next()) {
+ for (int i = 0; i < 10; i++) {
+ assertEquals("dummy", tables.getString(i + 1));
+ }
+ }</code></pre></div>
+
+
+ </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>