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:14 UTC
[36/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/TC_271.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_271.csv b/integration-testcases/src/test/resources/hiveExpected/TC_271.csv
deleted file mode 100644
index ef0f7e2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_271.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,ActiveOperatorId StringType,ActiveProvince StringType,ActiveStreet StringType
-Chinese,hongshan,10,Hubei Province,hongshan
-Chinese,hongshan,100001,Hubei Province,hongshan
-Chinese,hongshan,100004,Hubei Province,hongshan
-Chinese,hongshan,100008,Hubei Province,hongshan
-Chinese,hongshan,100024,Hubei Province,hongshan
-Chinese,hongshan,100025,Hubei Province,hongshan
-Chinese,hongshan,100039,Hubei Province,hongshan
-Chinese,hongshan,100045,Hubei Province,hongshan
-Chinese,hongshan,100046,Hubei Province,hongshan
-Chinese,hongshan,100047,Hubei Province,hongshan
-Chinese,hongshan,100056,Hubei Province,hongshan
-Chinese,hongshan,100058,Hubei Province,hongshan
-Chinese,hongshan,10006,Hubei Province,hongshan
-Chinese,hongshan,100061,Hubei Province,hongshan
-Chinese,hongshan,100070,Hubei Province,hongshan
-Chinese,hongshan,100078,Hubei Province,hongshan
-Chinese,longgang,100013,Guangdong Province,matishan
-Chinese,longgang,100020,Guangdong Province,matishan
-Chinese,longgang,100028,Guangdong Province,matishan
-Chinese,longgang,100032,Guangdong Province,matishan
-Chinese,longgang,100035,Guangdong Province,matishan
-Chinese,longgang,10004,Guangdong Province,matishan
-Chinese,longgang,100044,Guangdong Province,matishan
-Chinese,longgang,100054,Guangdong Province,matishan
-Chinese,longgang,100060,Guangdong Province,matishan
-Chinese,longgang,100073,Guangdong Province,matishan
-Chinese,longgang,100074,Guangdong Province,matishan
-Chinese,longgang,100083,Guangdong Province,matishan
-Chinese,longhua,1,Guangdong Province,mingzhi
-Chinese,longhua,100010,Guangdong Province,mingzhi
-Chinese,longhua,100017,Guangdong Province,mingzhi
-Chinese,longhua,100022,Guangdong Province,mingzhi
-Chinese,longhua,100026,Guangdong Province,mingzhi
-Chinese,longhua,100030,Guangdong Province,mingzhi
-Chinese,longhua,100055,Guangdong Province,mingzhi
-Chinese,longhua,100075,Guangdong Province,mingzhi
-Chinese,tianyuan,100002,Hunan Province,tianyua
-Chinese,tianyuan,100003,Hunan Province,tianyua
-Chinese,tianyuan,100027,Hunan Province,tianyua
-Chinese,tianyuan,100042,Hunan Province,tianyua
-Chinese,tianyuan,10005,Hunan Province,tianyua
-Chinese,tianyuan,100052,Hunan Province,tianyua
-Chinese,tianyuan,100053,Hunan Province,tianyua
-Chinese,tianyuan,100062,Hunan Province,tianyua
-Chinese,tianyuan,100063,Hunan Province,tianyua
-Chinese,tianyuan,100081,Hunan Province,tianyua
-Chinese,xiangtan,10000,Hunan Province,jianshelu
-Chinese,xiangtan,1000000,Hunan Province,jianshelu
-Chinese,xiangtan,100007,Hunan Province,jianshelu
-Chinese,xiangtan,100009,Hunan Province,jianshelu
-Chinese,xiangtan,10001,Hunan Province,jianshelu
-Chinese,xiangtan,100011,Hunan Province,jianshelu
-Chinese,xiangtan,100012,Hunan Province,jianshelu
-Chinese,xiangtan,100016,Hunan Province,jianshelu
-Chinese,xiangtan,10003,Hunan Province,jianshelu
-Chinese,xiangtan,100031,Hunan Province,jianshelu
-Chinese,xiangtan,100038,Hunan Province,jianshelu
-Chinese,xiangtan,100041,Hunan Province,jianshelu
-Chinese,xiangtan,100048,Hunan Province,jianshelu
-Chinese,xiangtan,100049,Hunan Province,jianshelu
-Chinese,xiangtan,100051,Hunan Province,jianshelu
-Chinese,xiangtan,100059,Hunan Province,jianshelu
-Chinese,xiangtan,100068,Hunan Province,jianshelu
-Chinese,xiangtan,10007,Hunan Province,jianshelu
-Chinese,xiangtan,100072,Hunan Province,jianshelu
-Chinese,xiangtan,100080,Hunan Province,jianshelu
-Chinese,xiangtan,100082,Hunan Province,jianshelu
-Chinese,xiangtan,100084,Hunan Province,jianshelu
-Chinese,yichang,100,Hubei Province,yichang
-Chinese,yichang,100000,Hubei Province,yichang
-Chinese,yichang,100018,Hubei Province,yichang
-Chinese,yichang,10002,Hubei Province,yichang
-Chinese,yichang,100023,Hubei Province,yichang
-Chinese,yichang,100033,Hubei Province,yichang
-Chinese,yichang,100040,Hubei Province,yichang
-Chinese,yichang,100043,Hubei Province,yichang
-Chinese,yichang,100050,Hubei Province,yichang
-Chinese,yichang,100066,Hubei Province,yichang
-Chinese,yichang,100069,Hubei Province,yichang
-Chinese,yichang,100076,Hubei Province,yichang
-Chinese,yuhua,1000,Hunan Province,shazitang
-Chinese,yuhua,100005,Hunan Province,shazitang
-Chinese,yuhua,100006,Hunan Province,shazitang
-Chinese,yuhua,100014,Hunan Province,shazitang
-Chinese,yuhua,100015,Hunan Province,shazitang
-Chinese,yuhua,100019,Hunan Province,shazitang
-Chinese,yuhua,100021,Hunan Province,shazitang
-Chinese,yuhua,100029,Hunan Province,shazitang
-Chinese,yuhua,100034,Hunan Province,shazitang
-Chinese,yuhua,100036,Hunan Province,shazitang
-Chinese,yuhua,100037,Hunan Province,shazitang
-Chinese,yuhua,100057,Hunan Province,shazitang
-Chinese,yuhua,100064,Hunan Province,shazitang
-Chinese,yuhua,100065,Hunan Province,shazitang
-Chinese,yuhua,100067,Hunan Province,shazitang
-Chinese,yuhua,100071,Hunan Province,shazitang
-Chinese,yuhua,100077,Hunan Province,shazitang
-Chinese,yuhua,100079,Hunan Province,shazitang
-Chinese,yuhua,10008,Hunan Province,shazitang
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_272.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_272.csv b/integration-testcases/src/test/resources/hiveExpected/TC_272.csv
deleted file mode 100644
index 70ebed1..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_272.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,ActiveOperatorId StringType,ActiveProvince StringType,ActiveStreet StringType,Sum_gamePointId DoubleType
-Chinese,hongshan,10,Hubei Province,hongshan,1714.635
-Chinese,hongshan,100001,Hubei Province,hongshan,505.0
-Chinese,hongshan,100004,Hubei Province,hongshan,2970.0
-Chinese,hongshan,100008,Hubei Province,hongshan,1442.0
-Chinese,hongshan,100024,Hubei Province,hongshan,2483.0
-Chinese,hongshan,100025,Hubei Province,hongshan,1724.0
-Chinese,hongshan,100039,Hubei Province,hongshan,1750.0
-Chinese,hongshan,100045,Hubei Province,hongshan,2553.0
-Chinese,hongshan,100046,Hubei Province,hongshan,1077.0
-Chinese,hongshan,100047,Hubei Province,hongshan,1823.0
-Chinese,hongshan,100056,Hubei Province,hongshan,750.0
-Chinese,hongshan,100058,Hubei Province,hongshan,2635.0
-Chinese,hongshan,10006,Hubei Province,hongshan,2478.0
-Chinese,hongshan,100061,Hubei Province,hongshan,1407.0
-Chinese,hongshan,100070,Hubei Province,hongshan,1567.0
-Chinese,hongshan,100078,Hubei Province,hongshan,1434.0
-Chinese,longgang,100013,Guangdong Province,matishan,355.0
-Chinese,longgang,100020,Guangdong Province,matishan,256.0
-Chinese,longgang,100028,Guangdong Province,matishan,2849.0
-Chinese,longgang,100032,Guangdong Province,matishan,1053.0
-Chinese,longgang,100035,Guangdong Province,matishan,2142.0
-Chinese,longgang,10004,Guangdong Province,matishan,1717.0
-Chinese,longgang,100044,Guangdong Province,matishan,1697.0
-Chinese,longgang,100054,Guangdong Province,matishan,1368.0
-Chinese,longgang,100060,Guangdong Province,matishan,538.0
-Chinese,longgang,100073,Guangdong Province,matishan,2488.0
-Chinese,longgang,100074,Guangdong Province,matishan,907.0
-Chinese,longgang,100083,Guangdong Province,matishan,2192.0
-Chinese,longhua,1,Guangdong Province,mingzhi,2738.562
-Chinese,longhua,100010,Guangdong Province,mingzhi,79.0
-Chinese,longhua,100017,Guangdong Province,mingzhi,2205.0
-Chinese,longhua,100022,Guangdong Province,mingzhi,1999.0
-Chinese,longhua,100026,Guangdong Province,mingzhi,1768.0
-Chinese,longhua,100030,Guangdong Province,mingzhi,1333.0
-Chinese,longhua,100055,Guangdong Province,mingzhi,1728.0
-Chinese,longhua,100075,Guangdong Province,mingzhi,2507.0
-Chinese,tianyuan,100002,Hunan Province,tianyua,1341.0
-Chinese,tianyuan,100003,Hunan Province,tianyua,2239.0
-Chinese,tianyuan,100027,Hunan Province,tianyua,2436.0
-Chinese,tianyuan,100042,Hunan Province,tianyua,2745.0
-Chinese,tianyuan,10005,Hunan Province,tianyua,1608.0
-Chinese,tianyuan,100052,Hunan Province,tianyua,845.0
-Chinese,tianyuan,100053,Hunan Province,tianyua,1655.0
-Chinese,tianyuan,100062,Hunan Province,tianyua,2952.0
-Chinese,tianyuan,100063,Hunan Province,tianyua,1226.0
-Chinese,tianyuan,100081,Hunan Province,tianyua,613.0
-Chinese,xiangtan,10000,Hunan Province,jianshelu,2175.0
-Chinese,xiangtan,1000000,Hunan Province,jianshelu,1600.0
-Chinese,xiangtan,100007,Hunan Province,jianshelu,1991.0
-Chinese,xiangtan,100009,Hunan Province,jianshelu,1841.0
-Chinese,xiangtan,10001,Hunan Province,jianshelu,298.0
-Chinese,xiangtan,100011,Hunan Province,jianshelu,202.0
-Chinese,xiangtan,100012,Hunan Province,jianshelu,568.0
-Chinese,xiangtan,100016,Hunan Province,jianshelu,1873.0
-Chinese,xiangtan,10003,Hunan Province,jianshelu,2071.0
-Chinese,xiangtan,100031,Hunan Province,jianshelu,1080.0
-Chinese,xiangtan,100038,Hunan Province,jianshelu,1229.0
-Chinese,xiangtan,100041,Hunan Province,jianshelu,2734.0
-Chinese,xiangtan,100048,Hunan Province,jianshelu,2399.0
-Chinese,xiangtan,100049,Hunan Province,jianshelu,2890.0
-Chinese,xiangtan,100051,Hunan Province,jianshelu,1407.0
-Chinese,xiangtan,100059,Hunan Province,jianshelu,1337.0
-Chinese,xiangtan,100068,Hunan Province,jianshelu,412.0
-Chinese,xiangtan,10007,Hunan Province,jianshelu,1350.0
-Chinese,xiangtan,100072,Hunan Province,jianshelu,448.0
-Chinese,xiangtan,100080,Hunan Province,jianshelu,954.0
-Chinese,xiangtan,100082,Hunan Province,jianshelu,2348.0
-Chinese,xiangtan,100084,Hunan Province,jianshelu,2826.0
-Chinese,yichang,100,Hubei Province,yichang,1271.0
-Chinese,yichang,100000,Hubei Province,yichang,136.0
-Chinese,yichang,100018,Hubei Province,yichang,441.0
-Chinese,yichang,10002,Hubei Province,yichang,2972.0
-Chinese,yichang,100023,Hubei Province,yichang,2194.0
-Chinese,yichang,100033,Hubei Province,yichang,760.0
-Chinese,yichang,100040,Hubei Province,yichang,2078.0
-Chinese,yichang,100043,Hubei Province,yichang,571.0
-Chinese,yichang,100050,Hubei Province,yichang,29.0
-Chinese,yichang,100066,Hubei Province,yichang,1864.0
-Chinese,yichang,100069,Hubei Province,yichang,1491.0
-Chinese,yichang,100076,Hubei Province,yichang,732.0
-Chinese,yuhua,1000,Hunan Province,shazitang,692.0
-Chinese,yuhua,100005,Hunan Province,shazitang,2593.0
-Chinese,yuhua,100006,Hunan Province,shazitang,2572.0
-Chinese,yuhua,100014,Hunan Province,shazitang,151.0
-Chinese,yuhua,100015,Hunan Province,shazitang,2863.0
-Chinese,yuhua,100019,Hunan Province,shazitang,2194.0
-Chinese,yuhua,100021,Hunan Province,shazitang,1778.0
-Chinese,yuhua,100029,Hunan Province,shazitang,1691.0
-Chinese,yuhua,100034,Hunan Province,shazitang,2061.0
-Chinese,yuhua,100036,Hunan Province,shazitang,2224.0
-Chinese,yuhua,100037,Hunan Province,shazitang,1015.0
-Chinese,yuhua,100057,Hunan Province,shazitang,2288.0
-Chinese,yuhua,100064,Hunan Province,shazitang,865.0
-Chinese,yuhua,100065,Hunan Province,shazitang,901.0
-Chinese,yuhua,100067,Hunan Province,shazitang,572.0
-Chinese,yuhua,100071,Hunan Province,shazitang,1973.0
-Chinese,yuhua,100077,Hunan Province,shazitang,2077.0
-Chinese,yuhua,100079,Hunan Province,shazitang,1098.0
-Chinese,yuhua,10008,Hunan Province,shazitang,813.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_273.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_273.csv b/integration-testcases/src/test/resources/hiveExpected/TC_273.csv
deleted file mode 100644
index a22e16a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_273.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,ActiveOperatorId StringType,ActiveProvince StringType,ActiveStreet StringType,Avg_gamePointId DoubleType
-Chinese,hongshan,10,Hubei Province,hongshan,1714.635
-Chinese,hongshan,100001,Hubei Province,hongshan,505.0
-Chinese,hongshan,100004,Hubei Province,hongshan,2970.0
-Chinese,hongshan,100008,Hubei Province,hongshan,1442.0
-Chinese,hongshan,100024,Hubei Province,hongshan,2483.0
-Chinese,hongshan,100025,Hubei Province,hongshan,1724.0
-Chinese,hongshan,100039,Hubei Province,hongshan,1750.0
-Chinese,hongshan,100045,Hubei Province,hongshan,2553.0
-Chinese,hongshan,100046,Hubei Province,hongshan,1077.0
-Chinese,hongshan,100047,Hubei Province,hongshan,1823.0
-Chinese,hongshan,100056,Hubei Province,hongshan,750.0
-Chinese,hongshan,100058,Hubei Province,hongshan,2635.0
-Chinese,hongshan,10006,Hubei Province,hongshan,2478.0
-Chinese,hongshan,100061,Hubei Province,hongshan,1407.0
-Chinese,hongshan,100070,Hubei Province,hongshan,1567.0
-Chinese,hongshan,100078,Hubei Province,hongshan,1434.0
-Chinese,longgang,100013,Guangdong Province,matishan,355.0
-Chinese,longgang,100020,Guangdong Province,matishan,256.0
-Chinese,longgang,100028,Guangdong Province,matishan,2849.0
-Chinese,longgang,100032,Guangdong Province,matishan,1053.0
-Chinese,longgang,100035,Guangdong Province,matishan,2142.0
-Chinese,longgang,10004,Guangdong Province,matishan,1717.0
-Chinese,longgang,100044,Guangdong Province,matishan,1697.0
-Chinese,longgang,100054,Guangdong Province,matishan,1368.0
-Chinese,longgang,100060,Guangdong Province,matishan,538.0
-Chinese,longgang,100073,Guangdong Province,matishan,2488.0
-Chinese,longgang,100074,Guangdong Province,matishan,907.0
-Chinese,longgang,100083,Guangdong Province,matishan,2192.0
-Chinese,longhua,1,Guangdong Province,mingzhi,2738.562
-Chinese,longhua,100010,Guangdong Province,mingzhi,79.0
-Chinese,longhua,100017,Guangdong Province,mingzhi,2205.0
-Chinese,longhua,100022,Guangdong Province,mingzhi,1999.0
-Chinese,longhua,100026,Guangdong Province,mingzhi,1768.0
-Chinese,longhua,100030,Guangdong Province,mingzhi,1333.0
-Chinese,longhua,100055,Guangdong Province,mingzhi,1728.0
-Chinese,longhua,100075,Guangdong Province,mingzhi,2507.0
-Chinese,tianyuan,100002,Hunan Province,tianyua,1341.0
-Chinese,tianyuan,100003,Hunan Province,tianyua,2239.0
-Chinese,tianyuan,100027,Hunan Province,tianyua,2436.0
-Chinese,tianyuan,100042,Hunan Province,tianyua,2745.0
-Chinese,tianyuan,10005,Hunan Province,tianyua,1608.0
-Chinese,tianyuan,100052,Hunan Province,tianyua,845.0
-Chinese,tianyuan,100053,Hunan Province,tianyua,1655.0
-Chinese,tianyuan,100062,Hunan Province,tianyua,2952.0
-Chinese,tianyuan,100063,Hunan Province,tianyua,1226.0
-Chinese,tianyuan,100081,Hunan Province,tianyua,613.0
-Chinese,xiangtan,10000,Hunan Province,jianshelu,2175.0
-Chinese,xiangtan,1000000,Hunan Province,jianshelu,1600.0
-Chinese,xiangtan,100007,Hunan Province,jianshelu,1991.0
-Chinese,xiangtan,100009,Hunan Province,jianshelu,1841.0
-Chinese,xiangtan,10001,Hunan Province,jianshelu,298.0
-Chinese,xiangtan,100011,Hunan Province,jianshelu,202.0
-Chinese,xiangtan,100012,Hunan Province,jianshelu,568.0
-Chinese,xiangtan,100016,Hunan Province,jianshelu,1873.0
-Chinese,xiangtan,10003,Hunan Province,jianshelu,2071.0
-Chinese,xiangtan,100031,Hunan Province,jianshelu,1080.0
-Chinese,xiangtan,100038,Hunan Province,jianshelu,1229.0
-Chinese,xiangtan,100041,Hunan Province,jianshelu,2734.0
-Chinese,xiangtan,100048,Hunan Province,jianshelu,2399.0
-Chinese,xiangtan,100049,Hunan Province,jianshelu,2890.0
-Chinese,xiangtan,100051,Hunan Province,jianshelu,1407.0
-Chinese,xiangtan,100059,Hunan Province,jianshelu,1337.0
-Chinese,xiangtan,100068,Hunan Province,jianshelu,412.0
-Chinese,xiangtan,10007,Hunan Province,jianshelu,1350.0
-Chinese,xiangtan,100072,Hunan Province,jianshelu,448.0
-Chinese,xiangtan,100080,Hunan Province,jianshelu,954.0
-Chinese,xiangtan,100082,Hunan Province,jianshelu,2348.0
-Chinese,xiangtan,100084,Hunan Province,jianshelu,2826.0
-Chinese,yichang,100,Hubei Province,yichang,1271.0
-Chinese,yichang,100000,Hubei Province,yichang,136.0
-Chinese,yichang,100018,Hubei Province,yichang,441.0
-Chinese,yichang,10002,Hubei Province,yichang,2972.0
-Chinese,yichang,100023,Hubei Province,yichang,2194.0
-Chinese,yichang,100033,Hubei Province,yichang,760.0
-Chinese,yichang,100040,Hubei Province,yichang,2078.0
-Chinese,yichang,100043,Hubei Province,yichang,571.0
-Chinese,yichang,100050,Hubei Province,yichang,29.0
-Chinese,yichang,100066,Hubei Province,yichang,1864.0
-Chinese,yichang,100069,Hubei Province,yichang,1491.0
-Chinese,yichang,100076,Hubei Province,yichang,732.0
-Chinese,yuhua,1000,Hunan Province,shazitang,692.0
-Chinese,yuhua,100005,Hunan Province,shazitang,2593.0
-Chinese,yuhua,100006,Hunan Province,shazitang,2572.0
-Chinese,yuhua,100014,Hunan Province,shazitang,151.0
-Chinese,yuhua,100015,Hunan Province,shazitang,2863.0
-Chinese,yuhua,100019,Hunan Province,shazitang,2194.0
-Chinese,yuhua,100021,Hunan Province,shazitang,1778.0
-Chinese,yuhua,100029,Hunan Province,shazitang,1691.0
-Chinese,yuhua,100034,Hunan Province,shazitang,2061.0
-Chinese,yuhua,100036,Hunan Province,shazitang,2224.0
-Chinese,yuhua,100037,Hunan Province,shazitang,1015.0
-Chinese,yuhua,100057,Hunan Province,shazitang,2288.0
-Chinese,yuhua,100064,Hunan Province,shazitang,865.0
-Chinese,yuhua,100065,Hunan Province,shazitang,901.0
-Chinese,yuhua,100067,Hunan Province,shazitang,572.0
-Chinese,yuhua,100071,Hunan Province,shazitang,1973.0
-Chinese,yuhua,100077,Hunan Province,shazitang,2077.0
-Chinese,yuhua,100079,Hunan Province,shazitang,1098.0
-Chinese,yuhua,10008,Hunan Province,shazitang,813.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_274.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_274.csv b/integration-testcases/src/test/resources/hiveExpected/TC_274.csv
deleted file mode 100644
index aac0478..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_274.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,Activecity StringType,Sum_gamepointid DoubleType
-Chinese,hongshan,wuhan,28312.635000000002
-Chinese,longgang,shenzhen,17562.0
-Chinese,yichang,yichang,14539.0
-Chinese,tianyuan,zhuzhou,17660.0
-Chinese,yuhua,changsha,30421.0
-Chinese,xiangtan,xiangtan,34033.0
-Chinese,longhua,guangzhou,14357.562
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_275.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_275.csv b/integration-testcases/src/test/resources/hiveExpected/TC_275.csv
deleted file mode 100644
index 637ee8c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_275.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-Latest_country StringType,Latest_city StringType,Latest_district StringType,Sum_gamepointid DoubleType
-Chinese,changsha,yuhua,26119.0
-Chinese,guangzhou,longhua,31520.561999999998
-Chinese,shenzhen,longgang,19969.0
-Chinese,wuhan,hongshan,18381.0
-Chinese,xiangtan,xiangtan,24753.635000000002
-Chinese,yichang,yichang,28467.0
-Chinese,zhuzhou,tianyuan,7675.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_276.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_276.csv b/integration-testcases/src/test/resources/hiveExpected/TC_276.csv
deleted file mode 100644
index 4acf79b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_276.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-Activecity StringType,ActiveCountry StringType,ActiveDistrict StringType,Count_imei LongType
-changsha,Chinese,yuhua,19
-guangzhou,Chinese,longhua,8
-shenzhen,Chinese,longgang,12
-wuhan,Chinese,hongshan,16
-xiangtan,Chinese,xiangtan,22
-yichang,Chinese,yichang,12
-zhuzhou,Chinese,tianyuan,10
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_277.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_277.csv b/integration-testcases/src/test/resources/hiveExpected/TC_277.csv
deleted file mode 100644
index 31ad275..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_277.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-Activecity StringType,ActiveCountry StringType,ActiveDistrict StringType,Max_gmaepointid DoubleType
-changsha,Chinese,yuhua,2863.0
-guangzhou,Chinese,longhua,2738.562
-shenzhen,Chinese,longgang,2849.0
-wuhan,Chinese,hongshan,2970.0
-xiangtan,Chinese,xiangtan,2890.0
-yichang,Chinese,yichang,2972.0
-zhuzhou,Chinese,tianyuan,2952.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_278.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_278.csv b/integration-testcases/src/test/resources/hiveExpected/TC_278.csv
deleted file mode 100644
index 66099fe..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_278.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-Activecity StringType,ActiveCountry StringType,ActiveDistrict StringType,Min_gamepointid DoubleType
-changsha,Chinese,yuhua,151.0
-guangzhou,Chinese,longhua,79.0
-shenzhen,Chinese,longgang,256.0
-wuhan,Chinese,hongshan,505.0
-xiangtan,Chinese,xiangtan,202.0
-yichang,Chinese,yichang,29.0
-zhuzhou,Chinese,tianyuan,613.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_279.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_279.csv b/integration-testcases/src/test/resources/hiveExpected/TC_279.csv
deleted file mode 100644
index e1789e2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_279.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveCountry StringType,DistinctCount_imei LongType
-Chinese,99
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_280.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_280.csv b/integration-testcases/src/test/resources/hiveExpected/TC_280.csv
deleted file mode 100644
index 91b2ed5..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_280.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-Activecity StringType,imei StringType,ActiveCountry StringType,ActiveDistrict StringType
-wuhan,1AA10,Chinese,hongshan
-wuhan,1AA100001,Chinese,hongshan
-wuhan,1AA100004,Chinese,hongshan
-wuhan,1AA100008,Chinese,hongshan
-wuhan,1AA100024,Chinese,hongshan
-wuhan,1AA100025,Chinese,hongshan
-wuhan,1AA100039,Chinese,hongshan
-wuhan,1AA100045,Chinese,hongshan
-wuhan,1AA100046,Chinese,hongshan
-wuhan,1AA100047,Chinese,hongshan
-wuhan,1AA100056,Chinese,hongshan
-wuhan,1AA100058,Chinese,hongshan
-wuhan,1AA10006,Chinese,hongshan
-wuhan,1AA100061,Chinese,hongshan
-wuhan,1AA100070,Chinese,hongshan
-wuhan,1AA100078,Chinese,hongshan
-shenzhen,1AA100013,Chinese,longgang
-shenzhen,1AA100020,Chinese,longgang
-shenzhen,1AA100028,Chinese,longgang
-shenzhen,1AA100032,Chinese,longgang
-shenzhen,1AA100035,Chinese,longgang
-shenzhen,1AA10004,Chinese,longgang
-shenzhen,1AA100044,Chinese,longgang
-shenzhen,1AA100054,Chinese,longgang
-shenzhen,1AA100060,Chinese,longgang
-shenzhen,1AA100073,Chinese,longgang
-shenzhen,1AA100074,Chinese,longgang
-shenzhen,1AA100083,Chinese,longgang
-guangzhou,1AA100055,Chinese,longhua
-guangzhou,1AA100075,Chinese,longhua
-guangzhou,1AA1,Chinese,longhua
-guangzhou,1AA100010,Chinese,longhua
-guangzhou,1AA100017,Chinese,longhua
-guangzhou,1AA100022,Chinese,longhua
-guangzhou,1AA100026,Chinese,longhua
-guangzhou,1AA100030,Chinese,longhua
-zhuzhou,1AA100002,Chinese,tianyuan
-zhuzhou,1AA100003,Chinese,tianyuan
-zhuzhou,1AA100027,Chinese,tianyuan
-zhuzhou,1AA100042,Chinese,tianyuan
-zhuzhou,1AA10005,Chinese,tianyuan
-zhuzhou,1AA100052,Chinese,tianyuan
-zhuzhou,1AA100053,Chinese,tianyuan
-zhuzhou,1AA100062,Chinese,tianyuan
-zhuzhou,1AA100063,Chinese,tianyuan
-zhuzhou,1AA100081,Chinese,tianyuan
-xiangtan,1AA10000,Chinese,xiangtan
-xiangtan,1AA1000000,Chinese,xiangtan
-xiangtan,1AA100007,Chinese,xiangtan
-xiangtan,1AA100009,Chinese,xiangtan
-xiangtan,1AA10001,Chinese,xiangtan
-xiangtan,1AA100011,Chinese,xiangtan
-xiangtan,1AA100012,Chinese,xiangtan
-xiangtan,1AA100016,Chinese,xiangtan
-xiangtan,1AA10003,Chinese,xiangtan
-xiangtan,1AA100031,Chinese,xiangtan
-xiangtan,1AA100038,Chinese,xiangtan
-xiangtan,1AA100041,Chinese,xiangtan
-xiangtan,1AA100048,Chinese,xiangtan
-xiangtan,1AA100049,Chinese,xiangtan
-xiangtan,1AA100051,Chinese,xiangtan
-xiangtan,1AA100059,Chinese,xiangtan
-xiangtan,1AA100068,Chinese,xiangtan
-xiangtan,1AA10007,Chinese,xiangtan
-xiangtan,1AA100072,Chinese,xiangtan
-xiangtan,1AA100080,Chinese,xiangtan
-xiangtan,1AA100082,Chinese,xiangtan
-xiangtan,1AA100084,Chinese,xiangtan
-yichang,1AA100040,Chinese,yichang
-yichang,1AA100043,Chinese,yichang
-yichang,1AA100050,Chinese,yichang
-yichang,1AA100066,Chinese,yichang
-yichang,1AA100069,Chinese,yichang
-yichang,1AA100076,Chinese,yichang
-yichang,1AA100,Chinese,yichang
-yichang,1AA100000,Chinese,yichang
-yichang,1AA100018,Chinese,yichang
-yichang,1AA10002,Chinese,yichang
-yichang,1AA100023,Chinese,yichang
-yichang,1AA100033,Chinese,yichang
-changsha,1AA100057,Chinese,yuhua
-changsha,1AA100064,Chinese,yuhua
-changsha,1AA100065,Chinese,yuhua
-changsha,1AA100067,Chinese,yuhua
-changsha,1AA100071,Chinese,yuhua
-changsha,1AA100077,Chinese,yuhua
-changsha,1AA100079,Chinese,yuhua
-changsha,1AA10008,Chinese,yuhua
-changsha,1AA1000,Chinese,yuhua
-changsha,1AA100005,Chinese,yuhua
-changsha,1AA100006,Chinese,yuhua
-changsha,1AA100014,Chinese,yuhua
-changsha,1AA100015,Chinese,yuhua
-changsha,1AA100019,Chinese,yuhua
-changsha,1AA100021,Chinese,yuhua
-changsha,1AA100029,Chinese,yuhua
-changsha,1AA100034,Chinese,yuhua
-changsha,1AA100036,Chinese,yuhua
-changsha,1AA100037,Chinese,yuhua
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_281.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_281.csv b/integration-testcases/src/test/resources/hiveExpected/TC_281.csv
deleted file mode 100644
index 861857e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_281.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-Activecity StringType,ActiveCountry StringType,ActiveDistrict StringType,Min_imei StringType,Max_imei StringType
-changsha,Chinese,yuhua,1AA1000,1AA10008
-guangzhou,Chinese,longhua,1AA1,1AA100075
-shenzhen,Chinese,longgang,1AA100013,1AA100083
-wuhan,Chinese,hongshan,1AA10,1AA100078
-xiangtan,Chinese,xiangtan,1AA10000,1AA100084
-yichang,Chinese,yichang,1AA100,1AA100076
-zhuzhou,Chinese,tianyuan,1AA100002,1AA100081
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_282.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_282.csv b/integration-testcases/src/test/resources/hiveExpected/TC_282.csv
deleted file mode 100644
index db7dac4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_282.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,Activecity StringType,Sum_gamepointid DoubleType
-Chinese,hongshan,wuhan,28312.635000000002
-Chinese,longgang,shenzhen,17562.0
-Chinese,longhua,guangzhou,14357.562
-Chinese,tianyuan,zhuzhou,17660.0
-Chinese,xiangtan,xiangtan,34033.0
-Chinese,yichang,yichang,14539.0
-Chinese,yuhua,changsha,30421.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_283.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_283.csv b/integration-testcases/src/test/resources/hiveExpected/TC_283.csv
deleted file mode 100644
index a8819db..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_283.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-AMSize StringType,total DoubleType
-0RAM size,1.742632E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_284.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_284.csv b/integration-testcases/src/test/resources/hiveExpected/TC_284.csv
deleted file mode 100644
index 76f756c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_284.csv
+++ /dev/null
@@ -1,9 +0,0 @@
-AMSize StringType,total DoubleType
-4RAM size,1.6792444E7
-6RAM size,1.0819629E7
-7RAM size,8232606.0
-3RAM size,6417154.0
-5RAM size,6385639.0
-0RAM size,6171950.0
-9RAM size,5660804.0
-8RAM size,5284541.562
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_285.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_285.csv b/integration-testcases/src/test/resources/hiveExpected/TC_285.csv
deleted file mode 100644
index 76f756c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_285.csv
+++ /dev/null
@@ -1,9 +0,0 @@
-AMSize StringType,total DoubleType
-4RAM size,1.6792444E7
-6RAM size,1.0819629E7
-7RAM size,8232606.0
-3RAM size,6417154.0
-5RAM size,6385639.0
-0RAM size,6171950.0
-9RAM size,5660804.0
-8RAM size,5284541.562
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_286.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_286.csv b/integration-testcases/src/test/resources/hiveExpected/TC_286.csv
deleted file mode 100644
index 282c12a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_286.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveAreaId StringType,AMSize_number LongType,total DoubleType
-1,7,4.8863556E7
-2,7,4.1185336562E7
-3,8,1.00876754E8
-4,7,1.02219772E8
-5,6,3.8359697E7
-6,8,7.662756463499999E7
-7,6,6.7214095E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_287.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_287.csv b/integration-testcases/src/test/resources/hiveExpected/TC_287.csv
deleted file mode 100644
index fa43bc3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_287.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveAreaId StringType,AMSize_number LongType,total DoubleType
-6,8,7.662756463499999E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_288.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_288.csv b/integration-testcases/src/test/resources/hiveExpected/TC_288.csv
deleted file mode 100644
index 282c12a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_288.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveAreaId StringType,AMSize_number LongType,total DoubleType
-1,7,4.8863556E7
-2,7,4.1185336562E7
-3,8,1.00876754E8
-4,7,1.02219772E8
-5,6,3.8359697E7
-6,8,7.662756463499999E7
-7,6,6.7214095E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_289.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_289.csv b/integration-testcases/src/test/resources/hiveExpected/TC_289.csv
deleted file mode 100644
index fa43bc3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_289.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveAreaId StringType,AMSize_number LongType,total DoubleType
-6,8,7.662756463499999E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_290.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_290.csv b/integration-testcases/src/test/resources/hiveExpected/TC_290.csv
deleted file mode 100644
index 5f55376..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_290.csv
+++ /dev/null
@@ -1,4 +0,0 @@
-ActiveProvince StringType,AMSize_number LongType,total DoubleType
-Hunan Province,10,2.41456223E8
-Guangdong Province,8,9.0048892562E7
-Hubei Province,9,1.43841659635E8
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_291.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_291.csv b/integration-testcases/src/test/resources/hiveExpected/TC_291.csv
deleted file mode 100644
index 25449ba..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_291.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-AMSize StringType,imei_number LongType,total DoubleType
-0RAM size,11,5.437552E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_292.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_292.csv b/integration-testcases/src/test/resources/hiveExpected/TC_292.csv
deleted file mode 100644
index 5f55376..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_292.csv
+++ /dev/null
@@ -1,4 +0,0 @@
-ActiveProvince StringType,AMSize_number LongType,total DoubleType
-Hunan Province,10,2.41456223E8
-Guangdong Province,8,9.0048892562E7
-Hubei Province,9,1.43841659635E8
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_293.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_293.csv b/integration-testcases/src/test/resources/hiveExpected/TC_293.csv
deleted file mode 100644
index f95f9e7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_293.csv
+++ /dev/null
@@ -1,4 +0,0 @@
-ActiveProvince StringType,AMSize_number LongType,total DoubleType
-Hubei Province,3,2.3775647E7
-Hunan Province,3,2.3622422E7
-Guangdong Province,3,1.8366698562E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_294.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_294.csv b/integration-testcases/src/test/resources/hiveExpected/TC_294.csv
deleted file mode 100644
index 46bd39f..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_294.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-ActiveOperatorId StringType,AMSize_number LongType,total DoubleType
-100007,1,337574.0
-100008,1,1072199.0
-100009,1,2391498.0
-100070,1,4204181.0
-100071,1,2201930.0
-100072,1,511576.0
-100073,1,583100.0
-100074,1,276249.0
-100075,1,3217834.0
-100076,1,8070591.0
-100077,1,6385639.0
-100078,1,6429950.0
-100079,1,5160219.0
-100010,1,8543359.0
-100011,1,4816462.0
-100012,1,8454563.0
-100013,1,2051894.0
-100014,1,7610226.0
-100015,1,6665954.0
-100016,1,6497165.0
-100017,1,2613669.0
-100018,1,574816.0
-100019,1,4461270.0
-100080,1,5153939.0
-100081,1,3336093.0
-100082,1,997163.0
-100083,1,509421.0
-100084,1,8979394.0
-1,1,5284541.562
-100020,1,833910.0
-100021,1,568695.0
-100022,1,834386.0
-100023,1,2852440.0
-100024,1,6171950.0
-100025,1,6535623.0
-100026,1,7488902.0
-100027,1,4752675.0
-100028,1,8882961.0
-100029,1,7776281.0
-10000,1,3787033.0
-10001,1,5986487.0
-10002,1,5207711.0
-10003,1,5588789.0
-10004,1,3079020.0
-100030,1,5858596.0
-10005,1,6191676.0
-100031,1,6417154.0
-10006,1,9397210.0
-10007,1,4157689.0
-100032,1,6995116.0
-10008,1,3361201.0
-100033,1,8230567.0
-100034,1,5799140.0
-100035,1,6285204.0
-100036,1,8433994.0
-100037,1,3312327.0
-100038,1,2845110.0
-100039,1,1903639.0
-10,1,6807314.635
-1000000,1,9739368.0
-1000,1,8979457.0
-100040,1,7882517.0
-100041,1,3457065.0
-100042,1,25995.0
-100043,1,3278738.0
-100044,1,5660804.0
-100045,1,9954785.0
-100046,1,426000.0
-100047,1,7841745.0
-100048,1,9502885.0
-100049,1,1954940.0
-100050,1,7768497.0
-100051,1,7238326.0
-100052,1,168570.0
-100053,1,2652739.0
-100054,1,6284524.0
-100055,1,7344049.0
-100056,1,1754573.0
-100057,1,5453821.0
-100058,1,5405743.0
-100059,1,170094.0
-100060,1,7421353.0
-100061,1,4360028.0
-100062,1,2365066.0
-100063,1,9319460.0
-100064,1,5566105.0
-100065,1,3167625.0
-100066,1,5594321.0
-100,1,8232606.0
-100067,1,7575768.0
-100068,1,3235498.0
-100069,1,7918697.0
-100000,1,1602594.0
-100001,1,2920291.0
-100002,1,9456953.0
-100003,1,90470.0
-100004,1,1442333.0
-100005,1,3943313.0
-100006,1,4453789.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_295.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_295.csv b/integration-testcases/src/test/resources/hiveExpected/TC_295.csv
deleted file mode 100644
index b172746..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_295.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveOperatorId StringType,AMSize_number LongType,total DoubleType
-100000,1,1602594.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_296.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_296.csv b/integration-testcases/src/test/resources/hiveExpected/TC_296.csv
deleted file mode 100644
index 282c12a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_296.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveAreaId StringType,AMSize_number LongType,total DoubleType
-1,7,4.8863556E7
-2,7,4.1185336562E7
-3,8,1.00876754E8
-4,7,1.02219772E8
-5,6,3.8359697E7
-6,8,7.662756463499999E7
-7,6,6.7214095E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_297.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_297.csv b/integration-testcases/src/test/resources/hiveExpected/TC_297.csv
deleted file mode 100644
index 99a361a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_297.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-Latest_DAY IntegerType,Latest_HOUR StringType,AMSize_number LongType,total DoubleType
-1,12,10,4.75346775197E8
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_298.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_298.csv b/integration-testcases/src/test/resources/hiveExpected/TC_298.csv
deleted file mode 100644
index 99a361a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_298.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-Latest_DAY IntegerType,Latest_HOUR StringType,AMSize_number LongType,total DoubleType
-1,12,10,4.75346775197E8
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_299.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_299.csv b/integration-testcases/src/test/resources/hiveExpected/TC_299.csv
deleted file mode 100644
index 1598a65..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_299.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-Activecity StringType,ActiveProvince StringType,AMSize_number LongType,total DoubleType
-xiangtan,Hunan Province,7,1.02219772E8
-yichang,Hubei Province,6,6.7214095E7
-shenzhen,Guangdong Province,7,4.8863556E7
-zhuzhou,Hunan Province,6,3.8359697E7
-changsha,Hunan Province,8,1.00876754E8
-guangzhou,Guangdong Province,7,4.1185336562E7
-wuhan,Hubei Province,8,7.662756463499999E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_300.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_300.csv b/integration-testcases/src/test/resources/hiveExpected/TC_300.csv
deleted file mode 100644
index 3057af4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_300.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-Activecity StringType,ActiveProvince StringType,AMSize_number LongType,total DoubleType
-shenzhen,Guangdong Province,7,4.8863556E7
-guangzhou,Guangdong Province,7,4.1185336562E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_301.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_301.csv b/integration-testcases/src/test/resources/hiveExpected/TC_301.csv
deleted file mode 100644
index 2560b85..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_301.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-ActiveOperatorId StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-100066,yichang,1,5594321.0
-10002,yichang,1,5207711.0
-100069,yichang,1,7918697.0
-100021,changsha,1,568695.0
-100002,zhuzhou,1,9456953.0
-100000,yichang,1,1602594.0
-100003,zhuzhou,1,90470.0
-100029,changsha,1,7776281.0
-100083,shenzhen,1,509421.0
-100061,wuhan,1,4360028.0
-100022,guangzhou,1,834386.0
-100026,guangzhou,1,7488902.0
-100020,shenzhen,1,833910.0
-10000,xiangtan,1,3787033.0
-10001,xiangtan,1,5986487.0
-100001,wuhan,1,2920291.0
-100068,xiangtan,1,3235498.0
-10003,xiangtan,1,5588789.0
-100004,wuhan,1,1442333.0
-100076,yichang,1,8070591.0
-100028,shenzhen,1,8882961.0
-10007,xiangtan,1,4157689.0
-100008,wuhan,1,1072199.0
-100034,changsha,1,5799140.0
-100036,changsha,1,8433994.0
-100037,changsha,1,3312327.0
-100007,xiangtan,1,337574.0
-100009,xiangtan,1,2391498.0
-100070,wuhan,1,4204181.0
-100030,guangzhou,1,5858596.0
-100018,yichang,1,574816.0
-1000000,xiangtan,1,9739368.0
-100078,wuhan,1,6429950.0
-100072,xiangtan,1,511576.0
-10004,shenzhen,1,3079020.0
-100081,zhuzhou,1,3336093.0
-100032,shenzhen,1,6995116.0
-100035,shenzhen,1,6285204.0
-100011,xiangtan,1,4816462.0
-100012,xiangtan,1,8454563.0
-100016,xiangtan,1,6497165.0
-100023,yichang,1,2852440.0
-100027,zhuzhou,1,4752675.0
-100080,xiangtan,1,5153939.0
-100082,xiangtan,1,997163.0
-100084,xiangtan,1,8979394.0
-100044,shenzhen,1,5660804.0
-100024,wuhan,1,6171950.0
-100025,wuhan,1,6535623.0
-10005,zhuzhou,1,6191676.0
-100057,changsha,1,5453821.0
-100,yichang,1,8232606.0
-100033,yichang,1,8230567.0
-100055,guangzhou,1,7344049.0
-1,guangzhou,1,5284541.562
-10006,wuhan,1,9397210.0
-100054,shenzhen,1,6284524.0
-100031,xiangtan,1,6417154.0
-100039,wuhan,1,1903639.0
-10,wuhan,1,6807314.635
-100064,changsha,1,5566105.0
-100065,changsha,1,3167625.0
-100040,yichang,1,7882517.0
-100042,zhuzhou,1,25995.0
-100067,changsha,1,7575768.0
-100038,xiangtan,1,2845110.0
-100043,yichang,1,3278738.0
-10008,changsha,1,3361201.0
-100005,changsha,1,3943313.0
-100006,changsha,1,4453789.0
-100060,shenzhen,1,7421353.0
-100045,wuhan,1,9954785.0
-100046,wuhan,1,426000.0
-100047,wuhan,1,7841745.0
-100041,xiangtan,1,3457065.0
-100071,changsha,1,2201930.0
-100052,zhuzhou,1,168570.0
-100050,yichang,1,7768497.0
-100077,changsha,1,6385639.0
-1000,changsha,1,8979457.0
-100053,zhuzhou,1,2652739.0
-100048,xiangtan,1,9502885.0
-100049,xiangtan,1,1954940.0
-100079,changsha,1,5160219.0
-100075,guangzhou,1,3217834.0
-100014,changsha,1,7610226.0
-100015,changsha,1,6665954.0
-100019,changsha,1,4461270.0
-100010,guangzhou,1,8543359.0
-100073,shenzhen,1,583100.0
-100074,shenzhen,1,276249.0
-100056,wuhan,1,1754573.0
-100051,xiangtan,1,7238326.0
-100017,guangzhou,1,2613669.0
-100058,wuhan,1,5405743.0
-100062,zhuzhou,1,2365066.0
-100063,zhuzhou,1,9319460.0
-100013,shenzhen,1,2051894.0
-100059,xiangtan,1,170094.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_302.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_302.csv b/integration-testcases/src/test/resources/hiveExpected/TC_302.csv
deleted file mode 100644
index ad059cc..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_302.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveOperatorId StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-100004,wuhan,1,1442333.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_303.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_303.csv b/integration-testcases/src/test/resources/hiveExpected/TC_303.csv
deleted file mode 100644
index 11e06de..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_303.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveAreaId StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-1,shenzhen,7,4.8863556E7
-5,zhuzhou,6,3.8359697E7
-6,wuhan,8,7.662756463499999E7
-3,changsha,8,1.00876754E8
-2,guangzhou,7,4.1185336562E7
-7,yichang,6,6.7214095E7
-4,xiangtan,7,1.02219772E8
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_304.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_304.csv b/integration-testcases/src/test/resources/hiveExpected/TC_304.csv
deleted file mode 100644
index 3c8bf87..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_304.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveAreaId StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-6,wuhan,8,7.662756463499999E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_305.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_305.csv b/integration-testcases/src/test/resources/hiveExpected/TC_305.csv
deleted file mode 100644
index 11e06de..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_305.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveAreaId StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-1,shenzhen,7,4.8863556E7
-5,zhuzhou,6,3.8359697E7
-6,wuhan,8,7.662756463499999E7
-3,changsha,8,1.00876754E8
-2,guangzhou,7,4.1185336562E7
-7,yichang,6,6.7214095E7
-4,xiangtan,7,1.02219772E8
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_306.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_306.csv b/integration-testcases/src/test/resources/hiveExpected/TC_306.csv
deleted file mode 100644
index 0c4bb6b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_306.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-ActiveAreaId StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-7,yichang,1,1602594.0
-6,wuhan,1,1442333.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_307.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_307.csv b/integration-testcases/src/test/resources/hiveExpected/TC_307.csv
deleted file mode 100644
index 437b1af..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_307.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-ActiveOperatorId StringType,ActiveAreaId StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-100043,7,yichang,1,3278738.0
-100082,4,xiangtan,1,997163.0
-100016,4,xiangtan,1,6497165.0
-100081,5,zhuzhou,1,3336093.0
-100076,7,yichang,1,8070591.0
-100019,3,changsha,1,4461270.0
-10004,1,shenzhen,1,3079020.0
-10,6,wuhan,1,6807314.635
-100042,5,zhuzhou,1,25995.0
-100070,6,wuhan,1,4204181.0
-100038,4,xiangtan,1,2845110.0
-100004,6,wuhan,1,1442333.0
-100013,1,shenzhen,1,2051894.0
-10006,6,wuhan,1,9397210.0
-10003,4,xiangtan,1,5588789.0
-100074,1,shenzhen,1,276249.0
-100053,5,zhuzhou,1,2652739.0
-100049,4,xiangtan,1,1954940.0
-100003,5,zhuzhou,1,90470.0
-10005,5,zhuzhou,1,6191676.0
-10002,7,yichang,1,5207711.0
-100057,3,changsha,1,5453821.0
-100031,4,xiangtan,1,6417154.0
-100035,1,shenzhen,1,6285204.0
-1000,3,changsha,1,8979457.0
-100034,3,changsha,1,5799140.0
-100079,3,changsha,1,5160219.0
-100029,3,changsha,1,7776281.0
-100073,1,shenzhen,1,583100.0
-100052,5,zhuzhou,1,168570.0
-100048,4,xiangtan,1,9502885.0
-100002,5,zhuzhou,1,9456953.0
-100080,4,xiangtan,1,5153939.0
-100063,5,zhuzhou,1,9319460.0
-100059,4,xiangtan,1,170094.0
-100025,6,wuhan,1,6535623.0
-100006,3,changsha,1,4453789.0
-100009,4,xiangtan,1,2391498.0
-100067,3,changsha,1,7575768.0
-100041,4,xiangtan,1,3457065.0
-100022,2,guangzhou,1,834386.0
-100069,7,yichang,1,7918697.0
-100047,6,wuhan,1,7841745.0
-100040,7,yichang,1,7882517.0
-10001,4,xiangtan,1,5986487.0
-100017,2,guangzhou,1,2613669.0
-100058,6,wuhan,1,5405743.0
-100083,1,shenzhen,1,509421.0
-100062,5,zhuzhou,1,2365066.0
-100008,6,wuhan,1,1072199.0
-100071,3,changsha,1,2201930.0
-100024,6,wuhan,1,6171950.0
-10007,4,xiangtan,1,4157689.0
-100005,3,changsha,1,3943313.0
-100021,3,changsha,1,568695.0
-100010,2,guangzhou,1,8543359.0
-100055,2,guangzhou,1,7344049.0
-100028,1,shenzhen,1,8882961.0
-100044,1,shenzhen,1,5660804.0
-100060,1,shenzhen,1,7421353.0
-100077,3,changsha,1,6385639.0
-100023,7,yichang,1,2852440.0
-100051,4,xiangtan,1,7238326.0
-100001,6,wuhan,1,2920291.0
-100046,6,wuhan,1,426000.0
-10000,4,xiangtan,1,3787033.0
-1000000,4,xiangtan,1,9739368.0
-100018,7,yichang,1,574816.0
-100050,7,yichang,1,7768497.0
-100012,4,xiangtan,1,8454563.0
-100000,7,yichang,1,1602594.0
-1,2,guangzhou,1,5284541.562
-100032,1,shenzhen,1,6995116.0
-100007,4,xiangtan,1,337574.0
-100065,3,changsha,1,3167625.0
-100068,4,xiangtan,1,3235498.0
-100084,4,xiangtan,1,8979394.0
-100015,3,changsha,1,6665954.0
-100045,6,wuhan,1,9954785.0
-100054,1,shenzhen,1,6284524.0
-100061,6,wuhan,1,4360028.0
-100033,7,yichang,1,8230567.0
-100056,6,wuhan,1,1754573.0
-100020,1,shenzhen,1,833910.0
-100037,3,changsha,1,3312327.0
-100026,2,guangzhou,1,7488902.0
-100011,4,xiangtan,1,4816462.0
-100072,4,xiangtan,1,511576.0
-100064,3,changsha,1,5566105.0
-100078,6,wuhan,1,6429950.0
-100014,3,changsha,1,7610226.0
-100,7,yichang,1,8232606.0
-10008,3,changsha,1,3361201.0
-100066,7,yichang,1,5594321.0
-100039,6,wuhan,1,1903639.0
-100030,2,guangzhou,1,5858596.0
-100075,2,guangzhou,1,3217834.0
-100027,5,zhuzhou,1,4752675.0
-100036,3,changsha,1,8433994.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_308.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_308.csv b/integration-testcases/src/test/resources/hiveExpected/TC_308.csv
deleted file mode 100644
index 1cd91a0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_308.csv
+++ /dev/null
@@ -1,50 +0,0 @@
-AMSize StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-7RAM size,yichang,14,1.15242211E8
-0RAM size,shenzhen,11,9.7712571E7
-6RAM size,guangzhou,9,6.7400118E7
-1RAM size,xiangtan,36,1.94071005E8
-9RAM size,shenzhen,20,1.1945328E8
-4RAM size,changsha,132,6.55134084E8
-8RAM size,zhuzhou,30,1.2824123E8
-8RAM size,yichang,20,8.060151E7
-4RAM size,guangzhou,22,1.61569078E8
-0RAM size,zhuzhou,11,1.04026483E8
-8RAM size,wuhan,10,1.442333E7
-2RAM size,changsha,2,4403860.0
-8RAM size,xiangtan,20,9.342275E7
-3RAM size,yichang,14,1.10861758E8
-6RAM size,zhuzhou,9,2.1285594E7
-0RAM size,wuhan,44,1.4694625E8
-6RAM size,wuhan,18,1.28445255E8
-9RAM size,wuhan,10,4.204181E7
-0RAM size,changsha,44,1.55468467E8
-3RAM size,changsha,14,9.3323356E7
-6RAM size,xiangtan,18,1.2996945E8
-4RAM size,yichang,88,3.96362956E8
-7RAM size,zhuzhou,7,633290.0
-0RAM size,guangzhou,11,9.3976949E7
-3RAM size,guangzhou,14,1.1681404E7
-9RAM size,changsha,20,1.1746321E8
-3RAM size,shenzhen,56,1.17094404E8
-4RAM size,wuhan,66,3.7813819197E8
-6RAM size,shenzhen,9,5.6566836E7
-7RAM size,wuhan,21,7.9516871E7
-4RAM size,xiangtan,132,5.86041984E8
-1RAM size,guangzhou,9,5.2727364E7
-7RAM size,changsha,7,5.3271582E7
-1RAM size,shenzhen,9,7505190.0
-4RAM size,shenzhen,44,2.31008206E8
-5RAM size,wuhan,5,4.698605E7
-2RAM size,xiangtan,2,8315378.0
-3RAM size,zhuzhou,42,1.9035926E8
-5RAM size,changsha,10,7.682548E7
-9RAM size,yichang,10,3.278738E7
-5RAM size,guangzhou,10,2.9157515E7
-3RAM size,wuhan,14,7.5680402E7
-8RAM size,guangzhou,10,5.284541562E7
-3RAM size,xiangtan,42,1.93558036E8
-1RAM size,zhuzhou,9,233955.0
-1RAM size,yichang,18,1.21291542E8
-8RAM size,shenzhen,10,2.051894E7
-9RAM size,xiangtan,40,1.2251467E8
-6RAM size,changsha,18,1.20374172E8
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_309.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_309.csv b/integration-testcases/src/test/resources/hiveExpected/TC_309.csv
deleted file mode 100644
index ba6af8b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_309.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-AMSize StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-8RAM size,wuhan,10,1.442333E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_310.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_310.csv b/integration-testcases/src/test/resources/hiveExpected/TC_310.csv
deleted file mode 100644
index ba6af8b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_310.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-AMSize StringType,Activecity StringType,AMSize_number LongType,total DoubleType
-8RAM size,wuhan,10,1.442333E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_311.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_311.csv b/integration-testcases/src/test/resources/hiveExpected/TC_311.csv
deleted file mode 100644
index 3a09510..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_311.csv
+++ /dev/null
@@ -1,50 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,AMSize_number LongType,total DoubleType
-7RAM size,3,7,5.3271582E7
-4RAM size,6,66,3.7813819197E8
-9RAM size,4,40,1.2251467E8
-3RAM size,7,14,1.10861758E8
-8RAM size,5,30,1.2824123E8
-1RAM size,1,9,7505190.0
-4RAM size,1,44,2.31008206E8
-3RAM size,2,14,1.1681404E7
-6RAM size,2,9,6.7400118E7
-0RAM size,5,11,1.04026483E8
-5RAM size,3,10,7.682548E7
-1RAM size,7,18,1.21291542E8
-4RAM size,7,88,3.96362956E8
-8RAM size,6,10,1.442333E7
-1RAM size,2,9,5.2727364E7
-4RAM size,2,22,1.61569078E8
-3RAM size,3,14,9.3323356E7
-8RAM size,1,10,2.051894E7
-6RAM size,3,18,1.20374172E8
-0RAM size,6,44,1.4694625E8
-7RAM size,5,7,633290.0
-0RAM size,1,11,9.7712571E7
-9RAM size,6,10,4.204181E7
-8RAM size,7,20,8.060151E7
-4RAM size,3,132,6.55134084E8
-9RAM size,1,20,1.1945328E8
-3RAM size,4,42,1.93558036E8
-8RAM size,2,10,5.284541562E7
-6RAM size,4,18,1.2996945E8
-7RAM size,6,21,7.9516871E7
-0RAM size,2,11,9.3976949E7
-9RAM size,7,10,3.278738E7
-2RAM size,3,2,4403860.0
-1RAM size,4,36,1.94071005E8
-4RAM size,4,132,5.86041984E8
-3RAM size,5,42,1.9035926E8
-6RAM size,5,9,2.1285594E7
-5RAM size,6,5,4.698605E7
-7RAM size,7,14,1.15242211E8
-0RAM size,3,44,1.55468467E8
-2RAM size,4,2,8315378.0
-1RAM size,5,9,233955.0
-9RAM size,3,20,1.1746321E8
-3RAM size,6,14,7.5680402E7
-6RAM size,6,18,1.28445255E8
-8RAM size,4,20,9.342275E7
-3RAM size,1,56,1.17094404E8
-6RAM size,1,9,5.6566836E7
-5RAM size,2,10,2.9157515E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_312.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_312.csv b/integration-testcases/src/test/resources/hiveExpected/TC_312.csv
deleted file mode 100644
index 49578e6..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_312.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveOperatorId StringType,total DoubleType,AMSize_count LongType
->50,4.75346775197E8,10
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_313.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_313.csv b/integration-testcases/src/test/resources/hiveExpected/TC_313.csv
deleted file mode 100644
index 49578e6..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_313.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveOperatorId StringType,total DoubleType,AMSize_count LongType
->50,4.75346775197E8,10
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_314.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_314.csv b/integration-testcases/src/test/resources/hiveExpected/TC_314.csv
deleted file mode 100644
index 89d65ac..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_314.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamepointid DoubleType
-0RAM size,1,2849.0
-0RAM size,2,79.0
-0RAM size,3,7663.0
-0RAM size,5,1341.0
-0RAM size,6,6082.0
-1RAM size,1,256.0
-1RAM size,2,1333.0
-1RAM size,4,7510.0
-1RAM size,5,2745.0
-1RAM size,7,3942.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_315.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_315.csv b/integration-testcases/src/test/resources/hiveExpected/TC_315.csv
deleted file mode 100644
index 442f35f..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_315.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,imei StringType
-8RAM size,2,1AA1
-4RAM size,6,1AA10
-7RAM size,7,1AA100
-5RAM size,3,1AA1000
-1RAM size,4,1AA10000
-4RAM size,7,1AA100000
-4RAM size,4,1AA1000000
-7RAM size,6,1AA100001
-0RAM size,5,1AA100002
-7RAM size,5,1AA100003
-8RAM size,6,1AA100004
-0RAM size,3,1AA100005
-4RAM size,3,1AA100006
-4RAM size,4,1AA100007
-0RAM size,6,1AA100008
-4RAM size,4,1AA100009
-6RAM size,4,1AA10001
-0RAM size,2,1AA100010
-1RAM size,4,1AA100011
-6RAM size,4,1AA100012
-8RAM size,1,1AA100013
-7RAM size,3,1AA100014
-3RAM size,3,1AA100015
-8RAM size,4,1AA100016
-5RAM size,2,1AA100017
-4RAM size,7,1AA100018
-0RAM size,3,1AA100019
-8RAM size,7,1AA10002
-1RAM size,1,1AA100020
-0RAM size,3,1AA100021
-3RAM size,2,1AA100022
-8RAM size,7,1AA100023
-0RAM size,6,1AA100024
-7RAM size,6,1AA100025
-6RAM size,2,1AA100026
-3RAM size,5,1AA100027
-0RAM size,1,1AA100028
-4RAM size,3,1AA100029
-9RAM size,4,1AA10003
-1RAM size,2,1AA100030
-3RAM size,4,1AA100031
-3RAM size,1,1AA100032
-7RAM size,7,1AA100033
-6RAM size,3,1AA100034
-6RAM size,1,1AA100035
-9RAM size,3,1AA100036
-9RAM size,3,1AA100037
-8RAM size,4,1AA100038
-7RAM size,6,1AA100039
-4RAM size,1,1AA10004
-1RAM size,7,1AA100040
-1RAM size,4,1AA100041
-1RAM size,5,1AA100042
-9RAM size,7,1AA100043
-9RAM size,1,1AA100044
-4RAM size,6,1AA100045
-4RAM size,6,1AA100046
-6RAM size,6,1AA100047
-1RAM size,4,1AA100048
-4RAM size,4,1AA100049
-3RAM size,5,1AA10005
-4RAM size,7,1AA100050
-3RAM size,4,1AA100051
-8RAM size,5,1AA100052
-3RAM size,5,1AA100053
-9RAM size,1,1AA100054
-4RAM size,2,1AA100055
-0RAM size,6,1AA100056
-4RAM size,3,1AA100057
-3RAM size,6,1AA100058
-3RAM size,4,1AA100059
-5RAM size,6,1AA10006
-4RAM size,1,1AA100060
-0RAM size,6,1AA100061
-6RAM size,5,1AA100062
-8RAM size,5,1AA100063
-4RAM size,3,1AA100064
-4RAM size,3,1AA100065
-1RAM size,7,1AA100066
-6RAM size,3,1AA100067
-4RAM size,4,1AA100068
-3RAM size,7,1AA100069
-2RAM size,4,1AA10007
-9RAM size,6,1AA100070
-2RAM size,3,1AA100071
-9RAM size,4,1AA100072
-3RAM size,1,1AA100073
-3RAM size,1,1AA100074
-5RAM size,2,1AA100075
-4RAM size,7,1AA100076
-5RAM size,3,1AA100077
-6RAM size,6,1AA100078
-0RAM size,3,1AA100079
-4RAM size,3,1AA10008
-9RAM size,4,1AA100080
-8RAM size,5,1AA100081
-9RAM size,4,1AA100082
-3RAM size,1,1AA100083
-4RAM size,4,1AA100084
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_316.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_316.csv b/integration-testcases/src/test/resources/hiveExpected/TC_316.csv
deleted file mode 100644
index 8aa62e4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_316.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-series StringType,gamepointid DoubleType
-2Series,1407.0
-6Series,1407.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_317.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_317.csv b/integration-testcases/src/test/resources/hiveExpected/TC_317.csv
deleted file mode 100644
index ff8dd1b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_317.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-channelsId StringType
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-3
-3
-3
-3
-3
-3
-3
-3
-3
-3
-3
-3
-3
-3
-3
-3
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
-5
-5
-5
-5
-5
-5
-5
-5
-5
-5
-5
-5
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_318.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_318.csv b/integration-testcases/src/test/resources/hiveExpected/TC_318.csv
deleted file mode 100644
index 01e3723..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_318.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 LongType,series StringType
-9,6Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_319.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_319.csv b/integration-testcases/src/test/resources/hiveExpected/TC_319.csv
deleted file mode 100644
index 525d239..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_319.csv
+++ /dev/null
@@ -1,8 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,Activecity StringType,Sum_gamePointId DoubleType
-Chinese,hongshan,wuhan,28312.635000000002
-Chinese,longgang,shenzhen,17562.0
-Chinese,longhua,guangzhou,14357.562
-Chinese,tianyuan,zhuzhou,17660.0
-Chinese,xiangtan,xiangtan,34033.0
-Chinese,yichang,yichang,14539.0
-Chinese,yuhua,changsha,30421.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_320.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_320.csv b/integration-testcases/src/test/resources/hiveExpected/TC_320.csv
deleted file mode 100644
index ce5bb9b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_320.csv
+++ /dev/null
@@ -1 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,Activecity StringType,Sum_gamePointId DoubleType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_321.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_321.csv b/integration-testcases/src/test/resources/hiveExpected/TC_321.csv
deleted file mode 100644
index 03b7689..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_321.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,Activecity StringType,Sum_gamePointId DoubleType
-Chinese,yichang,yichang,136.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_322.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_322.csv b/integration-testcases/src/test/resources/hiveExpected/TC_322.csv
deleted file mode 100644
index fc3ba1d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_322.csv
+++ /dev/null
@@ -1,17 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,deliveryCity StringType,Sum_Latest_YEAR LongType
-Chinese,hongshan,guangzhou,2015
-Chinese,longgang,changsha,2015
-Chinese,longgang,guangzhou,2015
-Chinese,longgang,shenzhen,2015
-Chinese,longgang,zhuzhou,2015
-Chinese,longhua,zhuzhou,2015
-Chinese,tianyuan,shenzhen,2015
-Chinese,tianyuan,zhuzhou,2015
-Chinese,xiangtan,shenzhen,2015
-Chinese,xiangtan,xiangtan,2015
-Chinese,yichang,guangzhou,2015
-Chinese,yichang,xiangtan,2015
-Chinese,yuhua,changsha,2015
-Chinese,yuhua,shenzhen,2015
-Chinese,yuhua,wuhan,2015
-Chinese,yuhua,zhuzhou,4030
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_323.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_323.csv b/integration-testcases/src/test/resources/hiveExpected/TC_323.csv
deleted file mode 100644
index 93e7002..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_323.csv
+++ /dev/null
@@ -1,7 +0,0 @@
-ActiveCountry StringType,ActiveDistrict StringType,deliveryCity StringType,Sum_Latest_YEAR LongType
-Chinese,hongshan,zhuzhou,2015
-Chinese,longgang,zhuzhou,6045
-Chinese,longhua,zhuzhou,6045
-Chinese,tianyuan,zhuzhou,6045
-Chinese,yichang,zhuzhou,2015
-Chinese,yuhua,zhuzhou,8060
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_324.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_324.csv b/integration-testcases/src/test/resources/hiveExpected/TC_324.csv
deleted file mode 100644
index b55b467..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_324.csv
+++ /dev/null
@@ -1,59 +0,0 @@
-modelId StringType,ActiveCountry StringType,ActiveDistrict StringType,deliveryCity StringType,Sum_Latest_YEAR LongType
-2008,Chinese,tianyuan,changsha,2015
-2069,Chinese,yuhua,changsha,2015
-2074,Chinese,longgang,wuhan,2015
-2133,Chinese,xiangtan,shenzhen,2015
-2142,Chinese,tianyuan,yichang,2015
-2151,Chinese,yuhua,zhuzhou,2015
-2164,Chinese,yuhua,xiangtan,2015
-2167,Chinese,longgang,changsha,2015
-2176,Chinese,longgang,xiangtan,2015
-2201,Chinese,yichang,wuhan,2015
-2300,Chinese,tianyuan,zhuzhou,2015
-2319,Chinese,hongshan,guangzhou,2015
-2320,Chinese,xiangtan,guangzhou,2015
-2355,Chinese,xiangtan,shenzhen,2015
-2381,Chinese,yuhua,xiangtan,2015
-2408,Chinese,xiangtan,guangzhou,2015
-2415,Chinese,yuhua,changsha,2015
-2457,Chinese,yichang,yichang,2015
-2479,Chinese,xiangtan,yichang,2015
-2531,Chinese,yuhua,wuhan,2015
-2563,Chinese,hongshan,changsha,2015
-2574,Chinese,longgang,shenzhen,2015
-2591,Chinese,yichang,xiangtan,2015
-2594,Chinese,tianyuan,yichang,2015
-2597,Chinese,longgang,guangzhou,2015
-2644,Chinese,xiangtan,xiangtan,2015
-2696,Chinese,longhua,zhuzhou,2015
-2705,Chinese,xiangtan,guangzhou,2015
-273,Chinese,yichang,wuhan,2015
-2759,Chinese,yuhua,yichang,2015
-2761,Chinese,xiangtan,xiangtan,2015
-2765,Chinese,hongshan,yichang,2015
-2797,Chinese,xiangtan,xiangtan,2015
-2799,Chinese,yuhua,yichang,2015
-2823,Chinese,longhua,yichang,2015
-2828,Chinese,yichang,zhuzhou,2015
-2930,Chinese,longhua,yichang,2015
-2940,Chinese,tianyuan,zhuzhou,2015
-2963,Chinese,xiangtan,changsha,2015
-297,Chinese,longgang,zhuzhou,2015
-396,Chinese,xiangtan,changsha,2015
-44,Chinese,hongshan,guangzhou,2015
-446,Chinese,yichang,yichang,2015
-466,Chinese,xiangtan,guangzhou,2015
-47,Chinese,hongshan,guangzhou,2015
-477,Chinese,xiangtan,yichang,2015
-499,Chinese,xiangtan,shenzhen,2015
-513,Chinese,longhua,zhuzhou,2015
-546,Chinese,xiangtan,changsha,2015
-631,Chinese,tianyuan,shenzhen,2015
-68,Chinese,hongshan,wuhan,2015
-716,Chinese,yuhua,zhuzhou,2015
-776,Chinese,longgang,zhuzhou,2015
-839,Chinese,hongshan,zhuzhou,2015
-864,Chinese,hongshan,guangzhou,2015
-872,Chinese,xiangtan,shenzhen,2015
-93,Chinese,hongshan,yichang,2015
-987,Chinese,yichang,wuhan,2015
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_325.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_325.csv b/integration-testcases/src/test/resources/hiveExpected/TC_325.csv
deleted file mode 100644
index 0188344..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_325.csv
+++ /dev/null
@@ -1,59 +0,0 @@
-imei StringType,deliveryCity StringType,Sum_Latest_YEAR LongType,Sum_gamePointId DoubleType
-1AA10,yichang,2015,1714.635
-1AA100,xiangtan,2015,1271.0
-1AA1000,wuhan,2015,692.0
-1AA10000,guangzhou,2015,2175.0
-1AA1000000,yichang,2015,1600.0
-1AA100002,changsha,2015,1341.0
-1AA100005,yichang,2015,2593.0
-1AA100006,changsha,2015,2572.0
-1AA100007,changsha,2015,1991.0
-1AA100009,yichang,2015,1841.0
-1AA10001,changsha,2015,298.0
-1AA100010,zhuzhou,2015,79.0
-1AA100011,guangzhou,2015,202.0
-1AA100012,xiangtan,2015,568.0
-1AA100013,changsha,2015,355.0
-1AA100016,changsha,2015,1873.0
-1AA100018,yichang,2015,441.0
-1AA100019,zhuzhou,2015,2194.0
-1AA10002,wuhan,2015,2972.0
-1AA100020,shenzhen,2015,256.0
-1AA100025,guangzhou,2015,1724.0
-1AA100026,yichang,2015,1768.0
-1AA100027,zhuzhou,2015,2436.0
-1AA100028,zhuzhou,2015,2849.0
-1AA100030,zhuzhou,2015,1333.0
-1AA100033,wuhan,2015,760.0
-1AA100036,changsha,2015,2224.0
-1AA100037,xiangtan,2015,1015.0
-1AA100038,shenzhen,2015,1229.0
-1AA10004,guangzhou,2015,1717.0
-1AA100041,shenzhen,2015,2734.0
-1AA100042,shenzhen,2015,2745.0
-1AA100046,guangzhou,2015,1077.0
-1AA100047,zhuzhou,2015,1823.0
-1AA100049,guangzhou,2015,2890.0
-1AA100050,yichang,2015,29.0
-1AA100051,guangzhou,2015,1407.0
-1AA100052,zhuzhou,2015,845.0
-1AA100055,yichang,2015,1728.0
-1AA100056,wuhan,2015,750.0
-1AA100057,zhuzhou,2015,2288.0
-1AA100058,guangzhou,2015,2635.0
-1AA100059,shenzhen,2015,1337.0
-1AA100060,xiangtan,2015,538.0
-1AA100061,changsha,2015,1407.0
-1AA100062,yichang,2015,2952.0
-1AA100063,yichang,2015,1226.0
-1AA100066,zhuzhou,2015,1864.0
-1AA10007,xiangtan,2015,1350.0
-1AA100070,guangzhou,2015,1567.0
-1AA100073,zhuzhou,2015,2488.0
-1AA100074,wuhan,2015,907.0
-1AA100076,wuhan,2015,732.0
-1AA100077,yichang,2015,2077.0
-1AA100078,yichang,2015,1434.0
-1AA100079,xiangtan,2015,1098.0
-1AA100080,shenzhen,2015,954.0
-1AA100082,xiangtan,2015,2348.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_326.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_326.csv b/integration-testcases/src/test/resources/hiveExpected/TC_326.csv
deleted file mode 100644
index d17cb0e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_326.csv
+++ /dev/null
@@ -1,94 +0,0 @@
-imei StringType,deliveryCity StringType,Sum_Latest_YEAR LongType,Sum_gamePointId DoubleType
-1AA1000000,yichang,2015,1600.0
-1AA100001,xiangtan,2015,505.0
-1AA100002,changsha,2015,1341.0
-1AA100003,zhuzhou,2015,2239.0
-1AA100004,yichang,2015,2970.0
-1AA100005,yichang,2015,2593.0
-1AA100006,changsha,2015,2572.0
-1AA100007,changsha,2015,1991.0
-1AA100008,changsha,2015,1442.0
-1AA100009,yichang,2015,1841.0
-1AA10001,changsha,2015,298.0
-1AA100010,zhuzhou,2015,79.0
-1AA100011,guangzhou,2015,202.0
-1AA100012,xiangtan,2015,568.0
-1AA100013,changsha,2015,355.0
-1AA100014,zhuzhou,2015,151.0
-1AA100015,xiangtan,2015,2863.0
-1AA100016,changsha,2015,1873.0
-1AA100017,xiangtan,2015,2205.0
-1AA100018,yichang,2015,441.0
-1AA100019,zhuzhou,2015,2194.0
-1AA10002,wuhan,2015,2972.0
-1AA100020,shenzhen,2015,256.0
-1AA100021,changsha,2015,1778.0
-1AA100022,zhuzhou,2015,1999.0
-1AA100023,guangzhou,2015,2194.0
-1AA100024,changsha,2015,2483.0
-1AA100025,guangzhou,2015,1724.0
-1AA100026,yichang,2015,1768.0
-1AA100027,zhuzhou,2015,2436.0
-1AA100028,zhuzhou,2015,2849.0
-1AA100029,xiangtan,2015,1691.0
-1AA10003,xiangtan,2015,2071.0
-1AA100030,zhuzhou,2015,1333.0
-1AA100031,yichang,2015,1080.0
-1AA100032,shenzhen,2015,1053.0
-1AA100033,wuhan,2015,760.0
-1AA100034,guangzhou,2015,2061.0
-1AA100035,changsha,2015,2142.0
-1AA100036,changsha,2015,2224.0
-1AA100037,xiangtan,2015,1015.0
-1AA100038,shenzhen,2015,1229.0
-1AA100039,shenzhen,2015,1750.0
-1AA10004,guangzhou,2015,1717.0
-1AA100040,yichang,2015,2078.0
-1AA100041,shenzhen,2015,2734.0
-1AA100042,shenzhen,2015,2745.0
-1AA100043,guangzhou,2015,571.0
-1AA100044,guangzhou,2015,1697.0
-1AA100045,xiangtan,2015,2553.0
-1AA100046,guangzhou,2015,1077.0
-1AA100047,zhuzhou,2015,1823.0
-1AA100048,guangzhou,2015,2399.0
-1AA100049,guangzhou,2015,2890.0
-1AA10005,xiangtan,2015,1608.0
-1AA100050,yichang,2015,29.0
-1AA100051,guangzhou,2015,1407.0
-1AA100052,zhuzhou,2015,845.0
-1AA100053,wuhan,2015,1655.0
-1AA100054,shenzhen,2015,1368.0
-1AA100055,yichang,2015,1728.0
-1AA100056,wuhan,2015,750.0
-1AA100057,zhuzhou,2015,2288.0
-1AA100058,guangzhou,2015,2635.0
-1AA100059,shenzhen,2015,1337.0
-1AA10006,guangzhou,2015,2478.0
-1AA100060,xiangtan,2015,538.0
-1AA100061,changsha,2015,1407.0
-1AA100062,yichang,2015,2952.0
-1AA100063,yichang,2015,1226.0
-1AA100064,zhuzhou,2015,865.0
-1AA100065,xiangtan,2015,901.0
-1AA100066,zhuzhou,2015,1864.0
-1AA100067,wuhan,2015,572.0
-1AA100068,guangzhou,2015,412.0
-1AA100069,xiangtan,2015,1491.0
-1AA10007,xiangtan,2015,1350.0
-1AA100070,guangzhou,2015,1567.0
-1AA100071,guangzhou,2015,1973.0
-1AA100072,changsha,2015,448.0
-1AA100073,zhuzhou,2015,2488.0
-1AA100074,wuhan,2015,907.0
-1AA100075,shenzhen,2015,2507.0
-1AA100076,wuhan,2015,732.0
-1AA100077,yichang,2015,2077.0
-1AA100078,yichang,2015,1434.0
-1AA100079,xiangtan,2015,1098.0
-1AA10008,shenzhen,2015,813.0
-1AA100080,shenzhen,2015,954.0
-1AA100081,shenzhen,2015,613.0
-1AA100082,xiangtan,2015,2348.0
-1AA100083,zhuzhou,2015,2192.0
-1AA100084,guangzhou,2015,2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_327.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_327.csv b/integration-testcases/src/test/resources/hiveExpected/TC_327.csv
deleted file mode 100644
index 3225a7c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_327.csv
+++ /dev/null
@@ -1,94 +0,0 @@
-imei StringType,deliveryCity StringType,Count_Latest_YEAR LongType,Sum_gamePointId DoubleType
-1AA1000000,yichang,1,1600.0
-1AA100001,xiangtan,1,505.0
-1AA100002,changsha,1,1341.0
-1AA100003,zhuzhou,1,2239.0
-1AA100004,yichang,1,2970.0
-1AA100005,yichang,1,2593.0
-1AA100006,changsha,1,2572.0
-1AA100007,changsha,1,1991.0
-1AA100008,changsha,1,1442.0
-1AA100009,yichang,1,1841.0
-1AA10001,changsha,1,298.0
-1AA100010,zhuzhou,1,79.0
-1AA100011,guangzhou,1,202.0
-1AA100012,xiangtan,1,568.0
-1AA100013,changsha,1,355.0
-1AA100014,zhuzhou,1,151.0
-1AA100015,xiangtan,1,2863.0
-1AA100016,changsha,1,1873.0
-1AA100017,xiangtan,1,2205.0
-1AA100018,yichang,1,441.0
-1AA100019,zhuzhou,1,2194.0
-1AA10002,wuhan,1,2972.0
-1AA100020,shenzhen,1,256.0
-1AA100021,changsha,1,1778.0
-1AA100022,zhuzhou,1,1999.0
-1AA100023,guangzhou,1,2194.0
-1AA100024,changsha,1,2483.0
-1AA100025,guangzhou,1,1724.0
-1AA100026,yichang,1,1768.0
-1AA100027,zhuzhou,1,2436.0
-1AA100028,zhuzhou,1,2849.0
-1AA100029,xiangtan,1,1691.0
-1AA10003,xiangtan,1,2071.0
-1AA100030,zhuzhou,1,1333.0
-1AA100031,yichang,1,1080.0
-1AA100032,shenzhen,1,1053.0
-1AA100033,wuhan,1,760.0
-1AA100034,guangzhou,1,2061.0
-1AA100035,changsha,1,2142.0
-1AA100036,changsha,1,2224.0
-1AA100037,xiangtan,1,1015.0
-1AA100038,shenzhen,1,1229.0
-1AA100039,shenzhen,1,1750.0
-1AA10004,guangzhou,1,1717.0
-1AA100040,yichang,1,2078.0
-1AA100041,shenzhen,1,2734.0
-1AA100042,shenzhen,1,2745.0
-1AA100043,guangzhou,1,571.0
-1AA100044,guangzhou,1,1697.0
-1AA100045,xiangtan,1,2553.0
-1AA100046,guangzhou,1,1077.0
-1AA100047,zhuzhou,1,1823.0
-1AA100048,guangzhou,1,2399.0
-1AA100049,guangzhou,1,2890.0
-1AA10005,xiangtan,1,1608.0
-1AA100050,yichang,1,29.0
-1AA100051,guangzhou,1,1407.0
-1AA100052,zhuzhou,1,845.0
-1AA100053,wuhan,1,1655.0
-1AA100054,shenzhen,1,1368.0
-1AA100055,yichang,1,1728.0
-1AA100056,wuhan,1,750.0
-1AA100057,zhuzhou,1,2288.0
-1AA100058,guangzhou,1,2635.0
-1AA100059,shenzhen,1,1337.0
-1AA10006,guangzhou,1,2478.0
-1AA100060,xiangtan,1,538.0
-1AA100061,changsha,1,1407.0
-1AA100062,yichang,1,2952.0
-1AA100063,yichang,1,1226.0
-1AA100064,zhuzhou,1,865.0
-1AA100065,xiangtan,1,901.0
-1AA100066,zhuzhou,1,1864.0
-1AA100067,wuhan,1,572.0
-1AA100068,guangzhou,1,412.0
-1AA100069,xiangtan,1,1491.0
-1AA10007,xiangtan,1,1350.0
-1AA100070,guangzhou,1,1567.0
-1AA100071,guangzhou,1,1973.0
-1AA100072,changsha,1,448.0
-1AA100073,zhuzhou,1,2488.0
-1AA100074,wuhan,1,907.0
-1AA100075,shenzhen,1,2507.0
-1AA100076,wuhan,1,732.0
-1AA100077,yichang,1,2077.0
-1AA100078,yichang,1,1434.0
-1AA100079,xiangtan,1,1098.0
-1AA10008,shenzhen,1,813.0
-1AA100080,shenzhen,1,954.0
-1AA100081,shenzhen,1,613.0
-1AA100082,xiangtan,1,2348.0
-1AA100083,zhuzhou,1,2192.0
-1AA100084,guangzhou,1,2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_328.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_328.csv b/integration-testcases/src/test/resources/hiveExpected/TC_328.csv
deleted file mode 100644
index bd2c49b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_328.csv
+++ /dev/null
@@ -1,94 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Latest_YEAR IntegerType,gamePointId DoubleType
-1AA100049,guangzhou,0Series,2015,2890.0
-1AA100065,xiangtan,0Series,2015,901.0
-1AA100070,guangzhou,0Series,2015,1567.0
-1AA100071,guangzhou,0Series,2015,1973.0
-1AA100076,wuhan,0Series,2015,732.0
-1AA100083,zhuzhou,0Series,2015,2192.0
-1AA100084,guangzhou,0Series,2015,2826.0
-1AA100001,xiangtan,0Series,2015,505.0
-1AA100002,changsha,0Series,2015,1341.0
-1AA100009,yichang,0Series,2015,1841.0
-1AA100011,guangzhou,0Series,2015,202.0
-1AA10002,wuhan,0Series,2015,2972.0
-1AA100021,changsha,0Series,2015,1778.0
-1AA100025,guangzhou,0Series,2015,1724.0
-1AA100027,zhuzhou,0Series,2015,2436.0
-1AA100005,yichang,1Series,2015,2593.0
-1AA100013,changsha,1Series,2015,355.0
-1AA100032,shenzhen,1Series,2015,1053.0
-1AA100045,xiangtan,2Series,2015,2553.0
-1AA100050,yichang,2Series,2015,29.0
-1AA100051,guangzhou,2Series,2015,1407.0
-1AA100053,wuhan,2Series,2015,1655.0
-1AA100063,yichang,2Series,2015,1226.0
-1AA100078,yichang,2Series,2015,1434.0
-1AA10001,changsha,2Series,2015,298.0
-1AA100029,xiangtan,2Series,2015,1691.0
-1AA100034,guangzhou,2Series,2015,2061.0
-1AA100042,shenzhen,3Series,2015,2745.0
-1AA100046,guangzhou,3Series,2015,1077.0
-1AA100048,guangzhou,3Series,2015,2399.0
-1AA10006,guangzhou,3Series,2015,2478.0
-1AA100075,shenzhen,3Series,2015,2507.0
-1AA100077,yichang,3Series,2015,2077.0
-1AA100010,zhuzhou,3Series,2015,79.0
-1AA100016,changsha,3Series,2015,1873.0
-1AA100004,yichang,4Series,2015,2970.0
-1AA100012,xiangtan,4Series,2015,568.0
-1AA100015,xiangtan,4Series,2015,2863.0
-1AA100059,shenzhen,4Series,2015,1337.0
-1AA100067,wuhan,4Series,2015,572.0
-1AA100072,changsha,4Series,2015,448.0
-1AA100073,zhuzhou,4Series,2015,2488.0
-1AA100079,xiangtan,4Series,2015,1098.0
-1AA100041,shenzhen,5Series,2015,2734.0
-1AA100058,guangzhou,5Series,2015,2635.0
-1AA10008,shenzhen,5Series,2015,813.0
-1AA100081,shenzhen,5Series,2015,613.0
-1AA100082,xiangtan,5Series,2015,2348.0
-1AA100003,zhuzhou,5Series,2015,2239.0
-1AA100014,zhuzhou,5Series,2015,151.0
-1AA100019,zhuzhou,5Series,2015,2194.0
-1AA100020,shenzhen,5Series,2015,256.0
-1AA100022,zhuzhou,5Series,2015,1999.0
-1AA100023,guangzhou,5Series,2015,2194.0
-1AA100028,zhuzhou,5Series,2015,2849.0
-1AA100035,changsha,5Series,2015,2142.0
-1AA100036,changsha,5Series,2015,2224.0
-1AA10004,guangzhou,5Series,2015,1717.0
-1AA100006,changsha,6Series,2015,2572.0
-1AA100024,changsha,6Series,2015,2483.0
-1AA100038,shenzhen,6Series,2015,1229.0
-1AA100052,zhuzhou,6Series,2015,845.0
-1AA100056,wuhan,6Series,2015,750.0
-1AA100061,changsha,6Series,2015,1407.0
-1AA100064,zhuzhou,6Series,2015,865.0
-1AA100066,zhuzhou,6Series,2015,1864.0
-1AA100074,wuhan,6Series,2015,907.0
-1AA1000000,yichang,7Series,2015,1600.0
-1AA100026,yichang,7Series,2015,1768.0
-1AA10003,xiangtan,7Series,2015,2071.0
-1AA100030,zhuzhou,7Series,2015,1333.0
-1AA100031,yichang,7Series,2015,1080.0
-1AA100037,xiangtan,7Series,2015,1015.0
-1AA100054,shenzhen,7Series,2015,1368.0
-1AA100055,yichang,7Series,2015,1728.0
-1AA100008,changsha,8Series,2015,1442.0
-1AA100018,yichang,8Series,2015,441.0
-1AA100033,wuhan,8Series,2015,760.0
-1AA100039,shenzhen,8Series,2015,1750.0
-1AA100040,yichang,8Series,2015,2078.0
-1AA100044,guangzhou,8Series,2015,1697.0
-1AA10005,xiangtan,8Series,2015,1608.0
-1AA100060,xiangtan,8Series,2015,538.0
-1AA100068,guangzhou,8Series,2015,412.0
-1AA100069,xiangtan,8Series,2015,1491.0
-1AA10007,xiangtan,8Series,2015,1350.0
-1AA100007,changsha,9Series,2015,1991.0
-1AA100017,xiangtan,9Series,2015,2205.0
-1AA100043,guangzhou,9Series,2015,571.0
-1AA100047,zhuzhou,9Series,2015,1823.0
-1AA100057,zhuzhou,9Series,2015,2288.0
-1AA100062,yichang,9Series,2015,2952.0
-1AA100080,shenzhen,9Series,2015,954.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_329.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_329.csv b/integration-testcases/src/test/resources/hiveExpected/TC_329.csv
deleted file mode 100644
index 6a6f97d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_329.csv
+++ /dev/null
@@ -1,94 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_gamePointId DoubleType,Count_Latest_DAY LongType
-1AA1000000,yichang,7Series,1600.0,1
-1AA100001,xiangtan,0Series,505.0,1
-1AA100002,changsha,0Series,1341.0,1
-1AA100003,zhuzhou,5Series,2239.0,1
-1AA100004,yichang,4Series,2970.0,1
-1AA100005,yichang,1Series,2593.0,1
-1AA100006,changsha,6Series,2572.0,1
-1AA100007,changsha,9Series,1991.0,1
-1AA100008,changsha,8Series,1442.0,1
-1AA100009,yichang,0Series,1841.0,1
-1AA10001,changsha,2Series,298.0,1
-1AA100010,zhuzhou,3Series,79.0,1
-1AA100011,guangzhou,0Series,202.0,1
-1AA100012,xiangtan,4Series,568.0,1
-1AA100013,changsha,1Series,355.0,1
-1AA100014,zhuzhou,5Series,151.0,1
-1AA100015,xiangtan,4Series,2863.0,1
-1AA100016,changsha,3Series,1873.0,1
-1AA100017,xiangtan,9Series,2205.0,1
-1AA100018,yichang,8Series,441.0,1
-1AA100019,zhuzhou,5Series,2194.0,1
-1AA10002,wuhan,0Series,2972.0,1
-1AA100020,shenzhen,5Series,256.0,1
-1AA100021,changsha,0Series,1778.0,1
-1AA100022,zhuzhou,5Series,1999.0,1
-1AA100023,guangzhou,5Series,2194.0,1
-1AA100024,changsha,6Series,2483.0,1
-1AA100025,guangzhou,0Series,1724.0,1
-1AA100026,yichang,7Series,1768.0,1
-1AA100027,zhuzhou,0Series,2436.0,1
-1AA100028,zhuzhou,5Series,2849.0,1
-1AA100029,xiangtan,2Series,1691.0,1
-1AA10003,xiangtan,7Series,2071.0,1
-1AA100030,zhuzhou,7Series,1333.0,1
-1AA100031,yichang,7Series,1080.0,1
-1AA100032,shenzhen,1Series,1053.0,1
-1AA100033,wuhan,8Series,760.0,1
-1AA100034,guangzhou,2Series,2061.0,1
-1AA100035,changsha,5Series,2142.0,1
-1AA100036,changsha,5Series,2224.0,1
-1AA100037,xiangtan,7Series,1015.0,1
-1AA100038,shenzhen,6Series,1229.0,1
-1AA100039,shenzhen,8Series,1750.0,1
-1AA10004,guangzhou,5Series,1717.0,1
-1AA100040,yichang,8Series,2078.0,1
-1AA100041,shenzhen,5Series,2734.0,1
-1AA100042,shenzhen,3Series,2745.0,1
-1AA100043,guangzhou,9Series,571.0,1
-1AA100044,guangzhou,8Series,1697.0,1
-1AA100045,xiangtan,2Series,2553.0,1
-1AA100046,guangzhou,3Series,1077.0,1
-1AA100047,zhuzhou,9Series,1823.0,1
-1AA100048,guangzhou,3Series,2399.0,1
-1AA100049,guangzhou,0Series,2890.0,1
-1AA10005,xiangtan,8Series,1608.0,1
-1AA100050,yichang,2Series,29.0,1
-1AA100051,guangzhou,2Series,1407.0,1
-1AA100052,zhuzhou,6Series,845.0,1
-1AA100053,wuhan,2Series,1655.0,1
-1AA100054,shenzhen,7Series,1368.0,1
-1AA100055,yichang,7Series,1728.0,1
-1AA100056,wuhan,6Series,750.0,1
-1AA100057,zhuzhou,9Series,2288.0,1
-1AA100058,guangzhou,5Series,2635.0,1
-1AA100059,shenzhen,4Series,1337.0,1
-1AA10006,guangzhou,3Series,2478.0,1
-1AA100060,xiangtan,8Series,538.0,1
-1AA100061,changsha,6Series,1407.0,1
-1AA100062,yichang,9Series,2952.0,1
-1AA100063,yichang,2Series,1226.0,1
-1AA100064,zhuzhou,6Series,865.0,1
-1AA100065,xiangtan,0Series,901.0,1
-1AA100066,zhuzhou,6Series,1864.0,1
-1AA100067,wuhan,4Series,572.0,1
-1AA100068,guangzhou,8Series,412.0,1
-1AA100069,xiangtan,8Series,1491.0,1
-1AA10007,xiangtan,8Series,1350.0,1
-1AA100070,guangzhou,0Series,1567.0,1
-1AA100071,guangzhou,0Series,1973.0,1
-1AA100072,changsha,4Series,448.0,1
-1AA100073,zhuzhou,4Series,2488.0,1
-1AA100074,wuhan,6Series,907.0,1
-1AA100075,shenzhen,3Series,2507.0,1
-1AA100076,wuhan,0Series,732.0,1
-1AA100077,yichang,3Series,2077.0,1
-1AA100078,yichang,2Series,1434.0,1
-1AA100079,xiangtan,4Series,1098.0,1
-1AA10008,shenzhen,5Series,813.0,1
-1AA100080,shenzhen,9Series,954.0,1
-1AA100081,shenzhen,5Series,613.0,1
-1AA100082,xiangtan,5Series,2348.0,1
-1AA100083,zhuzhou,0Series,2192.0,1
-1AA100084,guangzhou,0Series,2826.0,1