You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by ma...@apache.org on 2016/11/17 03:29:43 UTC

[2/2] kylin git commit: KYLIN-2197 fix gg group buildMandatoryColumnMask

KYLIN-2197 fix gg group buildMandatoryColumnMask

Signed-off-by: Hongbin Ma <ma...@apache.org>


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

Branch: refs/heads/master
Commit: f3d19f6da20fa415eac641b8daf6081b3eaaf9d4
Parents: 3b1850e
Author: Li Yang <li...@apache.org>
Authored: Wed Nov 16 13:33:08 2016 +0800
Committer: Hongbin Ma <ma...@apache.org>
Committed: Thu Nov 17 11:28:06 2016 +0800

----------------------------------------------------------------------
 .../kylin/cube/model/AggregationGroup.java      |   2 +-
 .../kylin/cube/cuboid/CuboidSchedulerTest.java  |  13 +
 .../cube_desc/ut_large_dimension_number.json    | 585 +++++++++++++++++++
 .../model_desc/ut_large_dimension_number.json   |  26 +
 .../localmeta/table/DEFAULT.WIDE_TABLE.json     | 217 +++++++
 5 files changed, 842 insertions(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/kylin/blob/f3d19f6d/core-cube/src/main/java/org/apache/kylin/cube/model/AggregationGroup.java
----------------------------------------------------------------------
diff --git a/core-cube/src/main/java/org/apache/kylin/cube/model/AggregationGroup.java b/core-cube/src/main/java/org/apache/kylin/cube/model/AggregationGroup.java
index 027d185..ab63c00 100644
--- a/core-cube/src/main/java/org/apache/kylin/cube/model/AggregationGroup.java
+++ b/core-cube/src/main/java/org/apache/kylin/cube/model/AggregationGroup.java
@@ -140,7 +140,7 @@ public class AggregationGroup {
         for (String dim : mandatory_dims) {
             TblColRef hColumn = cubeDesc.getModel().findColumn(dim);
             Integer index = rowKeyDesc.getColumnBitIndex(hColumn);
-            mandatoryColumnMask |= 1 << index;
+            mandatoryColumnMask |= (1L << index);
         }
 
     }

http://git-wip-us.apache.org/repos/asf/kylin/blob/f3d19f6d/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java
----------------------------------------------------------------------
diff --git a/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java b/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java
index ecb1200..bdceb0f 100644
--- a/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java
+++ b/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java
@@ -24,6 +24,7 @@ import static org.junit.Assert.fail;
 
 import java.util.Arrays;
 import java.util.Collection;
+import java.util.List;
 
 import org.apache.kylin.common.util.LocalFileMetadataTestCase;
 import org.apache.kylin.cube.CubeDescManager;
@@ -283,6 +284,18 @@ public class CuboidSchedulerTest extends LocalFileMetadataTestCase {
         assertEquals(cuboidScheduler.getCuboidCount(), sum);
     }
 
+    @Test
+    public void testCuboid_onlyBaseCuboid() {
+        CubeDesc cube = getCubeDescManager().getCubeDesc("ut_large_dimension_number");
+        CuboidScheduler scheduler = new CuboidScheduler(cube);
+        
+        Cuboid baseCuboid = Cuboid.getBaseCuboid(cube);
+        assertTrue(Cuboid.isValid(cube, baseCuboid.getId()));
+        
+        List<Long> spanningChild = scheduler.getSpanningCuboid(baseCuboid.getId());
+        assertTrue(spanningChild.size() > 0);
+    }
+
     public CubeDescManager getCubeDescManager() {
         return CubeDescManager.getInstance(getTestConfig());
     }

http://git-wip-us.apache.org/repos/asf/kylin/blob/f3d19f6d/examples/test_case_data/localmeta/cube_desc/ut_large_dimension_number.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/cube_desc/ut_large_dimension_number.json b/examples/test_case_data/localmeta/cube_desc/ut_large_dimension_number.json
new file mode 100644
index 0000000..c0e8568
--- /dev/null
+++ b/examples/test_case_data/localmeta/cube_desc/ut_large_dimension_number.json
@@ -0,0 +1,585 @@
+{
+  "uuid" : "9e89e128-f13e-4209-82d2-973985114793",
+  "last_modified" : 1479207711845,
+  "name" : "ut_large_dimension_number",
+  "model_name" : "ut_large_dimension_number",
+  "description" : "",
+  "null_string" : null,
+  "dimensions" : [ {
+    "name" : "DEFAULT.WIDE_TABLE.A",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "A",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.B",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "B",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.C",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "C",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.D",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "D",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.E",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "E",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.F",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "F",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.G",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "G",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.H",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "H",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.I",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "I",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.J",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "J",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.K",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "K",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.L",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "L",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.M",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "M",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.N",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "N",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.O",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "O",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.P",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "P",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.Q",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "Q",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.R",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "R",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.S",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "S",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.T",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "T",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.U",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "U",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.V",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "V",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.W",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "W",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.X",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "X",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.Y",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "Y",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.Z",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "Z",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AA",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AA",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AB",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AB",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AC",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AC",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AD",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AD",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AE",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AE",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AF",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AF",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AG",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AG",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AH",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AH",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AI",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AI",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AJ",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AJ",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AK",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AK",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AL",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AL",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AM",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AM",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AN",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AN",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AO",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AO",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AP",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AP",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AQ",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AQ",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AR",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AR",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AS",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AS",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AT",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AT",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AU",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AU",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AV",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AV",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AW",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AW",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AX",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AX",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AY",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AY",
+    "derived" : null
+  },{
+    "name" : "DEFAULT.WIDE_TABLE.AZ",
+    "table" : "DEFAULT.WIDE_TABLE",
+    "column" : "AZ",
+    "derived" : null
+  } ],
+  "measures" : [ {
+    "name" : "_COUNT_",
+    "function" : {
+      "expression" : "COUNT",
+      "parameter" : {
+        "type" : "constant",
+        "value" : "1",
+        "next_parameter" : null
+      },
+      "returntype" : "bigint"
+    },
+    "dependent_measure_ref" : null
+  } ],
+  "dictionaries" : [ ],
+  "rowkey" : {
+    "rowkey_columns" : [ {
+      "column" : "A",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "B",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "C",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "D",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "E",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "F",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "G",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "H",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "I",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "J",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "K",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "L",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "M",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "N",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "O",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "P",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "Q",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "R",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "S",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "T",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "U",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "V",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "W",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "X",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "Y",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "Z",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AA",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AB",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AC",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AD",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AE",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AF",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AG",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AH",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AI",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AJ",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AK",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AL",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AM",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AN",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AO",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AP",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AQ",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AR",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AS",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AT",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    }, {
+      "column" : "AU",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    },{
+      "column" : "AV",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    },{
+      "column" : "AW",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    },{
+      "column" : "AX",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    },{
+      "column" : "AY",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    },{
+      "column" : "AZ",
+      "encoding" : "dict",
+      "isShardBy" : false,
+      "index" : "eq"
+    } ]
+  },
+  "hbase_mapping" : {
+    "column_family" : [ {
+      "name" : "F1",
+      "columns" : [ {
+        "qualifier" : "M",
+        "measure_refs" : [ "_COUNT_" ]
+      } ]
+    } ]
+  },
+  "aggregation_groups" : [ {
+    "includes" : [ "A", "B", "C", "D", "E" ],
+    "select_rule" : {
+      "hierarchy_dims" : [ ],
+      "mandatory_dims" : [ ],
+      "joint_dims" : [ ]
+    }
+  }, {
+    "includes" : [ "F", "G", "H", "I", "J", "K", "L", "M" ],
+    "select_rule" : {
+      "hierarchy_dims" : [ ],
+      "mandatory_dims" : [ "F" ],
+      "joint_dims" : [ ]
+    }
+  } ],
+  "signature" : "4NqJVcVIYRF5PkJ0jS+9Rg==",
+  "notify_list" : [ ],
+  "status_need_notify" : [ "ERROR", "DISCARDED", "SUCCEED" ],
+  "partition_date_start" : 1469923200000,
+  "partition_date_end" : 3153600000000,
+  "auto_merge_time_ranges" : [ 604800000, 2419200000 ],
+  "retention_range" : 0,
+  "engine_type" : 100,
+  "storage_type" : 100,
+  "override_kylin_properties" : {
+    "kylin.cube.algorithm" : "auto",
+    "kylin.cube.aggrgroup.max.combination" : "4096",
+    "kylin.job.cubing.inmem.sampling.percent" : "100",
+    "kylin.hbase.default.compression.codec" : "none"
+  }
+}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/kylin/blob/f3d19f6d/examples/test_case_data/localmeta/model_desc/ut_large_dimension_number.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/model_desc/ut_large_dimension_number.json b/examples/test_case_data/localmeta/model_desc/ut_large_dimension_number.json
new file mode 100644
index 0000000..38b070e
--- /dev/null
+++ b/examples/test_case_data/localmeta/model_desc/ut_large_dimension_number.json
@@ -0,0 +1,26 @@
+{
+  "uuid" : "dd250ea4-27f7-4450-b604-fcfdf3578f5a",
+  "last_modified" : 1479206338080,
+  "version" : "1.6.0",
+  "name" : "ut_large_dimension_number",
+  "owner" : "ADMIN",
+  "description" : "",
+  "fact_table" : "DEFAULT.WIDE_TABLE",
+  "lookups" : [],
+  "dimensions" : [ {
+    "table" : "DEFAULT.WIDE_TABLE",
+    "columns" : ["A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "AA", "AB", "AC", "AD", "AE", "AF", "AG", "AH", "AI", "AJ", "AK", "AL", "AM", "AN", "AO", "AP", "AQ", "AR", "AS", "AT", "AU", "AV", "AW", "AX", "AY", "AZ"]
+  }],
+  "metrics" : [ "A" ],
+  "filter_condition" : "",
+  "partition_desc" : {
+    "partition_date_column" : "DEFAULT.WIDE_TABLE.A",
+    "partition_time_column" : null,
+    "partition_date_start" : 0,
+    "partition_date_format" : "yyyyMMdd",
+    "partition_time_format" : "HH:mm:ss",
+    "partition_type" : "APPEND",
+    "partition_condition_builder" : "org.apache.kylin.metadata.model.PartitionDesc$DefaultPartitionConditionBuilder"
+  },
+  "capacity" : "MEDIUM"
+}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/kylin/blob/f3d19f6d/examples/test_case_data/localmeta/table/DEFAULT.WIDE_TABLE.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/DEFAULT.WIDE_TABLE.json b/examples/test_case_data/localmeta/table/DEFAULT.WIDE_TABLE.json
new file mode 100644
index 0000000..ef142d1
--- /dev/null
+++ b/examples/test_case_data/localmeta/table/DEFAULT.WIDE_TABLE.json
@@ -0,0 +1,217 @@
+{
+  "uuid" : "cd267e5b-6835-4db2-a861-8b78f38271fe",
+  "last_modified" : 1479202699684,
+  "version" : "1.6.0",
+  "name" : "WIDE_TABLE",
+  "columns" : [ {
+    "id" : "1",
+    "name" : "A",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "2",
+    "name" : "B",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "3",
+    "name" : "C",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "4",
+    "name" : "D",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "5",
+    "name" : "E",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "6",
+    "name" : "F",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "7",
+    "name" : "G",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "8",
+    "name" : "H",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "9",
+    "name" : "I",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "10",
+    "name" : "J",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "11",
+    "name" : "K",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "12",
+    "name" : "L",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "13",
+    "name" : "M",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "14",
+    "name" : "N",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "15",
+    "name" : "O",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "16",
+    "name" : "P",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "17",
+    "name" : "Q",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "18",
+    "name" : "R",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "19",
+    "name" : "S",
+    "datatype" : "bigint"
+  }, {
+    "id" : "20",
+    "name" : "T",
+    "datatype" : "bigint"
+  }, {
+    "id" : "21",
+    "name" : "U",
+    "datatype" : "bigint"
+  }, {
+    "id" : "22",
+    "name" : "V",
+    "datatype" : "bigint"
+  }, {
+    "id" : "23",
+    "name" : "W",
+    "datatype" : "bigint"
+  }, {
+    "id" : "24",
+    "name" : "X",
+    "datatype" : "bigint"
+  }, {
+    "id" : "25",
+    "name" : "Y",
+    "datatype" : "bigint"
+  }, {
+    "id" : "26",
+    "name" : "Z",
+    "datatype" : "bigint"
+  }, {
+    "id" : "27",
+    "name" : "AA",
+    "datatype" : "bigint"
+  }, {
+    "id" : "28",
+    "name" : "AB",
+    "datatype" : "bigint"
+  }, {
+    "id" : "29",
+    "name" : "AC",
+    "datatype" : "bigint"
+  }, {
+    "id" : "30",
+    "name" : "AD",
+    "datatype" : "bigint"
+  }, {
+    "id" : "31",
+    "name" : "AE",
+    "datatype" : "bigint"
+  }, {
+    "id" : "32",
+    "name" : "AF",
+    "datatype" : "bigint"
+  }, {
+    "id" : "33",
+    "name" : "AG",
+    "datatype" : "bigint"
+  }, {
+    "id" : "34",
+    "name" : "AH",
+    "datatype" : "bigint"
+  }, {
+    "id" : "35",
+    "name" : "AI",
+    "datatype" : "bigint"
+  }, {
+    "id" : "36",
+    "name" : "AJ",
+    "datatype" : "bigint"
+  }, {
+    "id" : "37",
+    "name" : "AK",
+    "datatype" : "bigint"
+  }, {
+    "id" : "38",
+    "name" : "AL",
+    "datatype" : "bigint"
+  }, {
+    "id" : "39",
+    "name" : "AM",
+    "datatype" : "bigint"
+  }, {
+    "id" : "40",
+    "name" : "AN",
+    "datatype" : "bigint"
+  }, {
+    "id" : "41",
+    "name" : "AO",
+    "datatype" : "bigint"
+  }, {
+    "id" : "42",
+    "name" : "AP",
+    "datatype" : "bigint"
+  }, {
+    "id" : "43",
+    "name" : "AQ",
+    "datatype" : "bigint"
+  }, {
+    "id" : "44",
+    "name" : "AR",
+    "datatype" : "bigint"
+  }, {
+    "id" : "45",
+    "name" : "AS",
+    "datatype" : "bigint"
+  }, {
+    "id" : "46",
+    "name" : "AT",
+    "datatype" : "bigint"
+  }, {
+    "id" : "47",
+    "name" : "AU",
+    "datatype" : "bigint"
+  }, {
+    "id" : "48",
+    "name" : "AV",
+    "datatype" : "bigint"
+  }, {
+    "id" : "49",
+    "name" : "AW",
+    "datatype" : "bigint"
+  }, {
+    "id" : "50",
+    "name" : "AX",
+    "datatype" : "varchar(256)"
+  }, {
+    "id" : "51",
+    "name" : "AY",
+    "datatype" : "bigint"
+  }, {
+    "id" : "52",
+    "name" : "AZ",
+    "datatype" : "varchar(256)"
+  } ],
+  "source_type" : 0,
+  "database" : "DEFAULT"
+}
\ No newline at end of file