You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by lu...@apache.org on 2015/05/27 13:31:23 UTC

svn commit: r1681986 [2/3] - in /incubator/kylin/site: about/index.html blog/2015/01/26/introduce-data-model/index.html blog/index.html cn/index.html community/index.html docs/index.html download/index.html feed.xml index.html

Modified: incubator/kylin/site/feed.xml
URL: http://svn.apache.org/viewvc/incubator/kylin/site/feed.xml?rev=1681986&r1=1681985&r2=1681986&view=diff
==============================================================================
--- incubator/kylin/site/feed.xml (original)
+++ incubator/kylin/site/feed.xml Wed May 27 11:31:23 2015
@@ -19,55 +19,2890 @@
     <description>Apache Kylin Home</description>
     <link>http://kyli.io/</link>
     <atom:link href="http://kyli.io/feed.xml" rel="self" type="application/rss+xml"/>
-    <pubDate>Wed, 20 May 2015 20:23:34 +0800</pubDate>
-    <lastBuildDate>Wed, 20 May 2015 20:23:34 +0800</lastBuildDate>
+    <pubDate>Wed, 27 May 2015 19:25:55 +0800</pubDate>
+    <lastBuildDate>Wed, 27 May 2015 19:25:55 +0800</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>
-        <title>Introduce Data Model of Cube Designer</title>
-        <description>&lt;h3 id=&quot;background&quot;&gt;Background&lt;/h3&gt;
-&lt;p&gt;In previous version (before v0.6.4), Kylin introduced a GUI tool called Cube Designer for user (we called this role as &lt;strong&gt;Cube Modeler&lt;/strong&gt;) to architect OLAP Cube with dimensions, measures and other settings. It works well for most of the features but still not user friendly yet: &lt;/p&gt;
+        <title>FAQ on Kylin Installation and Usage</title>
+        <description>&lt;h4 id=&quot;some-npm-error-causes-error-exit-&quot;&gt;Some NPM error causes ERROR exit (中国大陆地区用户请特别注意此问题)?&lt;/h4&gt;
+&lt;p&gt;Check out &lt;a href=&quot;https://github.com/KylinOLAP/Kylin/issues/35&quot;&gt;https://github.com/KylinOLAP/Kylin/issues/35&lt;/a&gt;&lt;/p&gt;
+
+&lt;h4 id=&quot;cant-get-master-address-from-zookeeper-when-installing-kylin-on-hortonworks-sandbox&quot;&gt;Can’t get master address from ZooKeeper” when installing Kylin on Hortonworks Sandbox&lt;/h4&gt;
+&lt;p&gt;Check out &lt;a href=&quot;https://github.com/KylinOLAP/Kylin/issues/9&quot;&gt;https://github.com/KylinOLAP/Kylin/issues/9&lt;/a&gt;.&lt;/p&gt;
+
+&lt;h4 id=&quot;install-scripted-finished-in-my-virtual-machine-but-cannot-visit-via-httplocalhost9080&quot;&gt;Install scripted finished in my virtual machine, but cannot visit via http://localhost:9080&lt;/h4&gt;
+&lt;p&gt;Check out &lt;a href=&quot;https://github.com/KylinOLAP/Kylin/issues/12&quot;&gt;https://github.com/KylinOLAP/Kylin/issues/12&lt;/a&gt;.&lt;/p&gt;
+
+&lt;h4 id=&quot;map-reduce-job-information-cant-display-on-sandbox-deployment&quot;&gt;Map Reduce Job information can’t display on sandbox deployment&lt;/h4&gt;
+&lt;p&gt;Check out &lt;a href=&quot;https://github.com/KylinOLAP/Kylin/issues/40&quot;&gt;https://github.com/KylinOLAP/Kylin/issues/40&lt;/a&gt;&lt;/p&gt;
+
+&lt;h4 id=&quot;install-kylin-on-cdh-52-or-hadoop-25x&quot;&gt;Install Kylin on CDH 5.2 or Hadoop 2.5.x&lt;/h4&gt;
+&lt;p&gt;Check out discussion: &lt;a href=&quot;https://groups.google.com/forum/?utm_medium=email&amp;amp;utm_source=footer#!msg/kylin-olap/X0GZfsX1jLc/nzs6xAhNpLkJ&quot;&gt;https://groups.google.com/forum/?utm_medium=email&amp;amp;utm_source=footer#!msg/kylin-olap/X0GZfsX1jLc/nzs6xAhNpLkJ&lt;/a&gt;&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;I was able to deploy Kylin with following option in POM.
+&amp;lt;hadoop2.version&amp;gt;2.5.0&amp;lt;/hadoop2.version&amp;gt;
+&amp;lt;yarn.version&amp;gt;2.5.0&amp;lt;/yarn.version&amp;gt;
+&amp;lt;hbase-hadoop2.version&amp;gt;0.98.6-hadoop2&amp;lt;/hbase-hadoop2.version&amp;gt;
+&amp;lt;zookeeper.version&amp;gt;3.4.5&amp;lt;/zookeeper.version&amp;gt;
+&amp;lt;hive.version&amp;gt;0.13.1&amp;lt;/hive.version&amp;gt;
+My Cluster is running on Cloudera Distribution CDH 5.2.0.&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;h4 id=&quot;unable-to-load-a-big-cube-as-htable-with-javalangoutofmemoryerror-unable-to-create-new-native-thread&quot;&gt;Unable to load a big cube as HTable, with java.lang.OutOfMemoryError: unable to create new native thread&lt;/h4&gt;
+&lt;p&gt;HBase (as of writing) allocates one thread per region when bulk loading a HTable. Try reduce the number of regions of your cube by setting its “capacity” to “MEDIUM” or “LARGE”. Also tweaks OS &amp;amp; JVM can allow more threads, for example see &lt;a href=&quot;http://blog.egilh.com/2006/06/2811aspx.html&quot;&gt;this article&lt;/a&gt;.&lt;/p&gt;
+
+&lt;h4 id=&quot;failed-to-run-buildcubewithenginetest-saying-failed-to-connect-to-hbase-while-hbase-is-active&quot;&gt;Failed to run BuildCubeWithEngineTest, saying failed to connect to hbase while hbase is active&lt;/h4&gt;
+&lt;p&gt;User may get this error when first time run hbase client, please check the error trace to see whether there is an error saying couldn’t access a folder like “/hadoop/hbase/local/jars”; If that folder doesn’t exist, create it.&lt;/p&gt;
+
+&lt;h4 id=&quot;sumfield-returns-a-negtive-result-while-all-the-numbers-in-this-field-are--0&quot;&gt;SUM(field) returns a negtive result while all the numbers in this field are &amp;gt; 0&lt;/h4&gt;
+&lt;p&gt;If a column is declared as integer in Hive, the SQL engine (calcite) will use column’s type (integer) as the data type for “SUM(field)”, while the aggregated value on this field may exceed the scope of integer; in that case the cast will cause a negtive value be returned; The workround is, alter that column’s type to BIGINT in hive, and then sync the table schema to Kylin (the cube doesn’t need rebuild); Keep in mind that, always declare as BIGINT in hive for an integer column which would be used as a measure in Kylin; See hive number types: &lt;a href=&quot;https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-NumericTypes&quot;&gt;https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-NumericTypes&lt;/a&gt;&lt;/p&gt;
+
+&lt;h4 id=&quot;why-kylin-need-extract-the-distinct-columns-from-fact-table-before-building-cube&quot;&gt;Why Kylin need extract the distinct columns from Fact Table before building cube?&lt;/h4&gt;
+&lt;p&gt;Kylin uses dictionary to encode the values in each column, this greatly reduce the cube’s storage size. To build the dictionary, Kylin need fetch the distinct values for each column.&lt;/p&gt;
+
+&lt;h4 id=&quot;why-kylin-calculate-the-hive-table-cardinality&quot;&gt;Why Kylin calculate the HIVE table cardinality?&lt;/h4&gt;
+&lt;p&gt;The cardinality of dimensions is an important measure of cube complexity. The higher the cardinality, the bigger the cube, and thus the longer to build and the slower to query. Cardinality &amp;gt; 1,000 is worth attention and &amp;gt; 1,000,000 should be avoided at best effort. For optimal cube performance, try reduce high cardinality by categorize values or derive features.&lt;/p&gt;
+</description>
+        <pubDate>Mon, 18 May 2015 00:00:00 +0800</pubDate>
+        <link>http://kyli.io/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/</link>
+        <guid isPermaLink="true">http://kyli.io/faq/2015/05/18/FAQ-on-Kylin-Installation-and-Usage/</guid>
+        
+        
+        <category>faq</category>
+        
+      </item>
+    
+      <item>
+        <title>Export Kylin HBase data</title>
+        <description>&lt;p&gt;Kylin persists all data (meta data and cube) in HBase; You may want to export the data sometimes for whatever purposes (backup, migration, troubleshotting etc); This page describes the steps to do this and also there is a Java app for you to do this easily;&lt;/p&gt;
+
+&lt;p&gt;Steps:&lt;/p&gt;
 
 &lt;ol&gt;
