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/08/04 13:54:27 UTC
svn commit: r1694034 [3/4] - in /incubator/kylin/site: ./ about/ assets/
blog/ cn/ community/ development/ docs/ download/ images/
Added: incubator/kylin/site/development/rest_api.html
URL: http://svn.apache.org/viewvc/incubator/kylin/site/development/rest_api.html?rev=1694034&view=auto
==============================================================================
--- incubator/kylin/site/development/rest_api.html (added)
+++ incubator/kylin/site/development/rest_api.html Tue Aug 4 11:54:26 2015
@@ -0,0 +1,2504 @@
+<!--
+* 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 | REST API</title>
+ <meta name="description" content="Apache Kylin Home">
+ <meta name="author" content="Apache Kylin">
+ <link rel="shortcut icon" href="fav.png" type="image/png">
+
+
+
+<link rel="stylesheet" href="/assets/css/animate.css">
+<!-- Bootstrap -->
+<link rel="stylesheet" href="/assets/css/bootstrap.min.css">
+
+<!-- Fonts -->
+<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> -->
+
+<!-- Icons -->
+<link rel="stylesheet" href="/assets/css/font-awesome.min.css">
+
+ <!-- Custom styles -->
+ <link rel="stylesheet" href="/assets/css/styles.css">
+ <link rel="stylesheet" href="/assets/css/docs.css">
+ <link rel="stylesheet" href="/assets/css/pygments.css">
+
+ <link rel="canonical" href="http://kylin.incubator.apache.org/development/rest_api.html">
+ <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.incubator.apache.org/feed.xml" />
+
+<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]-->
+<script>
+ (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+ m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+ })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+ //oringal tracker for kylin.io
+ ga('create', 'UA-55534813-1', 'auto');
+ //new tracker for kylin.incubator.apache.org
+ ga('create', 'UA-55534813-2', 'auto', {'name':'incubator'});
+
+ ga('send', 'pageview');
+ ga('incubator.send', 'pageview');
+
+
+</script>
+<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/assets/js/nside.js"></script> </script>
+<script type="text/javascript" src="/assets/js/nnav.js"></script> </script>
+</head>
+
+ <body>
+ <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<header id="header" >
+
+ <div id="head" class="parallax" parallax-speed="3" >
+ <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="/assets/images/kylin_logo.jpg"> <span class="title" >Apache Kylin</span> <span class="tagline">Extreme OLAP Engine for Big Data</span>
+ </div>
+ </div>
+
+
+ <!-- Main Menu -->
+ <nav class="navbar navbar-default" role="navigation" id="nav-wrapper">
+ <div class="container-fluid" id="nav">
+ <!--
+ <img class="img-circle" width="40px" height="40px" id="circlelogo" src="/assets/images/kylin_logo.jpg">
+ -->
+ <!-- Brand and toggle get grouped for better mobile display -->
+ <div class="navbar-header">
+ <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
+ <span class="sr-only">Toggle navigation</span>
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ </button>
+
+ </div>
+
+ <!-- Collect the nav links, forms, and other content for toggling -->
+ <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
+ <ul class="nav navbar-nav">
+ <li><a href="/">Home</a></li>
+ <li><a href="/docs" >Docs</a></li>
+ <li><a href="/download">Download</li>
+ <li><a href="/community" >Community</a></li>
+ <li><a href="/development" >Development</a></li>
+ <li><a href="/blog">Blog</li>
+ <li><a href="/cn" >䏿ç</a></li>
+ <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li>
+ <li><a href="https://github.com/apache/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="container">
+ <div class="row">
+ <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" id="nside1" style=" padding-top: 2em">
+ <ul class="nav nav-pills nav-stacked">
+
+ <li><a href="#titleDevelopment Guide" data-toggle="collapse" id="navtitle">Development Guide</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul style="list-style-type:disc">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/index.html" class="list-group-item-lay pjaxlink">Development Quick Guide</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/dev_env.html" class="list-group-item-lay pjaxlink">Setup Development Env</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/metadata_store.html" class="list-group-item-lay pjaxlink">Kylin Metadata Store</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/new_metadata.html" class="list-group-item-lay pjaxlink">New meta data model structure</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/rest_api.html" class="list-group-item-lay pjaxlink">REST API</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/build_api.html" class="list-group-item-lay pjaxlink">Build Cube with Restful API</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/javascript_api.html" class="list-group-item-lay pjaxlink">How to consume Kylin REST API in javascript</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/web_tech.html" class="list-group-item-lay pjaxlink">Kylin web front end summary</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/development/test_minicluster.html" class="list-group-item-lay pjaxlink">Run Kylin test case with HBase Mini Cluster</a></li>
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+
+ </ul>
+</div>
+ <div class="col-md-9 col-lg-9 col-xs-14 aside2">
+ <div id="container">
+ <div id="pjax">
+ <h1 class="post-title">REST API</h1>
+ <h2 id="kylin-restful-api-list">Kylin Restful API List</h2>
+
+<ul>
+ <li>QUERY
+ <ul>
+ <li>Login</li>
+ <li>Query</li>
+ <li>List queryable tables</li>
+ </ul>
+ </li>
+ <li>CUBE
+ <ul>
+ <li>List cubes</li>
+ <li>Rebuild cube</li>
+ <li>Disable cube</li>
+ <li>Purge cube</li>
+ <li>Enable cube</li>
+ </ul>
+ </li>
+ <li>JOB
+ <ul>
+ <li>Resume job</li>
+ <li>Discard job</li>
+ <li>Get job step log</li>
+ </ul>
+ </li>
+ <li>Metadata
+ <ul>
+ <li>Get Hive Table</li>
+ <li>Get Hive Table (Extend Info)</li>
+ <li>Get Hive Tables</li>
+ <li>Load Hive Table</li>
+ </ul>
+ </li>
+ <li>Wipe cache</li>
+</ul>
+
+<h3 id="login">Login</h3>
+<p><code class="highlighter-rouge">POST /user/authentication</code></p>
+
+<p>for example: <br />
+```sh</p>
+
+<p>curl -c /path/to/cookiefile.txt -X POST -H âAuthorization: Basic XXXXXXXXXâ -H âContent-Type: application/jsonâ http://<host>:<port>/kylin/api/user/authentication
+```</port></host></p>
+
+<p>If login successfully, the JSESSIONID will be saved into the cookie file; In the subsequent http requests, attach the cookie, for example:</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>curl -b /path/to/cookiefile.txt -X PUT -H <span class="s1">'Content-Type: application/json'</span> -d <span class="s1">'{"startTime":'</span>1423526400000<span class="s1">', "endTime":'</span>1423526400<span class="s1">', "buildType":"BUILD"}'</span> http://<host>:<port>/kylin/api/cubes/your_cube/rebuild
+</code></pre>
+</div>
+
+<h3 id="header">Header</h3>
+<p>Authorization data encoded by basic auth. Header sample:<br />
+Authorization:Basic {data}<br />
+### Response Sample<br />
+```sh</p>
+
+<p>Status: 200OK<br />
+<code class="highlighter-rouge">
+</code>sh<br />
+{ <br />
+ âuserDetailsâ:{ <br />
+ âpasswordâ:null,<br />
+ âusernameâ:âsampleâ,<br />
+ âauthoritiesâ:[ <br />
+ { <br />
+ âauthorityâ:âROLE_ANALYSTâ<br />
+ },<br />
+ { <br />
+ âauthorityâ:âROLE_MODELERâ<br />
+ }<br />
+ ],<br />
+ âaccountNonExpiredâ:true,<br />
+ âaccountNonLockedâ:true,<br />
+ âcredentialsNonExpiredâ:true,<br />
+ âenabledâ:true<br />
+ }<br />
+}<br />
+```</p>
+
+<hr />
+
+<h3 id="query">Query</h3>
+<p><code class="highlighter-rouge">POST /query</code><br />
+### Request Body<br />
+* sql - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The sql query string.<br />
+* offset - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">int</code> Query offset. If offset is set in sql, curIndex will be ignored.<br />
+* limit - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">int</code> Query limit. If limit is set in sql, perPage will be ignored.<br />
+* acceptPartial - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">bool</code> Flag to switch partial query.<br />
+* project - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> Project to perform query. Default value is âDEFAULTâ<br />
+<code class="highlighter-rouge">sh
+{
+ "sql":"select * from TEST_KYLIN_FACT",
+ "offset":0,
+ "limit":50000,
+ "acceptPartial":true,
+ "project":"DEFAULT"
+}
+</code></p>
+
+<h3 id="response-sample">Response Sample</h3>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>Status: 200OK
+</code></pre>
+</div>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+ <span class="s2">"columnMetas"</span>:[
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:0,
+ <span class="s2">"label"</span>:<span class="s2">"CAL_DT"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"CAL_DT"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:0,
+ <span class="s2">"scale"</span>:0,
+ <span class="s2">"columnType"</span>:91,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"DATE"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:10,
+ <span class="s2">"label"</span>:<span class="s2">"LEAF_CATEG_ID"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"LEAF_CATEG_ID"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:10,
+ <span class="s2">"scale"</span>:0,
+ <span class="s2">"columnType"</span>:4,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"INTEGER"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:10,
+ <span class="s2">"label"</span>:<span class="s2">"LSTG_SITE_ID"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"LSTG_SITE_ID"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:10,
+ <span class="s2">"scale"</span>:0,
+ <span class="s2">"columnType"</span>:4,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"INTEGER"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:5,
+ <span class="s2">"label"</span>:<span class="s2">"SLR_SEGMENT_CD"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"SLR_SEGMENT_CD"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:5,
+ <span class="s2">"scale"</span>:0,
+ <span class="s2">"columnType"</span>:5,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"SMALLINT"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:256,
+ <span class="s2">"label"</span>:<span class="s2">"LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:256,
+ <span class="s2">"scale"</span>:0,
+ <span class="s2">"columnType"</span>:12,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"VARCHAR(256)"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:19,
+ <span class="s2">"label"</span>:<span class="s2">"SELLER_ID"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"SELLER_ID"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:19,
+ <span class="s2">"scale"</span>:0,
+ <span class="s2">"columnType"</span>:-5,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"BIGINT"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:19,
+ <span class="s2">"label"</span>:<span class="s2">"PRICE"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"PRICE"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:19,
+ <span class="s2">"scale"</span>:4,
+ <span class="s2">"columnType"</span>:3,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"DECIMAL(19, 4)"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:19,
+ <span class="s2">"label"</span>:<span class="s2">"MIN_PRICE_"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"MIN_PRICE_"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:19,
+ <span class="s2">"scale"</span>:4,
+ <span class="s2">"columnType"</span>:3,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"DECIMAL(19, 4)"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:19,
+ <span class="s2">"label"</span>:<span class="s2">"MAX_PRICE_"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"MAX_PRICE_"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:19,
+ <span class="s2">"scale"</span>:4,
+ <span class="s2">"columnType"</span>:3,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"DECIMAL(19, 4)"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"isNullable"</span>:1,
+ <span class="s2">"displaySize"</span>:19,
+ <span class="s2">"label"</span>:<span class="s2">"COUNT__"</span>,
+ <span class="s2">"name"</span>:<span class="s2">"COUNT__"</span>,
+ <span class="s2">"schemaName"</span>:null,
+ <span class="s2">"catelogName"</span>:null,
+ <span class="s2">"tableName"</span>:null,
+ <span class="s2">"precision"</span>:19,
+ <span class="s2">"scale"</span>:0,
+ <span class="s2">"columnType"</span>:-5,
+ <span class="s2">"columnTypeName"</span>:<span class="s2">"BIGINT"</span>,
+ <span class="s2">"readOnly"</span>:true,
+ <span class="s2">"writable"</span>:false,
+ <span class="s2">"caseSensitive"</span>:true,
+ <span class="s2">"searchable"</span>:false,
+ <span class="s2">"currency"</span>:false,
+ <span class="s2">"signed"</span>:true,
+ <span class="s2">"autoIncrement"</span>:false,
+ <span class="s2">"definitelyWritable"</span>:false
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"results"</span>:[
+ <span class="o">[</span>
+ <span class="s2">"2013-08-07"</span>,
+ <span class="s2">"32996"</span>,
+ <span class="s2">"15"</span>,
+ <span class="s2">"15"</span>,
+ <span class="s2">"Auction"</span>,
+ <span class="s2">"10000000"</span>,
+ <span class="s2">"49.048952730908745"</span>,
+ <span class="s2">"49.048952730908745"</span>,
+ <span class="s2">"49.048952730908745"</span>,
+ <span class="s2">"1"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"2013-08-07"</span>,
+ <span class="s2">"43398"</span>,
+ <span class="s2">"0"</span>,
+ <span class="s2">"14"</span>,
+ <span class="s2">"ABIN"</span>,
+ <span class="s2">"10000633"</span>,
+ <span class="s2">"85.78317064220418"</span>,
+ <span class="s2">"85.78317064220418"</span>,
+ <span class="s2">"85.78317064220418"</span>,
+ <span class="s2">"1"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"2013-08-07"</span>,
+ <span class="s2">"170083"</span>,
+ <span class="s2">"3"</span>,
+ <span class="s2">"12"</span>,
+ <span class="s2">"FP-non GTC"</span>,
+ <span class="s2">"10000688"</span>,
+ <span class="s2">"49.4518822857833"</span>,
+ <span class="s2">"49.4518822857833"</span>,
+ <span class="s2">"49.4518822857833"</span>,
+ <span class="s2">"1"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"2013-08-07"</span>,
+ <span class="s2">"73506"</span>,
+ <span class="s2">"0"</span>,
+ <span class="s2">"14"</span>,
+ <span class="s2">"Others"</span>,
+ <span class="s2">"10000858"</span>,
+ <span class="s2">"35.7556514660872"</span>,
+ <span class="s2">"35.7556514660872"</span>,
+ <span class="s2">"35.7556514660872"</span>,
+ <span class="s2">"1"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"2013-08-07"</span>,
+ <span class="s2">"26262"</span>,
+ <span class="s2">"0"</span>,
+ <span class="s2">"5"</span>,
+ <span class="s2">"FP-GTC"</span>,
+ <span class="s2">"10000914"</span>,
+ <span class="s2">"69.63202173718798"</span>,
+ <span class="s2">"69.63202173718798"</span>,
+ <span class="s2">"69.63202173718798"</span>,
+ <span class="s2">"1"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"2013-08-07"</span>,
+ <span class="s2">"1161"</span>,
+ <span class="s2">"3"</span>,
+ <span class="s2">"12"</span>,
+ <span class="s2">"Others"</span>,
+ <span class="s2">"10000959"</span>,
+ <span class="s2">"76.72392839984632"</span>,
+ <span class="s2">"76.72392839984632"</span>,
+ <span class="s2">"76.72392839984632"</span>,
+ <span class="s2">"1"</span>
+ <span class="o">]</span>
+ <span class="o">]</span>,
+ <span class="s2">"cube"</span>:<span class="s2">"test_kylin_cube_with_slr_desc"</span>,
+ <span class="s2">"affectedRowCount"</span>:0,
+ <span class="s2">"isException"</span>:false,
+ <span class="s2">"exceptionMessage"</span>:null,
+ <span class="s2">"duration"</span>:3451,
+ <span class="s2">"partial"</span>:false
+<span class="o">}</span>
+</code></pre>
+</div>
+
+<hr />
+
+<h3 id="list-queryable-tables">List queryable tables</h3>
+<p><code class="highlighter-rouge">GET /tables_and_columns</code><br />
+### Request Parameters<br />
+* project - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The project to load tables</p>
+
+<h3 id="response-sample-1">Response Sample</h3>
+<div class="highlighter-rouge"><pre class="highlight"><code>Status: 200OK
+</code></pre>
+</div>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
+ <span class="o">{</span>
+ <span class="s2">"columns"</span>:[
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CAL_DT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"CAL_DT"</span>,
+ <span class="s2">"data_TYPE"</span>:91,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:1,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"DATE"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CAL_DT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"WEEK_BEG_DT"</span>,
+ <span class="s2">"data_TYPE"</span>:91,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:2,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"DATE"</span>
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CAL_DT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"ref_GENERATION"</span>:null,
+ <span class="s2">"self_REFERENCING_COL_NAME"</span>:null,
+ <span class="s2">"type_SCHEM"</span>:null,
+ <span class="s2">"table_TYPE"</span>:<span class="s2">"TABLE"</span>,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_CAT"</span>:null,
+ <span class="s2">"type_NAME"</span>:null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"columns"</span>:[
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"LEAF_CATEG_ID"</span>,
+ <span class="s2">"data_TYPE"</span>:4,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:1,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"INTEGER"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"SITE_ID"</span>,
+ <span class="s2">"data_TYPE"</span>:4,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:2,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"INTEGER"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"META_CATEG_NAME"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:3,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"CATEG_LVL2_NAME"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:4,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"CATEG_LVL3_NAME"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:5,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"USER_DEFINED_FIELD1"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:6,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"USER_DEFINED_FIELD3"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:7,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"UPD_DATE"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:8,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"UPD_USER"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:9,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"ref_GENERATION"</span>:null,
+ <span class="s2">"self_REFERENCING_COL_NAME"</span>:null,
+ <span class="s2">"type_SCHEM"</span>:null,
+ <span class="s2">"table_TYPE"</span>:<span class="s2">"TABLE"</span>,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_CAT"</span>:null,
+ <span class="s2">"type_NAME"</span>:null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"columns"</span>:[
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"CAL_DT"</span>,
+ <span class="s2">"data_TYPE"</span>:91,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:1,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"DATE"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"LEAF_CATEG_ID"</span>,
+ <span class="s2">"data_TYPE"</span>:4,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:2,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"INTEGER"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"LSTG_SITE_ID"</span>,
+ <span class="s2">"data_TYPE"</span>:4,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:3,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"INTEGER"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"SLR_SEGMENT_CD"</span>,
+ <span class="s2">"data_TYPE"</span>:5,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:4,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"SMALLINT"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:5,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"SELLER_ID"</span>,
+ <span class="s2">"data_TYPE"</span>:-5,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:6,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"BIGINT"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"PRICE"</span>,
+ <span class="s2">"data_TYPE"</span>:3,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:19,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:4,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:19,
+ <span class="s2">"ordinal_POSITION"</span>:7,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"DECIMAL(19, 4)"</span>
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_KYLIN_FACT"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"ref_GENERATION"</span>:null,
+ <span class="s2">"self_REFERENCING_COL_NAME"</span>:null,
+ <span class="s2">"type_SCHEM"</span>:null,
+ <span class="s2">"table_TYPE"</span>:<span class="s2">"TABLE"</span>,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_CAT"</span>:null,
+ <span class="s2">"type_NAME"</span>:null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"columns"</span>:[
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_SELLER_TYPE_DIM"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"SELLER_TYPE_CD"</span>,
+ <span class="s2">"data_TYPE"</span>:5,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:1,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"SMALLINT"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_SELLER_TYPE_DIM"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"SELLER_TYPE_DESC"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:2,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_SELLER_TYPE_DIM"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"ref_GENERATION"</span>:null,
+ <span class="s2">"self_REFERENCING_COL_NAME"</span>:null,
+ <span class="s2">"type_SCHEM"</span>:null,
+ <span class="s2">"table_TYPE"</span>:<span class="s2">"TABLE"</span>,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_CAT"</span>:null,
+ <span class="s2">"type_NAME"</span>:null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"columns"</span>:[
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_SITES"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"SITE_ID"</span>,
+ <span class="s2">"data_TYPE"</span>:4,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:-1,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:-1,
+ <span class="s2">"ordinal_POSITION"</span>:1,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"INTEGER"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_SITES"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"SITE_NAME"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:2,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_SITES"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"column_NAME"</span>:<span class="s2">"CRE_USER"</span>,
+ <span class="s2">"data_TYPE"</span>:12,
+ <span class="s2">"nullable"</span>:1,
+ <span class="s2">"column_SIZE"</span>:256,
+ <span class="s2">"buffer_LENGTH"</span>:-1,
+ <span class="s2">"decimal_DIGITS"</span>:0,
+ <span class="s2">"num_PREC_RADIX"</span>:10,
+ <span class="s2">"column_DEF"</span>:null,
+ <span class="s2">"sql_DATA_TYPE"</span>:-1,
+ <span class="s2">"sql_DATETIME_SUB"</span>:-1,
+ <span class="s2">"char_OCTET_LENGTH"</span>:256,
+ <span class="s2">"ordinal_POSITION"</span>:3,
+ <span class="s2">"is_NULLABLE"</span>:<span class="s2">"YES"</span>,
+ <span class="s2">"scope_CATLOG"</span>:null,
+ <span class="s2">"scope_SCHEMA"</span>:null,
+ <span class="s2">"scope_TABLE"</span>:null,
+ <span class="s2">"source_DATA_TYPE"</span>:-1,
+ <span class="s2">"iS_AUTOINCREMENT"</span>:null,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_NAME"</span>:<span class="s2">"VARCHAR(256) CHARACTER SET </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="se">\"</span><span class="s2"> COLLATE </span><span class="se">\"</span><span class="s2">UTF-16LE</span><span class="nv">$en_US$primary</span><span class="se">\"</span><span class="s2">"</span>
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"table_NAME"</span>:<span class="s2">"TEST_SITES"</span>,
+ <span class="s2">"table_SCHEM"</span>:<span class="s2">"EDW"</span>,
+ <span class="s2">"ref_GENERATION"</span>:null,
+ <span class="s2">"self_REFERENCING_COL_NAME"</span>:null,
+ <span class="s2">"type_SCHEM"</span>:null,
+ <span class="s2">"table_TYPE"</span>:<span class="s2">"TABLE"</span>,
+ <span class="s2">"table_CAT"</span>:<span class="s2">"defaultCatalog"</span>,
+ <span class="s2">"remarks"</span>:null,
+ <span class="s2">"type_CAT"</span>:null,
+ <span class="s2">"type_NAME"</span>:null
+ <span class="o">}</span>
+<span class="o">]</span>
+</code></pre>
+</div>
+
+<hr />
+
+<h3 id="list-cubes">List cubes</h3>
+<p><code class="highlighter-rouge">GET /cubes</code><br />
+### Request Parameters<br />
+* cubeName - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> Cube name to find.<br />
+* offset - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">int</code> Offset used by pagination<br />
+* limit - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">int </code> Cubes per page.</p>
+
+<h3 id="response-sample-2">Response Sample</h3>
+<div class="highlighter-rouge"><pre class="highlight"><code>Status: 200OK
+</code></pre>
+</div>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
+ <span class="o">{</span>
+ <span class="s2">"uuid"</span>:<span class="s2">"1eaca32a-a33e-4b69-83dd-0bb8b1f8c53b"</span>,
+ <span class="s2">"last_modified"</span>:1407831634847,
+ <span class="s2">"name"</span>:<span class="s2">"test_kylin_cube_with_slr_empty"</span>,
+ <span class="s2">"owner"</span>:null,
+ <span class="s2">"version"</span>:null,
+ <span class="s2">"descriptor"</span>:<span class="s2">"test_kylin_cube_with_slr_desc"</span>,
+ <span class="s2">"cost"</span>:50,
+ <span class="s2">"status"</span>:<span class="s2">"DISABLED"</span>,
+ <span class="s2">"segments"</span>:[
+ <span class="o">]</span>,
+ <span class="s2">"create_time"</span>:null,
+ <span class="s2">"source_records_count"</span>:0,
+ <span class="s2">"source_records_size"</span>:0,
+ <span class="s2">"size_kb"</span>:0
+ <span class="o">}</span>
+<span class="o">]</span>
+</code></pre>
+</div>
+
+<h3 id="rebuild-cube">Rebuild cube</h3>
+<p><code class="highlighter-rouge">PUT /cubes/{cubeName}/rebuild</code><br />
+### Path Variable<br />
+* cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</p>
+
+<h3 id="request-body">Request Body</h3>
+<ul>
+ <li>startTime - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">long</code> Start timestamp of data to build, e.g. 1388563200000 for 2014-1-1</li>
+ <li>endTime - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">long</code> End timestamp of data to build</li>
+ <li>buildType - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Build type: âBUILDâ OR âMERGEâ</li>
+</ul>
+
+<h3 id="response-sample-3">Response Sample</h3>
+<div class="highlighter-rouge"><pre class="highlight"><code>Status: 200OK
+</code></pre>
+</div>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+ <span class="s2">"uuid"</span>:<span class="s2">"c143e0e4-ac5f-434d-acf3-46b0d15e3dc6"</span>,
+ <span class="s2">"last_modified"</span>:1407908916705,
+ <span class="s2">"name"</span>:<span class="s2">"test_kylin_cube_with_slr_empty - 19700101000000_20140731160000 - BUILD - PDT 2014-08-12 22:48:36"</span>,
+ <span class="s2">"type"</span>:<span class="s2">"BUILD"</span>,
+ <span class="s2">"duration"</span>:0,
+ <span class="s2">"related_cube"</span>:<span class="s2">"test_kylin_cube_with_slr_empty"</span>,
+ <span class="s2">"related_segment"</span>:<span class="s2">"19700101000000_20140731160000"</span>,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"mr_waiting"</span>:0,
+ <span class="s2">"steps"</span>:[
+ <span class="o">{</span>
+ <span class="s2">"interruptCmd"</span>:null,
+ <span class="s2">"name"</span>:<span class="s2">"Create Intermediate Flat Hive Table"</span>,
+ <span class="s2">"sequence_id"</span>:0,
+ <span class="s2">"exec_cmd"</span>:<span class="s2">"hive -e </span><span class="se">\"</span><span class="s2">DROP TABLE IF EXISTS kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6;</span><span class="se">\n</span><span class="s2">CREATE EXTERNAL TABLE IF NOT EXISTS kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6</span><span class="se">\n</span><span class="s2">(</span><span class="se">\n</span><span class="s2">CAL_DT date</span><span class="se">\n</span><span class="s2">,LEAF_CATEG_ID int</span><span class="se">\n</span><span class="s2">,LSTG_SITE_ID int</span><span class="se">\n</span><span class="s2">,META_CATEG_NAME string</span><span class="se">\n</span><span class="s2">,CATEG_LVL2_NAME string</span><span class="se">\n</span><span class="s2">,CATEG_LVL3_NAME string</span><span class="se">\n</span><span class="s2">,LSTG_FORMAT_NAME strin
g</span><span class="se">\n</span><span class="s2">,SLR_SEGMENT_CD smallint</span><span class="se">\n</span><span class="s2">,SELLER_ID bigint</span><span class="se">\n</span><span class="s2">,PRICE decimal</span><span class="se">\n</span><span class="s2">)</span><span class="se">\n</span><span class="s2">ROW FORMAT DELIMITED FIELDS TERMINATED BY '</span><span class="se">\\</span><span class="s2">177'</span><span class="se">\n</span><span class="s2">STORED AS SEQUENCEFILE</span><span class="se">\n</span><span class="s2">LOCATION '/tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6';</span><span class="se">\n</span><span class="s2">SET mapreduce.job.split.metainfo.maxsize=-1;</span><span class="se">\n</span><span class="s2">SET mapred.compress.map.output=true;</span><span class="se">\n</span><span class="s2">SET mapred.map.output.compression.codec=com.hadoop.compression.lzo
.LzoCodec;</span><span class="se">\n</span><span class="s2">SET mapred.output.compress=true;</span><span class="se">\n</span><span class="s2">SET mapred.output.compression.codec=com.hadoop.compression.lzo.LzoCodec;</span><span class="se">\n</span><span class="s2">SET mapred.output.compression.type=BLOCK;</span><span class="se">\n</span><span class="s2">SET mapreduce.job.max.split.locations=2000;</span><span class="se">\n</span><span class="s2">SET hive.exec.compress.output=true;</span><span class="se">\n</span><span class="s2">SET hive.auto.convert.join.noconditionaltask = true;</span><span class="se">\n</span><span class="s2">SET hive.auto.convert.join.noconditionaltask.size = 300000000;</span><span class="se">\n</span><span class="s2">INSERT OVERWRITE TABLE kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6</span><span class="se">\n</span><span class="s2">SELECT</span><span class="se">\n</span><span class="s2">TEST_K
YLIN_FACT.CAL_DT</span><span class="se">\n</span><span class="s2">,TEST_KYLIN_FACT.LEAF_CATEG_ID</span><span class="se">\n</span><span class="s2">,TEST_KYLIN_FACT.LSTG_SITE_ID</span><span class="se">\n</span><span class="s2">,TEST_CATEGORY_GROUPINGS.META_CATEG_NAME</span><span class="se">\n</span><span class="s2">,TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME</span><span class="se">\n</span><span class="s2">,TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME</span><span class="se">\n</span><span class="s2">,TEST_KYLIN_FACT.LSTG_FORMAT_NAME</span><span class="se">\n</span><span class="s2">,TEST_KYLIN_FACT.SLR_SEGMENT_CD</span><span class="se">\n</span><span class="s2">,TEST_KYLIN_FACT.SELLER_ID</span><span class="se">\n</span><span class="s2">,TEST_KYLIN_FACT.PRICE</span><span class="se">\n</span><span class="s2">FROM TEST_KYLIN_FACT</span><span class="se">\n</span><span class="s2">INNER JOIN TEST_CAL_DT</span><span class="se">\n</span><span class="s2">ON TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.CAL_DT</
span><span class="se">\n</span><span class="s2">INNER JOIN TEST_CATEGORY_GROUPINGS</span><span class="se">\n</span><span class="s2">ON TEST_KYLIN_FACT.LEAF_CATEG_ID = TEST_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_CATEGORY_GROUPINGS.SITE_ID</span><span class="se">\n</span><span class="s2">INNER JOIN TEST_SITES</span><span class="se">\n</span><span class="s2">ON TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_SITES.SITE_ID</span><span class="se">\n</span><span class="s2">INNER JOIN TEST_SELLER_TYPE_DIM</span><span class="se">\n</span><span class="s2">ON TEST_KYLIN_FACT.SLR_SEGMENT_CD = TEST_SELLER_TYPE_DIM.SELLER_TYPE_CD</span><span class="se">\n</span><span class="s2">WHERE (test_kylin_fact.cal_dt < '2014-07-31 16:00:00')</span><span class="se">\n</span><span class="s2">;</span><span class="se">\n\"</span><span class="s2">"</span>,
+ <span class="s2">"interrupt_cmd"</span>:null,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"exec_wait_time"</span>:0,
+ <span class="s2">"step_status"</span>:<span class="s2">"PENDING"</span>,
+ <span class="s2">"cmd_type"</span>:<span class="s2">"SHELL_CMD_HADOOP"</span>,
+ <span class="s2">"info"</span>:null,
+ <span class="s2">"run_async"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"interruptCmd"</span>:null,
+ <span class="s2">"name"</span>:<span class="s2">"Extract Fact Table Distinct Columns"</span>,
+ <span class="s2">"sequence_id"</span>:1,
+ <span class="s2">"exec_cmd"</span>:<span class="s2">" -conf C:/kylin/Kylin/server/src/main/resources/hadoop_job_conf_medium.xml -cubename test_kylin_cube_with_slr_empty -input /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6 -output /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/fact_distinct_columns -jobname Kylin_Fact_Distinct_Columns_test_kylin_cube_with_slr_empty_Step_1"</span>,
+ <span class="s2">"interrupt_cmd"</span>:null,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"exec_wait_time"</span>:0,
+ <span class="s2">"step_status"</span>:<span class="s2">"PENDING"</span>,
+ <span class="s2">"cmd_type"</span>:<span class="s2">"JAVA_CMD_HADOOP_FACTDISTINCT"</span>,
+ <span class="s2">"info"</span>:null,
+ <span class="s2">"run_async"</span>:true
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"interruptCmd"</span>:null,
+ <span class="s2">"name"</span>:<span class="s2">"Build Dimension Dictionary"</span>,
+ <span class="s2">"sequence_id"</span>:2,
+ <span class="s2">"exec_cmd"</span>:<span class="s2">" -cubename test_kylin_cube_with_slr_empty -segmentname 19700101000000_20140731160000 -input /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/fact_distinct_columns"</span>,
+ <span class="s2">"interrupt_cmd"</span>:null,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"exec_wait_time"</span>:0,
+ <span class="s2">"step_status"</span>:<span class="s2">"PENDING"</span>,
+ <span class="s2">"cmd_type"</span>:<span class="s2">"JAVA_CMD_HADOOP_NO_MR_DICTIONARY"</span>,
+ <span class="s2">"info"</span>:null,
+ <span class="s2">"run_async"</span>:false
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"interruptCmd"</span>:null,
+ <span class="s2">"name"</span>:<span class="s2">"Build Base Cuboid Data"</span>,
+ <span class="s2">"sequence_id"</span>:3,
+ <span class="s2">"exec_cmd"</span>:<span class="s2">" -conf C:/kylin/Kylin/server/src/main/resources/hadoop_job_conf_medium.xml -cubename test_kylin_cube_with_slr_empty -segmentname 19700101000000_20140731160000 -input /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6 -output /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/cuboid/base_cuboid -jobname Kylin_Base_Cuboid_Builder_test_kylin_cube_with_slr_empty_Step_3 -level 0"</span>,
+ <span class="s2">"interrupt_cmd"</span>:null,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"exec_wait_time"</span>:0,
+ <span class="s2">"step_status"</span>:<span class="s2">"PENDING"</span>,
+ <span class="s2">"cmd_type"</span>:<span class="s2">"JAVA_CMD_HADOOP_BASECUBOID"</span>,
+ <span class="s2">"info"</span>:null,
+ <span class="s2">"run_async"</span>:true
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"interruptCmd"</span>:null,
+ <span class="s2">"name"</span>:<span class="s2">"Build N-Dimension Cuboid Data : 8-Dimension"</span>,
+ <span class="s2">"sequence_id"</span>:4,
+ <span class="s2">"exec_cmd"</span>:<span class="s2">" -conf C:/kylin/Kylin/server/src/main/resources/hadoop_job_conf_medium.xml -cubename test_kylin_cube_with_slr_empty -segmentname 19700101000000_20140731160000 -input /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/cuboid/base_cuboid -output /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/cuboid/8d_cuboid -jobname Kylin_ND-Cuboid_Builder_test_kylin_cube_with_slr_empty_Step_4 -level 1"</span>,
+ <span class="s2">"interrupt_cmd"</span>:null,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"exec_wait_time"</span>:0,
+ <span class="s2">"step_status"</span>:<span class="s2">"PENDING"</span>,
+ <span class="s2">"cmd_type"</span>:<span class="s2">"JAVA_CMD_HADOOP_NDCUBOID"</span>,
+ <span class="s2">"info"</span>:null,
+ <span class="s2">"run_async"</span>:true
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"interruptCmd"</span>:null,
+ <span class="s2">"name"</span>:<span class="s2">"Build N-Dimension Cuboid Data : 7-Dimension"</span>,
+ <span class="s2">"sequence_id"</span>:5,
+ <span class="s2">"exec_cmd"</span>:<span class="s2">" -conf C:/kylin/Kylin/server/src/main/resources/hadoop_job_conf_medium.xml -cubename test_kylin_cube_with_slr_empty -segmentname 19700101000000_20140731160000 -input /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/cuboid/8d_cuboid -output /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/cuboid/7d_cuboid -jobname Kylin_ND-Cuboid_Builder_test_kylin_cube_with_slr_empty_Step_5 -level 2"</span>,
+ <span class="s2">"interrupt_cmd"</span>:null,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"exec_wait_time"</span>:0,
+ <span class="s2">"step_status"</span>:<span class="s2">"PENDING"</span>,
+ <span class="s2">"cmd_type"</span>:<span class="s2">"JAVA_CMD_HADOOP_NDCUBOID"</span>,
+ <span class="s2">"info"</span>:null,
+ <span class="s2">"run_async"</span>:true
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"interruptCmd"</span>:null,
+ <span class="s2">"name"</span>:<span class="s2">"Build N-Dimension Cuboid Data : 6-Dimension"</span>,
+ <span class="s2">"sequence_id"</span>:6,
+ <span class="s2">"exec_cmd"</span>:<span class="s2">" -conf C:/kylin/Kylin/server/src/main/resources/hadoop_job_conf_medium.xml -cubename test_kylin_cube_with_slr_empty -segmentname 19700101000000_20140731160000 -input /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/cuboid/7d_cuboid -output /tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/test_kylin_cube_with_slr_empty/cuboid/6d_cuboid -jobname Kylin_ND-Cuboid_Builder_test_kylin_cube_with_slr_empty_Step_6 -level 3"</span>,
+ <span class="s2">"interrupt_cmd"</span>:null,
+ <span class="s2">"exec_start_time"</span>:0,
+ <span class="s2">"exec_end_time"</span>:0,
+ <span class="s2">"exec_wait_time"</span>:0,
+ <span class="s2">"step_status"</span>:<span class="s2">"PENDING"</span>,
[... 878 lines stripped ...]