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/09/06 09:59:56 UTC

[32/50] [abbrv] incubator-kylin git commit: KYLIN-956 hbase compression: gzip for test case and snappy for binary

KYLIN-956 hbase compression: gzip for test case and snappy for binary


Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/4e073775
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/4e073775
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/4e073775

Branch: refs/heads/0.7
Commit: 4e073775de6ae8b4bc864fe159ef2797458d1607
Parents: 0eb8383
Author: honma <ho...@ebay.com>
Authored: Tue Sep 1 17:59:46 2015 +0800
Committer: Luke Han <lu...@apache.org>
Committed: Sun Sep 6 14:37:59 2015 +0800

----------------------------------------------------------------------
 conf/kylin.properties                           |   2 +-
 conf/kylin_job_conf.xml                         |  58 ++-
 .../test_kylin_cube_with_slr_1_new_segment.json |  43 --
 .../cube/test_kylin_cube_with_slr_empty.json    |  10 -
 ...est_kylin_cube_with_slr_left_join_empty.json |  11 -
 ...est_kylin_cube_with_slr_left_join_ready.json |  43 --
 .../cube/test_kylin_cube_with_slr_ready.json    |  45 --
 ...st_kylin_cube_with_slr_ready_2_segments.json |  73 ----
 .../cube/test_kylin_cube_without_slr_empty.json |  10 -
 ..._kylin_cube_without_slr_left_join_empty.json |  11 -
 ..._kylin_cube_without_slr_left_join_ready.json |  43 --
 ..._without_slr_left_join_ready_2_segments.json |  73 ----
 .../cube/test_kylin_cube_without_slr_ready.json |  43 --
 .../test_kylin_cube_with_slr_desc.json          | 176 --------
 ...test_kylin_cube_with_slr_left_join_desc.json | 186 ---------
 .../test_kylin_cube_without_slr_desc.json       | 285 -------------
 ...t_kylin_cube_without_slr_left_join_desc.json | 283 -------------
 .../localmeta_v1/kylin.properties               |  77 ----
 .../localmeta_v1/project/default.json           |  12 -
 .../localmeta_v1/project/onlyinner.json         |   8 -
 .../localmeta_v1/project/onlyleft.json          |   8 -
 .../localmeta_v1/table/TEST_CAL_DT.json         | 407 -------------------
 .../table/TEST_CATEGORY_GROUPINGS.json          | 151 -------
 .../localmeta_v1/table/TEST_KYLIN_FACT.json     |  43 --
 .../table/TEST_SELLER_TYPE_DIM.json             |  43 --
 .../localmeta_v1/table/TEST_SITES.json          |  47 ---
 .../localmeta_v1/table_exd/TEST_KYLIN_FACT.json |  16 -
 .../sandbox-hdp21/capacity-scheduler.xml        | 112 -----
 .../test_case_data/sandbox-hdp21/core-site.xml  | 106 -----
 .../sandbox-hdp21/hadoop-policy.xml             | 219 ----------
 .../test_case_data/sandbox-hdp21/hbase-site.xml | 193 ---------
 .../test_case_data/sandbox-hdp21/hdfs-site.xml  | 188 ---------
 .../test_case_data/sandbox-hdp21/hive-site.xml  |  21 -
 .../sandbox-hdp21/httpfs-site.xml               |  17 -
 .../sandbox-hdp21/kylin.properties              |  84 ----
 .../kylin_job_conf.lzo_disabled.xml             |  74 ----
 .../kylin_job_conf.lzo_enabled.xml              |  74 ----
 .../sandbox-hdp21/kylin_job_conf.xml            |  74 ----
 .../sandbox-hdp21/mapred-site.xml               | 169 --------
 .../test_case_data/sandbox-hdp21/yarn-site.xml  | 160 --------
 .../test_case_data/sandbox/kylin.properties     |   3 +
 website/_docs/install/advance_settings.md       |   2 +-
 42 files changed, 32 insertions(+), 3671 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/conf/kylin.properties
----------------------------------------------------------------------
diff --git a/conf/kylin.properties b/conf/kylin.properties
index e61aa59..8c7c647 100644
--- a/conf/kylin.properties
+++ b/conf/kylin.properties
@@ -61,7 +61,7 @@ kylin.job.yarn.app.rest.check.interval.seconds=10
 kylin.job.hive.database.for.intermediatetable=default
 
 #default compression codec for htable,snappy,lzo,gzip,lz4
-#kylin.hbase.default.compression.codec=snappy
+kylin.hbase.default.compression.codec=snappy
 
 ## Config for Restful APP ##
 # database connection settings:

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/conf/kylin_job_conf.xml
----------------------------------------------------------------------
diff --git a/conf/kylin_job_conf.xml b/conf/kylin_job_conf.xml
index 81704f2..1b718a0 100644
--- a/conf/kylin_job_conf.xml
+++ b/conf/kylin_job_conf.xml
@@ -24,41 +24,37 @@ limitations under the License. See accompanying LICENSE file.
         </description>
     </property>
 
-    <!-- uncomment the following 5 properties to enable lzo compressing
-
-	<property>
-		<name>mapred.compress.map.output</name>
-		<value>true</value>
-		<description>Compress map outputs</description>
-	</property>
-
-	<property>
-		<name>mapred.map.output.compression.codec</name>
-		<value>com.hadoop.compression.lzo.LzoCodec</value>
-		<description>The compression codec to use for map outputs
-		</description>
-	</property>
+    <property>
+        <name>mapred.compress.map.output</name>
+        <value>true</value>
+        <description>Compress map outputs</description>
+    </property>
 
-	<property>
-		<name>mapred.output.compress</name>
-		<value>true</value>
-		<description>Compress the output of a MapReduce job</description>
-	</property>
+    <property>
+        <name>mapred.map.output.compression.codec</name>
+        <value>org.apache.hadoop.io.compress.SnappyCodec</value>
+        <description>The compression codec to use for map outputs
+        </description>
+    </property>
 
-	<property>
-		<name>mapred.output.compression.codec</name>
-		<value>com.hadoop.compression.lzo.LzoCodec</value>
-		<description>The compression codec to use for job outputs
-		</description>
-	</property>
+    <property>
+        <name>mapred.output.compress</name>
+        <value>true</value>
+        <description>Compress the output of a MapReduce job</description>
+    </property>
 
-	<property>
-		<name>mapred.output.compression.type</name>
-		<value>BLOCK</value>
-		<description>The compression type to use for job outputs</description>
-	</property>
+    <property>
+        <name>mapred.output.compression.codec</name>
+        <value>org.apache.hadoop.io.compress.SnappyCodec</value>
+        <description>The compression codec to use for job outputs
+        </description>
+    </property>
 
-	!-->
+    <property>
+        <name>mapred.output.compression.type</name>
+        <value>BLOCK</value>
+        <description>The compression type to use for job outputs</description>
+    </property>
 
     <property>
         <name>mapreduce.job.max.split.locations</name>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_1_new_segment.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_1_new_segment.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_1_new_segment.json