-  &lt;li&gt;A user has to add dimension one by one, considering there are 20+ even 50+ dimensions, the entire process is really boring. &lt;/li&gt;
-  &lt;li&gt;Each dimension requires define join condition between fact table and lookup table which even already be defined in previous dimensions many times.&lt;/li&gt;
-  &lt;li&gt;Less validation check, especially for Hierarchy and Derived dimension, there are many exceptions in further steps which blocked many people to save the cube definition without any idea about the issue.&lt;/li&gt;
-  &lt;li&gt;Save/Next buttons are confusing user to click which one for real next step or just save current dimension settings&lt;/li&gt;
+  &lt;li&gt;Cleanup unused cubes to save storage space (be cautious on production!): run the following command in hbase CLI: &lt;/li&gt;
 &lt;/ol&gt;
 
-&lt;h3 id=&quot;data-model-of-cube-designer&quot;&gt;Data Model of Cube Designer&lt;/h3&gt;
-&lt;p&gt;With the feedback from our internal users and external community, we have came up one idea and would like to introduce a new concept (widely known in Data Warehouse and Business Intelligence domain): Data Model: a data model organises data elements and standardises how the data elements relate to one another.&lt;a href=&quot;http://en.wikipedia.org/wiki/Data_model&quot;&gt;Wikipedia&lt;/a&gt;. In Kylin, it using &lt;a href=&quot;http://en.wikipedia.org/wiki/Star_schema&quot;&gt;Star Schema&lt;/a&gt; as Data Model, which is the simplest style of data warehouse schema. The star schema consists of a few “fact tables” (possibly only one, justifying the name) referencing any number of “dimension tables”. It actually already there behind dimensions and measures and now just come to first step to define the relationship between different tables before create each dimension. 
-Now (after v0.6.4), to create a cube will follow below steps:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;hbase org.apache.hadoop.util.RunJar /${KYLIN_HOME}/lib/kylin-job-(version).jar org.apache.kylin.job.hadoop.cube.StorageCleanupJob --delete true&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
 
 &lt;ol&gt;
-  &lt;li&gt;Define data model first: pick up one fact table and then add other lookup tables (with their join conditions). The data mode must be presents as Star Schema.&lt;/li&gt;
-  &lt;li&gt;Then add dimensions, since all join conditions already presented in data model, each dimension could be more easy to create, just need to know what’s kind of type: normal, hierarchy and derived (will have another blog to introduce them). There’s also one helper called &lt;em&gt;Auto Generator&lt;/em&gt; to help generate many dimensions within simple clicks.&lt;/li&gt;
-  &lt;li&gt;Then define measures and others as previous cube designer did&lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;List all HBase tables, iterate and then export each Kylin table to HDFS; See &lt;a href=&quot;https://hbase.apache.org/book/ops_mgt.html#export&quot;&gt;https://hbase.apache.org/book/ops_mgt.html#export&lt;/a&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Copy the export folder from HDFS to local file system, and then archive it;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;(optional) Download the archive from Hadoop CLI to local;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Cleanup the export folder from CLI HDFS and local file system;&lt;/p&gt;
+  &lt;/li&gt;
 &lt;/ol&gt;
 
