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/07/07 14:37:15 UTC

svn commit: r1689640 [2/3] - in /incubator/kylin/site: ./ 2014/10/24/How-to-Contribute/ about/ api/2014/12/31/Build-Cube-with-Restful-API/ api/2015/03/18/Restful-Service-Doc/ assets/css/ assets/js/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/...

Modified: incubator/kylin/site/feed.xml
URL: http://svn.apache.org/viewvc/incubator/kylin/site/feed.xml?rev=1689640&r1=1689639&r2=1689640&view=diff
==============================================================================
--- incubator/kylin/site/feed.xml (original)
+++ incubator/kylin/site/feed.xml Tue Jul  7 12:37:14 2015
@@ -17,13 +17,458 @@
   <channel>
     <title>kylin.io</title>
     <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>Fri, 03 Jul 2015 03:54:53 -0700</pubDate>
-    <lastBuildDate>Fri, 03 Jul 2015 03:54:53 -0700</lastBuildDate>
+    <link>http://kylin.incubator.apache.org/</link>
+    <atom:link href="http://kylin.incubator.apache.org/feed.xml" rel="self" type="application/rss+xml"/>
+    <pubDate>Tue, 07 Jul 2015 05:33:42 -0700</pubDate>
+    <lastBuildDate>Tue, 07 Jul 2015 05:33:42 -0700</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>
+        <title>How to making a release (for Kylin committers)</title>
+        <description>&lt;p&gt;&lt;em&gt;This guide is for Apache Kylin Committers only.&lt;/em&gt;&lt;br /&gt;
+&lt;em&gt;Shell commands is on Mac OS X as sample.&lt;/em&gt;&lt;br /&gt;
+&lt;em&gt;For people in China, please aware using proxy to avoid potential firewall issue.&lt;/em&gt;  &lt;/p&gt;
+
+&lt;h1 id=&quot;setup-account&quot;&gt;Setup Account&lt;/h1&gt;
+&lt;p&gt;Make sure you have avaliable account and privlidge for following applications:&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;Apache account: &lt;a href=&quot;https://id.apache.org/&quot;&gt;https://id.apache.org&lt;/a&gt;    &lt;/li&gt;
+  &lt;li&gt;Apache Kylin git repo (main cobe base): &lt;a href=&quot;https://git-wip-us.apache.org/repos/asf/incubator-kylin.git&quot;&gt;https://git-wip-us.apache.org/repos/asf/incubator-kylin.git&lt;/a&gt;  &lt;/li&gt;
+  &lt;li&gt;Apache Kylin svn repo (for website only): &lt;a href=&quot;https://svn.apache.org/repos/asf/incubator/kylin&quot;&gt;https://svn.apache.org/repos/asf/incubator/kylin&lt;/a&gt;  &lt;/li&gt;
+  &lt;li&gt;Apache Nexus (maven repo): &lt;a href=&quot;https://repository.apache.org&quot;&gt;https://repository.apache.org&lt;/a&gt;  &lt;/li&gt;
+  &lt;li&gt;Apache Kylin dist repo: &lt;a href=&quot;https://dist.apache.org/repos/dist/dev/incubator/kylin&quot;&gt;https://dist.apache.org/repos/dist/dev/incubator/kylin&lt;/a&gt;  &lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h1 id=&quot;setup-pgp-signing-keys&quot;&gt;Setup PGP signing keys&lt;/h1&gt;
+&lt;p&gt;Follow instructions at &lt;a href=&quot;http://www.apache.org/dev/release-signing&quot;&gt;http://www.apache.org/dev/release-signing&lt;/a&gt; to create a key pair&lt;br /&gt;
+Install gpg (On Mac OS X as sample):&lt;br /&gt;
+&lt;code&gt;brew install gpg and gpg --gen-key&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;Generate gpg key:&lt;br /&gt;
+Reference: &lt;a href=&quot;https://www.gnupg.org/gph/en/manual/c14.html&quot;&gt;https://www.gnupg.org/gph/en/manual/c14.html&lt;/a&gt;&lt;br /&gt;
+&lt;em&gt;All new RSA keys generated should be at least 4096 bits. Do not generate new DSA keys&lt;/em&gt;&lt;br /&gt;
+&lt;code&gt;gpg --gen-key&lt;/code&gt;  &lt;/p&gt;
+
+&lt;p&gt;Verify your key:&lt;br /&gt;
+&lt;code&gt;gpg --list-sigs YOUR_NAME&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;Then add your key to your apache account, for example:&lt;br /&gt;
+&lt;a href=&quot;https://people.apache.org/keys/committer/lukehan.asc&quot;&gt;https://people.apache.org/keys/committer/lukehan.asc&lt;/a&gt;&lt;br /&gt;
+Generate ASCII Amromed Key:&lt;br /&gt;
+&lt;code&gt;gpg -a --export YOUR_MAIL_ADDRESS &amp;gt; YOUR_NAME.asc &amp;amp;&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;Upload key to public server:&lt;br /&gt;
+&lt;code&gt;gpg --send-keys YOUR_KEY_HASH&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;or Submit key via web:&lt;br /&gt;
+Open and Submit to &lt;a href=&quot;http://pool.sks-keyservers.net:11371&quot;&gt;http://pool.sks-keyservers.net:11371&lt;/a&gt; (you can pickup any avaliable public key server)&lt;br /&gt;
+Once your key submitted to server, you can verify using following command:&lt;br /&gt;
+&lt;code&gt;gpg --recv-keys YOUR_KEY_HASH&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;for example:&lt;br /&gt;
+&lt;code&gt;gpg --recv-keys 027DC364&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;Add your public key to the KEYS file by following instructions in the KEYS file.:&lt;br /&gt;
+&lt;em&gt;KEYS file location:&lt;/em&gt; &lt;strong&gt;${incubator-kylin}/KEYS&lt;/strong&gt;&lt;br /&gt;
+For example:&lt;br /&gt;
+&lt;code&gt;(gpg --list-sigs YOURNAME &amp;amp;&amp;amp; gpg --armor --export YOURNAME) &amp;gt;&amp;gt; KEYS&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;Commit your changes.&lt;/p&gt;
+
+&lt;h1 id=&quot;prepare-artifacts-for-release&quot;&gt;Prepare artifacts for release&lt;/h1&gt;
+&lt;p&gt;&lt;strong&gt;Before you start:&lt;/strong&gt;&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;Set up signing keys as described above.&lt;/li&gt;
+  &lt;li&gt;Make sure you are using JDK 1.7 (not 1.8).&lt;/li&gt;
+  &lt;li&gt;Make sure you are working on right release version number.&lt;/li&gt;
+  &lt;li&gt;Make sure that every “resolved” JIRA case (including duplicates) has a fix version assigned.&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;&lt;strong&gt;Making a snapshot&lt;/strong&gt;  &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;c&quot;&gt;# Set passphrase variable without putting it into shell history&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;read&lt;/span&gt; -s GPG_PASSPHRASE
+
+&lt;span class=&quot;c&quot;&gt;# Make sure that there are no junk files in the sandbox&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git clean -xn
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mvn clean
+
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mvn -Papache-release -Dgpg.passphrase&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;&lt;span class=&quot;k&quot;&gt;${&lt;/span&gt;&lt;span class=&quot;nv&quot;&gt;GPG_PASSPHRASE&lt;/span&gt;&lt;span class=&quot;k&quot;&gt;}&lt;/span&gt; install&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;When the dry-run has succeeded, change install to deploy.&lt;/p&gt;
+
+&lt;p&gt;&lt;strong&gt;Verify licenses&lt;/strong&gt;&lt;br /&gt;
+Run Apache RAT to check licenses issue:  &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;mvn -Papache-release clean rat:rat&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;Fix license issue if any.&lt;/p&gt;
+
+&lt;p&gt;&lt;strong&gt;Making a release&lt;/strong&gt;&lt;/p&gt;
+
+&lt;p&gt;Create a release branch named after the release, e.g. v0.7.2-release, and push it to Apache.  &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git checkout -b vX.Y.Z-release
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git push -u origin vX.Y.Z-release&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;We will use the branch for the entire the release process. Meanwhile, we do not allow commits to the master branch. After the release is final, we can use &lt;code&gt;git merge --ff-only&lt;/code&gt; to append the changes on the release branch onto the master branch. (Apache does not allow reverts to the master branch, which makes it difficult to clean up the kind of messy commits that inevitably happen while you are trying to finalize a release.)&lt;/p&gt;
+
+&lt;p&gt;Now, set up your environment and do a dry run. The dry run will not commit any changes back to git and gives you the opportunity to verify that the release process will complete as expected.&lt;/p&gt;
+
+&lt;p&gt;If any of the steps fail, clean up (see below), fix the problem, and start again from the top.  &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;c&quot;&gt;# Set passphrase variable without putting it into shell history&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;read&lt;/span&gt; -s GPG_PASSPHRASE
+
+&lt;span class=&quot;c&quot;&gt;# Make sure that there are no junk files in the sandbox&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git clean -xn
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mvn clean
+
+&lt;span class=&quot;c&quot;&gt;# Do a dry run of the release:prepare step, which sets version numbers.&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mvn -DdryRun&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;true&lt;/span&gt; -DskipTests -DreleaseVersion&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;X.Y.Z-incubating -DdevelopmentVersion&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;X.Y.Z+1-incubating-SNAPSHOT -Papache-release -Darguments&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;&lt;span class=&quot;s2&quot;&gt;&amp;quot;-Dgpg.passphrase=${GPG_PASSPHRASE}&amp;quot;&lt;/span&gt; release:prepare 2&amp;gt;&lt;span class=&quot;p&quot;&gt;&amp;amp;&lt;/span&gt;&lt;span class=&quot;m&quot;&gt;1&lt;/span&gt; &lt;span class=&quot;p&quot;&gt;|&lt;/span&gt; tee /tmp/prepare-dry.log&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;&lt;strong&gt;Check the artifacts:&lt;/strong&gt;&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;In the &lt;code&gt;target&lt;/code&gt; directory should be these 8 files, among others:
+    &lt;ul&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.tar.gz&lt;/li&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.tar.gz.asc&lt;/li&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.tar.gz.md5&lt;/li&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.tar.gz.sha1&lt;/li&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.zip&lt;/li&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.zip.asc&lt;/li&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.zip.md5&lt;/li&gt;
+      &lt;li&gt;apache-kylin-X.Y.Z-incubating-src.zip.sha1&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+  &lt;li&gt;Note that the file names start &lt;code&gt;apache-kylin-&lt;/code&gt; and include
+&lt;code&gt;incubating&lt;/code&gt; in the version.&lt;/li&gt;
+  &lt;li&gt;In the two source distros &lt;code&gt;.tar.gz&lt;/code&gt; and &lt;code&gt;.zip&lt;/code&gt;, check that all files belong to a directory called
+&lt;code&gt;apache-kylin-X.Y.Z-incubating-src&lt;/code&gt;.&lt;/li&gt;
+  &lt;li&gt;That directory must contain files &lt;code&gt;DISCLAIMER&lt;/code&gt;, &lt;code&gt;NOTICE&lt;/code&gt;, &lt;code&gt;LICENSE&lt;/code&gt;, &lt;code&gt;README.md&lt;/code&gt;&lt;/li&gt;
+  &lt;li&gt;Check PGP, per &lt;a href=&quot;https://httpd.apache.org/dev/verification.html&quot;&gt;this&lt;/a&gt;&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;&lt;strong&gt;Run real release:&lt;/strong&gt;
+Now, run the release for real.  &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;c&quot;&gt;# Prepare sets the version numbers, creates a tag, and pushes it to git.&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mvn -DskipTests -Papache-release -Darguments&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;&lt;span class=&quot;s2&quot;&gt;&amp;quot;-Dgpg.passphrase=${GPG_PASSPHRASE} -DskipTests&amp;quot;&lt;/span&gt; clean release:prepare
+
+&lt;span class=&quot;c&quot;&gt;# Perform checks out the tagged version, builds, and deploys to the staging repository&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mvn -DskipTests -Papache-release -Darguments&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;&lt;span class=&quot;s2&quot;&gt;&amp;quot;-Dgpg.passphrase=${GPG_PASSPHRASE} -DskipTests&amp;quot;&lt;/span&gt; release:perform&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;&lt;strong&gt;Verify the staged artifacts in the Nexus repository:&lt;/strong&gt;&lt;br /&gt;
+* Go to &lt;a href=&quot;https://repository.apache.org/&quot;&gt;https://repository.apache.org/&lt;/a&gt; and login
+* Under &lt;code&gt;Build Promotion&lt;/code&gt;, click &lt;code&gt;Staging Repositories&lt;/code&gt;
+* In the &lt;code&gt;Staging Repositories&lt;/code&gt; tab there should be a line with profile &lt;code&gt;org.apache.kylin&lt;/code&gt;
+* Navigate through the artifact tree and make sure the .jar, .pom, .asc files are present
+* Check the box on in the first column of the row,
+  and press the ‘Close’ button to publish the repository at
+  https://repository.apache.org/content/repositories/orgapachekylin-1006
+  (or a similar URL)&lt;/p&gt;
+
+&lt;p&gt;&lt;strong&gt;Upload to staging area:&lt;/strong&gt;&lt;br /&gt;
+Upload the artifacts via subversion to a staging area, https://dist.apache.org/repos/dist/dev/incubator/kylin/apache-kylin-X.Y.Z-incubating-rcN:&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;c&quot;&gt;# Create a subversion workspace, if you haven&amp;#39;t already&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mkdir -p ~/dist/dev
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;pushd&lt;/span&gt; ~/dist/dev
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;svn co https://dist.apache.org/repos/dist/dev/incubator/kylin
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;popd&lt;/span&gt;
+
+&lt;span class=&quot;c&quot;&gt;# Move the files into a directory&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;cd &lt;/span&gt;target
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mkdir ~/dist/dev/kylin/apache-kylin-X.Y.Z-incubating-rcN
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mv apache-kylin-* ~/dist/dev/kylin/apache-kylin-X.Y.Z-incubating-rcN
+
+&lt;span class=&quot;c&quot;&gt;# Check in&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;cd&lt;/span&gt; ~/dist/dev/kylin
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;svn add apache-kylin-X.Y.Z-incubating-rcN
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;svn commit -m &lt;span class=&quot;s1&quot;&gt;&amp;#39;Upload release artifacts to staging&amp;#39;&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;&lt;strong&gt;Cleaning up after a failed release attempt:&lt;/strong&gt;&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;c&quot;&gt;# Make sure that the tag you are about to generate does not already&lt;/span&gt;
+&lt;span class=&quot;c&quot;&gt;# exist (due to a failed release attempt)&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git tag
+
+&lt;span class=&quot;c&quot;&gt;# If the tag exists, delete it locally and remotely&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git tag -d apache-kylin-X.Y.Z-incubating
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git push origin :refs/tags/apache-kylin-X.Y.Z-incubating
+
+&lt;span class=&quot;c&quot;&gt;# Remove modified files&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mvn release:clean
+
+&lt;span class=&quot;c&quot;&gt;# Check whether there are modified files and if so, go back to the&lt;/span&gt;
+&lt;span class=&quot;c&quot;&gt;# original git commit&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git status
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;git reset --hard HEAD&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;h1 id=&quot;validate-a-release&quot;&gt;Validate a release&lt;/h1&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;c&quot;&gt;# Check that the signing key (e.g. 2AD3FAE3) is pushed&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;gpg --recv-keys key
+
+&lt;span class=&quot;c&quot;&gt;# Check keys&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;curl -O https://dist.apache.org/repos/dist/release/incubator/kylin/KEYS
+
+&lt;span class=&quot;c&quot;&gt;# Sign/check md5 and sha1 hashes&lt;/span&gt;
+&lt;span class=&quot;c&quot;&gt;# (Assumes your O/S has &amp;#39;md5&amp;#39; and &amp;#39;sha1&amp;#39; commands.)&lt;/span&gt;
+&lt;span class=&quot;k&quot;&gt;function&lt;/span&gt; checkHash&lt;span class=&quot;o&quot;&gt;()&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;{&lt;/span&gt;
+  &lt;span class=&quot;nb&quot;&gt;cd&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;$1&amp;quot;&lt;/span&gt;
+  &lt;span class=&quot;k&quot;&gt;for&lt;/span&gt; i in *.&lt;span class=&quot;o&quot;&gt;{&lt;/span&gt;zip,pom,gz&lt;span class=&quot;o&quot;&gt;}&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;do&lt;/span&gt;
+    &lt;span class=&quot;k&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;[&lt;/span&gt; ! -f &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;then&lt;/span&gt;
+      &lt;span class=&quot;k&quot;&gt;continue&lt;/span&gt;
+    &lt;span class=&quot;k&quot;&gt;fi&lt;/span&gt;
+    &lt;span class=&quot;k&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;[&lt;/span&gt; -f &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.md5 &lt;span class=&quot;o&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;then&lt;/span&gt;
+      &lt;span class=&quot;k&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;[&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;$(cat $i.md5)&amp;quot;&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;$(md5 -q $i)&amp;quot;&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;then&lt;/span&gt;
+        &lt;span class=&quot;nb&quot;&gt;echo&lt;/span&gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.md5 present and correct
+      &lt;span class=&quot;k&quot;&gt;else&lt;/span&gt;
+        &lt;span class=&quot;nb&quot;&gt;echo&lt;/span&gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.md5 does not match
+      &lt;span class=&quot;k&quot;&gt;fi&lt;/span&gt;
+    &lt;span class=&quot;k&quot;&gt;else&lt;/span&gt;
+      md5 -q &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt; &amp;gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.md5
+      &lt;span class=&quot;nb&quot;&gt;echo&lt;/span&gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.md5 created
+    &lt;span class=&quot;k&quot;&gt;fi&lt;/span&gt;
+    &lt;span class=&quot;k&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;[&lt;/span&gt; -f &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.sha1 &lt;span class=&quot;o&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;then&lt;/span&gt;
+      &lt;span class=&quot;k&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;[&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;$(cat $i.sha1)&amp;quot;&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;$(sha1 -q $i)&amp;quot;&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;]&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;then&lt;/span&gt;
+        &lt;span class=&quot;nb&quot;&gt;echo&lt;/span&gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.sha1 present and correct
+      &lt;span class=&quot;k&quot;&gt;else&lt;/span&gt;
+        &lt;span class=&quot;nb&quot;&gt;echo&lt;/span&gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.sha1 does not match
+      &lt;span class=&quot;k&quot;&gt;fi&lt;/span&gt;
+    &lt;span class=&quot;k&quot;&gt;else&lt;/span&gt;
+      sha1 -q &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt; &amp;gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.sha1
+      &lt;span class=&quot;nb&quot;&gt;echo&lt;/span&gt; &lt;span class=&quot;nv&quot;&gt;$i&lt;/span&gt;.sha1 created
+    &lt;span class=&quot;k&quot;&gt;fi&lt;/span&gt;
+  &lt;span class=&quot;k&quot;&gt;done&lt;/span&gt;
+&lt;span class=&quot;o&quot;&gt;}&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;checkHash apache-kylin-X.Y.Z-incubating-rcN&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;h1 id=&quot;apache-voting-process&quot;&gt;Apache voting process&lt;/h1&gt;
+
+&lt;p&gt;&lt;strong&gt;Vote on Apache Kylin dev mailing list&lt;/strong&gt;&lt;br /&gt;
+Release vote on dev list:  &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-text&quot; data-lang=&quot;text&quot;&gt;To: dev@kylin.incubator.apache.org
+Subject: [VOTE] Release apache-kylin-X.Y.Z-incubating (release candidate N)
+
+Hi all,
+
+I have created a build for Apache Kylin X.Y.Z-incubating, release candidate N.
+
+Changes highlights:
+...
+
+Thanks to everyone who has contributed to this release.
+Here’s release notes:
+https://github.com/apache/incubator-kylin/blob/XXX/docs/release_notes.md
+
+The commit to be voted upon:
+
+https://github.com/apache/incubator-kylin/commit/xxx
+
+Its hash is xxx.
+
+The artifacts to be voted on are located here:
+https://dist.apache.org/repos/dist/dev/incubator/kylin/apache-kylin-X.Y.Z-incubating-rcN/
+
+The hashes of the artifacts are as follows:
+src.zip.md5 xxx
+src.zip.sha1 xxx
+src.tar.gz.md5 xxx
+src.tar.gz.sha1 xxx
+
+A staged Maven repository is available for review at:
+https://repository.apache.org/content/repositories/orgapachekylin-XXXX/
+
+Release artifacts are signed with the following key:
+https://people.apache.org/keys/committer/lukehan.asc
+
+Please vote on releasing this package as Apache Kylin X.Y.Z-incubating.
+
+The vote is open for the next 72 hours and passes if a majority of
+at least three +1 PPMC votes are cast.
+
+[ ] +1 Release this package as Apache Kylin X.Y.Z-incubating
+[ ]  0 I don&amp;#39;t feel strongly about it, but I&amp;#39;m okay with the release
+[ ] -1 Do not release this package because...
+
+
+Here is my vote:
+
++1 (binding)
+
+Luke&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;After vote finishes, send out the result:  &lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-text&quot; data-lang=&quot;text&quot;&gt;Subject: [RESULT] [VOTE] Release apache-kylin-X.Y.Z-incubating (release candidate N)
+To: dev@kylin.incubator.apache.org
+
+Thanks to everyone who has tested the release candidate and given
+their comments and votes.
+
+The tally is as follows.
+
+N binding +1s:
+
+N non-binding +1s:
+
+No 0s or -1s.
+
+Therefore I am delighted to announce that the proposal to release
+Apache-Kylin-X.Y.Z-incubating has passed.
+
+I&amp;#39;ll now start a vote on the general list. Those of you in the IPMC,
+please recast your vote on the new thread.
+
+Luke&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;&lt;strong&gt;Vote on Apache incubator general mailing list&lt;/strong&gt; &lt;br /&gt;
+Use the &lt;a href=&quot;http://s.apache.org&quot;&gt;Apache URL shortener&lt;/a&gt; to generate
+shortened URLs for the vote proposal and result emails. Examples:
+&lt;a href=&quot;http://s.apache.org/kylin-0.7.1-vote_rc3&quot;&gt;http://s.apache.org/kylin-0.7.1-vote_rc3&lt;/a&gt; and
+&lt;a href=&quot;http://s.apache.org/kylin-0.7.1-result_rc3&quot;&gt;http://s.apache.org/kylin-0.7.1-result_rc3&lt;/a&gt;.&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-text&quot; data-lang=&quot;text&quot;&gt;To: general@incubator.apache.org
+Subject: [VOTE] Release Apache Kylin X.Y.Z (incubating)
+
+Hi all,
+
+The Apache Kylin community has voted on and approved a proposal to release
+Apache Kylin X.Y.Z (incubating).
+
+Proposal:
+http://s.apache.org/kylin-X.Y.Z-vote_rcN
+
+Vote result:
+N binding +1 votes
+N non-binding +1 votes
+No -1 votes
+http://s.apache.org/kylin-X.Y.Z-result_rcN
+
+
+The commit to be voted upon:
+https://github.com/apache/incubator-kylin/commit/XXX
+
+Its hash is XXX.
+
+The artifacts to be voted on are located here:
+https://dist.apache.org/repos/dist/dev/incubator/kylin/apache-kylin-X.Y.Z-incubating-rcN/
+
+The hashes of the artifacts are as follows:
+src.zip.md5 XXX
+src.zip.sha1 XXX
+src.tar.gz.md5 XXX
+src.tar.gz.sha1 XXX
+
+A staged Maven repository is available for review at:
+https://repository.apache.org/content/repositories/orgapachekylin-NNNN/
+
+Release artifacts are signed with the following key:
+https://people.apache.org/keys/committer/lukehan.asc
+
+Pursuant to the Releases section of the Incubation Policy and with
+the endorsement of our mentors we would now like to request
+the permission of the Incubator PMC to publish the release. The vote
+is open for 72 hours, or until the necessary number of votes (3 +1)
+is reached.
+
+[ ] +1 Release this package
+[ ]  0 I don&amp;#39;t feel strongly about it, but I&amp;#39;m okay with the release
+[ ] -1 Do not release this package because...
+
+
+Luke Han, on behalf of Apache Kylin PPMC&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;After vote finishes, send out the result:&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-text&quot; data-lang=&quot;text&quot;&gt;To: general@incubator.apache.org
+Subject: [RESULT] [VOTE] Release Apache Kylin X.Y.Z (incubating)
+
+This vote passes with N +1s and no 0 or -1 votes:
+
++1 &amp;lt;name&amp;gt; (binding or no-binding)
+
+Thanks everyone. We’ll now roll the release out to the mirrors.
+
+Luke Han, on behalf of Apache Kylin PPMC&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;h1 id=&quot;publishing-a-release&quot;&gt;Publishing a release&lt;/h1&gt;
+&lt;p&gt;After a successful release vote, we need to push the release
+out to mirrors, and other tasks.&lt;/p&gt;
+
+&lt;p&gt;In JIRA, search for
+&lt;a href=&quot;https://issues.apache.org/jira/issues/?jql=project%20%3D%20KYLIN%20&quot;&gt;all issues resolved in this release&lt;/a&gt;,
+and do a bulk update changing their status to “Closed”,
+with a change comment
+“Resolved in release X.Y.Z-incubating (YYYY-MM-DD)”
+(fill in release number and date appropriately).&lt;br /&gt;
+&lt;strong&gt;Uncheck “Send mail for this update”.&lt;/strong&gt;&lt;/p&gt;
+
+&lt;p&gt;Promote the staged nexus artifacts.&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;Go to &lt;a href=&quot;https://repository.apache.org/&quot;&gt;https://repository.apache.org/&lt;/a&gt; and login&lt;/li&gt;
+  &lt;li&gt;Under “Build Promotion” click “Staging Repositories”&lt;/li&gt;
+  &lt;li&gt;In the line with “orgapachekylin-xxxx”, check the box&lt;/li&gt;
+  &lt;li&gt;Press “Release” button&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;Check the artifacts into svn.&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;c&quot;&gt;# Get the release candidate.&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mkdir -p ~/dist/dev
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;cd&lt;/span&gt; ~/dist/dev
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;svn co https://dist.apache.org/repos/dist/dev/incubator/kylin
+
+&lt;span class=&quot;c&quot;&gt;# Copy the artifacts. Note that the copy does not have &amp;#39;-rcN&amp;#39; suffix.&lt;/span&gt;
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;mkdir -p ~/dist/release
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;cd&lt;/span&gt; ~/dist/release
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;svn co https://dist.apache.org/repos/dist/release/incubator/kylin
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;&lt;span class=&quot;nb&quot;&gt;cd &lt;/span&gt;kylin
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;cp -rp ../../dev/kylin/apache-kylin-X.Y.Z-incubating-rcN apache-kylin-X.Y.Z-incubating
+&lt;span class=&quot;nv&quot;&gt;$ &lt;/span&gt;svn add apache-kylin-X.Y.Z-incubating
+
+&lt;span class=&quot;c&quot;&gt;# Check in.&lt;/span&gt;
+svn commit -m &lt;span class=&quot;s1&quot;&gt;&amp;#39;checkin release artifacts&amp;#39;&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;Svnpubsub will publish to
+&lt;a href=&quot;https://dist.apache.org/repos/dist/release/incubator/kylin&quot;&gt;https://dist.apache.org/repos/dist/release/incubator/kylin&lt;/a&gt; and propagate to
+&lt;a href=&quot;http://www.apache.org/dyn/closer.cgi/incubator/kylin&quot;&gt;http://www.apache.org/dyn/closer.cgi/incubator/kylin&lt;/a&gt; within 24 hours.&lt;/p&gt;
+
+&lt;p&gt;If there are now more than 2 releases, clear out the oldest ones:&lt;/p&gt;
+
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&lt;span class=&quot;nb&quot;&gt;cd&lt;/span&gt; ~/dist/release/kylin
+svn rm apache-kylin-X.Y.Z-incubating
+svn commit -m &lt;span class=&quot;s1&quot;&gt;&amp;#39;Remove old release&amp;#39;&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+
+&lt;p&gt;The old releases will remain available in the
+&lt;a href=&quot;http://archive.apache.org/dist/incubator/kylin/&quot;&gt;release archive&lt;/a&gt;.&lt;/p&gt;
+
+&lt;p&gt;Release same version in JIRA, check &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN/?selectedTab=com.atlassian.jira.jira-projects-plugin:changelog-panel&quot;&gt;Change Log&lt;/a&gt; for the latest released version.&lt;/p&gt;
+
+&lt;h1 id=&quot;publishing-the-web-site&quot;&gt;Publishing the web site&lt;/h1&gt;
+&lt;p&gt;&lt;em&gt;TBD&lt;/em&gt;&lt;/p&gt;
+
+&lt;h1 id=&quot;thanks&quot;&gt;Thanks&lt;/h1&gt;
+&lt;p&gt;This guide drafted with reference from &lt;a href=&quot;http://calcite.incubator.apache.org&quot;&gt;Apache Calcite&lt;/a&gt; Howto doc, Thank you very much.&lt;/p&gt;
+
+</description>
+        <pubDate>Mon, 06 Jul 2015 00:00:00 -0700</pubDate>
+        <link>http://kylin.incubator.apache.org/howto/2015/07/06/How-to-making-a-release/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/howto/2015/07/06/How-to-making-a-release/</guid>
+        
+        
+        <category>howto</category>
+        
+      </item>
+    
+      <item>
         <title>Events and Conferences</title>
         <description>&lt;p&gt;&lt;strong&gt;Coming Events&lt;/strong&gt;&lt;/p&gt;
 
@@ -52,8 +497,8 @@
 
 </description>
         <pubDate>Thu, 02 Jul 2015 00:00:00 -0700</pubDate>
-        <link>http://kyli.io/gettingstarted/2015/07/02/Events-and-Conferences/</link>
-        <guid isPermaLink="true">http://kyli.io/gettingstarted/2015/07/02/Events-and-Conferences/</guid>
+        <link>http://kylin.incubator.apache.org/gettingstarted/2015/07/02/Events-and-Conferences/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/gettingstarted/2015/07/02/Events-and-Conferences/</guid>
         
         
         <category>gettingstarted</category>
@@ -210,8 +655,8 @@
 
 </description>
         <pubDate>Wed, 10 Jun 2015 05:28:00 -0700</pubDate>
-        <link>http://kyli.io/blog/2015/06/10/release-v0.7.1-incubating/</link>
-        <guid isPermaLink="true">http://kyli.io/blog/2015/06/10/release-v0.7.1-incubating/</guid>
+        <link>http://kylin.incubator.apache.org/blog/2015/06/10/release-v0.7.1-incubating/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/blog/2015/06/10/release-v0.7.1-incubating/</guid>
         
         
         <category>blog</category>
@@ -223,8 +668,8 @@
         <description>
 </description>
         <pubDate>Thu, 28 May 2015 00:00:00 -0700</pubDate>
-        <link>http://kyli.io/gettingstarted/2015/05/28/Terminology/</link>
-        <guid isPermaLink="true">http://kyli.io/gettingstarted/2015/05/28/Terminology/</guid>
+        <link>http://kylin.incubator.apache.org/gettingstarted/2015/05/28/Terminology/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/gettingstarted/2015/05/28/Terminology/</guid>
         
         
         <category>gettingstarted</category>
@@ -272,8 +717,8 @@ My Cluster is running on Cloudera Distri
 &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 -0700</pubDate>
-        <link>http://kyli.io/gettingstarted/2015/05/18/FAQ/</link>
-        <guid isPermaLink="true">http://kyli.io/gettingstarted/2015/05/18/FAQ/</guid>
+        <link>http://kylin.incubator.apache.org/gettingstarted/2015/05/18/FAQ/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/gettingstarted/2015/05/18/FAQ/</guid>
         
         
         <category>gettingstarted</category>
@@ -310,8 +755,8 @@ My Cluster is running on Cloudera Distri
 &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 -0700</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>
+        <link>http://kylin.incubator.apache.org/howto/2015/05/18/Export-Kylin-HBase-data/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/howto/2015/05/18/Export-Kylin-HBase-data/</guid>
         
         
         <category>howto</category>
@@ -490,8 +935,8 @@ My Cluster is running on Cloudera Distri
 &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 -0700</pubDate>
-        <link>http://kyli.io/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/</link>
-        <guid isPermaLink="true">http://kyli.io/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/</guid>
+        <link>http://kylin.incubator.apache.org/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E7%BD%91%E9%A1%B5%E7%89%88%E6%95%99%E7%A8%8B/</guid>
         
         
         <category>教程</category>
@@ -617,8 +1062,8 @@ My Cluster is running on Cloudera Distri
 &lt;/ul&gt;
 </description>
         <pubDate>Fri, 17 Apr 2015 00:00:00 -0700</pubDate>
-        <link>http://kyli.io/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/</link>
-        <guid isPermaLink="true">http://kyli.io/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/</guid>
+        <link>http://kylin.incubator.apache.org/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/%E6%95%99%E7%A8%8B/2015/04/17/Kylin%E5%92%8CTableau%E6%95%99%E7%A8%8B/</guid>
         
         
         <category>教程</category>
@@ -750,8 +1195,8 @@ Click &lt;code&gt;Server&lt;/code&gt; in
 &lt;/ul&gt;
 </description>
         <pubDate>Fri, 17 Apr 2015 00:00:00 -0700</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>
+        <link>http://kylin.incubator.apache.org/tutorial/2015/04/17/Kylin-and-Tableau-Tutorial/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/tutorial/2015/04/17/Kylin-and-Tableau-Tutorial/</guid>
         
         
         <category>tutorial</category>
@@ -930,2071 +1375,13 @@ Login with username/password: ADMIN/KYLI
 &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 -0700</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>
+        <link>http://kylin.incubator.apache.org/tutorial/2015/04/17/Kylin-Web-Tutorial/</link>
+        <guid isPermaLink="true">http://kylin.incubator.apache.org/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;,

[... 1034 lines stripped ...]