deleted file mode 100644
index 1f6865c..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_1_new_segment.json
+++ /dev/null
@@ -1,43 +0,0 @@
-{
-  "uuid" : "111ca32a-a33e-4b69-83dd-0bb8b1f8c53b",
-  "last_modified" : 1404098141020,
-  "name" : "test_kylin_cube_with_slr_1_new_segment",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_with_slr_desc",
-  "cost" : 50,
-  "segments" : [ {
-    "name" : "20130331080000_20131212080000",
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITH_SLR_READY-F24668F6-DCFF-4CB6-A89B-77F1119DF8FA",
-    "date_range_start" : 1364688000000,
-    "date_range_end" : 1386806400000,
-    "status" : "NEW",
-    "size_kb" : 0,
-    "source_records" : 0,
-    "source_records_size" : 0,
-    "last_build_time" : 0,
-    "last_build_job_id" : null,
-    "binary_signature" : null,
-    "dictionaries" : {
-	    "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/16d8185c-ee6b-4f8c-a919-756d9809f937.dict",
-	    "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/c6bf9b51-6e90-4337-8082-4e2fdf78307f.dict",
-	    "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/652bd393-678a-4f16-a504-fd8ce1229355.dict",
-	    "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-	    "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-	    "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/ad09f2d5-054a-4e1b-a776-7cc07399a6c1.dict",
-	    "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/ed0c3451-593c-494c-9019-64f63fcb0b8e.dict",
-	    "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/4243889f-bc81-4807-a975-7041bbbf35e7.dict",
-	    "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-	    "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/aceae914-4246-4251-a0c2-692fe7a300df.dict"
-	  },
-	 "snapshots" : {
-	    "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/4fe75ccd-9b24-4cdf-ac9d-b4038e947f89.snapshot",
-	    "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/8ff1339e-f804-47f3-b42c-1d4fa4ff0cf7.snapshot",
-	    "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/e172b442-ae10-447e-9071-c7dbb2bb38cc.snapshot",
-	    "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/28130338-fcf4-429e-91b0-cd8dfd397280.snapshot"
-	  }
-  } ],
-  "status" : "DISABLED",
-  "create_time" : null,
-  "notify_list" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_empty.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_empty.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_empty.json
deleted file mode 100644
index 70d89ea..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_empty.json
+++ /dev/null
@@ -1,10 +0,0 @@
-{
-  "uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8c53b",
-  "last_modified" : 0,
-  "name" : "test_kylin_cube_with_slr_empty",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_with_slr_desc",
-  "segments" : [ ],
-  "create_time" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_empty.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_empty.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_empty.json
deleted file mode 100644
index e708a86..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_empty.json
+++ /dev/null
@@ -1,11 +0,0 @@
-{
-  "uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8dddd",
-  "last_modified" : 0,
-  "name" : "test_kylin_cube_with_slr_left_join_empty",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_with_slr_left_join_desc",
-  "segments" : [ ],
-  "status" : "DISABLED",
-  "create_time" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_ready.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_ready.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_ready.json
deleted file mode 100644
index 90acf8d..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_left_join_ready.json
+++ /dev/null
@@ -1,43 +0,0 @@
-{
-  "uuid" : "kkkka32a-a33e-4b69-83dd-0bb8b1f8c53b",
-  "last_modified" : 1404097095621,
-  "name" : "test_kylin_cube_with_slr_left_join_ready",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_with_slr_left_join_desc",
-  "cost" : 50,
-  "segments" : [ {
-	"name" : null,
-	"storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITH_SLR_LEFT_JOIN_READY-BCF2F125-9B0B-40DD-9509-95EC59B31333",
-	"date_range_start" : null,
-	"date_range_end" : null,
-	"status" : "READY",
-	"size_kb" : 7690,
-	"source_records" : 10000,
-	"source_records_size" : 610288,
-	"last_build_time" : 1404097095455,
-	"last_build_job_id" : "bcf2f125-9b0b-40dd-9509-95ec59b31333",
-	"binary_signature" : null,
-      "dictionaries" : {
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/c12ae49d-9dbe-4a58-b169-19afac317696.dict",
-        "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/14fe66b3-5956-498c-bd93-40182cac5510.dict",
-        "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/0bec6bb3-1b0d-469c-8289-b8c4ca5d5001.dict",
-        "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-        "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/eacccee7-d120-4f4d-97d0-c99a5b83ec32.dict",
-        "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/ed0c3451-593c-494c-9019-64f63fcb0b8e.dict",
-        "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/8b4b1c06-fb74-486b-a2ad-74420afebcda.dict",
-        "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-        "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/c2af25cf-6c79-45e6-a6f6-6d2a8ecc6592.dict"
-      },
-      "snapshots" : {
-        "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/b43dd3f1-9a34-4721-8abc-df90962e94d8.snapshot",
-        "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/4af48c94-86de-4e22-a4fd-c49b06cbaa4f.snapshot",
-        "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/89715f33-15c9-4745-83f9-f2b9817d9100.snapshot",
-        "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/7d70b82e-43f6-4999-b012-0e91a9bb8408.snapshot"
-      }
-  } ],
-  "status" : "READY",
-  "create_time" : null,
-  "notify_list" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready.json
deleted file mode 100644
index 8b71f9b..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready.json
+++ /dev/null
@@ -1,45 +0,0 @@
-{
-  "uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8c53b",
-  "last_modified" : 1404098141020,
-  "name" : "test_kylin_cube_with_slr_ready",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_with_slr_desc",
-  "cost" : 50,
-  "segments" : [ {
-    "name" : "20130331080000_20131212080000",
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITH_SLR_READY-F24668F6-DCFF-4CB6-A89B-77F1119DF8FA",
-    "date_range_start" : 1364688000000,
-    "date_range_end" : 1386806400000,
-    "status" : "READY",
-    "size_kb" : 7801,
-    "source_records" : 10000,
-    "source_records_size" : 608012,
-    "last_build_time" : 1404098140902,
-    "last_build_job_id" : "f24668f6-dcff-4cb6-a89b-77f1119df8fa",
-    "binary_signature" : null,
-
-  "dictionaries" : {
-    "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/16d8185c-ee6b-4f8c-a919-756d9809f937.dict",
-    "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/c6bf9b51-6e90-4337-8082-4e2fdf78307f.dict",
-    "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/652bd393-678a-4f16-a504-fd8ce1229355.dict",
-    "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-    "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-    "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/ad09f2d5-054a-4e1b-a776-7cc07399a6c1.dict",
-    "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/ed0c3451-593c-494c-9019-64f63fcb0b8e.dict",
-    "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/4243889f-bc81-4807-a975-7041bbbf35e7.dict",
-    "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-    "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/aceae914-4246-4251-a0c2-692fe7a300df.dict"
-  },
-  "snapshots" : {
-    "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/4fe75ccd-9b24-4cdf-ac9d-b4038e947f89.snapshot",
-    "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/8ff1339e-f804-47f3-b42c-1d4fa4ff0cf7.snapshot",
-    "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/e172b442-ae10-447e-9071-c7dbb2bb38cc.snapshot",
-    "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/28130338-fcf4-429e-91b0-cd8dfd397280.snapshot"
-  }
-
-  } ],
-  "status" : "READY",
-  "create_time" : null,
-  "notify_list" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready_2_segments.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready_2_segments.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready_2_segments.json
deleted file mode 100644
index dba3bb2..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_with_slr_ready_2_segments.json
+++ /dev/null
@@ -1,73 +0,0 @@
-{
-  "uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8c53c",
-  "last_modified" : 1404098141020,
-  "name" : "test_kylin_cube_with_slr_ready_2_segments",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_with_slr_desc",
-  "cost" : 50,
-  "segments" : [ {
-    "name" : "19691231160000_20131112000000",
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITH_SLR_READY-F24668F6-DCFF-4CB6-A89B-77F1119DF8FA",
-    "date_range_start" : 1384240200000,
-    "date_range_end" : 1384243200000,
-    "status" : "READY",
-    "size_kb" : 7801,
-    "source_records" : 10000,
-    "source_records_size" : 608012,
-    "last_build_time" : 1404098140902,
-    "last_build_job_id" : "f24668f6-dcff-4cb6-a89b-77f1119df8fa",
-    "binary_signature" : null,
-      "dictionaries" : {
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/16d8185c-ee6b-4f8c-a919-756d9809f937.dict",
-        "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/c6bf9b51-6e90-4337-8082-4e2fdf78307f.dict",
-        "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/652bd393-678a-4f16-a504-fd8ce1229355.dict",
-        "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-        "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/ad09f2d5-054a-4e1b-a776-7cc07399a6c1.dict",
-        "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/ed0c3451-593c-494c-9019-64f63fcb0b8e.dict",
-        "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/4243889f-bc81-4807-a975-7041bbbf35e7.dict",
-        "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-        "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/aceae914-4246-4251-a0c2-692fe7a300df.dict"
-      },
-      "snapshots" : {
-        "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/4fe75ccd-9b24-4cdf-ac9d-b4038e947f89.snapshot",
-        "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/8ff1339e-f804-47f3-b42c-1d4fa4ff0cf7.snapshot",
-        "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/e172b442-ae10-447e-9071-c7dbb2bb38cc.snapshot",
-        "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/28130338-fcf4-429e-91b0-cd8dfd397280.snapshot"
-      }
-  }, {
-    "name" : "20131112000000_20131212000000",
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITH_SLR_READY-F24668F6-DCFF-4CB6-A89B-77F1119DF8FB",
-    "date_range_start" : 1384243200000,
-    "date_range_end" : 1386835200000,
-    "status" : "READY",
-    "size_kb" : 7801,
-    "source_records" : 10000,
-    "source_records_size" : 608012,
-    "last_build_time" : 1404098140902,
-    "last_build_job_id" : "f24668f6-dcff-4cb6-a89b-77f1119df8fb",
-    "binary_signature" : null,
-      "dictionaries" : {
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/16d8185c-ee6b-4f8c-a919-756d9809f937.dict",
-        "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/c6bf9b51-6e90-4337-8082-4e2fdf78307f.dict",
-        "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/652bd393-678a-4f16-a504-fd8ce1229355.dict",
-        "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-        "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/ad09f2d5-054a-4e1b-a776-7cc07399a6c1.dict",
-        "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/ed0c3451-593c-494c-9019-64f63fcb0b8e.dict",
-        "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/4243889f-bc81-4807-a975-7041bbbf35e7.dict",
-        "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-        "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/aceae914-4246-4251-a0c2-692fe7a300df.dict"
-      },
-      "snapshots" : {
-        "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/4fe75ccd-9b24-4cdf-ac9d-b4038e947f89.snapshot",
-        "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/8ff1339e-f804-47f3-b42c-1d4fa4ff0cf7.snapshot",
-        "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/e172b442-ae10-447e-9071-c7dbb2bb38cc.snapshot",
-        "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/28130338-fcf4-429e-91b0-cd8dfd397280.snapshot"
-      }
-  } ],
-  "status" : "READY",
-  "create_time" : null,
-  "notify_list" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_empty.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_empty.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_empty.json
deleted file mode 100644
index 6bd566a..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_empty.json
+++ /dev/null
@@ -1,10 +0,0 @@
-{
-  "uuid" : "daa53e80-41be-49a5-90ca-9fb7294db186",
-  "last_modified" : 0,
-  "name" : "test_kylin_cube_without_slr_empty",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_without_slr_desc",
-  "segments" : [ ],
-  "create_time" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_empty.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_empty.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_empty.json
deleted file mode 100644
index b4b5fd7..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_empty.json
+++ /dev/null
@@ -1,11 +0,0 @@
-{
-  "uuid" : "dddd3e80-41be-49a5-90ca-9fb7294db186",
-  "last_modified" : 0,
-  "name" : "test_kylin_cube_without_slr_left_join_empty",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_without_slr_left_join_desc",
-  "segments" : [ ],
-  "status" : "DISABLED",
-  "create_time" : null
-}

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready.json
deleted file mode 100644
index c84a0bd..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready.json
+++ /dev/null
@@ -1,43 +0,0 @@
-{
-  "uuid" : "mmmm3e80-41be-49a5-90ca-9fb7294db186",
-  "last_modified" : 1404097288087,
-  "name" : "test_kylin_cube_without_slr_left_join_ready",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_without_slr_left_join_desc",
-  "cost" : 10,
-  "segments" : [ {
-    "name" : null,
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITHOUT_SLR_LEFT_JOIN_READY-1EF30C45-17A4-4350-A032-A33B3B25E5B8",
-    "date_range_start" : null,
-    "date_range_end" : null,
-    "status" : "READY",
-    "size_kb" : 6060,
-    "source_records" : 10000,
-    "source_records_size" : 610288,
-    "last_build_time" : 1404097287905,
-    "last_build_job_id" : "1ef30c45-17a4-4350-a032-a33b3b25e5b8",
-    "binary_signature" : null,
-      "dictionaries" : {
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/eaed91b0-4182-4ee5-a733-1047a622ee29.dict",
-        "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/14fe66b3-5956-498c-bd93-40182cac5510.dict",
-        "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/0bec6bb3-1b0d-469c-8289-b8c4ca5d5001.dict",
-        "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-        "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/8f92faa4-7d2d-455c-8623-6e1d1b272afe.dict",
-        "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/aa634e3e-22d3-4cc2-9de5-085e9ac35c1f.dict",
-        "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/2602386c-debb-4968-8d2f-b52b8215e385.dict",
-        "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-        "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/0410d2c4-4686-40bc-ba14-170042a2de94.dict"
-      },
-      "snapshots" : {
-        "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/b43dd3f1-9a34-4721-8abc-df90962e94d8.snapshot",
-        "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/e5f004b5-0be1-4ccf-8950-20f8f86c1999.snapshot",
-        "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/89715f33-15c9-4745-83f9-f2b9817d9100.snapshot",
-        "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/7d70b82e-43f6-4999-b012-0e91a9bb8408.snapshot"
-      }
-  } ],
-  "status" : "READY",
-  "create_time" : null,
-  "notify_list" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready_2_segments.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready_2_segments.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready_2_segments.json
deleted file mode 100644
index 4d64bcd..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_left_join_ready_2_segments.json
+++ /dev/null
@@ -1,73 +0,0 @@
-{
-  "uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8c5ff",
-  "last_modified" : 1404098141020,
-  "name" : "test_kylin_cube_without_slr_left_join_ready_2_segments",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_without_slr_left_join_desc",
-  "cost" : 50,
-  "segments" : [ {
-    "name" : "19691231160000_20131112000000",
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITH_SLR_READY-F24668F6-DCFF-4CB6-A89B-77F1119DF8FA",
-    "date_range_start" : 0,
-    "date_range_end" : 1384243200000,
-    "status" : "READY",
-    "size_kb" : 7801,
-    "source_records" : 10000,
-    "source_records_size" : 608012,
-    "last_build_time" : 1404098140902,
-    "last_build_job_id" : "f24668f6-dcff-4cb6-a89b-77f1119df8fa",
-    "binary_signature" : null,
-      "dictionaries" : {
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/16d8185c-ee6b-4f8c-a919-756d9809f937.dict",
-        "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/c6bf9b51-6e90-4337-8082-4e2fdf78307f.dict",
-        "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/652bd393-678a-4f16-a504-fd8ce1229355.dict",
-        "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-        "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/ad09f2d5-054a-4e1b-a776-7cc07399a6c1.dict",
-        "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/ed0c3451-593c-494c-9019-64f63fcb0b8e.dict",
-        "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/4243889f-bc81-4807-a975-7041bbbf35e7.dict",
-        "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-        "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/aceae914-4246-4251-a0c2-692fe7a300df.dict"
-      },
-      "snapshots" : {
-        "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/4fe75ccd-9b24-4cdf-ac9d-b4038e947f89.snapshot",
-        "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/8ff1339e-f804-47f3-b42c-1d4fa4ff0cf7.snapshot",
-        "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/e172b442-ae10-447e-9071-c7dbb2bb38cc.snapshot",
-        "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/28130338-fcf4-429e-91b0-cd8dfd397280.snapshot"
-      }
-  }, {
-    "name" : "20131112000000_20131212000000",
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITH_SLR_READY-F24668F6-DCFF-4CB6-A89B-77F1119DF8FB",
-    "date_range_start" : 1384243200000,
-    "date_range_end" : 1386835200000,
-    "status" : "READY",
-    "size_kb" : 7801,
-    "source_records" : 10000,
-    "source_records_size" : 608012,
-    "last_build_time" : 1404098140902,
-    "last_build_job_id" : "f24668f6-dcff-4cb6-a89b-77f1119df8fb",
-    "binary_signature" : null,
-      "dictionaries" : {
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/16d8185c-ee6b-4f8c-a919-756d9809f937.dict",
-        "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/c6bf9b51-6e90-4337-8082-4e2fdf78307f.dict",
-        "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/652bd393-678a-4f16-a504-fd8ce1229355.dict",
-        "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-        "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/ad09f2d5-054a-4e1b-a776-7cc07399a6c1.dict",
-        "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/ed0c3451-593c-494c-9019-64f63fcb0b8e.dict",
-        "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/4243889f-bc81-4807-a975-7041bbbf35e7.dict",
-        "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-        "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/aceae914-4246-4251-a0c2-692fe7a300df.dict"
-      },
-      "snapshots" : {
-        "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/4fe75ccd-9b24-4cdf-ac9d-b4038e947f89.snapshot",
-        "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/8ff1339e-f804-47f3-b42c-1d4fa4ff0cf7.snapshot",
-        "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/e172b442-ae10-447e-9071-c7dbb2bb38cc.snapshot",
-        "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/28130338-fcf4-429e-91b0-cd8dfd397280.snapshot"
-      }
-  } ],
-  "status" : "READY",
-  "create_time" : null,
-  "notify_list" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_ready.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_ready.json b/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_ready.json
deleted file mode 100644
index ec88d1a..0000000
--- a/examples/test_case_data/localmeta_v1/cube/test_kylin_cube_without_slr_ready.json
+++ /dev/null
@@ -1,43 +0,0 @@
-{
-  "uuid" : "daa53e80-41be-49a5-90ca-9fb7294db186",
-  "last_modified" : 1404098303976,
-  "name" : "test_kylin_cube_without_slr_ready",
-  "owner" : null,
-  "version" : null,
-  "descriptor" : "test_kylin_cube_without_slr_desc",
-  "cost" : 10,
-  "segments" : [ {
-    "name" : null,
-    "storage_location_identifier" : "KYLIN-CUBE-TEST_KYLIN_CUBE_WITHOUT_SLR_READY-619D9B4A-DA56-48CA-9C58-29DC8323B200",
-    "date_range_start" : null,
-    "date_range_end" : null,
-    "status" : "READY",
-    "size_kb" : 5600,
-    "source_records" : 10000,
-    "source_records_size" : 608012,
-    "last_build_time" : 1404098303829,
-    "last_build_job_id" : "619d9b4a-da56-48ca-9c58-29dc8323b200",
-    "binary_signature" : null,
-      "dictionaries" : {
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL2_NAME/16d8185c-ee6b-4f8c-a919-756d9809f937.dict",
-        "TEST_KYLIN_FACT/SLR_SEGMENT_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/c6bf9b51-6e90-4337-8082-4e2fdf78307f.dict",
-        "TEST_KYLIN_FACT/LSTG_SITE_ID" : "/dict/TEST_SITES/SITE_ID/652bd393-678a-4f16-a504-fd8ce1229355.dict",
-        "TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD" : "/dict/TEST_SELLER_TYPE_DIM/SELLER_TYPE_CD/2a44ff38-f64b-42e7-9fcf-66afccac8047.dict",
-        "TEST_KYLIN_FACT/CAL_DT" : "/dict/PREDEFINED/date(yyyy-mm-dd)/64ac4f82-f2af-476e-85b9-f0805001014e.dict",
-        "TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/CATEG_LVL3_NAME/ad09f2d5-054a-4e1b-a776-7cc07399a6c1.dict",
-        "TEST_CAL_DT/CAL_DT" : "/dict/TEST_CAL_DT/CAL_DT/aa634e3e-22d3-4cc2-9de5-085e9ac35c1f.dict",
-        "TEST_KYLIN_FACT/LEAF_CATEG_ID" : "/dict/TEST_CATEGORY_GROUPINGS/LEAF_CATEG_ID/494683c1-52d1-4d9a-a3f7-8c53b30fd898.dict",
-        "TEST_SITES/SITE_ID" : "/dict/TEST_SITES/SITE_ID/ff7e8943-ac0f-4e66-b9ed-510f6a0b875d.dict",
-        "TEST_CATEGORY_GROUPINGS/META_CATEG_NAME" : "/dict/TEST_CATEGORY_GROUPINGS/META_CATEG_NAME/b298089f-9656-4693-b9b2-8fea46f06dd5.dict"
-      },
-      "snapshots" : {
-        "TEST_SELLER_TYPE_DIM" : "/table_snapshot/TEST_SELLER_TYPE_DIM.csv/4fe75ccd-9b24-4cdf-ac9d-b4038e947f89.snapshot",
-        "TEST_CAL_DT" : "/table_snapshot/TEST_CAL_DT.csv/9a1fbc0d-8790-4f32-99e1-7c60a9d124d4.snapshot",
-        "TEST_CATEGORY_GROUPINGS" : "/table_snapshot/TEST_CATEGORY_GROUPINGS.csv/e172b442-ae10-447e-9071-c7dbb2bb38cc.snapshot",
-        "TEST_SITES" : "/table_snapshot/TEST_SITES.csv/28130338-fcf4-429e-91b0-cd8dfd397280.snapshot"
-      }
-  } ],
-  "status" : "READY",
-  "create_time" : null,
-  "notify_list" : null
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_desc.json b/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_desc.json
deleted file mode 100644
index e7f8d79..0000000
--- a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_desc.json
+++ /dev/null
@@ -1,176 +0,0 @@
-{
-  "uuid": "a24ca905-1fc6-4f67-985c-38fa5aeafd92",
-  "name": "test_kylin_cube_with_slr_desc",
-  "fact_table": "test_kylin_fact",
-  "filter_condition": null,
-  "cube_partition_desc": {
-    "partition_date_column": "test_kylin_fact.cal_dt",
-    "partition_date_start": 0,
-    "cube_partition_type": "APPEND"
-  },
-  "dimensions": [
-    {
-      "id": "1",
-      "name": "cal_dt",
-      "datatype": "date",
-      "table": "test_cal_dt",
-      "column": "{FK}",
-      "derived": ["week_beg_dt"],
-      "join": {
-        "type": "inner",
-        "primary_key": ["cal_dt"],
-        "foreign_key": ["cal_dt"]
-      }
-    },
-    {
-      "id": "2",
-      "name": "category",
-      "table": "test_category_groupings",
-      "column": "{FK}",
-      "derived": ["USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER"],
-      "join": {
-        "type": "inner",
-        "primary_key": ["leaf_categ_id", "site_id"],
-        "foreign_key": ["leaf_categ_id", "lstg_site_id"]
-      },
-      "hierarchy": [
-        {
-          "level": "1",
-          "column": "meta_categ_name"
-        },
-        {
-          "level": "2",
-          "column": "categ_lvl2_name"
-        },
-        {
-          "level": "3",
-          "column": "categ_lvl3_name"
-        }
-      ]
-    },
-    {
-      "id": "3",
-      "name": "lstg_format_name",
-      "datatype": "string",
-      "table": "test_kylin_fact",
-      "column": "lstg_format_name"
-    },
-    {
-      "id": "4",
-      "name": "site_id",
-      "datatype": "string",
-      "table": "test_sites",
-      "column": "{FK}",
-      "derived": ["site_name", "cre_user"],
-      "join": {
-        "type": "inner",
-        "primary_key": ["site_id"],
-        "foreign_key": ["lstg_site_id"]
-      }
-    },
-    {
-      "id": "5",
-      "name": "seller_type_cd",
-      "datatype": "string",
-      "table": "test_seller_type_dim",
-      "column": "{FK}",
-      "derived": ["seller_type_desc"],
-      "join": {
-        "type": "inner",
-        "primary_key": ["seller_type_cd"],
-        "foreign_key": ["slr_segment_cd"]
-      }
-    },
-    {
-      "id": "6",
-      "name": "seller_id",
-      "datatype": "string",
-      "table": "test_kylin_fact",
-      "column": "seller_id"
-    }
-  ],
-  "measures": [
-    {
-      "id": "1",
-      "name": "gmv_sum",
-      "function": {
-        "expression": "sum",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "2",
-      "name": "gmv_min",
-      "function": {
-        "expression": "min",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "3",
-      "name": "gmv_max",
-      "function": {
-        "expression": "max",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "4",
-      "name": "trans_cnt",
-      "function": {
-        "expression": "count",
-        "returntype": "bigint",
-        "parameter": {
-          "type": "constant",
-          "value": "1"
-        }
-      }
-    }
-  ],
-  "rowkey":{
-    "rowkey_columns": [
-      { "column": "seller_id",        "length": 18,  "mandatory": "true" },
-      { "column": "cal_dt",           "dictionary": "date(yyyy-mm-dd)" },
-      { "column": "leaf_categ_id",    "dictionary": "string" },
-      { "column": "meta_categ_name",  "dictionary": "string" },
-      { "column": "categ_lvl2_name",  "dictionary": "string" },
-      { "column": "categ_lvl3_name",  "dictionary": "string" },
-      { "column": "lstg_format_name", "length": 12  },
-      { "column": "lstg_site_id",     "dictionary": "string" },
-      { "column": "slr_segment_cd",   "dictionary": "string" }
-    ],
-	"aggregation_groups": [
-	  ["leaf_categ_id","meta_categ_name","categ_lvl2_name","categ_lvl3_name","cal_dt"]
-	]
-  },
-  "hbase_mapping": {
-    "column_family": [
-      {
-        "name": "f1",
-        "columns": [
-          {
-            "qualifier": "m",
-            "measure_refs": [
-              "gmv_sum",
-              "gmv_min",
-              "gmv_max",
-              "trans_cnt"
-            ]
-          }
-        ]
-      }
-    ]
-  }
-}

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_left_join_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_left_join_desc.json b/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_left_join_desc.json
deleted file mode 100644
index 74f3996..0000000
--- a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_with_slr_left_join_desc.json
+++ /dev/null
@@ -1,186 +0,0 @@
-{
-  "uuid": "bbbba905-1fc6-4f67-985c-38fa5aeafd92",
-  "name": "test_kylin_cube_with_slr_left_join_desc",
-  "fact_table": "test_kylin_fact",
-  "cube_partition_desc": {
-    "partition_date_column": "test_kylin_fact.cal_dt",
-    "partition_date_start": 0,
-    "cube_partition_type": "APPEND"
-  },
-  "filter_condition": null,
-  "dimensions": [
-    {
-      "id": "1",
-      "name": "cal_dt",
-      "datatype": "date",
-      "table": "test_cal_dt",
-      "column": "{FK}",
-      "derived": ["week_beg_dt"],
-      "join": {
-        "type": "left",
-        "primary_key": ["cal_dt"],
-        "foreign_key": ["cal_dt"]
-      }
-    },
-    {
-      "id": "2",
-      "name": "category",
-      "table": "test_category_groupings",
-      "join": {
-        "type": "left",
-        "primary_key": ["leaf_categ_id", "site_id"],
-        "foreign_key": ["leaf_categ_id", "lstg_site_id"]
-      },
-      "hierarchy": [
-        {
-          "level": "1",
-          "column": "meta_categ_name"
-        },
-        {
-          "level": "2",
-          "column": "categ_lvl2_name"
-        },
-        {
-          "level": "3",
-          "column": "categ_lvl3_name"
-        }
-      ]
-    },
-    {
-      "id": "3",
-      "name": "category_derived",
-      "table": "test_category_groupings",
-      "column": "{FK}",
-      "derived": ["USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER"],
-      "join": {
-        "type": "left",
-        "primary_key": ["leaf_categ_id", "site_id"],
-        "foreign_key": ["leaf_categ_id", "lstg_site_id"]
-      }
-    },
-    {
-      "id": "4",
-      "name": "lstg_format_name",
-      "datatype": "string",
-      "table": "test_kylin_fact",
-      "column": "lstg_format_name"
-    },
-    {
-      "id": "5",
-      "name": "site_id",
-      "datatype": "string",
-      "table": "test_sites",
-      "column": "{FK}",
-      "derived": ["site_name", "cre_user"],
-      "join": {
-        "type": "left",
-        "primary_key": ["site_id"],
-        "foreign_key": ["lstg_site_id"]
-      }
-    },
-    {
-      "id": "6",
-      "name": "seller_type_cd",
-      "datatype": "string",
-      "table": "test_seller_type_dim",
-      "column": "{FK}",
-      "derived": ["seller_type_desc"],
-      "join": {
-        "type": "left",
-        "primary_key": ["seller_type_cd"],
-        "foreign_key": ["slr_segment_cd"]
-      }
-    },
-    {
-      "id": "7",
-      "name": "seller_id",
-      "datatype": "string",
-      "table": "test_kylin_fact",
-      "column": "seller_id"
-    }
-  ],
-  "measures": [
-    {
-      "id": "1",
-      "name": "gmv_sum",
-      "function": {
-        "expression": "sum",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "2",
-      "name": "gmv_min",
-      "function": {
-        "expression": "min",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "3",
-      "name": "gmv_max",
-      "function": {
-        "expression": "max",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "4",
-      "name": "trans_cnt",
-      "function": {
-        "expression": "count",
-        "returntype": "bigint",
-        "parameter": {
-          "type": "constant",
-          "value": "1"
-        }
-      }
-    }
-  ],
-  "rowkey":{
-    "rowkey_columns": [
-      { "column": "seller_id",        "length": 18,  "mandatory": "true" },
-      { "column": "cal_dt",           "dictionary": "date(yyyy-mm-dd)" },
-      { "column": "leaf_categ_id",    "dictionary": "string" },
-      { "column": "meta_categ_name",  "dictionary": "string" },
-      { "column": "categ_lvl2_name",  "dictionary": "string" },
-      { "column": "categ_lvl3_name",  "dictionary": "string" },
-      { "column": "lstg_format_name",  "length": 12  },
-      { "column": "lstg_site_id",     "dictionary": "string" },
-      { "column": "slr_segment_cd",   "dictionary": "string" }
-    ],
-	"aggregation_groups": [
-	  ["leaf_categ_id","meta_categ_name","categ_lvl2_name","categ_lvl3_name","cal_dt"]
-	]
-  },
-  "hbase_mapping": {
-    "column_family": [
-      {
-        "name": "f1",
-        "columns": [
-          {
-            "qualifier": "m",
-            "measure_refs": [
-              "gmv_sum",
-              "gmv_min",
-              "gmv_max",
-              "trans_cnt"
-            ]
-          }
-        ]
-      }
-    ]
-  }
-}

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_desc.json b/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_desc.json
deleted file mode 100644
index 4814020..0000000
--- a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_desc.json
+++ /dev/null
@@ -1,285 +0,0 @@
-{
-  "uuid": "9ac9b7a8-3929-4dff-b59d-2100aadc8dbf",
-  "name": "test_kylin_cube_without_slr_desc",
-  "capacity": "SMALL",
-  "fact_table": "test_kylin_fact",
-  "cube_partition_desc": {
-    "partition_date_column": null,
-    "partition_date_start": null,
-    "cube_partition_type": "APPEND"
-  },
-  "filter_condition": null,
-  "dimensions": [
-    {
-      "id": "1",
-      "name": "cal_dt",
-      "datatype": "date",
-      "table": "test_cal_dt",
-      "column": "{FK}",
-      "derived": [
-        "week_beg_dt"
-      ],
-      "join": {
-        "type": "inner",
-        "primary_key": [
-          "cal_dt"
-        ],
-        "foreign_key": [
-          "cal_dt"
-        ]
-      }
-    },
-    {
-      "id": "2",
-      "name": "category",
-      "table": "test_category_groupings",
-      "column": "{FK}",
-      "derived": [
-        "USER_DEFINED_FIELD1",
-        "USER_DEFINED_FIELD3",
-        "UPD_DATE",
-        "UPD_USER"
-      ],
-      "join": {
-        "type": "inner",
-        "primary_key": [
-          "leaf_categ_id",
-          "site_id"
-        ],
-        "foreign_key": [
-          "leaf_categ_id",
-          "lstg_site_id"
-        ]
-      },
-      "hierarchy": [
-        {
-          "level": "1",
-          "column": "meta_categ_name"
-        },
-        {
-          "level": "2",
-          "column": "categ_lvl2_name"
-        },
-        {
-          "level": "3",
-          "column": "categ_lvl3_name"
-        }
-      ]
-    },
-    {
-      "id": "3",
-      "name": "lstg_format_name",
-      "datatype": "string",
-      "table": "test_kylin_fact",
-      "column": "lstg_format_name"
-    },
-    {
-      "id": "4",
-      "name": "site_id",
-      "datatype": "string",
-      "table": "test_sites",
-      "column": "{FK}",
-      "derived": [
-        "site_name",
-        "cre_user"
-      ],
-      "join": {
-        "type": "inner",
-        "primary_key": [
-          "site_id"
-        ],
-        "foreign_key": [
-          "lstg_site_id"
-        ]
-      }
-    },
-    {
-      "id": "5",
-      "name": "seller_type_cd",
-      "datatype": "string",
-      "table": "test_seller_type_dim",
-      "column": "{FK}",
-      "derived": [
-        "seller_type_desc"
-      ],
-      "join": {
-        "type": "inner",
-        "primary_key": [
-          "seller_type_cd"
-        ],
-        "foreign_key": [
-          "slr_segment_cd"
-        ]
-      }
-    }
-  ],
-  "measures": [
-    {
-      "id": "1",
-      "name": "gmv_sum",
-      "function": {
-        "expression": "sum",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "2",
-      "name": "gmv_min",
-      "function": {
-        "expression": "min",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "3",
-      "name": "gmv_max",
-      "function": {
-        "expression": "max",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "4",
-      "name": "trans_cnt",
-      "function": {
-        "expression": "count",
-        "returntype": "bigint",
-        "parameter": {
-          "type": "constant",
-          "value": "1"
-        }
-      }
-    },
-    {
-      "id": "5",
-      "name": "seller_cnt_hll",
-      "function": {
-        "expression": "count_distinct",
-        "returntype": "hllc(10)",
-        "parameter": {
-          "type": "column",
-          "value": "seller_id"
-        }
-      }
-    },
-    {
-      "id": "6",
-      "name": "seller_cnt_long",
-      "function": {
-        "expression": "count_distinct",
-        "returntype": "bigint",
-        "parameter": {
-          "type": "column",
-          "value": "seller_id"
-        }
-      },
-      "dependent_measure_ref" : "seller_cnt_hll"
-    },
-    {
-      "id": "7",
-      "name": "seller_format_cnt",
-      "function": {
-        "expression": "count_distinct",
-        "returntype": "hllc(10)",
-        "parameter": {
-          "type": "column",
-          "value": "seller_id, lstg_format_name"
-        }
-      }
-    }
-  ],
-  "rowkey": {
-    "rowkey_columns": [
-      {
-        "column": "cal_dt",
-        "dictionary": "date(yyyy-mm-dd)",
-        "mandatory": "true"
-      },
-      {
-        "column": "leaf_categ_id",
-        "dictionary": "string"
-      },
-      {
-        "column": "meta_categ_name",
-        "dictionary": "string"
-      },
-      {
-        "column": "categ_lvl2_name",
-        "dictionary": "string"
-      },
-      {
-        "column": "categ_lvl3_name",
-        "dictionary": "string"
-      },
-      {
-        "column": "lstg_format_name",
-        "length": 12
-      },
-      {
-        "column": "lstg_site_id",
-        "dictionary": "string"
-      },
-      {
-        "column": "slr_segment_cd",
-        "dictionary": "string"
-      }
-    ],
-    "aggregation_groups": [
-      [
-        "lstg_format_name",
-        "lstg_site_id",
-        "slr_segment_cd"
-      ],
-      [
-        "leaf_categ_id",
-        "meta_categ_name",
-        "categ_lvl3_name",
-        "categ_lvl2_name",
-        "lstg_format_name"
-      ]
-    ]
-  },
-  "hbase_mapping": {
-    "column_family": [
-      {
-        "name": "f1",
-        "columns": [
-          {
-            "qualifier": "m",
-            "measure_refs": [
-              "gmv_sum",
-              "gmv_min",
-              "gmv_max",
-              "trans_cnt",
-              "seller_cnt_long"
-            ]
-          }
-        ]
-      },
-      {
-        "name": "f2",
-        "columns": [
-          {
-            "qualifier": "m",
-            "measure_refs": [
-                "seller_cnt_hll",
-                "seller_format_cnt"
-            ]
-          }
-        ]
-      }
-    ]
-  }
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_left_join_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_left_join_desc.json b/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_left_join_desc.json
deleted file mode 100644
index b7c275b..0000000
--- a/examples/test_case_data/localmeta_v1/cube_desc/test_kylin_cube_without_slr_left_join_desc.json
+++ /dev/null
@@ -1,283 +0,0 @@
-{
-  "uuid": "9ac9b7a8-3929-4dff-b59d-2100aadc8dbf",
-  "name": "test_kylin_cube_without_slr_left_join_desc",
-  "fact_table": "test_kylin_fact",
-  "cube_partition_desc": {
-    "partition_date_column": "test_kylin_fact.cal_dt",
-    "partition_date_start": 0,
-    "cube_partition_type": "UPDATE_INSERT"
-  },
-  "dimensions": [
-    {
-      "id": "1",
-      "name": "cal_dt",
-      "datatype": "date",
-      "table": "test_cal_dt",
-      "column": "{FK}",
-      "derived": [
-        "week_beg_dt"
-      ],
-      "join": {
-        "type": "left",
-        "primary_key": [
-          "cal_dt"
-        ],
-        "foreign_key": [
-          "cal_dt"
-        ]
-      }
-    },
-    {
-      "id": "2",
-      "name": "category",
-      "table": "test_category_groupings",
-      "column": "{FK}",
-      "derived": [
-        "USER_DEFINED_FIELD1",
-        "USER_DEFINED_FIELD3",
-        "UPD_DATE",
-        "UPD_USER"
-      ],
-      "join": {
-        "type": "left",
-        "primary_key": [
-          "leaf_categ_id",
-          "site_id"
-        ],
-        "foreign_key": [
-          "leaf_categ_id",
-          "lstg_site_id"
-        ]
-      },
-      "hierarchy": [
-        {
-          "level": "1",
-          "column": "meta_categ_name"
-        },
-        {
-          "level": "2",
-          "column": "categ_lvl2_name"
-        },
-        {
-          "level": "3",
-          "column": "categ_lvl3_name"
-        }
-      ]
-    },
-    {
-      "id": "3",
-      "name": "lstg_format_name",
-      "datatype": "string",
-      "table": "test_kylin_fact",
-      "column": "lstg_format_name"
-    },
-    {
-      "id": "4",
-      "name": "site_id",
-      "datatype": "string",
-      "table": "test_sites",
-      "column": "{FK}",
-      "derived": [
-        "site_name",
-        "cre_user"
-      ],
-      "join": {
-        "type": "left",
-        "primary_key": [
-          "site_id"
-        ],
-        "foreign_key": [
-          "lstg_site_id"
-        ]
-      }
-    },
-    {
-      "id": "5",
-      "name": "seller_type_cd",
-      "datatype": "string",
-      "table": "test_seller_type_dim",
-      "column": "{FK}",
-      "derived": [
-        "seller_type_desc"
-      ],
-      "join": {
-        "type": "left",
-        "primary_key": [
-          "seller_type_cd"
-        ],
-        "foreign_key": [
-          "slr_segment_cd"
-        ]
-      }
-    }
-  ],
-  "measures": [
-    {
-      "id": "1",
-      "name": "gmv_sum",
-      "function": {
-        "expression": "sum",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "2",
-      "name": "gmv_min",
-      "function": {
-        "expression": "min",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "3",
-      "name": "gmv_max",
-      "function": {
-        "expression": "max",
-        "returntype": "decimal",
-        "parameter": {
-          "type": "column",
-          "value": "price"
-        }
-      }
-    },
-    {
-      "id": "4",
-      "name": "trans_cnt",
-      "function": {
-        "expression": "count",
-        "returntype": "bigint",
-        "parameter": {
-          "type": "constant",
-          "value": "1"
-        }
-      }
-    },
-    {
-      "id": "5",
-      "name": "seller_cnt_hll",
-      "function": {
-        "expression": "count_distinct",
-        "returntype": "hllc(10)",
-        "parameter": {
-          "type": "column",
-          "value": "seller_id"
-        }
-      }
-    },
-    {
-      "id": "6",
-      "name": "seller_cnt_long",
-      "function": {
-        "expression": "count_distinct",
-        "returntype": "bigint",
-        "parameter": {
-          "type": "column",
-          "value": "seller_id"
-        }
-      },
-      "dependent_measure_ref" : "seller_cnt_hll"
-    },
-    {
-      "id": "7",
-      "name": "seller_format_cnt",
-      "function": {
-        "expression": "count_distinct",
-        "returntype": "hllc(10)",
-        "parameter": {
-          "type": "column",
-          "value": "seller_id, lstg_format_name"
-        }
-      }
-    }
-  ],
-  "rowkey": {
-    "rowkey_columns": [
-      {
-        "column": "cal_dt",
-        "dictionary": "date(yyyy-mm-dd)",
-        "mandatory": "true"
-      },
-      {
-        "column": "leaf_categ_id",
-        "dictionary": "string"
-      },
-      {
-        "column": "meta_categ_name",
-        "dictionary": "string"
-      },
-      {
-        "column": "categ_lvl2_name",
-        "dictionary": "string"
-      },
-      {
-        "column": "categ_lvl3_name",
-        "dictionary": "string"
-      },
-      {
-        "column": "lstg_format_name",
-        "dictionary": "string"
-      },
-      {
-        "column": "lstg_site_id",
-        "dictionary": "string"
-      },
-      {
-        "column": "slr_segment_cd",
-        "dictionary": "string"
-      }
-    ],
-    "aggregation_groups": [
-      [
-        "lstg_format_name",
-        "lstg_site_id",
-        "slr_segment_cd"
-      ],
-      [
-        "leaf_categ_id",
-        "meta_categ_name",
-        "categ_lvl3_name",
-        "categ_lvl2_name",
-        "lstg_format_name"
-      ]
-    ]
-  },
-  "hbase_mapping": {
-    "column_family": [
-      {
-        "name": "f1",
-        "columns": [
-          {
-            "qualifier": "m",
-            "measure_refs": [
-              "gmv_sum",
-              "gmv_min",
-              "gmv_max",
-              "trans_cnt",
-              "seller_cnt_long"
-            ]
-          }
-        ]
-      },
-      {
-        "name": "f2",
-        "columns": [
-          {
-            "qualifier": "m",
-            "measure_refs": [
-              "seller_cnt_hll",
-              "seller_format_cnt"
-             ]
-          }
-        ]
-      }
-    ]
-  }
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/kylin.properties
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/kylin.properties b/examples/test_case_data/localmeta_v1/kylin.properties
deleted file mode 100644
index ff9ece4..0000000
--- a/examples/test_case_data/localmeta_v1/kylin.properties
+++ /dev/null
@@ -1,77 +0,0 @@
-#
-# Licensed to the Apache Software Foundation (ASF) under one or more
-# contributor license agreements.  See the NOTICE file distributed with
-# this work for additional information regarding copyright ownership.
-# The ASF licenses this file to You under the Apache License, Version 2.0
-# (the "License"); you may not use this file except in compliance with
-# the License.  You may obtain a copy of the License at
-#
-#    http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing, software
-# distributed under the License is distributed on an "AS IS" BASIS,
-# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-# See the License for the specific language governing permissions and
-# limitations under the License.
-#
-
-## Config for Kylin Engine ##
-
-# List of web servers in use, this enables one web server instance to sync up with other servers.
-kylin.rest.servers=localhost:7070
-
-# The metadata store in hbase
-kylin.metadata.url=
-
-# The storage for final cube file in hbase
-kylin.storage.url=hbase:sandbox.hortonworks.com:2181:/hbase-unsecure
-
-# Temp folder in hdfs, make sure user has the right access to the hdfs directory
-kylin.hdfs.working.dir=/kylin
-
-kylin.job.mapreduce.default.reduce.input.mb=500
-
-# If true, job engine will not assume that hadoop CLI reside on the same server as it self
-# you will have to specify kylin.job.remote.cli.hostname, kylin.job.remote.cli.username and kylin.job.remote.cli.password
-kylin.job.run.as.remote.cmd=false
-
-# Only necessary when kylin.job.run.as.remote.cmd=true
-kylin.job.remote.cli.hostname=
-
-# Only necessary when kylin.job.run.as.remote.cmd=true
-kylin.job.remote.cli.username=
-
-# Only necessary when kylin.job.run.as.remote.cmd=true
-kylin.job.remote.cli.password=
-
-# Used by test cases to prepare synthetic data for sample cube
-kylin.job.remote.cli.working.dir=/tmp/kylin
-
-# Max count of concurrent jobs running
-kylin.job.concurrent.max.limit=10
-
-# Time interval to check hadoop job status
-kylin.job.yarn.app.rest.check.interval.seconds=10
-
-
-
-## Config for Restful APP ##
-# database connection settings:
-ldap.server=
-ldap.username=
-ldap.password=
-ldap.user.searchBase=
-ldap.user.searchPattern=
-ldap.user.groupSearchBase=
-ldap.service.searchBase=OU=
-ldap.service.searchPattern=
-ldap.service.groupSearchBase=
-acl.adminRole=
-acl.defaultRole=
-ganglia.group=
-ganglia.port=8664
-
-###########################config info for sandbox#######################
-kylin.sandbox=true
-
-

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/project/default.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/project/default.json b/examples/test_case_data/localmeta_v1/project/default.json
deleted file mode 100644
index a164af2..0000000
--- a/examples/test_case_data/localmeta_v1/project/default.json
+++ /dev/null
@@ -1,12 +0,0 @@
-{
-"uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8c91b",
-  "name": "default",
-  "cubes": [
-    "test_kylin_cube_with_slr_empty",
-    "test_kylin_cube_without_slr_empty",
-    "test_kylin_cube_with_slr_left_join_empty",
-    "test_kylin_cube_without_slr_left_join_empty"
-  ],
-    "last_modified" : 1418290489904,
-  "create_time" : "2014-10-22 23:06:27 PDT"
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/project/onlyinner.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/project/onlyinner.json b/examples/test_case_data/localmeta_v1/project/onlyinner.json
deleted file mode 100644
index 9544895..0000000
--- a/examples/test_case_data/localmeta_v1/project/onlyinner.json
+++ /dev/null
@@ -1,8 +0,0 @@
-{
-"uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8c92b",
-  "name": "onlyinner",
-  "cubes": [
-    "test_kylin_cube_with_slr_empty",
-    "test_kylin_cube_without_slr_empty"
-  ]
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/project/onlyleft.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/project/onlyleft.json b/examples/test_case_data/localmeta_v1/project/onlyleft.json
deleted file mode 100644
index 13e57ed..0000000
--- a/examples/test_case_data/localmeta_v1/project/onlyleft.json
+++ /dev/null
@@ -1,8 +0,0 @@
-{
-"uuid" : "1eaca32a-a33e-4b69-83dd-0bb8b1f8c93b",
-  "name": "onlyleft",
-  "cubes": [
-    "test_kylin_cube_with_slr_left_join_empty",
-    "test_kylin_cube_without_slr_left_join_empty"
-  ]
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/table/TEST_CAL_DT.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/table/TEST_CAL_DT.json b/examples/test_case_data/localmeta_v1/table/TEST_CAL_DT.json
deleted file mode 100644
index 0ad7ee1..0000000
--- a/examples/test_case_data/localmeta_v1/table/TEST_CAL_DT.json
+++ /dev/null
@@ -1,407 +0,0 @@
-{
-  "uuid" : "0ff420eb-79ad-40bd-bca9-12d8cd05c60a",
-  "name" : "TEST_CAL_DT",
-  "columns" : [ {
-    "id" : "1",
-    "name" : "CAL_DT",
-    "datatype" : "date"
-  }, {
-    "id" : "2",
-    "name" : "YEAR_BEG_DT",
-    "datatype" : "date"
-  }, {
-    "id" : "3",
-    "name" : "QTR_BEG_DT",
-    "datatype" : "date"
-  }, {
-    "id" : "4",
-    "name" : "MONTH_BEG_DT",
-    "datatype" : "date"
-  }, {
-    "id" : "5",
-    "name" : "WEEK_BEG_DT",
-    "datatype" : "date"
-  }, {
-    "id" : "6",
-    "name" : "AGE_FOR_YEAR_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "7",
-    "name" : "AGE_FOR_QTR_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "8",
-    "name" : "AGE_FOR_MONTH_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "9",
-    "name" : "AGE_FOR_WEEK_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "10",
-    "name" : "AGE_FOR_DT_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "11",
-    "name" : "AGE_FOR_RTL_YEAR_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "12",
-    "name" : "AGE_FOR_RTL_QTR_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "13",
-    "name" : "AGE_FOR_RTL_MONTH_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "14",
-    "name" : "AGE_FOR_RTL_WEEK_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "15",
-    "name" : "AGE_FOR_CS_WEEK_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "16",
-    "name" : "DAY_OF_CAL_ID",
-    "datatype" : "int"
-  }, {
-    "id" : "17",
-    "name" : "DAY_OF_YEAR_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "18",
-    "name" : "DAY_OF_QTR_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "19",
-    "name" : "DAY_OF_MONTH_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "20",
-    "name" : "DAY_OF_WEEK_ID",
-    "datatype" : "int"
-  }, {
-    "id" : "21",
-    "name" : "WEEK_OF_YEAR_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "22",
-    "name" : "WEEK_OF_CAL_ID",
-    "datatype" : "int"
-  }, {
-    "id" : "23",
-    "name" : "MONTH_OF_QTR_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "24",
-    "name" : "MONTH_OF_YEAR_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "25",
-    "name" : "MONTH_OF_CAL_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "26",
-    "name" : "QTR_OF_YEAR_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "27",
-    "name" : "QTR_OF_CAL_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "28",
-    "name" : "YEAR_OF_CAL_ID",
-    "datatype" : "smallint"
-  }, {
-    "id" : "29",
-    "name" : "YEAR_END_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "30",
-    "name" : "QTR_END_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "31",
-    "name" : "MONTH_END_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "32",
-    "name" : "WEEK_END_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "33",
-    "name" : "CAL_DT_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "34",
-    "name" : "CAL_DT_DESC",
-    "datatype" : "string"
-  }, {
-    "id" : "35",
-    "name" : "CAL_DT_SHORT_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "36",
-    "name" : "YTD_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "37",
-    "name" : "QTD_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "38",
-    "name" : "MTD_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "39",
-    "name" : "WTD_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "40",
-    "name" : "SEASON_BEG_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "41",
-    "name" : "DAY_IN_YEAR_COUNT",
-    "datatype" : "smallint"
-  }, {
-    "id" : "42",
-    "name" : "DAY_IN_QTR_COUNT",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "43",
-    "name" : "DAY_IN_MONTH_COUNT",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "44",
-    "name" : "DAY_IN_WEEK_COUNT",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "45",
-    "name" : "RTL_YEAR_BEG_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "46",
-    "name" : "RTL_QTR_BEG_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "47",
-    "name" : "RTL_MONTH_BEG_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "48",
-    "name" : "RTL_WEEK_BEG_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "49",
-    "name" : "CS_WEEK_BEG_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "50",
-    "name" : "CAL_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "51",
-    "name" : "DAY_OF_WEEK",
-    "datatype" : "string"
-  }, {
-    "id" : "52",
-    "name" : "MONTH_ID",
-    "datatype" : "string"
-  }, {
-    "id" : "53",
-    "name" : "PRD_DESC",
-    "datatype" : "string"
-  }, {
-    "id" : "54",
-    "name" : "PRD_FLAG",
-    "datatype" : "string"
-  }, {
-    "id" : "55",
-    "name" : "PRD_ID",
-    "datatype" : "string"
-  }, {
-    "id" : "56",
-    "name" : "PRD_IND",
-    "datatype" : "string"
-  }, {
-    "id" : "57",
-    "name" : "QTR_DESC",
-    "datatype" : "string"
-  }, {
-    "id" : "58",
-    "name" : "QTR_ID",
-    "datatype" : "string"
-  }, {
-    "id" : "59",
-    "name" : "QTR_IND",
-    "datatype" : "string"
-  }, {
-    "id" : "60",
-    "name" : "RETAIL_WEEK",
-    "datatype" : "string"
-  }, {
-    "id" : "61",
-    "name" : "RETAIL_YEAR",
-    "datatype" : "string"
-  }, {
-    "id" : "62",
-    "name" : "RETAIL_START_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "63",
-    "name" : "RETAIL_WK_END_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "64",
-    "name" : "WEEK_IND",
-    "datatype" : "string"
-  }, {
-    "id" : "65",
-    "name" : "WEEK_NUM_DESC",
-    "datatype" : "string"
-  }, {
-    "id" : "66",
-    "name" : "WEEK_BEG_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "67",
-    "name" : "WEEK_END_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "68",
-    "name" : "WEEK_IN_YEAR_ID",
-    "datatype" : "string"
-  }, {
-    "id" : "69",
-    "name" : "WEEK_ID",
-    "datatype" : "string"
-  }, {
-    "id" : "70",
-    "name" : "WEEK_BEG_END_DESC_MDY",
-    "datatype" : "string"
-  }, {
-    "id" : "71",
-    "name" : "WEEK_BEG_END_DESC_MD",
-    "datatype" : "string"
-  }, {
-    "id" : "72",
-    "name" : "YEAR_ID",
-    "datatype" : "string"
-  }, {
-    "id" : "73",
-    "name" : "YEAR_IND",
-    "datatype" : "string"
-  }, {
-    "id" : "74",
-    "name" : "CAL_DT_MNS_1YEAR_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "75",
-    "name" : "CAL_DT_MNS_2YEAR_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "76",
-    "name" : "CAL_DT_MNS_1QTR_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "77",
-    "name" : "CAL_DT_MNS_2QTR_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "78",
-    "name" : "CAL_DT_MNS_1MONTH_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "79",
-    "name" : "CAL_DT_MNS_2MONTH_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "80",
-    "name" : "CAL_DT_MNS_1WEEK_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "81",
-    "name" : "CAL_DT_MNS_2WEEK_DT",
-    "datatype" : "string"
-  }, {
-    "id" : "82",
-    "name" : "CURR_CAL_DT_MNS_1YEAR_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "83",
-    "name" : "CURR_CAL_DT_MNS_2YEAR_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "84",
-    "name" : "CURR_CAL_DT_MNS_1QTR_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "85",
-    "name" : "CURR_CAL_DT_MNS_2QTR_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "86",
-    "name" : "CURR_CAL_DT_MNS_1MONTH_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "87",
-    "name" : "CURR_CAL_DT_MNS_2MONTH_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "88",
-    "name" : "CURR_CAL_DT_MNS_1WEEK_YN_IND",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "89",
-    "name" : "CURR_CAL_DT_MNS_2WEEK_YN_IND",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "90",
-    "name" : "RTL_MONTH_OF_RTL_YEAR_ID",
-    "datatype" : "string"
-  }, {
-    "id" : "91",
-    "name" : "RTL_QTR_OF_RTL_YEAR_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "92",
-    "name" : "RTL_WEEK_OF_RTL_YEAR_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "93",
-    "name" : "SEASON_OF_YEAR_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "94",
-    "name" : "YTM_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "95",
-    "name" : "YTQ_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "96",
-    "name" : "YTW_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "97",
-    "name" : "CRE_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "98",
-    "name" : "CRE_USER",
-    "datatype" : "string"
-  }, {
-    "id" : "99",
-    "name" : "UPD_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "100",
-    "name" : "UPD_USER",
-    "datatype" : "string"
-  } ],
-  "database" : "edw",
-  "last_modified" : 0
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/table/TEST_CATEGORY_GROUPINGS.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/table/TEST_CATEGORY_GROUPINGS.json b/examples/test_case_data/localmeta_v1/table/TEST_CATEGORY_GROUPINGS.json
deleted file mode 100644
index 7bcd092..0000000
--- a/examples/test_case_data/localmeta_v1/table/TEST_CATEGORY_GROUPINGS.json
+++ /dev/null
@@ -1,151 +0,0 @@
-{
-  "uuid" : "952d11b5-69d9-45d1-92af-227489485e3f",
-  "name" : "TEST_CATEGORY_GROUPINGS",
-  "columns" : [ {
-    "id" : "1",
-    "name" : "LEAF_CATEG_ID",
-    "datatype" : "bigint"
-  }, {
-    "id" : "2",
-    "name" : "LEAF_CATEG_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "3",
-    "name" : "SITE_ID",
-    "datatype" : "int"
-  }, {
-    "id" : "4",
-    "name" : "CATEG_BUSN_MGR",
-    "datatype" : "string"
-  }, {
-    "id" : "5",
-    "name" : "CATEG_BUSN_UNIT",
-    "datatype" : "string"
-  }, {
-    "id" : "6",
-    "name" : "REGN_CATEG",
-    "datatype" : "string"
-  }, {
-    "id" : "7",
-    "name" : "USER_DEFINED_FIELD1",
-    "datatype" : "string"
-  }, {
-    "id" : "8",
-    "name" : "USER_DEFINED_FIELD3",
-    "datatype" : "string"
-  }, {
-    "id" : "9",
-    "name" : "CRE_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "10",
-    "name" : "UPD_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "11",
-    "name" : "CRE_USER",
-    "datatype" : "string"
-  }, {
-    "id" : "12",
-    "name" : "UPD_USER",
-    "datatype" : "string"
-  }, {
-    "id" : "13",
-    "name" : "META_CATEG_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "14",
-    "name" : "META_CATEG_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "15",
-    "name" : "CATEG_LVL2_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "16",
-    "name" : "CATEG_LVL3_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "17",
-    "name" : "CATEG_LVL4_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "18",
-    "name" : "CATEG_LVL5_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "19",
-    "name" : "CATEG_LVL6_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "20",
-    "name" : "CATEG_LVL7_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "21",
-    "name" : "CATEG_LVL2_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "22",
-    "name" : "CATEG_LVL3_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "23",
-    "name" : "CATEG_LVL4_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "24",
-    "name" : "CATEG_LVL5_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "25",
-    "name" : "CATEG_LVL6_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "26",
-    "name" : "CATEG_LVL7_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "27",
-    "name" : "CATEG_FLAGS",
-    "datatype" : "decimal"
-  }, {
-    "id" : "28",
-    "name" : "ADULT_CATEG_YN",
-    "datatype" : "string"
-  }, {
-    "id" : "29",
-    "name" : "DOMAIN_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "30",
-    "name" : "USER_DEFINED_FIELD5",
-    "datatype" : "string"
-  }, {
-    "id" : "31",
-    "name" : "VCS_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "32",
-    "name" : "GCS_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "33",
-    "name" : "MOVE_TO",
-    "datatype" : "decimal"
-  }, {
-    "id" : "34",
-    "name" : "SAP_CATEGORY_ID",
-    "datatype" : "decimal"
-  }, {
-    "id" : "35",
-    "name" : "SRC_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "36",
-    "name" : "BSNS_VRTCL_NAME",
-    "datatype" : "string"
-  } ],
-  "database" : "DEFAULT",
-  "last_modified" : 0
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/table/TEST_KYLIN_FACT.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/table/TEST_KYLIN_FACT.json b/examples/test_case_data/localmeta_v1/table/TEST_KYLIN_FACT.json
deleted file mode 100644
index 732351a..0000000
--- a/examples/test_case_data/localmeta_v1/table/TEST_KYLIN_FACT.json
+++ /dev/null
@@ -1,43 +0,0 @@
-{
-  "uuid" : "e286e39e-40d7-44c2-8fa2-41b365522771",
-  "name" : "TEST_KYLIN_FACT",
-  "columns" : [ {
-    "id" : "1",
-    "name" : "TRANS_ID",
-    "datatype" : "bigint"
-  }, {
-    "id" : "2",
-    "name" : "CAL_DT",
-    "datatype" : "date"
-  }, {
-    "id" : "3",
-    "name" : "LSTG_FORMAT_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "4",
-    "name" : "LEAF_CATEG_ID",
-    "datatype" : "bigint"
-  }, {
-    "id" : "5",
-    "name" : "LSTG_SITE_ID",
-    "datatype" : "int"
-  }, {
-    "id" : "6",
-    "name" : "SLR_SEGMENT_CD",
-    "datatype" : "smallint"
-  }, {
-    "id" : "7",
-    "name" : "PRICE",
-    "datatype" : "decimal(18,6)"
-  }, {
-    "id" : "8",
-    "name" : "ITEM_COUNT",
-    "datatype" : "bigint"
-  }, {
-    "id" : "9",
-    "name" : "SELLER_ID",
-    "datatype" : "bigint"
-  } ],
-  "database" : "DEFAULT",
-  "last_modified" : 0
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/table/TEST_SELLER_TYPE_DIM.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/table/TEST_SELLER_TYPE_DIM.json b/examples/test_case_data/localmeta_v1/table/TEST_SELLER_TYPE_DIM.json
deleted file mode 100644
index 42f4d9c..0000000
--- a/examples/test_case_data/localmeta_v1/table/TEST_SELLER_TYPE_DIM.json
+++ /dev/null
@@ -1,43 +0,0 @@
-{
-  "uuid" : "9ecc90c4-55df-436f-8602-2fbd4bca72e1",
-  "name" : "TEST_SELLER_TYPE_DIM",
-  "columns" : [ {
-    "id" : "1",
-    "name" : "SELLER_TYPE_CD",
-    "datatype" : "smallint"
-  }, {
-    "id" : "2",
-    "name" : "SELLER_TYPE_DESC",
-    "datatype" : "string"
-  }, {
-    "id" : "3",
-    "name" : "GLBL_RPRT_SLR_SGMNT_CD",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "4",
-    "name" : "SELLER_GROUP_CD",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "5",
-    "name" : "SELLER_GROUP_DESC",
-    "datatype" : "string"
-  }, {
-    "id" : "6",
-    "name" : "CRE_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "7",
-    "name" : "CRE_USER",
-    "datatype" : "string"
-  }, {
-    "id" : "8",
-    "name" : "UPD_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "9",
-    "name" : "UPD_USER",
-    "datatype" : "string"
-  } ],
-  "database" : "edw",
-  "last_modified" : 0
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/table/TEST_SITES.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/table/TEST_SITES.json b/examples/test_case_data/localmeta_v1/table/TEST_SITES.json
deleted file mode 100644
index d451e34..0000000
--- a/examples/test_case_data/localmeta_v1/table/TEST_SITES.json
+++ /dev/null
@@ -1,47 +0,0 @@
-{
-  "uuid" : "338a3325-a947-46d1-9ece-e079b3b8d4a6",
-  "name" : "TEST_SITES",
-  "columns" : [ {
-    "id" : "1",
-    "name" : "SITE_ID",
-    "datatype" : "int"
-  }, {
-    "id" : "2",
-    "name" : "SITE_NAME",
-    "datatype" : "string"
-  }, {
-    "id" : "3",
-    "name" : "SITE_DOMAIN_CODE",
-    "datatype" : "string"
-  }, {
-    "id" : "4",
-    "name" : "DFAULT_LSTG_CURNCY",
-    "datatype" : "int"
-  }, {
-    "id" : "5",
-    "name" : "EOA_EMAIL_CSTMZBL_SITE_YN_ID",
-    "datatype" : "tinyint"
-  }, {
-    "id" : "6",
-    "name" : "SITE_CNTRY_ID",
-    "datatype" : "int"
-  }, {
-    "id" : "7",
-    "name" : "CRE_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "8",
-    "name" : "UPD_DATE",
-    "datatype" : "string"
-  }, {
-    "id" : "9",
-    "name" : "CRE_USER",
-    "datatype" : "string"
-  }, {
-    "id" : "10",
-    "name" : "UPD_USER",
-    "datatype" : "string"
-  } ],
-  "database" : "edw",
-  "last_modified" : 0
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/4e073775/examples/test_case_data/localmeta_v1/table_exd/TEST_KYLIN_FACT.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta_v1/table_exd/TEST_KYLIN_FACT.json b/examples/test_case_data/localmeta_v1/table_exd/TEST_KYLIN_FACT.json
deleted file mode 100644
index 7cc5b5e..0000000
--- a/examples/test_case_data/localmeta_v1/table_exd/TEST_KYLIN_FACT.json
+++ /dev/null
@@ -1,16 +0,0 @@
-{
-  "minFileSize" : "21745785",
-  "totalNumberFiles" : "1",
-  "location" : "/user/hive/warehouse/test_kylin_fact",
-  "lastUpdateTime" : "1416847983199",
-  "lastAccessTime" : "1416847980624",
-  "columns" : "",
-  "partitionColumns" : "",
-  "maxFileSize" : "56146493",
-  "inputformat" : "",
-  "partitioned" : "false",
-  "tableName" : "test_kylin_fact",
-  "owner" : "",
-  "totalFileSize" : "538720920",
-  "outputformat" : ""
-}
\ No newline at end of file