-&lt;h3 id=&quot;benefits&quot;&gt;Benefits&lt;/h3&gt;
+&lt;p&gt;Kylin provide the “ExportHBaseData.java” (currently only exist in “minicluster” branch) for you to do the step 2-5 in one run; Please ensure the correct path of “kylin.properties” has been set in the sys env; This Java uses the sandbox config by default;&lt;/p&gt;
+</description>
+        <pubDate>Mon, 18 May 2015 00:00:00 +0800</pubDate>
+        <link>http://kyli.io/howto/2015/05/18/Export-Kylin-HBase-data/</link>
+        <guid isPermaLink="true">http://kyli.io/howto/2015/05/18/Export-Kylin-HBase-data/</guid>
+        
+        
+        <category>howto</category>
+        
+      </item>
+    
+      <item>
+        <title>Kylin and Tableau Tutorial</title>
+        <description>&lt;blockquote&gt;
+  &lt;p&gt;There are some limitations of Kylin ODBC driver with Tableau, please read carefully this instruction before you try it.&lt;/p&gt;
+
+  &lt;ul&gt;
+    &lt;li&gt;Only support “managed” analysis path, Kylin engine will raise exception for unexpected dimension or metric&lt;/li&gt;
+    &lt;li&gt;Please always select Fact Table first, then add lookup tables with correct join condition (defined join type in cube)&lt;/li&gt;
+    &lt;li&gt;Do not try to join between fact tables or lookup tables;&lt;/li&gt;
+    &lt;li&gt;You can try to use high cardinality dimensions like seller id as Tableau Filter, but the engine will only return limited seller id in Tableau’s filter now.&lt;/li&gt;
+  &lt;/ul&gt;
+
+  &lt;p&gt;More detail information or any issue, please contact Kylin Team: &lt;code&gt;kylinolap@gmail.com&lt;/code&gt;&lt;/p&gt;
+&lt;/blockquote&gt;
+
+&lt;h3 id=&quot;step-1-install-odbc-driver&quot;&gt;Step 1. Install ODBC Driver&lt;/h3&gt;
+&lt;p&gt;Refer to wiki page &lt;a href=&quot;https://github.com/KylinOLAP/Kylin/wiki/Kylin-ODBC-Driver-Tutorial&quot;&gt;Kylin ODBC Driver Tutorial&lt;/a&gt;.&lt;/p&gt;
+
+&lt;h3 id=&quot;step-2-connect-to-kylin-server&quot;&gt;Step 2. Connect to Kylin Server&lt;/h3&gt;
+&lt;blockquote&gt;
+  &lt;p&gt;We recommended to use Connect Using Driver instead of Using DSN since Tableau team will not manage your DSN on Tableau Servers.&lt;/p&gt;
+&lt;/blockquote&gt;
+
+&lt;p&gt;Connect Using Driver: Select “Other Database(ODBC)” in the left panel and choose KylinODBCDriver in the pop-up window. &lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/1 odbc.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Enter your Sever location and credentials: server host, port, username and password.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/2 serverhost.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Click “Connect” to get the list of projects that you have permission to access. See details about permission in &lt;a href=&quot;https://github.com/KylinOLAP/Kylin/wiki/Kylin-Cube-Permission-Grant-Tutorial&quot;&gt;Kylin Cube Permission Grant Tutorial&lt;/a&gt;. Then choose the project you want to connect in the drop down list. &lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/3 project.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Click “Done” to complete the connection.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/4 done.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;h3 id=&quot;step-3-using-single-table-or-multiple-tables&quot;&gt;Step 3. Using Single Table or Multiple Tables&lt;/h3&gt;
+&lt;blockquote&gt;
+  &lt;p&gt;Limitation&lt;/p&gt;
+
+  &lt;ul&gt;
+    &lt;li&gt;Must select FACT table first&lt;/li&gt;
+    &lt;li&gt;Do not support select from lookup table only&lt;/li&gt;
+    &lt;li&gt;The join condition must match within cube definition&lt;/li&gt;
+  &lt;/ul&gt;
+&lt;/blockquote&gt;
+
+&lt;p&gt;&lt;strong&gt;Select Fact Table&lt;/strong&gt;&lt;/p&gt;
+
+&lt;p&gt;Select &lt;code&gt;Multiple Tables&lt;/code&gt;.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/5 multipleTable.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Then click &lt;code&gt;Add Table...&lt;/code&gt; to add a fact table.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/6 facttable.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/6 facttable2.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;&lt;strong&gt;Select Look-up Table&lt;/strong&gt;&lt;/p&gt;
+
+&lt;p&gt;Click &lt;code&gt;Add Table...&lt;/code&gt; to add a look-up table. &lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/7 lkptable.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Set up the join clause carefully. &lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/8 join.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Keep add tables through click &lt;code&gt;Add Table...&lt;/code&gt; until all the look-up tables have been added properly. Give the connection a name for use in Tableau.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/9 connName.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;&lt;strong&gt;Using Connect Live&lt;/strong&gt;&lt;/p&gt;
+
+&lt;p&gt;There are three types of &lt;code&gt;Data Connection&lt;/code&gt;. Choose the &lt;code&gt;Connect Live&lt;/code&gt; option. &lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/10 connectLive.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Then you can enjoy analyzing with Tableau.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/11 analysis.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;&lt;strong&gt;Add additional look-up Tables&lt;/strong&gt;&lt;/p&gt;
+
+&lt;p&gt;Click &lt;code&gt;Data&lt;/code&gt; in the top menu bar, select &lt;code&gt;Edit Tables...&lt;/code&gt; to update the look-up table information.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/12 edit tables.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;h3 id=&quot;step-4-using-customized-sql&quot;&gt;Step 4. Using Customized SQL&lt;/h3&gt;
+&lt;p&gt;To use customized SQL resembles using Single Table/Multiple Tables, except that you just need to paste your SQL in &lt;code&gt;Custom SQL&lt;/code&gt; tab and take the same instruction as above.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/19 custom.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;h3 id=&quot;step-5-publish-to-tableau-server&quot;&gt;Step 5. Publish to Tableau Server&lt;/h3&gt;
+&lt;p&gt;Suppose you have finished making a dashboard with Tableau, you can publish it to Tableau Server.
+Click &lt;code&gt;Server&lt;/code&gt; in the top menu bar, select &lt;code&gt;Publish Workbook...&lt;/code&gt;. &lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/14 publish.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Then sign in your Tableau Server and prepare to publish. &lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/16 prepare-publish.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;If you’re Using Driver Connect instead of DSN connect, you’ll need to additionally embed your password in. Click the &lt;code&gt;Authentication&lt;/code&gt; button at left bottom and select &lt;code&gt;Embedded Password&lt;/code&gt;. Click &lt;code&gt;Publish&lt;/code&gt; and you will see the result.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/17 embedded-pwd.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;h3 id=&quot;tips&quot;&gt;Tips&lt;/h3&gt;
+&lt;ul&gt;
+  &lt;li&gt;
+    &lt;p&gt;Hide Table name in Tableau&lt;/p&gt;
+
+    &lt;ul&gt;
+      &lt;li&gt;Tableau will display columns be grouped by source table name, but user may want to organize columns with different structure. Using “Group by Folder” in Tableau and Create Folders to group different columns.&lt;/li&gt;
+    &lt;/ul&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-and-Tableau-Tutorial/18 groupby-folder.jpg&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+&lt;/ul&gt;
+</description>
+        <pubDate>Fri, 17 Apr 2015 00:00:00 +0800</pubDate>
+        <link>http://kyli.io/tutorial/2015/04/17/Kylin-and-Tableau-Tutorial/</link>
+        <guid isPermaLink="true">http://kyli.io/tutorial/2015/04/17/Kylin-and-Tableau-Tutorial/</guid>
+        
+        
+        <category>tutorial</category>
+        
+      </item>
+    
+      <item>
+        <title>Kylin Web Tutorial</title>
+        <description>&lt;blockquote&gt;
+  &lt;p&gt;&lt;strong&gt;Supported Browsers&lt;/strong&gt;&lt;/p&gt;
+
+  &lt;p&gt;Windows: Google Chrome, FireFox&lt;/p&gt;
+
+  &lt;p&gt;Mac: Google Chrome, FireFox, Safari&lt;/p&gt;
+&lt;/blockquote&gt;
+
+&lt;h2 id=&quot;access--login&quot;&gt;1. Access &amp;amp; Login&lt;/h2&gt;
+&lt;p&gt;Host to access: http://your_sandbox_ip:9080
+Login with username/password: ADMIN/KYLIN&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/1 login.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;h2 id=&quot;available-hive-tables-in-kylin&quot;&gt;2. Available Hive Tables in Kylin&lt;/h2&gt;
+&lt;p&gt;Although Kylin will using SQL as query interface and leverage Hive metadata, kylin will not enable user to query all hive tables since it’s a pre-build OLAP (MOLAP) system so far. To enable Table in Kylin, it will be easy to using “Sync” function to sync up tables from Hive.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/2 tables.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;h2 id=&quot;kylin-olap-cube&quot;&gt;3. Kylin OLAP Cube&lt;/h2&gt;
+&lt;p&gt;Kylin’s OLAP Cubes are pre-calculation datasets from Star Schema Hive tables, Here’s the web management interface for user to explorer, manage all cubes.Go to &lt;code&gt;Cubes&lt;/code&gt; Menu, it will list all cubes available in system:&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/3 cubes.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;To explore more detail about the Cube&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;
+    &lt;p&gt;Form View:&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/4 form-view.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;SQL View (Hive Query to read data to generate the cube):&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/5 sql-view.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Visualization (Showing the Star Schema behind of this cube):&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/6 visualization.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Access (Grant user/role privileges, Grant operation only open to Admin in beta):&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/7 access.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h2 id=&quot;write-and-execute-sql-on-web&quot;&gt;4. Write and Execute SQL on web&lt;/h2&gt;
+&lt;p&gt;Kylin’s web offer a simple query tool for user to run SQL to explorer existing cube, verify result and explorer the result set using #5’s Pivot analysis and visualization&lt;/p&gt;
+
+&lt;blockquote&gt;
+  &lt;p&gt;&lt;strong&gt;Query Limit&lt;/strong&gt;&lt;/p&gt;
+
+  &lt;ol&gt;
+    &lt;li&gt;
+      &lt;p&gt;Only SELECT query be supported&lt;/p&gt;
+    &lt;/li&gt;
+    &lt;li&gt;
+      &lt;p&gt;To avoid huge network traffic from server to client, the scan range’s threshold be set to 1,000,000 in beta.&lt;/p&gt;
+    &lt;/li&gt;
+    &lt;li&gt;
+      &lt;p&gt;SQL can’t found data from cube will not redirect to Hive in beta&lt;/p&gt;
+    &lt;/li&gt;
+  &lt;/ol&gt;
+&lt;/blockquote&gt;
+
+&lt;p&gt;Go to “Query” menu:&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/8 query.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;
+    &lt;p&gt;Source Tables:&lt;/p&gt;
+
+    &lt;p&gt;Browser current available Tables (same structure and metadata as Hive):&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/9 query-table.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;New Query:&lt;/p&gt;
+
+    &lt;p&gt;You can write and execute your query and explorer the result. One query for you reference:&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/10 query-result.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Saved Query:&lt;/p&gt;
+
+    &lt;p&gt;Associate with user account, you can get saved query from different browsers even machines.
+ Click “Save” in Result area, it will popup for name and description to save current query:&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/11 save-query.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+    &lt;p&gt;Click “Saved Queries” to browser all your saved queries, you could direct resubmit it to run or remove it:&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/11 save-query-2.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Query History:&lt;/p&gt;
+
+    &lt;p&gt;Only keep the current user’s query history in current bowser, it will require cookie enabled and will lost if you clean up bowser’s cache.Click “Query History” tab, you could directly resubmit any of them to execute again.&lt;/p&gt;
+  &lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h2 id=&quot;pivot-analysis-and-visualization&quot;&gt;5. Pivot Analysis and Visualization&lt;/h2&gt;
+&lt;p&gt;There’s one simple pivot and visualization analysis tool in Kylin’s web for user to explore their query result:&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;
+    &lt;p&gt;General Information:&lt;/p&gt;
+
+    &lt;p&gt;When the query execute success, it will present a success indictor and also a cube’s name which be hit. 
+ Also it will present how long this query be executed in backend engine (not cover network traffic from Kylin server to browser):&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/12 general.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Query Result:&lt;/p&gt;
+
+    &lt;p&gt;It’s easy to order on one column.&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/13 results.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Export to CSV File&lt;/p&gt;
+
+    &lt;p&gt;Click “Export” button to save current result as CSV file.&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Pivot Table:&lt;/p&gt;
+
+    &lt;p&gt;Drag and Drop one or more columns into the header, the result will grouping by such column’s value:&lt;/p&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/14 drag.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+  &lt;li&gt;
+    &lt;p&gt;Visualization:&lt;/p&gt;
+
+    &lt;p&gt;Also, the result set will be easy to show with different charts in “Visualization”:&lt;/p&gt;
+
+    &lt;p&gt;note: line chart only available when there’s at least one dimension with real “Date” data type of column from Hive Table.&lt;/p&gt;
+
+    &lt;ul&gt;
+      &lt;li&gt;Bar Chart:&lt;/li&gt;
+    &lt;/ul&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/15 bar-chart.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+    &lt;ul&gt;
+      &lt;li&gt;Pie Chart:&lt;/li&gt;
+    &lt;/ul&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/16 pie-chart.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+
+    &lt;ul&gt;
+      &lt;li&gt;Line Chart&lt;/li&gt;
+    &lt;/ul&gt;
+
+    &lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/17 line-chart.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+  &lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h2 id=&quot;cube-build-job-monitoring&quot;&gt;6. Cube Build Job Monitoring&lt;/h2&gt;
+&lt;p&gt;Monitor and manage cube build process, diagnostic into the detail and even link to Hadoop’s job information directly:&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/images/Kylin-Web-Tutorial/7 job-steps.png&quot; alt=&quot;&quot; /&gt;&lt;/p&gt;
+</description>
+        <pubDate>Fri, 17 Apr 2015 00:00:00 +0800</pubDate>
+        <link>http://kyli.io/tutorial/2015/04/17/Kylin-Web-Tutorial/</link>
+        <guid isPermaLink="true">http://kyli.io/tutorial/2015/04/17/Kylin-Web-Tutorial/</guid>
+        
+        
+        <category>tutorial</category>
+        
+      </item>
+    
+      <item>
+        <title>Restful Service Doc</title>
+        <description>&lt;h2 id=&quot;kylin-restful-api-list&quot;&gt;Kylin Restful API List&lt;/h2&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;QUERY
+    &lt;ul&gt;
+      &lt;li&gt;Login&lt;/li&gt;
+      &lt;li&gt;Query&lt;/li&gt;
+      &lt;li&gt;List queryable tables&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+  &lt;li&gt;CUBE
+    &lt;ul&gt;
+      &lt;li&gt;List cubes&lt;/li&gt;
+      &lt;li&gt;Rebuild cube&lt;/li&gt;
+      &lt;li&gt;Disable cube&lt;/li&gt;
+      &lt;li&gt;Purge cube&lt;/li&gt;
+      &lt;li&gt;Enable cube&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+  &lt;li&gt;JOB
+    &lt;ul&gt;
+      &lt;li&gt;Resume job&lt;/li&gt;
+      &lt;li&gt;Discard job&lt;/li&gt;
+      &lt;li&gt;Get job step log&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+  &lt;li&gt;Metadata
+    &lt;ul&gt;
+      &lt;li&gt;Get Hive Table&lt;/li&gt;
+      &lt;li&gt;Get Hive Table (Extend Info)&lt;/li&gt;
+      &lt;li&gt;Get Hive Tables &lt;/li&gt;
+      &lt;li&gt;Load Hive Table&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+  &lt;li&gt;Wipe cache&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;hr /&gt;
+
+&lt;h3 id=&quot;login&quot;&gt;Login&lt;/h3&gt;
+&lt;p&gt;&lt;code&gt;POST /user/authentication&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;for example: &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;sh
+curl -c /path/to/cookiefile.txt -X POST -H &amp;quot;Authorization: Basic XXXXXXXXX&amp;quot; -H &amp;#39;Content-Type: application/json&amp;#39; http://&amp;lt;host&amp;gt;:&amp;lt;port&amp;gt;/kylin/api/user/authentication&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;If login successfully, the JSESSIONID will be saved into the cookie file; In the subsequent http requests, attach the cookie, for example:&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;curl -b /path/to/cookiefile.txt -X PUT -H &amp;#39;Content-Type: application/json&amp;#39; -d &amp;#39;{&amp;quot;startTime&amp;quot;:&amp;#39;1423526400000&amp;#39;, &amp;quot;endTime&amp;quot;:&amp;#39;1423526400&amp;#39;, &amp;quot;buildType&amp;quot;:&amp;quot;BUILD&amp;quot;}&amp;#39; http://&amp;lt;host&amp;gt;:&amp;lt;port&amp;gt;/kylin/api/cubes/your_cube/rebuild&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;h4 id=&quot;header&quot;&gt;Header&lt;/h4&gt;
+&lt;p&gt;Authorization data encoded by basic auth. Header sample:
+Authorization:Basic {data}&lt;/p&gt;
+
+&lt;h4 id=&quot;response-sample&quot;&gt;Response Sample&lt;/h4&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;Status: 200OK&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;{  
+   &amp;quot;userDetails&amp;quot;:{  
+      &amp;quot;password&amp;quot;:null,
+      &amp;quot;username&amp;quot;:&amp;quot;sample&amp;quot;,
+      &amp;quot;authorities&amp;quot;:[  
+         {  
+            &amp;quot;authority&amp;quot;:&amp;quot;ROLE_ANALYST&amp;quot;
+         },
+         {  
+            &amp;quot;authority&amp;quot;:&amp;quot;ROLE_MODELER&amp;quot;
+         }
+      ],
+      &amp;quot;accountNonExpired&amp;quot;:true,
+      &amp;quot;accountNonLocked&amp;quot;:true,
+      &amp;quot;credentialsNonExpired&amp;quot;:true,
+      &amp;quot;enabled&amp;quot;:true
+   }
+}&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;hr /&gt;
+
+&lt;h3 id=&quot;query&quot;&gt;Query&lt;/h3&gt;
+&lt;p&gt;&lt;code&gt;POST /query&lt;/code&gt;&lt;/p&gt;
+
+&lt;h4 id=&quot;request-body&quot;&gt;Request Body&lt;/h4&gt;
+&lt;ul&gt;
+  &lt;li&gt;sql - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;string&lt;/code&gt; The sql query string.&lt;/li&gt;
+  &lt;li&gt;offset - &lt;code&gt;optional&lt;/code&gt; &lt;code&gt;int&lt;/code&gt; Query offset. If offset is set in sql, curIndex will be ignored.&lt;/li&gt;
+  &lt;li&gt;limit - &lt;code&gt;optional&lt;/code&gt; &lt;code&gt;int&lt;/code&gt; Query limit. If limit is set in sql, perPage will be ignored.&lt;/li&gt;
+  &lt;li&gt;acceptPartial - &lt;code&gt;optional&lt;/code&gt; &lt;code&gt;bool&lt;/code&gt; Flag to switch partial query.&lt;/li&gt;
+  &lt;li&gt;project - &lt;code&gt;optional&lt;/code&gt; &lt;code&gt;string&lt;/code&gt; Project to perform query. Default value is ‘DEFAULT’&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;{  
+   &amp;quot;sql&amp;quot;:&amp;quot;select * from TEST_KYLIN_FACT&amp;quot;,
+   &amp;quot;offset&amp;quot;:0,
+   &amp;quot;limit&amp;quot;:50000,
+   &amp;quot;acceptPartial&amp;quot;:true,
+   &amp;quot;project&amp;quot;:&amp;quot;DEFAULT&amp;quot;
+}&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;h4 id=&quot;response-sample-1&quot;&gt;Response Sample&lt;/h4&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;Status: 200OK&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;{  
+   &amp;quot;columnMetas&amp;quot;:[  
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:0,
+         &amp;quot;label&amp;quot;:&amp;quot;CAL_DT&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;CAL_DT&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:0,
+         &amp;quot;scale&amp;quot;:0,
+         &amp;quot;columnType&amp;quot;:91,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;DATE&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:10,
+         &amp;quot;label&amp;quot;:&amp;quot;LEAF_CATEG_ID&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;LEAF_CATEG_ID&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:10,
+         &amp;quot;scale&amp;quot;:0,
+         &amp;quot;columnType&amp;quot;:4,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;INTEGER&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:10,
+         &amp;quot;label&amp;quot;:&amp;quot;LSTG_SITE_ID&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;LSTG_SITE_ID&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:10,
+         &amp;quot;scale&amp;quot;:0,
+         &amp;quot;columnType&amp;quot;:4,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;INTEGER&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:5,
+         &amp;quot;label&amp;quot;:&amp;quot;SLR_SEGMENT_CD&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;SLR_SEGMENT_CD&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:5,
+         &amp;quot;scale&amp;quot;:0,
+         &amp;quot;columnType&amp;quot;:5,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;SMALLINT&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:256,
+         &amp;quot;label&amp;quot;:&amp;quot;LSTG_FORMAT_NAME&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;LSTG_FORMAT_NAME&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:256,
+         &amp;quot;scale&amp;quot;:0,
+         &amp;quot;columnType&amp;quot;:12,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;VARCHAR(256)&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:19,
+         &amp;quot;label&amp;quot;:&amp;quot;SELLER_ID&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;SELLER_ID&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:19,
+         &amp;quot;scale&amp;quot;:0,
+         &amp;quot;columnType&amp;quot;:-5,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;BIGINT&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:19,
+         &amp;quot;label&amp;quot;:&amp;quot;PRICE&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;PRICE&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:19,
+         &amp;quot;scale&amp;quot;:4,
+         &amp;quot;columnType&amp;quot;:3,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;DECIMAL(19, 4)&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:19,
+         &amp;quot;label&amp;quot;:&amp;quot;MIN_PRICE_&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;MIN_PRICE_&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:19,
+         &amp;quot;scale&amp;quot;:4,
+         &amp;quot;columnType&amp;quot;:3,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;DECIMAL(19, 4)&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:19,
+         &amp;quot;label&amp;quot;:&amp;quot;MAX_PRICE_&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;MAX_PRICE_&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:19,
+         &amp;quot;scale&amp;quot;:4,
+         &amp;quot;columnType&amp;quot;:3,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;DECIMAL(19, 4)&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      },
+      {  
+         &amp;quot;isNullable&amp;quot;:1,
+         &amp;quot;displaySize&amp;quot;:19,
+         &amp;quot;label&amp;quot;:&amp;quot;COUNT__&amp;quot;,
+         &amp;quot;name&amp;quot;:&amp;quot;COUNT__&amp;quot;,
+         &amp;quot;schemaName&amp;quot;:null,
+         &amp;quot;catelogName&amp;quot;:null,
+         &amp;quot;tableName&amp;quot;:null,
+         &amp;quot;precision&amp;quot;:19,
+         &amp;quot;scale&amp;quot;:0,
+         &amp;quot;columnType&amp;quot;:-5,
+         &amp;quot;columnTypeName&amp;quot;:&amp;quot;BIGINT&amp;quot;,
+         &amp;quot;readOnly&amp;quot;:true,
+         &amp;quot;writable&amp;quot;:false,
+         &amp;quot;caseSensitive&amp;quot;:true,
+         &amp;quot;searchable&amp;quot;:false,
+         &amp;quot;currency&amp;quot;:false,
+         &amp;quot;signed&amp;quot;:true,
+         &amp;quot;autoIncrement&amp;quot;:false,
+         &amp;quot;definitelyWritable&amp;quot;:false
+      }
+   ],
+   &amp;quot;results&amp;quot;:[  
+      [  
+         &amp;quot;2013-08-07&amp;quot;,
+         &amp;quot;32996&amp;quot;,
+         &amp;quot;15&amp;quot;,
+         &amp;quot;15&amp;quot;,
+         &amp;quot;Auction&amp;quot;,
+         &amp;quot;10000000&amp;quot;,
+         &amp;quot;49.048952730908745&amp;quot;,
+         &amp;quot;49.048952730908745&amp;quot;,
+         &amp;quot;49.048952730908745&amp;quot;,
+         &amp;quot;1&amp;quot;
+      ],
+      [  
+         &amp;quot;2013-08-07&amp;quot;,
+         &amp;quot;43398&amp;quot;,
+         &amp;quot;0&amp;quot;,
+         &amp;quot;14&amp;quot;,
+         &amp;quot;ABIN&amp;quot;,
+         &amp;quot;10000633&amp;quot;,
+         &amp;quot;85.78317064220418&amp;quot;,
+         &amp;quot;85.78317064220418&amp;quot;,
+         &amp;quot;85.78317064220418&amp;quot;,
+         &amp;quot;1&amp;quot;
+      ],
+      [  
+         &amp;quot;2013-08-07&amp;quot;,
+         &amp;quot;170083&amp;quot;,
+         &amp;quot;3&amp;quot;,
+         &amp;quot;12&amp;quot;,
+         &amp;quot;FP-non GTC&amp;quot;,
+         &amp;quot;10000688&amp;quot;,
+         &amp;quot;49.4518822857833&amp;quot;,
+         &amp;quot;49.4518822857833&amp;quot;,
+         &amp;quot;49.4518822857833&amp;quot;,
+         &amp;quot;1&amp;quot;
+      ],
+      [  
+         &amp;quot;2013-08-07&amp;quot;,
+         &amp;quot;73506&amp;quot;,
+         &amp;quot;0&amp;quot;,
+         &amp;quot;14&amp;quot;,
+         &amp;quot;Others&amp;quot;,
+         &amp;quot;10000858&amp;quot;,
+         &amp;quot;35.7556514660872&amp;quot;,
+         &amp;quot;35.7556514660872&amp;quot;,
+         &amp;quot;35.7556514660872&amp;quot;,
+         &amp;quot;1&amp;quot;
+      ],
+      [  
+         &amp;quot;2013-08-07&amp;quot;,
+         &amp;quot;26262&amp;quot;,
+         &amp;quot;0&amp;quot;,
+         &amp;quot;5&amp;quot;,
+         &amp;quot;FP-GTC&amp;quot;,
+         &amp;quot;10000914&amp;quot;,
+         &amp;quot;69.63202173718798&amp;quot;,
+         &amp;quot;69.63202173718798&amp;quot;,
+         &amp;quot;69.63202173718798&amp;quot;,
+         &amp;quot;1&amp;quot;
+      ],
+      [  
+         &amp;quot;2013-08-07&amp;quot;,
+         &amp;quot;1161&amp;quot;,
+         &amp;quot;3&amp;quot;,
+         &amp;quot;12&amp;quot;,
+         &amp;quot;Others&amp;quot;,
+         &amp;quot;10000959&amp;quot;,
+         &amp;quot;76.72392839984632&amp;quot;,
+         &amp;quot;76.72392839984632&amp;quot;,
+         &amp;quot;76.72392839984632&amp;quot;,
+         &amp;quot;1&amp;quot;
+      ]
+   ],
+   &amp;quot;cube&amp;quot;:&amp;quot;test_kylin_cube_with_slr_desc&amp;quot;,
+   &amp;quot;affectedRowCount&amp;quot;:0,
+   &amp;quot;isException&amp;quot;:false,
+   &amp;quot;exceptionMessage&amp;quot;:null,
+   &amp;quot;duration&amp;quot;:3451,
+   &amp;quot;partial&amp;quot;:false
+}&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;hr /&gt;
+
+&lt;h3 id=&quot;list-queryable-tables&quot;&gt;List queryable tables&lt;/h3&gt;
+&lt;p&gt;&lt;code&gt;GET /tables_and_columns&lt;/code&gt;&lt;/p&gt;
+
+&lt;h4 id=&quot;request-parameters&quot;&gt;Request Parameters&lt;/h4&gt;
+&lt;ul&gt;
+  &lt;li&gt;project - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;string&lt;/code&gt; The project to load tables&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h4 id=&quot;response-sample-2&quot;&gt;Response Sample&lt;/h4&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;Status: 200OK&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;[  
+   {  
+      &amp;quot;columns&amp;quot;:[  
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CAL_DT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;CAL_DT&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:91,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:1,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;DATE&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CAL_DT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;WEEK_BEG_DT&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:91,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:2,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;DATE&amp;quot;
+         }
+      ],
+      &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CAL_DT&amp;quot;,
+      &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+      &amp;quot;ref_GENERATION&amp;quot;:null,
+      &amp;quot;self_REFERENCING_COL_NAME&amp;quot;:null,
+      &amp;quot;type_SCHEM&amp;quot;:null,
+      &amp;quot;table_TYPE&amp;quot;:&amp;quot;TABLE&amp;quot;,
+      &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+      &amp;quot;remarks&amp;quot;:null,
+      &amp;quot;type_CAT&amp;quot;:null,
+      &amp;quot;type_NAME&amp;quot;:null
+   },
+   {  
+      &amp;quot;columns&amp;quot;:[  
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;LEAF_CATEG_ID&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:4,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:1,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;INTEGER&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;SITE_ID&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:4,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:2,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;INTEGER&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;META_CATEG_NAME&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:3,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;CATEG_LVL2_NAME&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:4,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;CATEG_LVL3_NAME&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:5,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;USER_DEFINED_FIELD1&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:6,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;USER_DEFINED_FIELD3&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:7,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;UPD_DATE&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:8,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;UPD_USER&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:9,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         }
+      ],
+      &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_CATEGORY_GROUPINGS&amp;quot;,
+      &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+      &amp;quot;ref_GENERATION&amp;quot;:null,
+      &amp;quot;self_REFERENCING_COL_NAME&amp;quot;:null,
+      &amp;quot;type_SCHEM&amp;quot;:null,
+      &amp;quot;table_TYPE&amp;quot;:&amp;quot;TABLE&amp;quot;,
+      &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+      &amp;quot;remarks&amp;quot;:null,
+      &amp;quot;type_CAT&amp;quot;:null,
+      &amp;quot;type_NAME&amp;quot;:null
+   },
+   {  
+      &amp;quot;columns&amp;quot;:[  
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;CAL_DT&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:91,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:1,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;DATE&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;LEAF_CATEG_ID&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:4,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:2,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;INTEGER&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;LSTG_SITE_ID&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:4,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:3,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;INTEGER&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;SLR_SEGMENT_CD&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:5,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:4,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;SMALLINT&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;LSTG_FORMAT_NAME&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:5,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;SELLER_ID&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:-5,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:6,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;BIGINT&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;PRICE&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:3,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:19,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:4,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:19,
+            &amp;quot;ordinal_POSITION&amp;quot;:7,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;DECIMAL(19, 4)&amp;quot;
+         }
+      ],
+      &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_KYLIN_FACT&amp;quot;,
+      &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+      &amp;quot;ref_GENERATION&amp;quot;:null,
+      &amp;quot;self_REFERENCING_COL_NAME&amp;quot;:null,
+      &amp;quot;type_SCHEM&amp;quot;:null,
+      &amp;quot;table_TYPE&amp;quot;:&amp;quot;TABLE&amp;quot;,
+      &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+      &amp;quot;remarks&amp;quot;:null,
+      &amp;quot;type_CAT&amp;quot;:null,
+      &amp;quot;type_NAME&amp;quot;:null
+   },
+   {  
+      &amp;quot;columns&amp;quot;:[  
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_SELLER_TYPE_DIM&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;SELLER_TYPE_CD&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:5,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:1,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;SMALLINT&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_SELLER_TYPE_DIM&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;SELLER_TYPE_DESC&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:2,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         }
+      ],
+      &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_SELLER_TYPE_DIM&amp;quot;,
+      &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+      &amp;quot;ref_GENERATION&amp;quot;:null,
+      &amp;quot;self_REFERENCING_COL_NAME&amp;quot;:null,
+      &amp;quot;type_SCHEM&amp;quot;:null,
+      &amp;quot;table_TYPE&amp;quot;:&amp;quot;TABLE&amp;quot;,
+      &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+      &amp;quot;remarks&amp;quot;:null,
+      &amp;quot;type_CAT&amp;quot;:null,
+      &amp;quot;type_NAME&amp;quot;:null
+   },
+   {  
+      &amp;quot;columns&amp;quot;:[  
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_SITES&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;SITE_ID&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:4,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:-1,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:-1,
+            &amp;quot;ordinal_POSITION&amp;quot;:1,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;INTEGER&amp;quot;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_SITES&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;SITE_NAME&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:2,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         },
+         {  
+            &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_SITES&amp;quot;,
+            &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+            &amp;quot;column_NAME&amp;quot;:&amp;quot;CRE_USER&amp;quot;,
+            &amp;quot;data_TYPE&amp;quot;:12,
+            &amp;quot;nullable&amp;quot;:1,
+            &amp;quot;column_SIZE&amp;quot;:256,
+            &amp;quot;buffer_LENGTH&amp;quot;:-1,
+            &amp;quot;decimal_DIGITS&amp;quot;:0,
+            &amp;quot;num_PREC_RADIX&amp;quot;:10,
+            &amp;quot;column_DEF&amp;quot;:null,
+            &amp;quot;sql_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;sql_DATETIME_SUB&amp;quot;:-1,
+            &amp;quot;char_OCTET_LENGTH&amp;quot;:256,
+            &amp;quot;ordinal_POSITION&amp;quot;:3,
+            &amp;quot;is_NULLABLE&amp;quot;:&amp;quot;YES&amp;quot;,
+            &amp;quot;scope_CATLOG&amp;quot;:null,
+            &amp;quot;scope_SCHEMA&amp;quot;:null,
+            &amp;quot;scope_TABLE&amp;quot;:null,
+            &amp;quot;source_DATA_TYPE&amp;quot;:-1,
+            &amp;quot;iS_AUTOINCREMENT&amp;quot;:null,
+            &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+            &amp;quot;remarks&amp;quot;:null,
+            &amp;quot;type_NAME&amp;quot;:&amp;quot;VARCHAR(256) CHARACTER SET &lt;span class=&quot;c&quot;&gt;\&amp;quot;UTF-16LE\&amp;quot; COLLATE \&amp;quot;UTF-16LE$en_US$primary\&amp;quot;&amp;quot;&lt;/span&gt;
+         }
+      ],
+      &amp;quot;table_NAME&amp;quot;:&amp;quot;TEST_SITES&amp;quot;,
+      &amp;quot;table_SCHEM&amp;quot;:&amp;quot;EDW&amp;quot;,
+      &amp;quot;ref_GENERATION&amp;quot;:null,
+      &amp;quot;self_REFERENCING_COL_NAME&amp;quot;:null,
+      &amp;quot;type_SCHEM&amp;quot;:null,
+      &amp;quot;table_TYPE&amp;quot;:&amp;quot;TABLE&amp;quot;,
+      &amp;quot;table_CAT&amp;quot;:&amp;quot;defaultCatalog&amp;quot;,
+      &amp;quot;remarks&amp;quot;:null,
+      &amp;quot;type_CAT&amp;quot;:null,
+      &amp;quot;type_NAME&amp;quot;:null
+   }
+]&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;hr /&gt;
+
+&lt;h3 id=&quot;list-cubes&quot;&gt;List cubes&lt;/h3&gt;
+&lt;p&gt;&lt;code&gt;GET /cubes&lt;/code&gt;&lt;/p&gt;
+
+&lt;h4 id=&quot;request-parameters-1&quot;&gt;Request Parameters&lt;/h4&gt;
+&lt;ul&gt;
+  &lt;li&gt;cubeName - &lt;code&gt;optional&lt;/code&gt; &lt;code&gt;string&lt;/code&gt; Cube name to find.&lt;/li&gt;
+  &lt;li&gt;offset - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;int&lt;/code&gt; Offset used by pagination&lt;/li&gt;
+  &lt;li&gt;limit - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;int &lt;/code&gt; Cubes per page.&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h4 id=&quot;response-sample-3&quot;&gt;Response Sample&lt;/h4&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;Status: 200OK&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;[  
+   {  
+      &amp;quot;uuid&amp;quot;:&amp;quot;1eaca32a-a33e-4b69-83dd-0bb8b1f8c53b&amp;quot;,
+      &amp;quot;last_modified&amp;quot;:1407831634847,
+      &amp;quot;name&amp;quot;:&amp;quot;test_kylin_cube_with_slr_empty&amp;quot;,
+      &amp;quot;owner&amp;quot;:null,
+      &amp;quot;version&amp;quot;:null,
+      &amp;quot;descriptor&amp;quot;:&amp;quot;test_kylin_cube_with_slr_desc&amp;quot;,
+      &amp;quot;cost&amp;quot;:50,
+      &amp;quot;status&amp;quot;:&amp;quot;DISABLED&amp;quot;,
+      &amp;quot;segments&amp;quot;:[  
+      ],
+      &amp;quot;create_time&amp;quot;:null,
+      &amp;quot;source_records_count&amp;quot;:0,
+      &amp;quot;source_records_size&amp;quot;:0,
+      &amp;quot;size_kb&amp;quot;:0
+   }
+]&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;h3 id=&quot;rebuild-cube&quot;&gt;Rebuild cube&lt;/h3&gt;
+&lt;p&gt;&lt;code&gt;PUT /cubes/{cubeName}/rebuild&lt;/code&gt;&lt;/p&gt;
+
+&lt;h4 id=&quot;path-variable&quot;&gt;Path Variable&lt;/h4&gt;
+&lt;ul&gt;
+  &lt;li&gt;cubeName - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;string&lt;/code&gt; Cube name.&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h4 id=&quot;request-body-1&quot;&gt;Request Body&lt;/h4&gt;
+&lt;ul&gt;
+  &lt;li&gt;startTime - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;long&lt;/code&gt; Start timestamp of data to build, e.g. 1388563200000 for 2014-1-1&lt;/li&gt;
+  &lt;li&gt;endTime - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;long&lt;/code&gt; End timestamp of data to build&lt;/li&gt;
+  &lt;li&gt;buildType - &lt;code&gt;required&lt;/code&gt; &lt;code&gt;string&lt;/code&gt; Build type: ‘BUILD’ OR ‘MERGE’&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h4 id=&quot;response-sample-4&quot;&gt;Response Sample&lt;/h4&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;Status: 200OK&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-groff&quot; data-lang=&quot;groff&quot;&gt;{  
+   &amp;quot;uuid&amp;quot;:&amp;quot;c143e0e4-ac5f-434d-acf3-46b0d15e3dc6&amp;quot;,
+   &amp;quot;last_modified&amp;quot;:1407908916705,
+   &amp;quot;name&amp;quot;:&amp;quot;test_kylin_cube_with_slr_empty - 19700101000000_20140731160000 - BUILD - PDT 2014-08-12 22:48:36&amp;quot;,
+   &amp;quot;type&amp;quot;:&amp;quot;BUILD&amp;quot;,
+   &amp;quot;duration&amp;quot;:0,
+   &amp;quot;related_cube&amp;quot;:&amp;quot;test_kylin_cube_with_slr_empty&amp;quot;,
+   &amp;quot;related_segment&amp;quot;:&amp;quot;19700101000000_20140731160000&amp;quot;,
+   &amp;quot;exec_start_time&amp;quot;:0,
+   &amp;quot;exec_end_time&amp;quot;:0,
+   &amp;quot;mr_waiting&amp;quot;:0,
+   &amp;quot;steps&amp;quot;:[  
+      {  
+         &amp;quot;interruptCmd&amp;quot;:null,
+         &amp;quot;name&amp;quot;:&amp;quot;Create Intermediate Flat Hive Table&amp;quot;,
+         &amp;quot;sequence_id&amp;quot;:0,
+         &amp;quot;exec_cmd&amp;quot;:&amp;quot;hive -e &lt;span class=&quot;c&quot;&gt;\&amp;quot;DROP TABLE IF EXISTS kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6;\nCREATE EXTERNAL TABLE IF NOT EXISTS kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6\n(\nCAL_DT date\n,LEAF_CATEG_ID int\n,LSTG_SITE_ID int\n,META_CATEG_NAME string\n,CATEG_LVL2_NAME string\n,CATEG_LVL3_NAME string\n,LSTG_FORMAT_NAME string\n,SLR_SEGMENT_CD smallint\n,SELLER_ID bigint\n,PRICE decimal\n)\nROW FORMAT DELIMITED FIELDS TERMINATED BY &amp;#39;\\177&amp;#39;\nSTORED AS SEQUENCEFILE\nLOCATION &amp;#39;/tmp/kylin-c143e0e4-ac5f-434d-acf3-46b0d15e3dc6/kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6&amp;#39;;\nSET mapreduce.job.split.metainfo.maxsize=-1;\nSET mapred.compress.map.output=true;\nSET mapred.map.out
 put.compression.codec=com.hadoop.compression.lzo.LzoCodec;\nSET mapred.output.compress=true;\nSET mapred.output.compression.codec=com.hadoop.compression.lzo.LzoCodec;\nSET mapred.output.compression.type=BLOCK;\nSET mapreduce.job.max.split.locations=2000;\nSET hive.exec.compress.output=true;\nSET hive.auto.convert.join.noconditionaltask = true;\nSET hive.auto.convert.join.noconditionaltask.size = 300000000;\nINSERT OVERWRITE TABLE kylin_intermediate_test_kylin_cube_with_slr_desc_19700101000000_20140731160000_c143e0e4_ac5f_434d_acf3_46b0d15e3dc6\nSELECT\nTEST_KYLIN_FACT.CAL_DT\n,TEST_KYLIN_FACT.LEAF_CATEG_ID\n,TEST_KYLIN_FACT.LSTG_SITE_ID\n,TEST_CATEGORY_GROUPINGS.META_CATEG_NAME\n,TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME\n,TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME\n,TEST_KYLIN_FACT.LSTG_FORMAT_NAME\n,TEST_KYLIN_FACT.SLR_SEGMENT_CD\n,TEST_KYLIN_FACT.SELLER_ID\n,TEST_KYLIN_FACT.PRICE\nFROM TEST_KYLIN_FACT\nINNER JOIN TEST_CAL_DT\nON TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.CAL_DT\nINNER JOIN 
 TEST_CATEGORY_GROUPINGS\nON TEST_KYLIN_FACT.LEAF_CATEG_ID = TEST_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_CATEGORY_GROUPINGS.SITE_ID\nINNER JOIN TEST_SITES\nON TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_SITES.SITE_ID\nINNER JOIN TEST_SELLER_TYPE_DIM\nON TEST_KYLIN_FACT.SLR_SEGMENT_CD = TEST_SELLER_TYPE_DIM.SELLER_TYPE_CD\nWHERE (test_kylin_fact.cal_dt &amp;lt; &amp;#39;2014-07-31 16:00:00&amp;#39;)\n;\n\&amp;quot;&amp;quot;,&lt;/span&gt;
+         &amp;quot;interrupt_cmd&amp;quot;:null,
+         &amp;quot;exec_start_time&amp;quot;:0,
+         &amp;quot;exec_end_time&amp;quot;:0,
+         &amp;quot;exec_wait_time&amp;quot;:0,
+         &amp;quot;step_status&amp;quot;:&amp;quot;PENDING&amp;quot;,
+         &amp;quot;cmd_type&amp;quot;:&amp;quot;SHELL_CMD_HADOOP&amp;quot;,
+         &amp;quot;info&amp;quot;:null,
+         &amp;quot;run_async&amp;quot;:false
+      },
+      {  
+         &amp;quot;interruptCmd&amp;quot;:null,
+         &amp;quot;name&amp;quot;:&amp;quot;Extract Fact Table Distinct Columns&amp;quot;,
+         &amp;quot;sequence_id&amp;quot;:1,

[... 1349 lines stripped ...]