Modified: kylin/site/docs/howto/howto_use_restapi.html URL: http://svn.apache.org/viewvc/kylin/site/docs/howto/howto_use_restapi.html?rev=1723232&r1=1723231&r2=1723232&view=diff ============================================================================== --- kylin/site/docs/howto/howto_use_restapi.html (original) +++ kylin/site/docs/howto/howto_use_restapi.html Wed Jan 6 05:44:15 2016 @@ -1673,1841 +1673,907 @@ <p>version: v1.0, since: v0.7.1</p> <article class="post-content" > - <h2 id="kylin-restful-api-list">Kylin Restful API List</h2> + <p>This page lists all the Restful API that provided by Kylin; The endpoint of the Rest service is started with <strong>/kylin/api</strong>, so donât forget to add it before a certain APIâs path. For example, to get all cube instances, send HTTP GET request to â/kylin/api/cubesâ.</p> <ul> <li>QUERY <ul> - <li>Login</li> - <li>Query</li> - <li>List queryable tables</li> + <li><a href="#login">Login</a></li> + <li><a href="#query">Query</a></li> + <li><a href="#list-queryable-tables">List queryable tables</a></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> + <li><a href="#list-cubes">List cubes</a></li> + <li><a href="#get-cube">Get cube</a></li> + <li><a href="#get-cube-descriptor">Get cube descriptor (dimension, measure info, etc)</a></li> + <li><a href="#get-data-model">Get data model (fact and lookup table info)</a></li> + <li><a href="#build-cube">Build cube</a></li> + <li><a href="#disable-cube">Disable cube</a></li> + <li><a href="#purge-cube">Purge cube</a></li> + <li><a href="#enable-cube">Enable cube</a></li> </ul> </li> <li>JOB <ul> - <li>Resume job</li> - <li>Discard job</li> - <li>Get job step log</li> + <li><a href="#resume-job">Resume job</a></li> + <li><a href="#discard-job">Discard job</a></li> + <li><a href="#get-job-step-output">Get job step output</a></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> + <li><a href="#get-hive-table">Get Hive Table</a></li> + <li><a href="#get-hive-table-extend-info">Get Hive Table (Extend Info)</a></li> + <li><a href="#get-hive-tables">Get Hive Tables</a></li> + <li><a href="#load-hive-tables">Load Hive Tables</a></li> + </ul> + </li> + <li>Cache + <ul> + <li><a href="#wipe-cache">Wipe cache</a></li> </ul> </li> - <li>Wipe cache</li> </ul> -<h3 id="login">Login</h3> +<h2 id="login">Login</h2> <p><code class="highlighter-rouge">POST /user/authentication</code></p> -<p>for example: <br /> -```sh</p> +<p>for example:</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> +<div class="highlighter-rouge"><pre class="highlight"><code>curl -c /path/to/cookiefile.txt -X POST -H "Authorization: Basic XXXXXXXXX" -H 'Content-Type: application/json' http://<host>:<port>/kylin/api/user/authentication +</code></pre> +</div> <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 +<div class="highlighter-rouge"><pre class="highlight"><code>curl -b /path/to/cookiefile.txt -X PUT -H 'Content-Type: application/json' -d '{"startTime":'1423526400000', "endTime":'1423526400', "buildType":"BUILD"}' http://<host>:<port>/kylin/api/cubes/your_cube/rebuild </code></pre> </div> -<h3 id="header">Header</h3> +<h4 id="header">Header</h4> <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 /> +Authorization:Basic {data}</p> -<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> +<h4 id="response-sample">Response Sample</h4> -<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="s2">"userDetails"</span>:<span class="o">{</span> + <span class="s2">"password"</span>:null, + <span class="s2">"username"</span>:<span class="s2">"sample"</span>, + <span class="s2">"authorities"</span>:[ + <span class="o">{</span> + <span class="s2">"authority"</span>:<span class="s2">"ROLE_ANALYST"</span> + <span class="o">}</span>, + <span class="o">{</span> + <span class="s2">"authority"</span>:<span class="s2">"ROLE_MODELER"</span> + <span class="o">}</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="s2">"accountNonExpired"</span>:true, + <span class="s2">"accountNonLocked"</span>:true, + <span class="s2">"credentialsNonExpired"</span>:true, + <span class="s2">"enabled"</span>:true + <span class="o">}</span> <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> +<h2 id="query">Query</h2> +<p><code class="highlighter-rouge">POST /query</code></p> -<h3 id="response-sample-1">Response Sample</h3> -<div class="highlighter-rouge"><pre class="highlight"><code>Status: 200OK -</code></pre> +<h4 id="request-body">Request Body</h4> +<ul> + <li>sql - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The sql query string.</li> + <li>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.</li> + <li>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.</li> + <li>acceptPartial - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">bool</code> Flag to switch partial query.</li> + <li>project - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> Project to perform query. Default value is âDEFAULTâ.</li> +</ul> + +<div class="highlighter-rouge"><pre class="highlight"><code><span class="p">{</span><span class="w"> + </span><span class="nt">"sql"</span><span class="p">:</span><span class="s2">"select * from TEST_KYLIN_FACT"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"offset"</span><span class="p">:</span><span class="mi">0</span><span class="p">,</span><span class="w"> + </span><span class="nt">"limit"</span><span class="p">:</span><span class="mi">50000</span><span class="p">,</span><span class="w"> + </span><span class="nt">"acceptPartial"</span><span class="p">:</span><span class="kc">true</span><span class="p">,</span><span class="w"> + </span><span class="nt">"project"</span><span class="p">:</span><span class="s2">"DEFAULT"</span><span class="w"> +</span><span class="p">}</span><span class="w"> +</span></code></pre> +</div> + +<h4 id="response-sample-1">Response Sample</h4> + +<div class="highlighter-rouge"><pre class="highlight"><code><span class="p">{</span><span class="w"> + </span><span class="nt">"columnMetas"</span><span class="p">:[</span><span class="w"> + </span><span class="p">{</span><span class="w"> + </span><span class="nt">"isNullable"</span><span class="p">:</span><span class="mi">1</span><span class="p">,</span><span class="w"> + </span><span class="nt">"displaySize"</span><span class="p">:</span><span class="mi">0</span><span class="p">,</span><span class="w"> + </span><span class="nt">"label"</span><span class="p">:</span><span class="s2">"CAL_DT"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"name"</span><span class="p">:</span><span class="s2">"CAL_DT"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"schemaName"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> + </span><span class="nt">"catelogName"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> + </span><span class="nt">"tableName"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> + </span><span class="nt">"precision"</span><span class="p">:</span><span class="mi">0</span><span class="p">,</span><span class="w"> + </span><span class="nt">"scale"</span><span class="p">:</span><span class="mi">0</span><span class="p">,</span><span class="w"> + </span><span class="nt">"columnType"</span><span class="p">:</span><span class="mi">91</span><span class="p">,</span><span class="w"> + </span><span class="nt">"columnTypeName"</span><span class="p">:</span><span class="s2">"DATE"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"readOnly"</span><span class="p">:</span><span class="kc">true</span><span class="p">,</span><span class="w"> + </span><span class="nt">"writable"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"caseSensitive"</span><span class="p">:</span><span class="kc">true</span><span class="p">,</span><span class="w"> + </span><span class="nt">"searchable"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"currency"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"signed"</span><span class="p">:</span><span class="kc">true</span><span class="p">,</span><span class="w"> + </span><span class="nt">"autoIncrement"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"definitelyWritable"</span><span class="p">:</span><span class="kc">false</span><span class="w"> + </span><span class="p">},</span><span class="w"> + </span><span class="p">{</span><span class="w"> + </span><span class="nt">"isNullable"</span><span class="p">:</span><span class="mi">1</span><span class="p">,</span><span class="w"> + </span><span class="nt">"displaySize"</span><span class="p">:</span><span class="mi">10</span><span class="p">,</span><span class="w"> + </span><span class="nt">"label"</span><span class="p">:</span><span class="s2">"LEAF_CATEG_ID"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"name"</span><span class="p">:</span><span class="s2">"LEAF_CATEG_ID"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"schemaName"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> + </span><span class="nt">"catelogName"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> + </span><span class="nt">"tableName"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> + </span><span class="nt">"precision"</span><span class="p">:</span><span class="mi">10</span><span class="p">,</span><span class="w"> + </span><span class="nt">"scale"</span><span class="p">:</span><span class="mi">0</span><span class="p">,</span><span class="w"> + </span><span class="nt">"columnType"</span><span class="p">:</span><span class="mi">4</span><span class="p">,</span><span class="w"> + </span><span class="nt">"columnTypeName"</span><span class="p">:</span><span class="s2">"INTEGER"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"readOnly"</span><span class="p">:</span><span class="kc">true</span><span class="p">,</span><span class="w"> + </span><span class="nt">"writable"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"caseSensitive"</span><span class="p">:</span><span class="kc">true</span><span class="p">,</span><span class="w"> + </span><span class="nt">"searchable"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"currency"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"signed"</span><span class="p">:</span><span class="kc">true</span><span class="p">,</span><span class="w"> + </span><span class="nt">"autoIncrement"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"definitelyWritable"</span><span class="p">:</span><span class="kc">false</span><span class="w"> + </span><span class="p">},</span><span class="w"> + </span><span class="err">...</span><span class="w"> + </span><span class="p">],</span><span class="w"> + </span><span class="nt">"results"</span><span class="p">:[</span><span class="w"> + </span><span class="p">[</span><span class="w"> + </span><span class="s2">"2013-08-07"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"32996"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"15"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"15"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"Auction"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"10000000"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"49.048952730908745"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"49.048952730908745"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"49.048952730908745"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"1"</span><span class="w"> + </span><span class="p">],</span><span class="w"> + </span><span class="p">[</span><span class="w"> + </span><span class="s2">"2013-08-07"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"43398"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"0"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"14"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"ABIN"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"10000633"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"85.78317064220418"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"85.78317064220418"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"85.78317064220418"</span><span class="p">,</span><span class="w"> + </span><span class="s2">"1"</span><span class="w"> + </span><span class="p">],</span><span class="w"> + </span><span class="err">...</span><span class="w"> + </span><span class="p">],</span><span class="w"> + </span><span class="nt">"cube"</span><span class="p">:</span><span class="s2">"test_kylin_cube_with_slr_desc"</span><span class="p">,</span><span class="w"> + </span><span class="nt">"affectedRowCount"</span><span class="p">:</span><span class="mi">0</span><span class="p">,</span><span class="w"> + </span><span class="nt">"isException"</span><span class="p">:</span><span class="kc">false</span><span class="p">,</span><span class="w"> + </span><span class="nt">"exceptionMessage"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> + </span><span class="nt">"duration"</span><span class="p">:</span><span class="mi">3451</span><span class="p">,</span><span class="w"> + </span><span class="nt">"partial"</span><span class="p">:</span><span class="kc">false</span><span class="w"> +</span><span class="p">}</span><span class="w"> +</span></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> + +<hr /> + +<h2 id="list-queryable-tables">List queryable tables</h2> +<p><code class="highlighter-rouge">GET /tables_and_columns</code></p> + +<h4 id="request-parameters">Request Parameters</h4> +<ul> + <li>project - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The project to load tables</li> +</ul> + +<h4 id="response-sample-2">Response Sample</h4> +<div class="highlighter-rouge"><pre class="highlight"><code>[ + { + "columns":[ + { + "table_NAME":"TEST_CAL_DT", + "table_SCHEM":"EDW", + "column_NAME":"CAL_DT", + "data_TYPE":91, + "nullable":1, + "column_SIZE":-1, + "buffer_LENGTH":-1, + "decimal_DIGITS":0, + "num_PREC_RADIX":10, + "column_DEF":null, + "sql_DATA_TYPE":-1, + "sql_DATETIME_SUB":-1, + "char_OCTET_LENGTH":-1, + "ordinal_POSITION":1, + "is_NULLABLE":"YES", + "scope_CATLOG":null, + "scope_SCHEMA":null, + "scope_TABLE":null, + "source_DATA_TYPE":-1, + "iS_AUTOINCREMENT":null, + "table_CAT":"defaultCatalog", + "remarks":null, + "type_NAME":"DATE" + }, + { + "table_NAME":"TEST_CAL_DT", + "table_SCHEM":"EDW", + "column_NAME":"WEEK_BEG_DT", + "data_TYPE":91, + "nullable":1, + "column_SIZE":-1, + "buffer_LENGTH":-1, + "decimal_DIGITS":0, + "num_PREC_RADIX":10, + "column_DEF":null, + "sql_DATA_TYPE":-1, + "sql_DATETIME_SUB":-1, + "char_OCTET_LENGTH":-1, + "ordinal_POSITION":2, + "is_NULLABLE":"YES", + "scope_CATLOG":null, + "scope_SCHEMA":null, + "scope_TABLE":null, + "source_DATA_TYPE":-1, + "iS_AUTOINCREMENT":null, + "table_CAT":"defaultCatalog", + "remarks":null, + "type_NAME":"DATE" + } + ], + "table_NAME":"TEST_CAL_DT", + "table_SCHEM":"EDW", + "ref_GENERATION":null, + "self_REFERENCING_COL_NAME":null, + "type_SCHEM":null, + "table_TYPE":"TABLE", + "table_CAT":"defaultCatalog", + "remarks":null, + "type_CAT":null, + "type_NAME":null + }, + ... +] </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> +<h2 id="list-cubes">List cubes</h2> +<p><code class="highlighter-rouge">GET /cubes</code></p> + +<h4 id="request-parameters-1">Request Parameters</h4> +<ul> + <li>cubeName - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> Cube name to find.</li> + <li>projectName - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> project name.</li> + <li>offset - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">int</code> Offset used by pagination</li> + <li>limit - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">int </code> Cubes per page.</li> +</ul> -<h3 id="response-sample-2">Response Sample</h3> -<div class="highlighter-rouge"><pre class="highlight"><code>Status: 200OK +<h4 id="response-sample-3">Response Sample</h4> +<div class="highlighter-rouge"><pre class="highlight"><code>[ + { + "uuid":"1eaca32a-a33e-4b69-83dd-0bb8b1f8c53b", + "last_modified":1407831634847, + "name":"test_kylin_cube_with_slr_empty", + "owner":null, + "version":null, + "descriptor":"test_kylin_cube_with_slr_desc", + "cost":50, + "status":"DISABLED", + "segments":[ + ], + "create_time":null, + "source_records_count":0, + "source_records_size":0, + "size_kb":0 + } +] </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> + +<h2 id="get-cube">Get cube</h2> +<p><code class="highlighter-rouge">GET /cubes/{cubeName}</code></p> + +<h4 id="path-variable">Path Variable</h4> +<ul> + <li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name to find.</li> +</ul> + +<h2 id="get-cube-descriptor">Get cube descriptor</h2> +<p><code class="highlighter-rouge">GET /cube_desc/{cubeName}</code></p> + +<h4 id="path-variable-1">Path Variable</h4> +<ul> + <li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li> +</ul> + +<h4 id="response-sample-4">Response Sample</h4> + +<div class="highlighter-rouge"><pre class="highlight"><code>[ + { + "uuid": "a24ca905-1fc6-4f67-985c-38fa5aeafd92", + "name": "test_kylin_cube_with_slr_desc", + "description": null, + "dimensions": [ + { + "id": 0, + "name": "CAL_DT", + "table": "EDW.TEST_CAL_DT", + "column": null, + "derived": [ + "WEEK_BEG_DT" + ], + "hierarchy": false + }, + { + "id": 1, + "name": "CATEGORY", + "table": "DEFAULT.TEST_CATEGORY_GROUPINGS", + "column": null, + "derived": [ + "USER_DEFINED_FIELD1", + "USER_DEFINED_FIELD3", + "UPD_DATE", + "UPD_USER" + ], + "hierarchy": false + }, + { + "id": 2, + "name": "CATEGORY_HIERARCHY", + "table": "DEFAULT.TEST_CATEGORY_GROUPINGS", + "column": [ + "META_CATEG_NAME", + "CATEG_LVL2_NAME", + "CATEG_LVL3_NAME" + ], + "derived": null, + "hierarchy": true + }, + { + "id": 3, + "name": "LSTG_FORMAT_NAME", + "table": "DEFAULT.TEST_KYLIN_FACT", + "column": [ + "LSTG_FORMAT_NAME" + ], + "derived": null, + "hierarchy": false + }, + { + "id": 4, + "name": "SITE_ID", + "table": "EDW.TEST_SITES", + "column": null, + "derived": [ + "SITE_NAME", + "CRE_USER" + ], + "hierarchy": false + }, + { + "id": 5, + "name": "SELLER_TYPE_CD", + "table": "EDW.TEST_SELLER_TYPE_DIM", + "column": null, + "derived": [ + "SELLER_TYPE_DESC" + ], + "hierarchy": false + }, + { + "id": 6, + "name": "SELLER_ID", + "table": "DEFAULT.TEST_KYLIN_FACT", + "column": [ + "SELLER_ID" + ], + "derived": null, + "hierarchy": false + } + ], + "measures": [ + { + "id": 1, + "name": "GMV_SUM", + "function": { + "expression": "SUM", + "parameter": { + "type": "column", + "value": "PRICE", + "next_parameter": null + }, + "returntype": "decimal(19,4)" + }, + "dependent_measure_ref": null + }, + { + "id": 2, + "name": "GMV_MIN", + "function": { + "expression": "MIN", + "parameter": { + "type": "column", + "value": "PRICE", + "next_parameter": null + }, + "returntype": "decimal(19,4)" + }, + "dependent_measure_ref": null + }, + { + "id": 3, + "name": "GMV_MAX", + "function": { + "expression": "MAX", + "parameter": { + "type": "column", + "value": "PRICE", + "next_parameter": null + }, + "returntype": "decimal(19,4)" + }, + "dependent_measure_ref": null + }, + { + "id": 4, + "name": "TRANS_CNT", + "function": { + "expression": "COUNT", + "parameter": { + "type": "constant", + "value": "1", + "next_parameter": null + }, + "returntype": "bigint" + }, + "dependent_measure_ref": null + }, + { + "id": 5, + "name": "ITEM_COUNT_SUM", + "function": { + "expression": "SUM", + "parameter": { + "type": "column", + "value": "ITEM_COUNT", + "next_parameter": null + }, + "returntype": "bigint" + }, + "dependent_measure_ref": null + } + ], + "rowkey": { + "rowkey_columns": [ + { + "column": "SELLER_ID", + "length": 18, + "dictionary": null, + "mandatory": true + }, + { + "column": "CAL_DT", + "length": 0, + "dictionary": "true", + "mandatory": false + }, + { + "column": "LEAF_CATEG_ID", + "length": 0, + "dictionary": "true", + "mandatory": false + }, + { + "column": "META_CATEG_NAME", + "length": 0, + "dictionary": "true", + "mandatory": false + }, + { + "column": "CATEG_LVL2_NAME", + "length": 0, + "dictionary": "true", + "mandatory": false + }, + { + "column": "CATEG_LVL3_NAME", + "length": 0, + "dictionary": "true", + "mandatory": false + }, + { + "column": "LSTG_FORMAT_NAME",
[... 1288 lines stripped ...]
