You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ra...@apache.org on 2016/12/28 10:53:18 UTC
[40/52] [partial] incubator-carbondata git commit: remove integration-testcases

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/DTS2015121707872 .csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/DTS2015121707872 .csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/DTS2015121707872 .csv
deleted file mode 100644
index 6381764..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/DTS2015121707872 .csv	
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Partial Success,2015-12-24 13:16:40.0,2015-12-24 13:16:45.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_001.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_001.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_001.csv
deleted file mode 100644
index 0da21b9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_001.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 14:27:10.0, 2015-11-05 14:27:10.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_002.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_002.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_002.csv
deleted file mode 100644
index c630683..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_002.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:01:23.0, 2015-11-05 15:01:26.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_003.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_003.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_003.csv
deleted file mode 100644
index f6754fd..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_003.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:15:42.0, 2015-11-05 15:15:43.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_004.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_004.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_004.csv
deleted file mode 100644
index 70a35c7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_004.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:23:02.0, 2015-11-05 15:23:03.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_005.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_005.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_005.csv
deleted file mode 100644
index 70a35c7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_005.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:23:02.0, 2015-11-05 15:23:03.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_006.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_006.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_006.csv
deleted file mode 100644
index 70a35c7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_006.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:23:02.0, 2015-11-05 15:23:03.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_007.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_007.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_007.csv
deleted file mode 100644
index 2fff4f3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_007.csv
+++ /dev/null
@@ -1 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_008.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_008.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_008.csv
deleted file mode 100644
index 2fff4f3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_008.csv
+++ /dev/null
@@ -1 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_009.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_009.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_009.csv
deleted file mode 100644
index 5d956e9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_009.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 17:43:21.0, 2015-11-05 17:43:22.0
-1,Success,2015-11-05 17:43:43.0, 2015-11-05 17:43:44.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_012.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_012.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_012.csv
deleted file mode 100644
index 34d0946..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_012.csv
+++ /dev/null
@@ -1 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_013.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_013.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_013.csv
deleted file mode 100644
index 6ea374e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_013.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 18:09:40.0, 2015-11-05 18:09:41.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1246.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1246.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1246.csv
deleted file mode 100644
index 0da21b9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1246.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 14:27:10.0, 2015-11-05 14:27:10.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1247.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1247.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1247.csv
deleted file mode 100644
index c630683..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1247.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:01:23.0, 2015-11-05 15:01:26.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1248.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1248.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1248.csv
deleted file mode 100644
index f6754fd..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1248.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:15:42.0, 2015-11-05 15:15:43.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1249.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1249.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1249.csv
deleted file mode 100644
index 70a35c7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1249.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:23:02.0, 2015-11-05 15:23:03.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1250.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1250.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1250.csv
deleted file mode 100644
index 70a35c7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1250.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:23:02.0, 2015-11-05 15:23:03.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1251.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1251.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1251.csv
deleted file mode 100644
index 70a35c7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1251.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 15:23:02.0, 2015-11-05 15:23:03.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1252.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1252.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1252.csv
deleted file mode 100644
index 2fff4f3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1252.csv
+++ /dev/null
@@ -1 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1253.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1253.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1253.csv
deleted file mode 100644
index 2fff4f3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1253.csv
+++ /dev/null
@@ -1 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1254.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1254.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1254.csv
deleted file mode 100644
index 5d956e9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1254.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 17:43:21.0, 2015-11-05 17:43:22.0
-1,Success,2015-11-05 17:43:43.0, 2015-11-05 17:43:44.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1257.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1257.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1257.csv
deleted file mode 100644
index 34d0946..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1257.csv
+++ /dev/null
@@ -1 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1258.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1258.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1258.csv
deleted file mode 100644
index 6ea374e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1258.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
-0,Success,2015-11-05 18:09:40.0, 2015-11-05 18:09:41.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1336.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1336.csv b/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1336.csv
deleted file mode 100644
index 34d0946..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/ShowLoad/TC_1336.csv
+++ /dev/null
@@ -1 +0,0 @@
-LoadSequenceId StringType,Status StringType,Load Start Time TimestampType,Load End Time TimestampType
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateCube_TC_001.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateCube_TC_001.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateCube_TC_001.csv
deleted file mode 100644
index 5abb99c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateCube_TC_001.csv
+++ /dev/null
@@ -1 +0,0 @@
-result StringType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateVIPTable_TC_001.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateVIPTable_TC_001.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateVIPTable_TC_001.csv
deleted file mode 100644
index 5abb99c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_CreateVIPTable_TC_001.csv
+++ /dev/null
@@ -1 +0,0 @@
-result StringType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_DataLoad_TC_001.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_DataLoad_TC_001.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_DataLoad_TC_001.csv
deleted file mode 100644
index 5abb99c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_DataLoad_TC_001.csv
+++ /dev/null
@@ -1 +0,0 @@
-result StringType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_LoadVIPTable_TC_002.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_LoadVIPTable_TC_002.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_LoadVIPTable_TC_002.csv
deleted file mode 100644
index 5abb99c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_LoadVIPTable_TC_002.csv
+++ /dev/null
@@ -1 +0,0 @@
-result StringType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_001.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_001.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_001.csv
deleted file mode 100644
index 3922464..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_001.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-MSISDN StringType,total LongType
-8613649905753,2381

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_002.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_002.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_002.csv
deleted file mode 100644
index 6edc4e3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_002.csv
+++ /dev/null
@@ -1,20 +0,0 @@
-MSISDN StringType,total LongType
-8613893462639,2874640
-8613993676885,73783
-8618394185970,23865
-8618793100458,15112
-8618794812876,14411
-8615120474362,6936
-8613893853351,6486
-8618393012284,5700
-8613993800024,5044
-8618794965341,4840
-8613993899110,4364
-8613519003078,2485
-8613649905753,2381
-8613893600602,2346
-8615117035070,1310
-8618700943475,1185
-8613919791668,928
-8615209309657,290
-8613993104233,280

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_003.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_003.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_003.csv
deleted file mode 100644
index 71f6b63..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_003.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-MSISDN StringType,total LongType
-8613893462639,2874640
-8613993676885,73783

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_004.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_004.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_004.csv
deleted file mode 100644
index 2bd4f7b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_004.csv
+++ /dev/null
@@ -1,7 +0,0 @@
-APP_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-Network_Admin,5,12402
-Web_Browsing,6,2972886
-IM,2,29565
-Tunnelling,1,4364
-Game,1,2485
-,4,24684

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_005.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_005.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_005.csv
deleted file mode 100644
index 4a89bba..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_005.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-APP_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-Web_Browsing,6,2972886

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_006.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_006.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_006.csv
deleted file mode 100644
index 7a0bfe5..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_006.csv
+++ /dev/null
@@ -1,10 +0,0 @@
-APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-QQ_Media,1,5700
-DNS,5,12402
-QQ_IM,1,23865
-HTTP,4,2896722
-XiaYiDao,1,2485
-HTTP_Browsing,1,2381
-HTTPS,1,73783
-,4,24684
-SSL,1,4364

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_007.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_007.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_007.csv
deleted file mode 100644
index cb62741..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_007.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-HTTP,1,2874640

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_008.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_008.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_008.csv
deleted file mode 100644
index ceaf07c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_008.csv
+++ /dev/null
@@ -1,17 +0,0 @@
-TERMINAL_BRAND StringType,msidn_number LongType,total LongType
-OPPO,1,928
-HTC,2,2661
-\u7f8e\u5947,1,2485
-NOKIA,1,14411
-MARCONI,1,2874640
-SUNUP,1,290
-TIANYU,1,23865
-LANBOXING,1,4364
-BBK,1,6936
-SECURE,1,1185
-MOTOROLA,3,80137
-DAXIAN,1,6486
-LENOVO,1,2346
-,1,4840
-\u5c71\u6c34,1,5700
-SANGFEI,1,15112

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_009.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_009.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_009.csv
deleted file mode 100644
index 2d38c20..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_009.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-TERMINAL_BRAND StringType,msidn_number LongType,total LongType
-MARCONI,1,2874640

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_010.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_010.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_010.csv
deleted file mode 100644
index cb044c7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_010.csv
+++ /dev/null
@@ -1,5 +0,0 @@
-TERMINAL_TYPE StringType,msidn_number LongType,total LongType
- ,2,2875825
-SMARTPHONE,8,123420
-,1,4840
-FEATURE PHONE,8,42301

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_011.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_011.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_011.csv
deleted file mode 100644
index b241fbb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_011.csv
+++ /dev/null
@@ -1,5 +0,0 @@
-TERMINAL_TYPE StringType,msidn_number LongType,total LongType
- ,2,2875825
-SMARTPHONE,8,123420
-FEATURE PHONE,8,42301
-,1,4840

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_012.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_012.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_012.csv
deleted file mode 100644
index f5ebdfe..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_012.csv
+++ /dev/null
@@ -1,20 +0,0 @@
-CGI StringType,msidn_number LongType,total LongType
-460003772902063,1,73783
-460003788311323,1,5700
-460003777109392,1,6486
-460003787211338,1,1310
-460003776440020,1,5044
-460003773401611,1,2381
-460003767804016,1,4840
-460003784806621,1,1185
-460003787360026,1,14411
-460003785041401,1,6936
-460003766033446,1,15112
-460003776906411,1,4364
-460003782800719,1,2874640
-460003764930757,1,928
-460003788410098,1,23865
-460003763202233,1,2485
-460003763606253,1,290
-460003788100762,1,280
-460003784118872,1,2346

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_013.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_013.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_013.csv
deleted file mode 100644
index 945f471..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_013.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-CGI StringType,msidn_number LongType,total LongType
-460003772902063,1,73783

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_014.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_014.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_014.csv
deleted file mode 100644
index 093fa5c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_014.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-RAT_NAME StringType,msidn_number LongType,total LongType
-GERAN,19,3046386

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_015.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_015.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_015.csv
deleted file mode 100644
index dffc202..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_015.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-DAY StringType,HOUR StringType,msidn_number LongType,total LongType
-8-1,23,19,3046386

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_016.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_016.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_016.csv
deleted file mode 100644
index dffc202..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_016.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-DAY StringType,HOUR StringType,msidn_number LongType,total LongType
-8-1,23,19,3046386

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_017.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_017.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_017.csv
deleted file mode 100644
index 6d239f1..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_017.csv
+++ /dev/null
@@ -1,10 +0,0 @@
-APP_SUB_CATEGORY_NAME StringType,APP_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-HTTPS,Web_Browsing,1,73783
-QQ_IM,IM,1,23865
-HTTP_Browsing,Web_Browsing,1,2381
-XiaYiDao,Game,1,2485
-,,4,24684
-SSL,Tunnelling,1,4364
-HTTP,Web_Browsing,4,2896722
-QQ_Media,IM,1,5700
-DNS,Network_Admin,5,12402

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_018.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_018.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_018.csv
deleted file mode 100644
index 3563441..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_018.csv
+++ /dev/null
@@ -1,4 +0,0 @@
-APP_SUB_CATEGORY_NAME StringType,APP_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-HTTP,Web_Browsing,4,2896722
-HTTPS,Web_Browsing,1,73783
-HTTP_Browsing,Web_Browsing,1,2381

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_019.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_019.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_019.csv
deleted file mode 100644
index c310fce..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_019.csv
+++ /dev/null
@@ -1,19 +0,0 @@
-TERMINAL_BRAND StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-SECURE,HTTP,1,1185
-HTC,HTTP_Browsing,1,2381
-TIANYU,QQ_IM,1,23865
-DAXIAN,HTTP,1,6486
-BBK,,1,6936
-\u5c71\u6c34,QQ_Media,1,5700
-LENOVO,,1,2346
-LANBOXING,SSL,1,4364
-MOTOROLA,DNS,2,6354
-MOTOROLA,HTTPS,1,73783
-SANGFEI,,1,15112
-\u7f8e\u5947,XiaYiDao,1,2485
-NOKIA,HTTP,1,14411
-,DNS,1,4840
-MARCONI,HTTP,1,2874640
-OPPO,DNS,1,928
-HTC,DNS,1,280
-SUNUP,,1,290

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_020.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_020.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_020.csv
deleted file mode 100644
index 98d9021..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_020.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-TERMINAL_BRAND StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-HTC,HTTP_Browsing,1,2381
-HTC,DNS,1,280

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_021.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_021.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_021.csv
deleted file mode 100644
index 5abce00..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_021.csv
+++ /dev/null
@@ -1,10 +0,0 @@
-RAT_NAME StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-GERAN,QQ_Media,1,5700
-GERAN,HTTP,4,2896722
-GERAN,XiaYiDao,1,2485
-GERAN,,4,24684
-GERAN,QQ_IM,1,23865
-GERAN,DNS,5,12402
-GERAN,HTTPS,1,73783
-GERAN,SSL,1,4364
-GERAN,HTTP_Browsing,1,2381

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_022.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_022.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_022.csv
deleted file mode 100644
index 8115499..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_022.csv
+++ /dev/null
@@ -1,10 +0,0 @@
-RAT_NAME StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-GERAN,HTTP,4,2896722
-GERAN,HTTPS,1,73783
-GERAN,,4,24684
-GERAN,QQ_IM,1,23865
-GERAN,DNS,5,12402
-GERAN,QQ_Media,1,5700
-GERAN,SSL,1,4364
-GERAN,XiaYiDao,1,2485
-GERAN,HTTP_Browsing,1,2381

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_023.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_023.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_023.csv
deleted file mode 100644
index fe48dc8..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_023.csv
+++ /dev/null
@@ -1,15 +0,0 @@
-TERMINAL_TYPE StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-SMARTPHONE,,1,2346
-SMARTPHONE,QQ_IM,1,23865
-FEATURE PHONE,QQ_Media,1,5700
-SMARTPHONE,DNS,3,6634
-FEATURE PHONE,HTTP,1,6486
-SMARTPHONE,HTTPS,1,73783
-FEATURE PHONE,XiaYiDao,1,2485
-SMARTPHONE,HTTP_Browsing,1,2381
- ,HTTP,2,2875825
-FEATURE PHONE,,3,22338
-,DNS,1,4840
-FEATURE PHONE,DNS,1,928
-FEATURE PHONE,SSL,1,4364
-SMARTPHONE,HTTP,1,14411

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_024.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_024.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_024.csv
deleted file mode 100644
index e1d050b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_024.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-TERMINAL_TYPE StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-SMARTPHONE,HTTPS,1,73783
-SMARTPHONE,HTTP_Browsing,1,2381

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_025.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_025.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_025.csv
deleted file mode 100644
index f0473ae..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_025.csv
+++ /dev/null
@@ -1,20 +0,0 @@
-HOUR StringType,cgi StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-23,460003788311323,QQ_Media,1,5700
-23,460003763606253,,1,290
-23,460003784806621,HTTP,1,1185
-23,460003776440020,DNS,1,5044
-23,460003772902063,HTTPS,1,73783
-23,460003782800719,HTTP,1,2874640
-23,460003776906411,SSL,1,4364
-23,460003788410098,QQ_IM,1,23865
-23,460003766033446,,1,15112
-23,460003763202233,XiaYiDao,1,2485
-23,460003764930757,DNS,1,928
-23,460003787211338,DNS,1,1310
-23,460003767804016,DNS,1,4840
-23,460003773401611,HTTP_Browsing,1,2381
-23,460003784118872,,1,2346
-23,460003785041401,,1,6936
-23,460003777109392,HTTP,1,6486
-23,460003788100762,DNS,1,280
-23,460003787360026,HTTP,1,14411

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_026.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_026.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_026.csv
deleted file mode 100644
index 6c18fed..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_026.csv
+++ /dev/null
@@ -1,15 +0,0 @@
-RAT_NAME StringType,APP_SUB_CATEGORY_NAME StringType,TERMINAL_TYPE StringType,msidn_number LongType,total LongType
-GERAN,SSL,FEATURE PHONE,1,4364
-GERAN,HTTP,SMARTPHONE,1,14411
-GERAN,,SMARTPHONE,1,2346
-GERAN,QQ_IM,SMARTPHONE,1,23865
-GERAN,QQ_Media,FEATURE PHONE,1,5700
-GERAN,DNS,SMARTPHONE,3,6634
-GERAN,HTTPS,SMARTPHONE,1,73783
-GERAN,HTTP,FEATURE PHONE,1,6486
-GERAN,XiaYiDao,FEATURE PHONE,1,2485
-GERAN,HTTP_Browsing,SMARTPHONE,1,2381
-GERAN,HTTP, ,2,2875825
-GERAN,,FEATURE PHONE,3,22338
-GERAN,DNS,,1,4840
-GERAN,DNS,FEATURE PHONE,1,928

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_027.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_027.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_027.csv
deleted file mode 100644
index 9a1b587..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_027.csv
+++ /dev/null
@@ -1,20 +0,0 @@
-MSISDN StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-8613993676885,HTTPS,1,73783
-8618394185970,QQ_IM,1,23865
-8613993800024,DNS,1,5044
-8613893600602,,1,2346
-8613919791668,DNS,1,928
-8618793100458,,1,15112
-8618794812876,HTTP,1,14411
-8618700943475,HTTP,1,1185
-8613993104233,DNS,1,280
-8615120474362,,1,6936
-8615209309657,,1,290
-8613893462639,HTTP,1,2874640
-8615117035070,DNS,1,1310
-8613519003078,XiaYiDao,1,2485
-8613893853351,HTTP,1,6486
-8613649905753,HTTP_Browsing,1,2381
-8618794965341,DNS,1,4840
-8613993899110,SSL,1,4364
-8618393012284,QQ_Media,1,5700

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_028.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_028.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_028.csv
deleted file mode 100644
index 0a90713..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_028.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-MSISDN StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-8613993104233,DNS,1,280
-8613649905753,HTTP_Browsing,1,2381

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_029.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_029.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_029.csv
deleted file mode 100644
index f4dc63e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_029.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-MSISDN StringType,APP_SUB_CATEGORY_NAME StringType,msidn_number LongType,total LongType
-8613649905753,HTTP_Browsing,1,2381
-8613993104233,DNS,1,280

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_030.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_030.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_030.csv
deleted file mode 100644
index a6a31fd..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_030.csv
+++ /dev/null
@@ -1,20 +0,0 @@
-MSISDN StringType,RAT_NAME StringType,msidn_number LongType,total LongType
-8618794965341,GERAN,1,4840
-8613993676885,GERAN,1,73783
-8613893462639,GERAN,1,2874640
-8613993800024,GERAN,1,5044
-8618394185970,GERAN,1,23865
-8613893853351,GERAN,1,6486
-8613919791668,GERAN,1,928
-8613993104233,GERAN,1,280
-8613893600602,GERAN,1,2346
-8618393012284,GERAN,1,5700
-8613519003078,GERAN,1,2485
-8618793100458,GERAN,1,15112
-8615117035070,GERAN,1,1310
-8615120474362,GERAN,1,6936
-8613649905753,GERAN,1,2381
-8615209309657,GERAN,1,290
-8613993899110,GERAN,1,4364
-8618794812876,GERAN,1,14411
-8618700943475,GERAN,1,1185

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_031.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_031.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_031.csv
deleted file mode 100644
index 48729b2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_031.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-level StringType,total LongType,MSISDN_count LongType
-<1m,171746,18
-10M~1M,2874640,1

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_032.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_032.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_032.csv
deleted file mode 100644
index 3b913c4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_032.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-TERMINAL_TYPE StringType,msidn_number LongType,total LongType
-SMARTPHONE,1,5044

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_033.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_033.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_033.csv
deleted file mode 100644
index b391d21..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_033.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-TERMINAL_TYPE StringType,total LongType
-FEATURE PHONE,2485

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_034.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_034.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_034.csv
deleted file mode 100644
index 472dd00..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_034.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-TERMINAL_TYPE StringType,UP_THROUGHPUT IntegerType,total DoubleType
-SMARTPHONE,134,146

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_035.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_035.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_035.csv
deleted file mode 100644
index 1780d26..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_035.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-SOURCE_INFO StringType,APP_CATEGORY_ID StringType,RAT_NAME StringType,TERMINAL_TYPE StringType,UP_THROUGHPUT IntegerType,DOWN_THROUGHPUT DoubleType
-GN,2,GERAN,SMARTPHONE,13934,9931

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_036.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_036.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_036.csv
deleted file mode 100644
index 0b0b7d6..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_036.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-SOURCE_INFO StringType,APP_CATEGORY_ID StringType,APP_CATEGORY_NAME StringType,AREA_CODE StringType,CITY StringType,UP_THROUGHPUT IntegerType,DOWN_THROUGHPUT DoubleType
-GN,-1,,0930,\u4e34\u590f,200,90

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_037.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_037.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_037.csv
deleted file mode 100644
index 1d4d7d5..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_037.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-SOURCE_INFO StringType,APP_CATEGORY_ID StringType
-GN,-1

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_038.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_038.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_038.csv
deleted file mode 100644
index 35a7755..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_038.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-SOURCE_INFO StringType,APP_CATEGORY_ID StringType,TERMINAL_BRAND StringType,TERMINAL_MODEL StringType,UP_THROUGHPUT IntegerType,DOWN_THROUGHPUT DoubleType
-GN,-1,LENOVO,LENOVO A60,1662,684

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_039.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_039.csv b/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_039.csv
deleted file mode 100644
index 7e2d5a4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SmartPCC_Perf_TC_039.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-SOURCE_INFO StringType,APP_CATEGORY_ID StringType,CGI StringType,DAY StringType,HOUR StringType,MIN StringType,UP_THROUGHPUT IntegerType,DOWN_THROUGHPUT DoubleType
-GN,16,460003776906411,8-1,23,0,1647,2717

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_001.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_001.csv b/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_001.csv
deleted file mode 100644
index 6f58b03..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_001.csv
+++ /dev/null
@@ -1,31 +0,0 @@
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                  
-
-                                                                                               
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01   
-
-                                                                                                   
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                                                                           
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                                        
-
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                                         
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                                                 
-
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                                     
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                                       
-
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                                    
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                   
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                   
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01                  
-
-CREATE AGGREGATETABLE ActiveProvince,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01       
-
-CREATE AGGREGATETABLE Latest_province,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube my.Carbon01  
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_002.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_002.csv b/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_002.csv
deleted file mode 100644
index 31787f5..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_002.csv
+++ /dev/null
@@ -1,27 +0,0 @@
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber) from cube Carbon01                                                                                                                  
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                                                                                   
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                                                           
-
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                        
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                         
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                                    
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                     
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                        
-
-CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                                    
-
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                   
-
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryTime,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                  
-
- CREATE AGGREGATETABLE ActiveProvince,MAC,productionDate,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01            
-    
-CREATE AGGREGATETABLE ActiveProvince,MAC,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01                  
-
-CREATE AGGREGATETABLE ActiveProvince,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01       
-
-CREATE AGGREGATETABLE Latest_province,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber) from cube Carbon01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_003.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_003.csv b/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_003.csv
deleted file mode 100644
index 0357ae4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_003.csv
+++ /dev/null
@@ -1,31 +0,0 @@
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber)                                                                                                                  
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                         
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                                                          
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                        
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                         
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                                   
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                    
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                      
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                 
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                  
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                   
-
-
- ActiveProvince,MAC,productionDate,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                
-
-ActiveProvince,MAC,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                  
- ActiveProvince,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)       
- Latest_province,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_004.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_004.csv b/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_004.csv
deleted file mode 100644
index 0357ae4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_004.csv
+++ /dev/null
@@ -1,31 +0,0 @@
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber)                                                                                                                  
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                         
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                                                          
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                        
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                         
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                                   
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                    
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                      
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                 
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                  
-
-
-ActiveProvince,MAC,productionDate,deliveryTime,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                   
-
-
- ActiveProvince,MAC,productionDate,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                
-
-ActiveProvince,MAC,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                  
- ActiveProvince,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)       
- Latest_province,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_005.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_005.csv b/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_005.csv
deleted file mode 100644
index c47f48d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_005.csv
+++ /dev/null
@@ -1 +0,0 @@
-CREATE AGGREGATETABLE MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveProvince,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber) from cube Carbon01 
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_006.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_006.csv b/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_006.csv
deleted file mode 100644
index e600605..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_006.csv
+++ /dev/null
@@ -1 +0,0 @@
-MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveProvince,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_007.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_007.csv b/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_007.csv
deleted file mode 100644
index cf4dd92..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/SuggestAggregation/TC_007.csv
+++ /dev/null
@@ -1,16 +0,0 @@
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber)                                                                                                                  
-ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                                                                                   
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                                                           
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                        
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                          
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                                    
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_operaSysVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                     
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_EMUIVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                        
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                                    
- ActiveProvince,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                   
- ActiveProvince,MAC,productionDate,deliveryTime,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                   
- ActiveProvince,MAC,productionDate,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                
- ActiveProvince,MAC,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)                  
- ActiveProvince,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)       
- Latest_province,MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveCountry,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_country,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_phonePADPartitionedVersions,sum(gamePointId),sum(contractNumber)  
- MAC,productionDate,deliveryTime,deliveryCountry,ActiveCheckTime,ActiveProvince,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_phonePADPartitionedVersions,Latest_MONTH,Latest_DAY,Latest_EMUIVersion,Latest_BacVerNumber,sum(gamePointId),sum(contractNumber) 
\ No newline at end of file