carbondata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ravipes...@apache.org
Subject [34/52] [partial] incubator-carbondata git commit: remove integration-testcases
Date Wed, 28 Dec 2016 10:53:12 GMT
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_360.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_360.csv b/integration-testcases/src/test/resources/hiveExpected/TC_360.csv
deleted file mode 100644
index d56473e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_360.csv
+++ /dev/null
@@ -1,91 +0,0 @@
-gamePointId DoubleType,Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType
-2738.562,2015,1,1AA1,yichang,7Series
-1714.635,2015,10,1AA10,yichang,7Series
-1271.0,2015,100,1AA100,xiangtan,5Series
-2175.0,2015,10000,1AA10000,guangzhou,7Series
-1600.0,2015,1000000,1AA1000000,yichang,7Series
-505.0,2015,100001,1AA100001,xiangtan,0Series
-1341.0,2015,100002,1AA100002,changsha,0Series
-2239.0,2015,100003,1AA100003,zhuzhou,5Series
-2970.0,2015,100004,1AA100004,yichang,4Series
-2593.0,2015,100005,1AA100005,yichang,1Series
-2572.0,2015,100006,1AA100006,changsha,6Series
-1991.0,2015,100007,1AA100007,changsha,9Series
-1442.0,2015,100008,1AA100008,changsha,8Series
-1841.0,2015,100009,1AA100009,yichang,0Series
-298.0,2015,10001,1AA10001,changsha,2Series
-79.0,2015,100010,1AA100010,zhuzhou,3Series
-202.0,2015,100011,1AA100011,guangzhou,0Series
-568.0,2015,100012,1AA100012,xiangtan,4Series
-355.0,2015,100013,1AA100013,changsha,1Series
-151.0,2015,100014,1AA100014,zhuzhou,5Series
-2863.0,2015,100015,1AA100015,xiangtan,4Series
-1873.0,2015,100016,1AA100016,changsha,3Series
-2205.0,2015,100017,1AA100017,xiangtan,9Series
-441.0,2015,100018,1AA100018,yichang,8Series
-2194.0,2015,100019,1AA100019,zhuzhou,5Series
-256.0,2015,100020,1AA100020,shenzhen,5Series
-1778.0,2015,100021,1AA100021,changsha,0Series
-1999.0,2015,100022,1AA100022,zhuzhou,5Series
-2194.0,2015,100023,1AA100023,guangzhou,5Series
-2483.0,2015,100024,1AA100024,changsha,6Series
-1724.0,2015,100025,1AA100025,guangzhou,0Series
-1768.0,2015,100026,1AA100026,yichang,7Series
-2436.0,2015,100027,1AA100027,zhuzhou,0Series
-2849.0,2015,100028,1AA100028,zhuzhou,5Series
-1691.0,2015,100029,1AA100029,xiangtan,2Series
-2071.0,2015,10003,1AA10003,xiangtan,7Series
-1333.0,2015,100030,1AA100030,zhuzhou,7Series
-1080.0,2015,100031,1AA100031,yichang,7Series
-1053.0,2015,100032,1AA100032,shenzhen,1Series
-2061.0,2015,100034,1AA100034,guangzhou,2Series
-2142.0,2015,100035,1AA100035,changsha,5Series
-2224.0,2015,100036,1AA100036,changsha,5Series
-1015.0,2015,100037,1AA100037,xiangtan,7Series
-1229.0,2015,100038,1AA100038,shenzhen,6Series
-1750.0,2015,100039,1AA100039,shenzhen,8Series
-1717.0,2015,10004,1AA10004,guangzhou,5Series
-2078.0,2015,100040,1AA100040,yichang,8Series
-2734.0,2015,100041,1AA100041,shenzhen,5Series
-2745.0,2015,100042,1AA100042,shenzhen,3Series
-571.0,2015,100043,1AA100043,guangzhou,9Series
-1697.0,2015,100044,1AA100044,guangzhou,8Series
-2553.0,2015,100045,1AA100045,xiangtan,2Series
-1077.0,2015,100046,1AA100046,guangzhou,3Series
-1823.0,2015,100047,1AA100047,zhuzhou,9Series
-2399.0,2015,100048,1AA100048,guangzhou,3Series
-2890.0,2015,100049,1AA100049,guangzhou,0Series
-1608.0,2015,10005,1AA10005,xiangtan,8Series
-29.0,2015,100050,1AA100050,yichang,2Series
-1407.0,2015,100051,1AA100051,guangzhou,2Series
-845.0,2015,100052,1AA100052,zhuzhou,6Series
-1368.0,2015,100054,1AA100054,shenzhen,7Series
-1728.0,2015,100055,1AA100055,yichang,7Series
-2288.0,2015,100057,1AA100057,zhuzhou,9Series
-2635.0,2015,100058,1AA100058,guangzhou,5Series
-1337.0,2015,100059,1AA100059,shenzhen,4Series
-2478.0,2015,10006,1AA10006,guangzhou,3Series
-538.0,2015,100060,1AA100060,xiangtan,8Series
-1407.0,2015,100061,1AA100061,changsha,6Series
-2952.0,2015,100062,1AA100062,yichang,9Series
-1226.0,2015,100063,1AA100063,yichang,2Series
-865.0,2015,100064,1AA100064,zhuzhou,6Series
-901.0,2015,100065,1AA100065,xiangtan,0Series
-1864.0,2015,100066,1AA100066,zhuzhou,6Series
-412.0,2015,100068,1AA100068,guangzhou,8Series
-1491.0,2015,100069,1AA100069,xiangtan,8Series
-1350.0,2015,10007,1AA10007,xiangtan,8Series
-1567.0,2015,100070,1AA100070,guangzhou,0Series
-1973.0,2015,100071,1AA100071,guangzhou,0Series
-448.0,2015,100072,1AA100072,changsha,4Series
-2488.0,2015,100073,1AA100073,zhuzhou,4Series
-2507.0,2015,100075,1AA100075,shenzhen,3Series
-2077.0,2015,100077,1AA100077,yichang,3Series
-1434.0,2015,100078,1AA100078,yichang,2Series
-1098.0,2015,100079,1AA100079,xiangtan,4Series
-813.0,2015,10008,1AA10008,shenzhen,5Series
-954.0,2015,100080,1AA100080,shenzhen,9Series
-613.0,2015,100081,1AA100081,shenzhen,5Series
-2348.0,2015,100082,1AA100082,xiangtan,5Series
-2192.0,2015,100083,1AA100083,zhuzhou,0Series
-2826.0,2015,100084,1AA100084,guangzhou,0Series

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_361.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_361.csv b/integration-testcases/src/test/resources/hiveExpected/TC_361.csv
deleted file mode 100644
index 0153e44..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_361.csv
+++ /dev/null
@@ -1,14 +0,0 @@
-gamePointId DoubleType,Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType
-1341.0,2015,100002,1AA100002,changsha,0Series
-2572.0,2015,100006,1AA100006,changsha,6Series
-1991.0,2015,100007,1AA100007,changsha,9Series
-1442.0,2015,100008,1AA100008,changsha,8Series
-298.0,2015,10001,1AA10001,changsha,2Series
-355.0,2015,100013,1AA100013,changsha,1Series
-1873.0,2015,100016,1AA100016,changsha,3Series
-1778.0,2015,100021,1AA100021,changsha,0Series
-2483.0,2015,100024,1AA100024,changsha,6Series
-2142.0,2015,100035,1AA100035,changsha,5Series
-2224.0,2015,100036,1AA100036,changsha,5Series
-1407.0,2015,100061,1AA100061,changsha,6Series
-448.0,2015,100072,1AA100072,changsha,4Series

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_362.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_362.csv b/integration-testcases/src/test/resources/hiveExpected/TC_362.csv
deleted file mode 100644
index 7f9a637..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_362.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType
-2015,1,1AA1,yichang,7Series,2738.562
-2015,10,1AA10,yichang,7Series,1714.635
-2015,100,1AA100,xiangtan,5Series,1271.0
-2015,1000,1AA1000,wuhan,5Series,692.0
-2015,10000,1AA10000,guangzhou,7Series,2175.0
-2015,100000,1AA100000,wuhan,9Series,136.0
-2015,1000000,1AA1000000,yichang,7Series,1600.0
-2015,100001,1AA100001,xiangtan,0Series,505.0
-2015,100002,1AA100002,changsha,0Series,1341.0
-2015,100003,1AA100003,zhuzhou,5Series,2239.0
-2015,100004,1AA100004,yichang,4Series,2970.0
-2015,100005,1AA100005,yichang,1Series,2593.0
-2015,100006,1AA100006,changsha,6Series,2572.0
-2015,100007,1AA100007,changsha,9Series,1991.0
-2015,100008,1AA100008,changsha,8Series,1442.0
-2015,100009,1AA100009,yichang,0Series,1841.0
-2015,10001,1AA10001,changsha,2Series,298.0
-2015,100010,1AA100010,zhuzhou,3Series,79.0
-2015,100011,1AA100011,guangzhou,0Series,202.0
-2015,100012,1AA100012,xiangtan,4Series,568.0
-2015,100013,1AA100013,changsha,1Series,355.0
-2015,100014,1AA100014,zhuzhou,5Series,151.0
-2015,100015,1AA100015,xiangtan,4Series,2863.0
-2015,100016,1AA100016,changsha,3Series,1873.0
-2015,100017,1AA100017,xiangtan,9Series,2205.0
-2015,100018,1AA100018,yichang,8Series,441.0
-2015,100019,1AA100019,zhuzhou,5Series,2194.0
-2015,10002,1AA10002,wuhan,0Series,2972.0
-2015,100020,1AA100020,shenzhen,5Series,256.0
-2015,100021,1AA100021,changsha,0Series,1778.0
-2015,100022,1AA100022,zhuzhou,5Series,1999.0
-2015,100023,1AA100023,guangzhou,5Series,2194.0
-2015,100024,1AA100024,changsha,6Series,2483.0
-2015,100025,1AA100025,guangzhou,0Series,1724.0
-2015,100026,1AA100026,yichang,7Series,1768.0
-2015,100027,1AA100027,zhuzhou,0Series,2436.0
-2015,100028,1AA100028,zhuzhou,5Series,2849.0
-2015,100029,1AA100029,xiangtan,2Series,1691.0
-2015,10003,1AA10003,xiangtan,7Series,2071.0
-2015,100030,1AA100030,zhuzhou,7Series,1333.0
-2015,100031,1AA100031,yichang,7Series,1080.0
-2015,100032,1AA100032,shenzhen,1Series,1053.0
-2015,100033,1AA100033,wuhan,8Series,760.0
-2015,100034,1AA100034,guangzhou,2Series,2061.0
-2015,100035,1AA100035,changsha,5Series,2142.0
-2015,100036,1AA100036,changsha,5Series,2224.0
-2015,100037,1AA100037,xiangtan,7Series,1015.0
-2015,100038,1AA100038,shenzhen,6Series,1229.0
-2015,100039,1AA100039,shenzhen,8Series,1750.0
-2015,10004,1AA10004,guangzhou,5Series,1717.0
-2015,100040,1AA100040,yichang,8Series,2078.0
-2015,100041,1AA100041,shenzhen,5Series,2734.0
-2015,100042,1AA100042,shenzhen,3Series,2745.0
-2015,100043,1AA100043,guangzhou,9Series,571.0
-2015,100044,1AA100044,guangzhou,8Series,1697.0
-2015,100045,1AA100045,xiangtan,2Series,2553.0
-2015,100046,1AA100046,guangzhou,3Series,1077.0
-2015,100047,1AA100047,zhuzhou,9Series,1823.0
-2015,100048,1AA100048,guangzhou,3Series,2399.0
-2015,100049,1AA100049,guangzhou,0Series,2890.0
-2015,10005,1AA10005,xiangtan,8Series,1608.0
-2015,100050,1AA100050,yichang,2Series,29.0
-2015,100051,1AA100051,guangzhou,2Series,1407.0
-2015,100052,1AA100052,zhuzhou,6Series,845.0
-2015,100053,1AA100053,wuhan,2Series,1655.0
-2015,100054,1AA100054,shenzhen,7Series,1368.0
-2015,100055,1AA100055,yichang,7Series,1728.0
-2015,100056,1AA100056,wuhan,6Series,750.0
-2015,100057,1AA100057,zhuzhou,9Series,2288.0
-2015,100058,1AA100058,guangzhou,5Series,2635.0
-2015,100059,1AA100059,shenzhen,4Series,1337.0
-2015,10006,1AA10006,guangzhou,3Series,2478.0
-2015,100060,1AA100060,xiangtan,8Series,538.0
-2015,100061,1AA100061,changsha,6Series,1407.0
-2015,100062,1AA100062,yichang,9Series,2952.0
-2015,100063,1AA100063,yichang,2Series,1226.0
-2015,100064,1AA100064,zhuzhou,6Series,865.0
-2015,100065,1AA100065,xiangtan,0Series,901.0
-2015,100066,1AA100066,zhuzhou,6Series,1864.0
-2015,100067,1AA100067,wuhan,4Series,572.0
-2015,100068,1AA100068,guangzhou,8Series,412.0
-2015,100069,1AA100069,xiangtan,8Series,1491.0
-2015,10007,1AA10007,xiangtan,8Series,1350.0
-2015,100070,1AA100070,guangzhou,0Series,1567.0
-2015,100071,1AA100071,guangzhou,0Series,1973.0
-2015,100072,1AA100072,changsha,4Series,448.0
-2015,100073,1AA100073,zhuzhou,4Series,2488.0
-2015,100074,1AA100074,wuhan,6Series,907.0
-2015,100075,1AA100075,shenzhen,3Series,2507.0
-2015,100076,1AA100076,wuhan,0Series,732.0
-2015,100077,1AA100077,yichang,3Series,2077.0
-2015,100078,1AA100078,yichang,2Series,1434.0
-2015,100079,1AA100079,xiangtan,4Series,1098.0
-2015,10008,1AA10008,shenzhen,5Series,813.0
-2015,100080,1AA100080,shenzhen,9Series,954.0
-2015,100081,1AA100081,shenzhen,5Series,613.0
-2015,100082,1AA100082,xiangtan,5Series,2348.0
-2015,100083,1AA100083,zhuzhou,0Series,2192.0
-2015,100084,1AA100084,guangzhou,0Series,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_363.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_363.csv b/integration-testcases/src/test/resources/hiveExpected/TC_363.csv
deleted file mode 100644
index 96dc76f..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_363.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType
-2015,1,1AA1,yichang,7Series,2738.562
-2015,10,1AA10,yichang,7Series,1714.635
-2015,100,1AA100,xiangtan,5Series,1271.0
-2015,1000,1AA1000,wuhan,5Series,692.0
-2015,10000,1AA10000,guangzhou,7Series,2175.0
-2015,10001,1AA10001,changsha,2Series,298.0
-2015,10002,1AA10002,wuhan,0Series,2972.0
-2015,10003,1AA10003,xiangtan,7Series,2071.0
-2015,10004,1AA10004,guangzhou,5Series,1717.0
-2015,10005,1AA10005,xiangtan,8Series,1608.0
-2015,10006,1AA10006,guangzhou,3Series,2478.0
-2015,10007,1AA10007,xiangtan,8Series,1350.0
-2015,10008,1AA10008,shenzhen,5Series,813.0
-2015,100000,1AA100000,wuhan,9Series,136.0
-2015,100001,1AA100001,xiangtan,0Series,505.0
-2015,100002,1AA100002,changsha,0Series,1341.0
-2015,100003,1AA100003,zhuzhou,5Series,2239.0
-2015,100004,1AA100004,yichang,4Series,2970.0
-2015,100005,1AA100005,yichang,1Series,2593.0
-2015,100006,1AA100006,changsha,6Series,2572.0
-2015,100007,1AA100007,changsha,9Series,1991.0
-2015,100008,1AA100008,changsha,8Series,1442.0
-2015,100009,1AA100009,yichang,0Series,1841.0
-2015,100010,1AA100010,zhuzhou,3Series,79.0
-2015,100011,1AA100011,guangzhou,0Series,202.0
-2015,100012,1AA100012,xiangtan,4Series,568.0
-2015,100013,1AA100013,changsha,1Series,355.0
-2015,100014,1AA100014,zhuzhou,5Series,151.0
-2015,100015,1AA100015,xiangtan,4Series,2863.0
-2015,100016,1AA100016,changsha,3Series,1873.0
-2015,100017,1AA100017,xiangtan,9Series,2205.0
-2015,100018,1AA100018,yichang,8Series,441.0
-2015,100019,1AA100019,zhuzhou,5Series,2194.0
-2015,100020,1AA100020,shenzhen,5Series,256.0
-2015,100021,1AA100021,changsha,0Series,1778.0
-2015,100022,1AA100022,zhuzhou,5Series,1999.0
-2015,100023,1AA100023,guangzhou,5Series,2194.0
-2015,100024,1AA100024,changsha,6Series,2483.0
-2015,100025,1AA100025,guangzhou,0Series,1724.0
-2015,100026,1AA100026,yichang,7Series,1768.0
-2015,100027,1AA100027,zhuzhou,0Series,2436.0
-2015,100028,1AA100028,zhuzhou,5Series,2849.0
-2015,100029,1AA100029,xiangtan,2Series,1691.0
-2015,100030,1AA100030,zhuzhou,7Series,1333.0
-2015,100031,1AA100031,yichang,7Series,1080.0
-2015,100032,1AA100032,shenzhen,1Series,1053.0
-2015,100033,1AA100033,wuhan,8Series,760.0
-2015,100034,1AA100034,guangzhou,2Series,2061.0
-2015,100035,1AA100035,changsha,5Series,2142.0
-2015,100036,1AA100036,changsha,5Series,2224.0
-2015,100037,1AA100037,xiangtan,7Series,1015.0
-2015,100038,1AA100038,shenzhen,6Series,1229.0
-2015,100039,1AA100039,shenzhen,8Series,1750.0
-2015,100040,1AA100040,yichang,8Series,2078.0
-2015,100041,1AA100041,shenzhen,5Series,2734.0
-2015,100042,1AA100042,shenzhen,3Series,2745.0
-2015,100043,1AA100043,guangzhou,9Series,571.0
-2015,100044,1AA100044,guangzhou,8Series,1697.0
-2015,100045,1AA100045,xiangtan,2Series,2553.0
-2015,100046,1AA100046,guangzhou,3Series,1077.0
-2015,100047,1AA100047,zhuzhou,9Series,1823.0
-2015,100048,1AA100048,guangzhou,3Series,2399.0
-2015,100049,1AA100049,guangzhou,0Series,2890.0
-2015,100050,1AA100050,yichang,2Series,29.0
-2015,100051,1AA100051,guangzhou,2Series,1407.0
-2015,100052,1AA100052,zhuzhou,6Series,845.0
-2015,100053,1AA100053,wuhan,2Series,1655.0
-2015,100054,1AA100054,shenzhen,7Series,1368.0
-2015,100055,1AA100055,yichang,7Series,1728.0
-2015,100056,1AA100056,wuhan,6Series,750.0
-2015,100057,1AA100057,zhuzhou,9Series,2288.0
-2015,100058,1AA100058,guangzhou,5Series,2635.0
-2015,100059,1AA100059,shenzhen,4Series,1337.0
-2015,100060,1AA100060,xiangtan,8Series,538.0
-2015,100061,1AA100061,changsha,6Series,1407.0
-2015,100062,1AA100062,yichang,9Series,2952.0
-2015,100063,1AA100063,yichang,2Series,1226.0
-2015,100064,1AA100064,zhuzhou,6Series,865.0
-2015,100065,1AA100065,xiangtan,0Series,901.0
-2015,100066,1AA100066,zhuzhou,6Series,1864.0
-2015,100067,1AA100067,wuhan,4Series,572.0
-2015,100068,1AA100068,guangzhou,8Series,412.0
-2015,100069,1AA100069,xiangtan,8Series,1491.0
-2015,100070,1AA100070,guangzhou,0Series,1567.0
-2015,100071,1AA100071,guangzhou,0Series,1973.0
-2015,100072,1AA100072,changsha,4Series,448.0
-2015,100073,1AA100073,zhuzhou,4Series,2488.0
-2015,100074,1AA100074,wuhan,6Series,907.0
-2015,100075,1AA100075,shenzhen,3Series,2507.0
-2015,100076,1AA100076,wuhan,0Series,732.0
-2015,100077,1AA100077,yichang,3Series,2077.0
-2015,100078,1AA100078,yichang,2Series,1434.0
-2015,100079,1AA100079,xiangtan,4Series,1098.0
-2015,100080,1AA100080,shenzhen,9Series,954.0
-2015,100081,1AA100081,shenzhen,5Series,613.0
-2015,100082,1AA100082,xiangtan,5Series,2348.0
-2015,100083,1AA100083,zhuzhou,0Series,2192.0
-2015,100084,1AA100084,guangzhou,0Series,2826.0
-2015,1000000,1AA1000000,yichang,7Series,1600.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_364.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_364.csv b/integration-testcases/src/test/resources/hiveExpected/TC_364.csv
deleted file mode 100644
index 49407bd..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_364.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType
-2015,1000000,1AA1000000,yichang,7Series,1600.0
-2015,100084,1AA100084,guangzhou,0Series,2826.0
-2015,100083,1AA100083,zhuzhou,0Series,2192.0
-2015,100082,1AA100082,xiangtan,5Series,2348.0
-2015,100081,1AA100081,shenzhen,5Series,613.0
-2015,100080,1AA100080,shenzhen,9Series,954.0
-2015,100079,1AA100079,xiangtan,4Series,1098.0
-2015,100078,1AA100078,yichang,2Series,1434.0
-2015,100077,1AA100077,yichang,3Series,2077.0
-2015,100076,1AA100076,wuhan,0Series,732.0
-2015,100075,1AA100075,shenzhen,3Series,2507.0
-2015,100074,1AA100074,wuhan,6Series,907.0
-2015,100073,1AA100073,zhuzhou,4Series,2488.0
-2015,100072,1AA100072,changsha,4Series,448.0
-2015,100071,1AA100071,guangzhou,0Series,1973.0
-2015,100070,1AA100070,guangzhou,0Series,1567.0
-2015,100069,1AA100069,xiangtan,8Series,1491.0
-2015,100068,1AA100068,guangzhou,8Series,412.0
-2015,100067,1AA100067,wuhan,4Series,572.0
-2015,100066,1AA100066,zhuzhou,6Series,1864.0
-2015,100065,1AA100065,xiangtan,0Series,901.0
-2015,100064,1AA100064,zhuzhou,6Series,865.0
-2015,100063,1AA100063,yichang,2Series,1226.0
-2015,100062,1AA100062,yichang,9Series,2952.0
-2015,100061,1AA100061,changsha,6Series,1407.0
-2015,100060,1AA100060,xiangtan,8Series,538.0
-2015,100059,1AA100059,shenzhen,4Series,1337.0
-2015,100058,1AA100058,guangzhou,5Series,2635.0
-2015,100057,1AA100057,zhuzhou,9Series,2288.0
-2015,100056,1AA100056,wuhan,6Series,750.0
-2015,100055,1AA100055,yichang,7Series,1728.0
-2015,100054,1AA100054,shenzhen,7Series,1368.0
-2015,100053,1AA100053,wuhan,2Series,1655.0
-2015,100052,1AA100052,zhuzhou,6Series,845.0
-2015,100051,1AA100051,guangzhou,2Series,1407.0
-2015,100050,1AA100050,yichang,2Series,29.0
-2015,100049,1AA100049,guangzhou,0Series,2890.0
-2015,100048,1AA100048,guangzhou,3Series,2399.0
-2015,100047,1AA100047,zhuzhou,9Series,1823.0
-2015,100046,1AA100046,guangzhou,3Series,1077.0
-2015,100045,1AA100045,xiangtan,2Series,2553.0
-2015,100044,1AA100044,guangzhou,8Series,1697.0
-2015,100043,1AA100043,guangzhou,9Series,571.0
-2015,100042,1AA100042,shenzhen,3Series,2745.0
-2015,100041,1AA100041,shenzhen,5Series,2734.0
-2015,100040,1AA100040,yichang,8Series,2078.0
-2015,100039,1AA100039,shenzhen,8Series,1750.0
-2015,100038,1AA100038,shenzhen,6Series,1229.0
-2015,100037,1AA100037,xiangtan,7Series,1015.0
-2015,100036,1AA100036,changsha,5Series,2224.0
-2015,100035,1AA100035,changsha,5Series,2142.0
-2015,100034,1AA100034,guangzhou,2Series,2061.0
-2015,100033,1AA100033,wuhan,8Series,760.0
-2015,100032,1AA100032,shenzhen,1Series,1053.0
-2015,100031,1AA100031,yichang,7Series,1080.0
-2015,100030,1AA100030,zhuzhou,7Series,1333.0
-2015,100029,1AA100029,xiangtan,2Series,1691.0
-2015,100028,1AA100028,zhuzhou,5Series,2849.0
-2015,100027,1AA100027,zhuzhou,0Series,2436.0
-2015,100026,1AA100026,yichang,7Series,1768.0
-2015,100025,1AA100025,guangzhou,0Series,1724.0
-2015,100024,1AA100024,changsha,6Series,2483.0
-2015,100023,1AA100023,guangzhou,5Series,2194.0
-2015,100022,1AA100022,zhuzhou,5Series,1999.0
-2015,100021,1AA100021,changsha,0Series,1778.0
-2015,100020,1AA100020,shenzhen,5Series,256.0
-2015,100019,1AA100019,zhuzhou,5Series,2194.0
-2015,100018,1AA100018,yichang,8Series,441.0
-2015,100017,1AA100017,xiangtan,9Series,2205.0
-2015,100016,1AA100016,changsha,3Series,1873.0
-2015,100015,1AA100015,xiangtan,4Series,2863.0
-2015,100014,1AA100014,zhuzhou,5Series,151.0
-2015,100013,1AA100013,changsha,1Series,355.0
-2015,100012,1AA100012,xiangtan,4Series,568.0
-2015,100011,1AA100011,guangzhou,0Series,202.0
-2015,100010,1AA100010,zhuzhou,3Series,79.0
-2015,100009,1AA100009,yichang,0Series,1841.0
-2015,100008,1AA100008,changsha,8Series,1442.0
-2015,100007,1AA100007,changsha,9Series,1991.0
-2015,100006,1AA100006,changsha,6Series,2572.0
-2015,100005,1AA100005,yichang,1Series,2593.0
-2015,100004,1AA100004,yichang,4Series,2970.0
-2015,100003,1AA100003,zhuzhou,5Series,2239.0
-2015,100002,1AA100002,changsha,0Series,1341.0
-2015,100001,1AA100001,xiangtan,0Series,505.0
-2015,100000,1AA100000,wuhan,9Series,136.0
-2015,10008,1AA10008,shenzhen,5Series,813.0
-2015,10007,1AA10007,xiangtan,8Series,1350.0
-2015,10006,1AA10006,guangzhou,3Series,2478.0
-2015,10005,1AA10005,xiangtan,8Series,1608.0
-2015,10004,1AA10004,guangzhou,5Series,1717.0
-2015,10003,1AA10003,xiangtan,7Series,2071.0
-2015,10002,1AA10002,wuhan,0Series,2972.0
-2015,10001,1AA10001,changsha,2Series,298.0
-2015,10000,1AA10000,guangzhou,7Series,2175.0
-2015,1000,1AA1000,wuhan,5Series,692.0
-2015,100,1AA100,xiangtan,5Series,1271.0
-2015,10,1AA10,yichang,7Series,1714.635
-2015,1,1AA1,yichang,7Series,2738.562

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_365.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_365.csv b/integration-testcases/src/test/resources/hiveExpected/TC_365.csv
deleted file mode 100644
index aae08e4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_365.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Sum_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1,2738.562
-1AA10,yichang,7Series,2015,10,1714.635
-1AA100,xiangtan,5Series,2015,100,1271.0
-1AA1000,wuhan,5Series,2015,1000,692.0
-1AA10000,guangzhou,7Series,2015,10000,2175.0
-1AA100000,wuhan,9Series,2015,100000,136.0
-1AA1000000,yichang,7Series,2015,1000000,1600.0
-1AA100001,xiangtan,0Series,2015,100001,505.0
-1AA100002,changsha,0Series,2015,100002,1341.0
-1AA100003,zhuzhou,5Series,2015,100003,2239.0
-1AA100004,yichang,4Series,2015,100004,2970.0
-1AA100005,yichang,1Series,2015,100005,2593.0
-1AA100006,changsha,6Series,2015,100006,2572.0
-1AA100007,changsha,9Series,2015,100007,1991.0
-1AA100008,changsha,8Series,2015,100008,1442.0
-1AA100009,yichang,0Series,2015,100009,1841.0
-1AA10001,changsha,2Series,2015,10001,298.0
-1AA100010,zhuzhou,3Series,2015,100010,79.0
-1AA100011,guangzhou,0Series,2015,100011,202.0
-1AA100012,xiangtan,4Series,2015,100012,568.0
-1AA100013,changsha,1Series,2015,100013,355.0
-1AA100014,zhuzhou,5Series,2015,100014,151.0
-1AA100015,xiangtan,4Series,2015,100015,2863.0
-1AA100016,changsha,3Series,2015,100016,1873.0
-1AA100017,xiangtan,9Series,2015,100017,2205.0
-1AA100018,yichang,8Series,2015,100018,441.0
-1AA100019,zhuzhou,5Series,2015,100019,2194.0
-1AA10002,wuhan,0Series,2015,10002,2972.0
-1AA100020,shenzhen,5Series,2015,100020,256.0
-1AA100021,changsha,0Series,2015,100021,1778.0
-1AA100022,zhuzhou,5Series,2015,100022,1999.0
-1AA100023,guangzhou,5Series,2015,100023,2194.0
-1AA100024,changsha,6Series,2015,100024,2483.0
-1AA100025,guangzhou,0Series,2015,100025,1724.0
-1AA100026,yichang,7Series,2015,100026,1768.0
-1AA100027,zhuzhou,0Series,2015,100027,2436.0
-1AA100028,zhuzhou,5Series,2015,100028,2849.0
-1AA100029,xiangtan,2Series,2015,100029,1691.0
-1AA10003,xiangtan,7Series,2015,10003,2071.0
-1AA100030,zhuzhou,7Series,2015,100030,1333.0
-1AA100031,yichang,7Series,2015,100031,1080.0
-1AA100032,shenzhen,1Series,2015,100032,1053.0
-1AA100033,wuhan,8Series,2015,100033,760.0
-1AA100034,guangzhou,2Series,2015,100034,2061.0
-1AA100035,changsha,5Series,2015,100035,2142.0
-1AA100036,changsha,5Series,2015,100036,2224.0
-1AA100037,xiangtan,7Series,2015,100037,1015.0
-1AA100038,shenzhen,6Series,2015,100038,1229.0
-1AA100039,shenzhen,8Series,2015,100039,1750.0
-1AA10004,guangzhou,5Series,2015,10004,1717.0
-1AA100040,yichang,8Series,2015,100040,2078.0
-1AA100041,shenzhen,5Series,2015,100041,2734.0
-1AA100042,shenzhen,3Series,2015,100042,2745.0
-1AA100043,guangzhou,9Series,2015,100043,571.0
-1AA100044,guangzhou,8Series,2015,100044,1697.0
-1AA100045,xiangtan,2Series,2015,100045,2553.0
-1AA100046,guangzhou,3Series,2015,100046,1077.0
-1AA100047,zhuzhou,9Series,2015,100047,1823.0
-1AA100048,guangzhou,3Series,2015,100048,2399.0
-1AA100049,guangzhou,0Series,2015,100049,2890.0
-1AA10005,xiangtan,8Series,2015,10005,1608.0
-1AA100050,yichang,2Series,2015,100050,29.0
-1AA100051,guangzhou,2Series,2015,100051,1407.0
-1AA100052,zhuzhou,6Series,2015,100052,845.0
-1AA100053,wuhan,2Series,2015,100053,1655.0
-1AA100054,shenzhen,7Series,2015,100054,1368.0
-1AA100055,yichang,7Series,2015,100055,1728.0
-1AA100056,wuhan,6Series,2015,100056,750.0
-1AA100057,zhuzhou,9Series,2015,100057,2288.0
-1AA100058,guangzhou,5Series,2015,100058,2635.0
-1AA100059,shenzhen,4Series,2015,100059,1337.0
-1AA10006,guangzhou,3Series,2015,10006,2478.0
-1AA100060,xiangtan,8Series,2015,100060,538.0
-1AA100061,changsha,6Series,2015,100061,1407.0
-1AA100062,yichang,9Series,2015,100062,2952.0
-1AA100063,yichang,2Series,2015,100063,1226.0
-1AA100064,zhuzhou,6Series,2015,100064,865.0
-1AA100065,xiangtan,0Series,2015,100065,901.0
-1AA100066,zhuzhou,6Series,2015,100066,1864.0
-1AA100067,wuhan,4Series,2015,100067,572.0
-1AA100068,guangzhou,8Series,2015,100068,412.0
-1AA100069,xiangtan,8Series,2015,100069,1491.0
-1AA10007,xiangtan,8Series,2015,10007,1350.0
-1AA100070,guangzhou,0Series,2015,100070,1567.0
-1AA100071,guangzhou,0Series,2015,100071,1973.0
-1AA100072,changsha,4Series,2015,100072,448.0
-1AA100073,zhuzhou,4Series,2015,100073,2488.0
-1AA100074,wuhan,6Series,2015,100074,907.0
-1AA100075,shenzhen,3Series,2015,100075,2507.0
-1AA100076,wuhan,0Series,2015,100076,732.0
-1AA100077,yichang,3Series,2015,100077,2077.0
-1AA100078,yichang,2Series,2015,100078,1434.0
-1AA100079,xiangtan,4Series,2015,100079,1098.0
-1AA10008,shenzhen,5Series,2015,10008,813.0
-1AA100080,shenzhen,9Series,2015,100080,954.0
-1AA100081,shenzhen,5Series,2015,100081,613.0
-1AA100082,xiangtan,5Series,2015,100082,2348.0
-1AA100083,zhuzhou,0Series,2015,100083,2192.0
-1AA100084,guangzhou,0Series,2015,100084,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_366.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_366.csv b/integration-testcases/src/test/resources/hiveExpected/TC_366.csv
deleted file mode 100644
index f2d9c82..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_366.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Avg_deviceInformationId DoubleType,Sum_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1.0,2738.562
-1AA10,yichang,7Series,2015,10.0,1714.635
-1AA100,xiangtan,5Series,2015,100.0,1271.0
-1AA1000,wuhan,5Series,2015,1000.0,692.0
-1AA10000,guangzhou,7Series,2015,10000.0,2175.0
-1AA100000,wuhan,9Series,2015,100000.0,136.0
-1AA1000000,yichang,7Series,2015,1000000.0,1600.0
-1AA100001,xiangtan,0Series,2015,100001.0,505.0
-1AA100002,changsha,0Series,2015,100002.0,1341.0
-1AA100003,zhuzhou,5Series,2015,100003.0,2239.0
-1AA100004,yichang,4Series,2015,100004.0,2970.0
-1AA100005,yichang,1Series,2015,100005.0,2593.0
-1AA100006,changsha,6Series,2015,100006.0,2572.0
-1AA100007,changsha,9Series,2015,100007.0,1991.0
-1AA100008,changsha,8Series,2015,100008.0,1442.0
-1AA100009,yichang,0Series,2015,100009.0,1841.0
-1AA10001,changsha,2Series,2015,10001.0,298.0
-1AA100010,zhuzhou,3Series,2015,100010.0,79.0
-1AA100011,guangzhou,0Series,2015,100011.0,202.0
-1AA100012,xiangtan,4Series,2015,100012.0,568.0
-1AA100013,changsha,1Series,2015,100013.0,355.0
-1AA100014,zhuzhou,5Series,2015,100014.0,151.0
-1AA100015,xiangtan,4Series,2015,100015.0,2863.0
-1AA100016,changsha,3Series,2015,100016.0,1873.0
-1AA100017,xiangtan,9Series,2015,100017.0,2205.0
-1AA100018,yichang,8Series,2015,100018.0,441.0
-1AA100019,zhuzhou,5Series,2015,100019.0,2194.0
-1AA10002,wuhan,0Series,2015,10002.0,2972.0
-1AA100020,shenzhen,5Series,2015,100020.0,256.0
-1AA100021,changsha,0Series,2015,100021.0,1778.0
-1AA100022,zhuzhou,5Series,2015,100022.0,1999.0
-1AA100023,guangzhou,5Series,2015,100023.0,2194.0
-1AA100024,changsha,6Series,2015,100024.0,2483.0
-1AA100025,guangzhou,0Series,2015,100025.0,1724.0
-1AA100026,yichang,7Series,2015,100026.0,1768.0
-1AA100027,zhuzhou,0Series,2015,100027.0,2436.0
-1AA100028,zhuzhou,5Series,2015,100028.0,2849.0
-1AA100029,xiangtan,2Series,2015,100029.0,1691.0
-1AA10003,xiangtan,7Series,2015,10003.0,2071.0
-1AA100030,zhuzhou,7Series,2015,100030.0,1333.0
-1AA100031,yichang,7Series,2015,100031.0,1080.0
-1AA100032,shenzhen,1Series,2015,100032.0,1053.0
-1AA100033,wuhan,8Series,2015,100033.0,760.0
-1AA100034,guangzhou,2Series,2015,100034.0,2061.0
-1AA100035,changsha,5Series,2015,100035.0,2142.0
-1AA100036,changsha,5Series,2015,100036.0,2224.0
-1AA100037,xiangtan,7Series,2015,100037.0,1015.0
-1AA100038,shenzhen,6Series,2015,100038.0,1229.0
-1AA100039,shenzhen,8Series,2015,100039.0,1750.0
-1AA10004,guangzhou,5Series,2015,10004.0,1717.0
-1AA100040,yichang,8Series,2015,100040.0,2078.0
-1AA100041,shenzhen,5Series,2015,100041.0,2734.0
-1AA100042,shenzhen,3Series,2015,100042.0,2745.0
-1AA100043,guangzhou,9Series,2015,100043.0,571.0
-1AA100044,guangzhou,8Series,2015,100044.0,1697.0
-1AA100045,xiangtan,2Series,2015,100045.0,2553.0
-1AA100046,guangzhou,3Series,2015,100046.0,1077.0
-1AA100047,zhuzhou,9Series,2015,100047.0,1823.0
-1AA100048,guangzhou,3Series,2015,100048.0,2399.0
-1AA100049,guangzhou,0Series,2015,100049.0,2890.0
-1AA10005,xiangtan,8Series,2015,10005.0,1608.0
-1AA100050,yichang,2Series,2015,100050.0,29.0
-1AA100051,guangzhou,2Series,2015,100051.0,1407.0
-1AA100052,zhuzhou,6Series,2015,100052.0,845.0
-1AA100053,wuhan,2Series,2015,100053.0,1655.0
-1AA100054,shenzhen,7Series,2015,100054.0,1368.0
-1AA100055,yichang,7Series,2015,100055.0,1728.0
-1AA100056,wuhan,6Series,2015,100056.0,750.0
-1AA100057,zhuzhou,9Series,2015,100057.0,2288.0
-1AA100058,guangzhou,5Series,2015,100058.0,2635.0
-1AA100059,shenzhen,4Series,2015,100059.0,1337.0
-1AA10006,guangzhou,3Series,2015,10006.0,2478.0
-1AA100060,xiangtan,8Series,2015,100060.0,538.0
-1AA100061,changsha,6Series,2015,100061.0,1407.0
-1AA100062,yichang,9Series,2015,100062.0,2952.0
-1AA100063,yichang,2Series,2015,100063.0,1226.0
-1AA100064,zhuzhou,6Series,2015,100064.0,865.0
-1AA100065,xiangtan,0Series,2015,100065.0,901.0
-1AA100066,zhuzhou,6Series,2015,100066.0,1864.0
-1AA100067,wuhan,4Series,2015,100067.0,572.0
-1AA100068,guangzhou,8Series,2015,100068.0,412.0
-1AA100069,xiangtan,8Series,2015,100069.0,1491.0
-1AA10007,xiangtan,8Series,2015,10007.0,1350.0
-1AA100070,guangzhou,0Series,2015,100070.0,1567.0
-1AA100071,guangzhou,0Series,2015,100071.0,1973.0
-1AA100072,changsha,4Series,2015,100072.0,448.0
-1AA100073,zhuzhou,4Series,2015,100073.0,2488.0
-1AA100074,wuhan,6Series,2015,100074.0,907.0
-1AA100075,shenzhen,3Series,2015,100075.0,2507.0
-1AA100076,wuhan,0Series,2015,100076.0,732.0
-1AA100077,yichang,3Series,2015,100077.0,2077.0
-1AA100078,yichang,2Series,2015,100078.0,1434.0
-1AA100079,xiangtan,4Series,2015,100079.0,1098.0
-1AA10008,shenzhen,5Series,2015,10008.0,813.0
-1AA100080,shenzhen,9Series,2015,100080.0,954.0
-1AA100081,shenzhen,5Series,2015,100081.0,613.0
-1AA100082,xiangtan,5Series,2015,100082.0,2348.0
-1AA100083,zhuzhou,0Series,2015,100083.0,2192.0
-1AA100084,guangzhou,0Series,2015,100084.0,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_367.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_367.csv b/integration-testcases/src/test/resources/hiveExpected/TC_367.csv
deleted file mode 100644
index 3714f21..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_367.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Count_deviceInformationId LongType,Sum_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1,2738.562
-1AA10,yichang,7Series,2015,1,1714.635
-1AA100,xiangtan,5Series,2015,1,1271.0
-1AA1000,wuhan,5Series,2015,1,692.0
-1AA10000,guangzhou,7Series,2015,1,2175.0
-1AA100000,wuhan,9Series,2015,1,136.0
-1AA1000000,yichang,7Series,2015,1,1600.0
-1AA100001,xiangtan,0Series,2015,1,505.0
-1AA100002,changsha,0Series,2015,1,1341.0
-1AA100003,zhuzhou,5Series,2015,1,2239.0
-1AA100004,yichang,4Series,2015,1,2970.0
-1AA100005,yichang,1Series,2015,1,2593.0
-1AA100006,changsha,6Series,2015,1,2572.0
-1AA100007,changsha,9Series,2015,1,1991.0
-1AA100008,changsha,8Series,2015,1,1442.0
-1AA100009,yichang,0Series,2015,1,1841.0
-1AA10001,changsha,2Series,2015,1,298.0
-1AA100010,zhuzhou,3Series,2015,1,79.0
-1AA100011,guangzhou,0Series,2015,1,202.0
-1AA100012,xiangtan,4Series,2015,1,568.0
-1AA100013,changsha,1Series,2015,1,355.0
-1AA100014,zhuzhou,5Series,2015,1,151.0
-1AA100015,xiangtan,4Series,2015,1,2863.0
-1AA100016,changsha,3Series,2015,1,1873.0
-1AA100017,xiangtan,9Series,2015,1,2205.0
-1AA100018,yichang,8Series,2015,1,441.0
-1AA100019,zhuzhou,5Series,2015,1,2194.0
-1AA10002,wuhan,0Series,2015,1,2972.0
-1AA100020,shenzhen,5Series,2015,1,256.0
-1AA100021,changsha,0Series,2015,1,1778.0
-1AA100022,zhuzhou,5Series,2015,1,1999.0
-1AA100023,guangzhou,5Series,2015,1,2194.0
-1AA100024,changsha,6Series,2015,1,2483.0
-1AA100025,guangzhou,0Series,2015,1,1724.0
-1AA100026,yichang,7Series,2015,1,1768.0
-1AA100027,zhuzhou,0Series,2015,1,2436.0
-1AA100028,zhuzhou,5Series,2015,1,2849.0
-1AA100029,xiangtan,2Series,2015,1,1691.0
-1AA10003,xiangtan,7Series,2015,1,2071.0
-1AA100030,zhuzhou,7Series,2015,1,1333.0
-1AA100031,yichang,7Series,2015,1,1080.0
-1AA100032,shenzhen,1Series,2015,1,1053.0
-1AA100033,wuhan,8Series,2015,1,760.0
-1AA100034,guangzhou,2Series,2015,1,2061.0
-1AA100035,changsha,5Series,2015,1,2142.0
-1AA100036,changsha,5Series,2015,1,2224.0
-1AA100037,xiangtan,7Series,2015,1,1015.0
-1AA100038,shenzhen,6Series,2015,1,1229.0
-1AA100039,shenzhen,8Series,2015,1,1750.0
-1AA10004,guangzhou,5Series,2015,1,1717.0
-1AA100040,yichang,8Series,2015,1,2078.0
-1AA100041,shenzhen,5Series,2015,1,2734.0
-1AA100042,shenzhen,3Series,2015,1,2745.0
-1AA100043,guangzhou,9Series,2015,1,571.0
-1AA100044,guangzhou,8Series,2015,1,1697.0
-1AA100045,xiangtan,2Series,2015,1,2553.0
-1AA100046,guangzhou,3Series,2015,1,1077.0
-1AA100047,zhuzhou,9Series,2015,1,1823.0
-1AA100048,guangzhou,3Series,2015,1,2399.0
-1AA100049,guangzhou,0Series,2015,1,2890.0
-1AA10005,xiangtan,8Series,2015,1,1608.0
-1AA100050,yichang,2Series,2015,1,29.0
-1AA100051,guangzhou,2Series,2015,1,1407.0
-1AA100052,zhuzhou,6Series,2015,1,845.0
-1AA100053,wuhan,2Series,2015,1,1655.0
-1AA100054,shenzhen,7Series,2015,1,1368.0
-1AA100055,yichang,7Series,2015,1,1728.0
-1AA100056,wuhan,6Series,2015,1,750.0
-1AA100057,zhuzhou,9Series,2015,1,2288.0
-1AA100058,guangzhou,5Series,2015,1,2635.0
-1AA100059,shenzhen,4Series,2015,1,1337.0
-1AA10006,guangzhou,3Series,2015,1,2478.0
-1AA100060,xiangtan,8Series,2015,1,538.0
-1AA100061,changsha,6Series,2015,1,1407.0
-1AA100062,yichang,9Series,2015,1,2952.0
-1AA100063,yichang,2Series,2015,1,1226.0
-1AA100064,zhuzhou,6Series,2015,1,865.0
-1AA100065,xiangtan,0Series,2015,1,901.0
-1AA100066,zhuzhou,6Series,2015,1,1864.0
-1AA100067,wuhan,4Series,2015,1,572.0
-1AA100068,guangzhou,8Series,2015,1,412.0
-1AA100069,xiangtan,8Series,2015,1,1491.0
-1AA10007,xiangtan,8Series,2015,1,1350.0
-1AA100070,guangzhou,0Series,2015,1,1567.0
-1AA100071,guangzhou,0Series,2015,1,1973.0
-1AA100072,changsha,4Series,2015,1,448.0
-1AA100073,zhuzhou,4Series,2015,1,2488.0
-1AA100074,wuhan,6Series,2015,1,907.0
-1AA100075,shenzhen,3Series,2015,1,2507.0
-1AA100076,wuhan,0Series,2015,1,732.0
-1AA100077,yichang,3Series,2015,1,2077.0
-1AA100078,yichang,2Series,2015,1,1434.0
-1AA100079,xiangtan,4Series,2015,1,1098.0
-1AA10008,shenzhen,5Series,2015,1,813.0
-1AA100080,shenzhen,9Series,2015,1,954.0
-1AA100081,shenzhen,5Series,2015,1,613.0
-1AA100082,xiangtan,5Series,2015,1,2348.0
-1AA100083,zhuzhou,0Series,2015,1,2192.0
-1AA100084,guangzhou,0Series,2015,1,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_368.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_368.csv b/integration-testcases/src/test/resources/hiveExpected/TC_368.csv
deleted file mode 100644
index 9f4f844..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_368.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,LONG_COL_0 LongType,Sum_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1,2738.562
-1AA10,yichang,7Series,2015,1,1714.635
-1AA100,xiangtan,5Series,2015,1,1271.0
-1AA1000,wuhan,5Series,2015,1,692.0
-1AA10000,guangzhou,7Series,2015,1,2175.0
-1AA100000,wuhan,9Series,2015,1,136.0
-1AA1000000,yichang,7Series,2015,1,1600.0
-1AA100001,xiangtan,0Series,2015,1,505.0
-1AA100002,changsha,0Series,2015,1,1341.0
-1AA100003,zhuzhou,5Series,2015,1,2239.0
-1AA100004,yichang,4Series,2015,1,2970.0
-1AA100005,yichang,1Series,2015,1,2593.0
-1AA100006,changsha,6Series,2015,1,2572.0
-1AA100007,changsha,9Series,2015,1,1991.0
-1AA100008,changsha,8Series,2015,1,1442.0
-1AA100009,yichang,0Series,2015,1,1841.0
-1AA10001,changsha,2Series,2015,1,298.0
-1AA100010,zhuzhou,3Series,2015,1,79.0
-1AA100011,guangzhou,0Series,2015,1,202.0
-1AA100012,xiangtan,4Series,2015,1,568.0
-1AA100013,changsha,1Series,2015,1,355.0
-1AA100014,zhuzhou,5Series,2015,1,151.0
-1AA100015,xiangtan,4Series,2015,1,2863.0
-1AA100016,changsha,3Series,2015,1,1873.0
-1AA100017,xiangtan,9Series,2015,1,2205.0
-1AA100018,yichang,8Series,2015,1,441.0
-1AA100019,zhuzhou,5Series,2015,1,2194.0
-1AA10002,wuhan,0Series,2015,1,2972.0
-1AA100020,shenzhen,5Series,2015,1,256.0
-1AA100021,changsha,0Series,2015,1,1778.0
-1AA100022,zhuzhou,5Series,2015,1,1999.0
-1AA100023,guangzhou,5Series,2015,1,2194.0
-1AA100024,changsha,6Series,2015,1,2483.0
-1AA100025,guangzhou,0Series,2015,1,1724.0
-1AA100026,yichang,7Series,2015,1,1768.0
-1AA100027,zhuzhou,0Series,2015,1,2436.0
-1AA100028,zhuzhou,5Series,2015,1,2849.0
-1AA100029,xiangtan,2Series,2015,1,1691.0
-1AA10003,xiangtan,7Series,2015,1,2071.0
-1AA100030,zhuzhou,7Series,2015,1,1333.0
-1AA100031,yichang,7Series,2015,1,1080.0
-1AA100032,shenzhen,1Series,2015,1,1053.0
-1AA100033,wuhan,8Series,2015,1,760.0
-1AA100034,guangzhou,2Series,2015,1,2061.0
-1AA100035,changsha,5Series,2015,1,2142.0
-1AA100036,changsha,5Series,2015,1,2224.0
-1AA100037,xiangtan,7Series,2015,1,1015.0
-1AA100038,shenzhen,6Series,2015,1,1229.0
-1AA100039,shenzhen,8Series,2015,1,1750.0
-1AA10004,guangzhou,5Series,2015,1,1717.0
-1AA100040,yichang,8Series,2015,1,2078.0
-1AA100041,shenzhen,5Series,2015,1,2734.0
-1AA100042,shenzhen,3Series,2015,1,2745.0
-1AA100043,guangzhou,9Series,2015,1,571.0
-1AA100044,guangzhou,8Series,2015,1,1697.0
-1AA100045,xiangtan,2Series,2015,1,2553.0
-1AA100046,guangzhou,3Series,2015,1,1077.0
-1AA100047,zhuzhou,9Series,2015,1,1823.0
-1AA100048,guangzhou,3Series,2015,1,2399.0
-1AA100049,guangzhou,0Series,2015,1,2890.0
-1AA10005,xiangtan,8Series,2015,1,1608.0
-1AA100050,yichang,2Series,2015,1,29.0
-1AA100051,guangzhou,2Series,2015,1,1407.0
-1AA100052,zhuzhou,6Series,2015,1,845.0
-1AA100053,wuhan,2Series,2015,1,1655.0
-1AA100054,shenzhen,7Series,2015,1,1368.0
-1AA100055,yichang,7Series,2015,1,1728.0
-1AA100056,wuhan,6Series,2015,1,750.0
-1AA100057,zhuzhou,9Series,2015,1,2288.0
-1AA100058,guangzhou,5Series,2015,1,2635.0
-1AA100059,shenzhen,4Series,2015,1,1337.0
-1AA10006,guangzhou,3Series,2015,1,2478.0
-1AA100060,xiangtan,8Series,2015,1,538.0
-1AA100061,changsha,6Series,2015,1,1407.0
-1AA100062,yichang,9Series,2015,1,2952.0
-1AA100063,yichang,2Series,2015,1,1226.0
-1AA100064,zhuzhou,6Series,2015,1,865.0
-1AA100065,xiangtan,0Series,2015,1,901.0
-1AA100066,zhuzhou,6Series,2015,1,1864.0
-1AA100067,wuhan,4Series,2015,1,572.0
-1AA100068,guangzhou,8Series,2015,1,412.0
-1AA100069,xiangtan,8Series,2015,1,1491.0
-1AA10007,xiangtan,8Series,2015,1,1350.0
-1AA100070,guangzhou,0Series,2015,1,1567.0
-1AA100071,guangzhou,0Series,2015,1,1973.0
-1AA100072,changsha,4Series,2015,1,448.0
-1AA100073,zhuzhou,4Series,2015,1,2488.0
-1AA100074,wuhan,6Series,2015,1,907.0
-1AA100075,shenzhen,3Series,2015,1,2507.0
-1AA100076,wuhan,0Series,2015,1,732.0
-1AA100077,yichang,3Series,2015,1,2077.0
-1AA100078,yichang,2Series,2015,1,1434.0
-1AA100079,xiangtan,4Series,2015,1,1098.0
-1AA10008,shenzhen,5Series,2015,1,813.0
-1AA100080,shenzhen,9Series,2015,1,954.0
-1AA100081,shenzhen,5Series,2015,1,613.0
-1AA100082,xiangtan,5Series,2015,1,2348.0
-1AA100083,zhuzhou,0Series,2015,1,2192.0
-1AA100084,guangzhou,0Series,2015,1,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_369.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_369.csv b/integration-testcases/src/test/resources/hiveExpected/TC_369.csv
deleted file mode 100644
index 4675f10..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_369.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-series StringType,gamePointId DoubleType,deviceInformationId IntegerType,Latest_YEAR IntegerType,imei StringType,deliveryCity StringType
-7Series,2738.562,1,2015,1AA1,yichang
-7Series,1714.635,10,2015,1AA10,yichang
-5Series,1271.0,100,2015,1AA100,xiangtan
-5Series,692.0,1000,2015,1AA1000,wuhan
-7Series,2175.0,10000,2015,1AA10000,guangzhou
-9Series,136.0,100000,2015,1AA100000,wuhan
-7Series,1600.0,1000000,2015,1AA1000000,yichang
-0Series,505.0,100001,2015,1AA100001,xiangtan
-0Series,1341.0,100002,2015,1AA100002,changsha
-5Series,2239.0,100003,2015,1AA100003,zhuzhou
-4Series,2970.0,100004,2015,1AA100004,yichang
-1Series,2593.0,100005,2015,1AA100005,yichang
-6Series,2572.0,100006,2015,1AA100006,changsha
-9Series,1991.0,100007,2015,1AA100007,changsha
-8Series,1442.0,100008,2015,1AA100008,changsha
-0Series,1841.0,100009,2015,1AA100009,yichang
-2Series,298.0,10001,2015,1AA10001,changsha
-3Series,79.0,100010,2015,1AA100010,zhuzhou
-0Series,202.0,100011,2015,1AA100011,guangzhou
-4Series,568.0,100012,2015,1AA100012,xiangtan
-1Series,355.0,100013,2015,1AA100013,changsha
-5Series,151.0,100014,2015,1AA100014,zhuzhou
-4Series,2863.0,100015,2015,1AA100015,xiangtan
-3Series,1873.0,100016,2015,1AA100016,changsha
-9Series,2205.0,100017,2015,1AA100017,xiangtan
-8Series,441.0,100018,2015,1AA100018,yichang
-5Series,2194.0,100019,2015,1AA100019,zhuzhou
-0Series,2972.0,10002,2015,1AA10002,wuhan
-5Series,256.0,100020,2015,1AA100020,shenzhen
-0Series,1778.0,100021,2015,1AA100021,changsha
-5Series,1999.0,100022,2015,1AA100022,zhuzhou
-5Series,2194.0,100023,2015,1AA100023,guangzhou
-6Series,2483.0,100024,2015,1AA100024,changsha
-0Series,1724.0,100025,2015,1AA100025,guangzhou
-7Series,1768.0,100026,2015,1AA100026,yichang
-0Series,2436.0,100027,2015,1AA100027,zhuzhou
-5Series,2849.0,100028,2015,1AA100028,zhuzhou
-2Series,1691.0,100029,2015,1AA100029,xiangtan
-7Series,2071.0,10003,2015,1AA10003,xiangtan
-7Series,1333.0,100030,2015,1AA100030,zhuzhou
-7Series,1080.0,100031,2015,1AA100031,yichang
-1Series,1053.0,100032,2015,1AA100032,shenzhen
-8Series,760.0,100033,2015,1AA100033,wuhan
-2Series,2061.0,100034,2015,1AA100034,guangzhou
-5Series,2142.0,100035,2015,1AA100035,changsha
-5Series,2224.0,100036,2015,1AA100036,changsha
-7Series,1015.0,100037,2015,1AA100037,xiangtan
-6Series,1229.0,100038,2015,1AA100038,shenzhen
-8Series,1750.0,100039,2015,1AA100039,shenzhen
-5Series,1717.0,10004,2015,1AA10004,guangzhou
-8Series,2078.0,100040,2015,1AA100040,yichang
-5Series,2734.0,100041,2015,1AA100041,shenzhen
-3Series,2745.0,100042,2015,1AA100042,shenzhen
-9Series,571.0,100043,2015,1AA100043,guangzhou
-8Series,1697.0,100044,2015,1AA100044,guangzhou
-2Series,2553.0,100045,2015,1AA100045,xiangtan
-3Series,1077.0,100046,2015,1AA100046,guangzhou
-9Series,1823.0,100047,2015,1AA100047,zhuzhou
-3Series,2399.0,100048,2015,1AA100048,guangzhou
-0Series,2890.0,100049,2015,1AA100049,guangzhou
-8Series,1608.0,10005,2015,1AA10005,xiangtan
-2Series,29.0,100050,2015,1AA100050,yichang
-2Series,1407.0,100051,2015,1AA100051,guangzhou
-6Series,845.0,100052,2015,1AA100052,zhuzhou
-2Series,1655.0,100053,2015,1AA100053,wuhan
-7Series,1368.0,100054,2015,1AA100054,shenzhen
-7Series,1728.0,100055,2015,1AA100055,yichang
-6Series,750.0,100056,2015,1AA100056,wuhan
-9Series,2288.0,100057,2015,1AA100057,zhuzhou
-5Series,2635.0,100058,2015,1AA100058,guangzhou
-4Series,1337.0,100059,2015,1AA100059,shenzhen
-3Series,2478.0,10006,2015,1AA10006,guangzhou
-8Series,538.0,100060,2015,1AA100060,xiangtan
-6Series,1407.0,100061,2015,1AA100061,changsha
-9Series,2952.0,100062,2015,1AA100062,yichang
-2Series,1226.0,100063,2015,1AA100063,yichang
-6Series,865.0,100064,2015,1AA100064,zhuzhou
-0Series,901.0,100065,2015,1AA100065,xiangtan
-6Series,1864.0,100066,2015,1AA100066,zhuzhou
-4Series,572.0,100067,2015,1AA100067,wuhan
-8Series,412.0,100068,2015,1AA100068,guangzhou
-8Series,1491.0,100069,2015,1AA100069,xiangtan
-8Series,1350.0,10007,2015,1AA10007,xiangtan
-0Series,1567.0,100070,2015,1AA100070,guangzhou
-0Series,1973.0,100071,2015,1AA100071,guangzhou
-4Series,448.0,100072,2015,1AA100072,changsha
-4Series,2488.0,100073,2015,1AA100073,zhuzhou
-6Series,907.0,100074,2015,1AA100074,wuhan
-3Series,2507.0,100075,2015,1AA100075,shenzhen
-0Series,732.0,100076,2015,1AA100076,wuhan
-3Series,2077.0,100077,2015,1AA100077,yichang
-2Series,1434.0,100078,2015,1AA100078,yichang
-4Series,1098.0,100079,2015,1AA100079,xiangtan
-5Series,813.0,10008,2015,1AA10008,shenzhen
-9Series,954.0,100080,2015,1AA100080,shenzhen
-5Series,613.0,100081,2015,1AA100081,shenzhen
-5Series,2348.0,100082,2015,1AA100082,xiangtan
-0Series,2192.0,100083,2015,1AA100083,zhuzhou
-0Series,2826.0,100084,2015,1AA100084,guangzhou

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_370.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_370.csv b/integration-testcases/src/test/resources/hiveExpected/TC_370.csv
deleted file mode 100644
index bd0ebee..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_370.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Max_deviceInformationId IntegerType,Sum_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1,2738.562
-1AA10,yichang,7Series,2015,10,1714.635
-1AA100,xiangtan,5Series,2015,100,1271.0
-1AA1000,wuhan,5Series,2015,1000,692.0
-1AA10000,guangzhou,7Series,2015,10000,2175.0
-1AA100000,wuhan,9Series,2015,100000,136.0
-1AA1000000,yichang,7Series,2015,1000000,1600.0
-1AA100001,xiangtan,0Series,2015,100001,505.0
-1AA100002,changsha,0Series,2015,100002,1341.0
-1AA100003,zhuzhou,5Series,2015,100003,2239.0
-1AA100004,yichang,4Series,2015,100004,2970.0
-1AA100005,yichang,1Series,2015,100005,2593.0
-1AA100006,changsha,6Series,2015,100006,2572.0
-1AA100007,changsha,9Series,2015,100007,1991.0
-1AA100008,changsha,8Series,2015,100008,1442.0
-1AA100009,yichang,0Series,2015,100009,1841.0
-1AA10001,changsha,2Series,2015,10001,298.0
-1AA100010,zhuzhou,3Series,2015,100010,79.0
-1AA100011,guangzhou,0Series,2015,100011,202.0
-1AA100012,xiangtan,4Series,2015,100012,568.0
-1AA100013,changsha,1Series,2015,100013,355.0
-1AA100014,zhuzhou,5Series,2015,100014,151.0
-1AA100015,xiangtan,4Series,2015,100015,2863.0
-1AA100016,changsha,3Series,2015,100016,1873.0
-1AA100017,xiangtan,9Series,2015,100017,2205.0
-1AA100018,yichang,8Series,2015,100018,441.0
-1AA100019,zhuzhou,5Series,2015,100019,2194.0
-1AA10002,wuhan,0Series,2015,10002,2972.0
-1AA100020,shenzhen,5Series,2015,100020,256.0
-1AA100021,changsha,0Series,2015,100021,1778.0
-1AA100022,zhuzhou,5Series,2015,100022,1999.0
-1AA100023,guangzhou,5Series,2015,100023,2194.0
-1AA100024,changsha,6Series,2015,100024,2483.0
-1AA100025,guangzhou,0Series,2015,100025,1724.0
-1AA100026,yichang,7Series,2015,100026,1768.0
-1AA100027,zhuzhou,0Series,2015,100027,2436.0
-1AA100028,zhuzhou,5Series,2015,100028,2849.0
-1AA100029,xiangtan,2Series,2015,100029,1691.0
-1AA10003,xiangtan,7Series,2015,10003,2071.0
-1AA100030,zhuzhou,7Series,2015,100030,1333.0
-1AA100031,yichang,7Series,2015,100031,1080.0
-1AA100032,shenzhen,1Series,2015,100032,1053.0
-1AA100033,wuhan,8Series,2015,100033,760.0
-1AA100034,guangzhou,2Series,2015,100034,2061.0
-1AA100035,changsha,5Series,2015,100035,2142.0
-1AA100036,changsha,5Series,2015,100036,2224.0
-1AA100037,xiangtan,7Series,2015,100037,1015.0
-1AA100038,shenzhen,6Series,2015,100038,1229.0
-1AA100039,shenzhen,8Series,2015,100039,1750.0
-1AA10004,guangzhou,5Series,2015,10004,1717.0
-1AA100040,yichang,8Series,2015,100040,2078.0
-1AA100041,shenzhen,5Series,2015,100041,2734.0
-1AA100042,shenzhen,3Series,2015,100042,2745.0
-1AA100043,guangzhou,9Series,2015,100043,571.0
-1AA100044,guangzhou,8Series,2015,100044,1697.0
-1AA100045,xiangtan,2Series,2015,100045,2553.0
-1AA100046,guangzhou,3Series,2015,100046,1077.0
-1AA100047,zhuzhou,9Series,2015,100047,1823.0
-1AA100048,guangzhou,3Series,2015,100048,2399.0
-1AA100049,guangzhou,0Series,2015,100049,2890.0
-1AA10005,xiangtan,8Series,2015,10005,1608.0
-1AA100050,yichang,2Series,2015,100050,29.0
-1AA100051,guangzhou,2Series,2015,100051,1407.0
-1AA100052,zhuzhou,6Series,2015,100052,845.0
-1AA100053,wuhan,2Series,2015,100053,1655.0
-1AA100054,shenzhen,7Series,2015,100054,1368.0
-1AA100055,yichang,7Series,2015,100055,1728.0
-1AA100056,wuhan,6Series,2015,100056,750.0
-1AA100057,zhuzhou,9Series,2015,100057,2288.0
-1AA100058,guangzhou,5Series,2015,100058,2635.0
-1AA100059,shenzhen,4Series,2015,100059,1337.0
-1AA10006,guangzhou,3Series,2015,10006,2478.0
-1AA100060,xiangtan,8Series,2015,100060,538.0
-1AA100061,changsha,6Series,2015,100061,1407.0
-1AA100062,yichang,9Series,2015,100062,2952.0
-1AA100063,yichang,2Series,2015,100063,1226.0
-1AA100064,zhuzhou,6Series,2015,100064,865.0
-1AA100065,xiangtan,0Series,2015,100065,901.0
-1AA100066,zhuzhou,6Series,2015,100066,1864.0
-1AA100067,wuhan,4Series,2015,100067,572.0
-1AA100068,guangzhou,8Series,2015,100068,412.0
-1AA100069,xiangtan,8Series,2015,100069,1491.0
-1AA10007,xiangtan,8Series,2015,10007,1350.0
-1AA100070,guangzhou,0Series,2015,100070,1567.0
-1AA100071,guangzhou,0Series,2015,100071,1973.0
-1AA100072,changsha,4Series,2015,100072,448.0
-1AA100073,zhuzhou,4Series,2015,100073,2488.0
-1AA100074,wuhan,6Series,2015,100074,907.0
-1AA100075,shenzhen,3Series,2015,100075,2507.0
-1AA100076,wuhan,0Series,2015,100076,732.0
-1AA100077,yichang,3Series,2015,100077,2077.0
-1AA100078,yichang,2Series,2015,100078,1434.0
-1AA100079,xiangtan,4Series,2015,100079,1098.0
-1AA10008,shenzhen,5Series,2015,10008,813.0
-1AA100080,shenzhen,9Series,2015,100080,954.0
-1AA100081,shenzhen,5Series,2015,100081,613.0
-1AA100082,xiangtan,5Series,2015,100082,2348.0
-1AA100083,zhuzhou,0Series,2015,100083,2192.0
-1AA100084,guangzhou,0Series,2015,100084,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_371.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_371.csv b/integration-testcases/src/test/resources/hiveExpected/TC_371.csv
deleted file mode 100644
index f1d9494..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_371.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Min_deviceInformationId IntegerType,Sum_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1,2738.562
-1AA10,yichang,7Series,2015,10,1714.635
-1AA100,xiangtan,5Series,2015,100,1271.0
-1AA1000,wuhan,5Series,2015,1000,692.0
-1AA10000,guangzhou,7Series,2015,10000,2175.0
-1AA100000,wuhan,9Series,2015,100000,136.0
-1AA1000000,yichang,7Series,2015,1000000,1600.0
-1AA100001,xiangtan,0Series,2015,100001,505.0
-1AA100002,changsha,0Series,2015,100002,1341.0
-1AA100003,zhuzhou,5Series,2015,100003,2239.0
-1AA100004,yichang,4Series,2015,100004,2970.0
-1AA100005,yichang,1Series,2015,100005,2593.0
-1AA100006,changsha,6Series,2015,100006,2572.0
-1AA100007,changsha,9Series,2015,100007,1991.0
-1AA100008,changsha,8Series,2015,100008,1442.0
-1AA100009,yichang,0Series,2015,100009,1841.0
-1AA10001,changsha,2Series,2015,10001,298.0
-1AA100010,zhuzhou,3Series,2015,100010,79.0
-1AA100011,guangzhou,0Series,2015,100011,202.0
-1AA100012,xiangtan,4Series,2015,100012,568.0
-1AA100013,changsha,1Series,2015,100013,355.0
-1AA100014,zhuzhou,5Series,2015,100014,151.0
-1AA100015,xiangtan,4Series,2015,100015,2863.0
-1AA100016,changsha,3Series,2015,100016,1873.0
-1AA100017,xiangtan,9Series,2015,100017,2205.0
-1AA100018,yichang,8Series,2015,100018,441.0
-1AA100019,zhuzhou,5Series,2015,100019,2194.0
-1AA10002,wuhan,0Series,2015,10002,2972.0
-1AA100020,shenzhen,5Series,2015,100020,256.0
-1AA100021,changsha,0Series,2015,100021,1778.0
-1AA100022,zhuzhou,5Series,2015,100022,1999.0
-1AA100023,guangzhou,5Series,2015,100023,2194.0
-1AA100024,changsha,6Series,2015,100024,2483.0
-1AA100025,guangzhou,0Series,2015,100025,1724.0
-1AA100026,yichang,7Series,2015,100026,1768.0
-1AA100027,zhuzhou,0Series,2015,100027,2436.0
-1AA100028,zhuzhou,5Series,2015,100028,2849.0
-1AA100029,xiangtan,2Series,2015,100029,1691.0
-1AA10003,xiangtan,7Series,2015,10003,2071.0
-1AA100030,zhuzhou,7Series,2015,100030,1333.0
-1AA100031,yichang,7Series,2015,100031,1080.0
-1AA100032,shenzhen,1Series,2015,100032,1053.0
-1AA100033,wuhan,8Series,2015,100033,760.0
-1AA100034,guangzhou,2Series,2015,100034,2061.0
-1AA100035,changsha,5Series,2015,100035,2142.0
-1AA100036,changsha,5Series,2015,100036,2224.0
-1AA100037,xiangtan,7Series,2015,100037,1015.0
-1AA100038,shenzhen,6Series,2015,100038,1229.0
-1AA100039,shenzhen,8Series,2015,100039,1750.0
-1AA10004,guangzhou,5Series,2015,10004,1717.0
-1AA100040,yichang,8Series,2015,100040,2078.0
-1AA100041,shenzhen,5Series,2015,100041,2734.0
-1AA100042,shenzhen,3Series,2015,100042,2745.0
-1AA100043,guangzhou,9Series,2015,100043,571.0
-1AA100044,guangzhou,8Series,2015,100044,1697.0
-1AA100045,xiangtan,2Series,2015,100045,2553.0
-1AA100046,guangzhou,3Series,2015,100046,1077.0
-1AA100047,zhuzhou,9Series,2015,100047,1823.0
-1AA100048,guangzhou,3Series,2015,100048,2399.0
-1AA100049,guangzhou,0Series,2015,100049,2890.0
-1AA10005,xiangtan,8Series,2015,10005,1608.0
-1AA100050,yichang,2Series,2015,100050,29.0
-1AA100051,guangzhou,2Series,2015,100051,1407.0
-1AA100052,zhuzhou,6Series,2015,100052,845.0
-1AA100053,wuhan,2Series,2015,100053,1655.0
-1AA100054,shenzhen,7Series,2015,100054,1368.0
-1AA100055,yichang,7Series,2015,100055,1728.0
-1AA100056,wuhan,6Series,2015,100056,750.0
-1AA100057,zhuzhou,9Series,2015,100057,2288.0
-1AA100058,guangzhou,5Series,2015,100058,2635.0
-1AA100059,shenzhen,4Series,2015,100059,1337.0
-1AA10006,guangzhou,3Series,2015,10006,2478.0
-1AA100060,xiangtan,8Series,2015,100060,538.0
-1AA100061,changsha,6Series,2015,100061,1407.0
-1AA100062,yichang,9Series,2015,100062,2952.0
-1AA100063,yichang,2Series,2015,100063,1226.0
-1AA100064,zhuzhou,6Series,2015,100064,865.0
-1AA100065,xiangtan,0Series,2015,100065,901.0
-1AA100066,zhuzhou,6Series,2015,100066,1864.0
-1AA100067,wuhan,4Series,2015,100067,572.0
-1AA100068,guangzhou,8Series,2015,100068,412.0
-1AA100069,xiangtan,8Series,2015,100069,1491.0
-1AA10007,xiangtan,8Series,2015,10007,1350.0
-1AA100070,guangzhou,0Series,2015,100070,1567.0
-1AA100071,guangzhou,0Series,2015,100071,1973.0
-1AA100072,changsha,4Series,2015,100072,448.0
-1AA100073,zhuzhou,4Series,2015,100073,2488.0
-1AA100074,wuhan,6Series,2015,100074,907.0
-1AA100075,shenzhen,3Series,2015,100075,2507.0
-1AA100076,wuhan,0Series,2015,100076,732.0
-1AA100077,yichang,3Series,2015,100077,2077.0
-1AA100078,yichang,2Series,2015,100078,1434.0
-1AA100079,xiangtan,4Series,2015,100079,1098.0
-1AA10008,shenzhen,5Series,2015,10008,813.0
-1AA100080,shenzhen,9Series,2015,100080,954.0
-1AA100081,shenzhen,5Series,2015,100081,613.0
-1AA100082,xiangtan,5Series,2015,100082,2348.0
-1AA100083,zhuzhou,0Series,2015,100083,2192.0
-1AA100084,guangzhou,0Series,2015,100084,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_372.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_372.csv b/integration-testcases/src/test/resources/hiveExpected/TC_372.csv
deleted file mode 100644
index d0111b4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_372.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType
-2015,100050,1AA100050,yichang,2Series,29.0
-2015,100010,1AA100010,zhuzhou,3Series,79.0
-2015,100000,1AA100000,wuhan,9Series,136.0
-2015,100014,1AA100014,zhuzhou,5Series,151.0
-2015,100011,1AA100011,guangzhou,0Series,202.0
-2015,100020,1AA100020,shenzhen,5Series,256.0
-2015,10001,1AA10001,changsha,2Series,298.0
-2015,100013,1AA100013,changsha,1Series,355.0
-2015,100068,1AA100068,guangzhou,8Series,412.0
-2015,100018,1AA100018,yichang,8Series,441.0
-2015,100072,1AA100072,changsha,4Series,448.0
-2015,100001,1AA100001,xiangtan,0Series,505.0
-2015,100060,1AA100060,xiangtan,8Series,538.0
-2015,100012,1AA100012,xiangtan,4Series,568.0
-2015,100043,1AA100043,guangzhou,9Series,571.0
-2015,100067,1AA100067,wuhan,4Series,572.0
-2015,100081,1AA100081,shenzhen,5Series,613.0
-2015,1000,1AA1000,wuhan,5Series,692.0
-2015,100076,1AA100076,wuhan,0Series,732.0
-2015,100056,1AA100056,wuhan,6Series,750.0
-2015,100033,1AA100033,wuhan,8Series,760.0
-2015,10008,1AA10008,shenzhen,5Series,813.0
-2015,100052,1AA100052,zhuzhou,6Series,845.0
-2015,100064,1AA100064,zhuzhou,6Series,865.0
-2015,100065,1AA100065,xiangtan,0Series,901.0
-2015,100074,1AA100074,wuhan,6Series,907.0
-2015,100080,1AA100080,shenzhen,9Series,954.0
-2015,100037,1AA100037,xiangtan,7Series,1015.0
-2015,100032,1AA100032,shenzhen,1Series,1053.0
-2015,100046,1AA100046,guangzhou,3Series,1077.0
-2015,100031,1AA100031,yichang,7Series,1080.0
-2015,100079,1AA100079,xiangtan,4Series,1098.0
-2015,100063,1AA100063,yichang,2Series,1226.0
-2015,100038,1AA100038,shenzhen,6Series,1229.0
-2015,100,1AA100,xiangtan,5Series,1271.0
-2015,100030,1AA100030,zhuzhou,7Series,1333.0
-2015,100059,1AA100059,shenzhen,4Series,1337.0
-2015,100002,1AA100002,changsha,0Series,1341.0
-2015,10007,1AA10007,xiangtan,8Series,1350.0
-2015,100054,1AA100054,shenzhen,7Series,1368.0
-2015,100051,1AA100051,guangzhou,2Series,1407.0
-2015,100061,1AA100061,changsha,6Series,1407.0
-2015,100078,1AA100078,yichang,2Series,1434.0
-2015,100008,1AA100008,changsha,8Series,1442.0
-2015,100069,1AA100069,xiangtan,8Series,1491.0
-2015,100070,1AA100070,guangzhou,0Series,1567.0
-2015,1000000,1AA1000000,yichang,7Series,1600.0
-2015,10005,1AA10005,xiangtan,8Series,1608.0
-2015,100053,1AA100053,wuhan,2Series,1655.0
-2015,100029,1AA100029,xiangtan,2Series,1691.0
-2015,100044,1AA100044,guangzhou,8Series,1697.0
-2015,10,1AA10,yichang,7Series,1714.635
-2015,10004,1AA10004,guangzhou,5Series,1717.0
-2015,100025,1AA100025,guangzhou,0Series,1724.0
-2015,100055,1AA100055,yichang,7Series,1728.0
-2015,100039,1AA100039,shenzhen,8Series,1750.0
-2015,100026,1AA100026,yichang,7Series,1768.0
-2015,100021,1AA100021,changsha,0Series,1778.0
-2015,100047,1AA100047,zhuzhou,9Series,1823.0
-2015,100009,1AA100009,yichang,0Series,1841.0
-2015,100066,1AA100066,zhuzhou,6Series,1864.0
-2015,100016,1AA100016,changsha,3Series,1873.0
-2015,100071,1AA100071,guangzhou,0Series,1973.0
-2015,100007,1AA100007,changsha,9Series,1991.0
-2015,100022,1AA100022,zhuzhou,5Series,1999.0
-2015,100034,1AA100034,guangzhou,2Series,2061.0
-2015,10003,1AA10003,xiangtan,7Series,2071.0
-2015,100077,1AA100077,yichang,3Series,2077.0
-2015,100040,1AA100040,yichang,8Series,2078.0
-2015,100035,1AA100035,changsha,5Series,2142.0
-2015,10000,1AA10000,guangzhou,7Series,2175.0
-2015,100083,1AA100083,zhuzhou,0Series,2192.0
-2015,100019,1AA100019,zhuzhou,5Series,2194.0
-2015,100023,1AA100023,guangzhou,5Series,2194.0
-2015,100017,1AA100017,xiangtan,9Series,2205.0
-2015,100036,1AA100036,changsha,5Series,2224.0
-2015,100003,1AA100003,zhuzhou,5Series,2239.0
-2015,100057,1AA100057,zhuzhou,9Series,2288.0
-2015,100082,1AA100082,xiangtan,5Series,2348.0
-2015,100048,1AA100048,guangzhou,3Series,2399.0
-2015,100027,1AA100027,zhuzhou,0Series,2436.0
-2015,10006,1AA10006,guangzhou,3Series,2478.0
-2015,100024,1AA100024,changsha,6Series,2483.0
-2015,100073,1AA100073,zhuzhou,4Series,2488.0
-2015,100075,1AA100075,shenzhen,3Series,2507.0
-2015,100045,1AA100045,xiangtan,2Series,2553.0
-2015,100006,1AA100006,changsha,6Series,2572.0
-2015,100005,1AA100005,yichang,1Series,2593.0
-2015,100058,1AA100058,guangzhou,5Series,2635.0
-2015,100041,1AA100041,shenzhen,5Series,2734.0
-2015,1,1AA1,yichang,7Series,2738.562
-2015,100042,1AA100042,shenzhen,3Series,2745.0
-2015,100084,1AA100084,guangzhou,0Series,2826.0
-2015,100028,1AA100028,zhuzhou,5Series,2849.0
-2015,100015,1AA100015,xiangtan,4Series,2863.0
-2015,100049,1AA100049,guangzhou,0Series,2890.0
-2015,100062,1AA100062,yichang,9Series,2952.0
-2015,100004,1AA100004,yichang,4Series,2970.0
-2015,10002,1AA10002,wuhan,0Series,2972.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_373.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_373.csv b/integration-testcases/src/test/resources/hiveExpected/TC_373.csv
deleted file mode 100644
index cf1a4bb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_373.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType
-2015,10002,1AA10002,wuhan,0Series,2972.0
-2015,100004,1AA100004,yichang,4Series,2970.0
-2015,100062,1AA100062,yichang,9Series,2952.0
-2015,100049,1AA100049,guangzhou,0Series,2890.0
-2015,100015,1AA100015,xiangtan,4Series,2863.0
-2015,100028,1AA100028,zhuzhou,5Series,2849.0
-2015,100084,1AA100084,guangzhou,0Series,2826.0
-2015,100042,1AA100042,shenzhen,3Series,2745.0
-2015,1,1AA1,yichang,7Series,2738.562
-2015,100041,1AA100041,shenzhen,5Series,2734.0
-2015,100058,1AA100058,guangzhou,5Series,2635.0
-2015,100005,1AA100005,yichang,1Series,2593.0
-2015,100006,1AA100006,changsha,6Series,2572.0
-2015,100045,1AA100045,xiangtan,2Series,2553.0
-2015,100075,1AA100075,shenzhen,3Series,2507.0
-2015,100073,1AA100073,zhuzhou,4Series,2488.0
-2015,100024,1AA100024,changsha,6Series,2483.0
-2015,10006,1AA10006,guangzhou,3Series,2478.0
-2015,100027,1AA100027,zhuzhou,0Series,2436.0
-2015,100048,1AA100048,guangzhou,3Series,2399.0
-2015,100082,1AA100082,xiangtan,5Series,2348.0
-2015,100057,1AA100057,zhuzhou,9Series,2288.0
-2015,100003,1AA100003,zhuzhou,5Series,2239.0
-2015,100036,1AA100036,changsha,5Series,2224.0
-2015,100017,1AA100017,xiangtan,9Series,2205.0
-2015,100019,1AA100019,zhuzhou,5Series,2194.0
-2015,100023,1AA100023,guangzhou,5Series,2194.0
-2015,100083,1AA100083,zhuzhou,0Series,2192.0
-2015,10000,1AA10000,guangzhou,7Series,2175.0
-2015,100035,1AA100035,changsha,5Series,2142.0
-2015,100040,1AA100040,yichang,8Series,2078.0
-2015,100077,1AA100077,yichang,3Series,2077.0
-2015,10003,1AA10003,xiangtan,7Series,2071.0
-2015,100034,1AA100034,guangzhou,2Series,2061.0
-2015,100022,1AA100022,zhuzhou,5Series,1999.0
-2015,100007,1AA100007,changsha,9Series,1991.0
-2015,100071,1AA100071,guangzhou,0Series,1973.0
-2015,100016,1AA100016,changsha,3Series,1873.0
-2015,100066,1AA100066,zhuzhou,6Series,1864.0
-2015,100009,1AA100009,yichang,0Series,1841.0
-2015,100047,1AA100047,zhuzhou,9Series,1823.0
-2015,100021,1AA100021,changsha,0Series,1778.0
-2015,100026,1AA100026,yichang,7Series,1768.0
-2015,100039,1AA100039,shenzhen,8Series,1750.0
-2015,100055,1AA100055,yichang,7Series,1728.0
-2015,100025,1AA100025,guangzhou,0Series,1724.0
-2015,10004,1AA10004,guangzhou,5Series,1717.0
-2015,10,1AA10,yichang,7Series,1714.635
-2015,100044,1AA100044,guangzhou,8Series,1697.0
-2015,100029,1AA100029,xiangtan,2Series,1691.0
-2015,100053,1AA100053,wuhan,2Series,1655.0
-2015,10005,1AA10005,xiangtan,8Series,1608.0
-2015,1000000,1AA1000000,yichang,7Series,1600.0
-2015,100070,1AA100070,guangzhou,0Series,1567.0
-2015,100069,1AA100069,xiangtan,8Series,1491.0
-2015,100008,1AA100008,changsha,8Series,1442.0
-2015,100078,1AA100078,yichang,2Series,1434.0
-2015,100051,1AA100051,guangzhou,2Series,1407.0
-2015,100061,1AA100061,changsha,6Series,1407.0
-2015,100054,1AA100054,shenzhen,7Series,1368.0
-2015,10007,1AA10007,xiangtan,8Series,1350.0
-2015,100002,1AA100002,changsha,0Series,1341.0
-2015,100059,1AA100059,shenzhen,4Series,1337.0
-2015,100030,1AA100030,zhuzhou,7Series,1333.0
-2015,100,1AA100,xiangtan,5Series,1271.0
-2015,100038,1AA100038,shenzhen,6Series,1229.0
-2015,100063,1AA100063,yichang,2Series,1226.0
-2015,100079,1AA100079,xiangtan,4Series,1098.0
-2015,100031,1AA100031,yichang,7Series,1080.0
-2015,100046,1AA100046,guangzhou,3Series,1077.0
-2015,100032,1AA100032,shenzhen,1Series,1053.0
-2015,100037,1AA100037,xiangtan,7Series,1015.0
-2015,100080,1AA100080,shenzhen,9Series,954.0
-2015,100074,1AA100074,wuhan,6Series,907.0
-2015,100065,1AA100065,xiangtan,0Series,901.0
-2015,100064,1AA100064,zhuzhou,6Series,865.0
-2015,100052,1AA100052,zhuzhou,6Series,845.0
-2015,10008,1AA10008,shenzhen,5Series,813.0
-2015,100033,1AA100033,wuhan,8Series,760.0
-2015,100056,1AA100056,wuhan,6Series,750.0
-2015,100076,1AA100076,wuhan,0Series,732.0
-2015,1000,1AA1000,wuhan,5Series,692.0
-2015,100081,1AA100081,shenzhen,5Series,613.0
-2015,100067,1AA100067,wuhan,4Series,572.0
-2015,100043,1AA100043,guangzhou,9Series,571.0
-2015,100012,1AA100012,xiangtan,4Series,568.0
-2015,100060,1AA100060,xiangtan,8Series,538.0
-2015,100001,1AA100001,xiangtan,0Series,505.0
-2015,100072,1AA100072,changsha,4Series,448.0
-2015,100018,1AA100018,yichang,8Series,441.0
-2015,100068,1AA100068,guangzhou,8Series,412.0
-2015,100013,1AA100013,changsha,1Series,355.0
-2015,10001,1AA10001,changsha,2Series,298.0
-2015,100020,1AA100020,shenzhen,5Series,256.0
-2015,100011,1AA100011,guangzhou,0Series,202.0
-2015,100014,1AA100014,zhuzhou,5Series,151.0
-2015,100000,1AA100000,wuhan,9Series,136.0
-2015,100010,1AA100010,zhuzhou,3Series,79.0
-2015,100050,1AA100050,yichang,2Series,29.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_374.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_374.csv b/integration-testcases/src/test/resources/hiveExpected/TC_374.csv
deleted file mode 100644
index 7d87ec6..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_374.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Avg_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1,2738.562
-1AA10,yichang,7Series,2015,10,1714.635
-1AA100,xiangtan,5Series,2015,100,1271.0
-1AA1000,wuhan,5Series,2015,1000,692.0
-1AA10000,guangzhou,7Series,2015,10000,2175.0
-1AA100000,wuhan,9Series,2015,100000,136.0
-1AA1000000,yichang,7Series,2015,1000000,1600.0
-1AA100001,xiangtan,0Series,2015,100001,505.0
-1AA100002,changsha,0Series,2015,100002,1341.0
-1AA100003,zhuzhou,5Series,2015,100003,2239.0
-1AA100004,yichang,4Series,2015,100004,2970.0
-1AA100005,yichang,1Series,2015,100005,2593.0
-1AA100006,changsha,6Series,2015,100006,2572.0
-1AA100007,changsha,9Series,2015,100007,1991.0
-1AA100008,changsha,8Series,2015,100008,1442.0
-1AA100009,yichang,0Series,2015,100009,1841.0
-1AA10001,changsha,2Series,2015,10001,298.0
-1AA100010,zhuzhou,3Series,2015,100010,79.0
-1AA100011,guangzhou,0Series,2015,100011,202.0
-1AA100012,xiangtan,4Series,2015,100012,568.0
-1AA100013,changsha,1Series,2015,100013,355.0
-1AA100014,zhuzhou,5Series,2015,100014,151.0
-1AA100015,xiangtan,4Series,2015,100015,2863.0
-1AA100016,changsha,3Series,2015,100016,1873.0
-1AA100017,xiangtan,9Series,2015,100017,2205.0
-1AA100018,yichang,8Series,2015,100018,441.0
-1AA100019,zhuzhou,5Series,2015,100019,2194.0
-1AA10002,wuhan,0Series,2015,10002,2972.0
-1AA100020,shenzhen,5Series,2015,100020,256.0
-1AA100021,changsha,0Series,2015,100021,1778.0
-1AA100022,zhuzhou,5Series,2015,100022,1999.0
-1AA100023,guangzhou,5Series,2015,100023,2194.0
-1AA100024,changsha,6Series,2015,100024,2483.0
-1AA100025,guangzhou,0Series,2015,100025,1724.0
-1AA100026,yichang,7Series,2015,100026,1768.0
-1AA100027,zhuzhou,0Series,2015,100027,2436.0
-1AA100028,zhuzhou,5Series,2015,100028,2849.0
-1AA100029,xiangtan,2Series,2015,100029,1691.0
-1AA10003,xiangtan,7Series,2015,10003,2071.0
-1AA100030,zhuzhou,7Series,2015,100030,1333.0
-1AA100031,yichang,7Series,2015,100031,1080.0
-1AA100032,shenzhen,1Series,2015,100032,1053.0
-1AA100033,wuhan,8Series,2015,100033,760.0
-1AA100034,guangzhou,2Series,2015,100034,2061.0
-1AA100035,changsha,5Series,2015,100035,2142.0
-1AA100036,changsha,5Series,2015,100036,2224.0
-1AA100037,xiangtan,7Series,2015,100037,1015.0
-1AA100038,shenzhen,6Series,2015,100038,1229.0
-1AA100039,shenzhen,8Series,2015,100039,1750.0
-1AA10004,guangzhou,5Series,2015,10004,1717.0
-1AA100040,yichang,8Series,2015,100040,2078.0
-1AA100041,shenzhen,5Series,2015,100041,2734.0
-1AA100042,shenzhen,3Series,2015,100042,2745.0
-1AA100043,guangzhou,9Series,2015,100043,571.0
-1AA100044,guangzhou,8Series,2015,100044,1697.0
-1AA100045,xiangtan,2Series,2015,100045,2553.0
-1AA100046,guangzhou,3Series,2015,100046,1077.0
-1AA100047,zhuzhou,9Series,2015,100047,1823.0
-1AA100048,guangzhou,3Series,2015,100048,2399.0
-1AA100049,guangzhou,0Series,2015,100049,2890.0
-1AA10005,xiangtan,8Series,2015,10005,1608.0
-1AA100050,yichang,2Series,2015,100050,29.0
-1AA100051,guangzhou,2Series,2015,100051,1407.0
-1AA100052,zhuzhou,6Series,2015,100052,845.0
-1AA100053,wuhan,2Series,2015,100053,1655.0
-1AA100054,shenzhen,7Series,2015,100054,1368.0
-1AA100055,yichang,7Series,2015,100055,1728.0
-1AA100056,wuhan,6Series,2015,100056,750.0
-1AA100057,zhuzhou,9Series,2015,100057,2288.0
-1AA100058,guangzhou,5Series,2015,100058,2635.0
-1AA100059,shenzhen,4Series,2015,100059,1337.0
-1AA10006,guangzhou,3Series,2015,10006,2478.0
-1AA100060,xiangtan,8Series,2015,100060,538.0
-1AA100061,changsha,6Series,2015,100061,1407.0
-1AA100062,yichang,9Series,2015,100062,2952.0
-1AA100063,yichang,2Series,2015,100063,1226.0
-1AA100064,zhuzhou,6Series,2015,100064,865.0
-1AA100065,xiangtan,0Series,2015,100065,901.0
-1AA100066,zhuzhou,6Series,2015,100066,1864.0
-1AA100067,wuhan,4Series,2015,100067,572.0
-1AA100068,guangzhou,8Series,2015,100068,412.0
-1AA100069,xiangtan,8Series,2015,100069,1491.0
-1AA10007,xiangtan,8Series,2015,10007,1350.0
-1AA100070,guangzhou,0Series,2015,100070,1567.0
-1AA100071,guangzhou,0Series,2015,100071,1973.0
-1AA100072,changsha,4Series,2015,100072,448.0
-1AA100073,zhuzhou,4Series,2015,100073,2488.0
-1AA100074,wuhan,6Series,2015,100074,907.0
-1AA100075,shenzhen,3Series,2015,100075,2507.0
-1AA100076,wuhan,0Series,2015,100076,732.0
-1AA100077,yichang,3Series,2015,100077,2077.0
-1AA100078,yichang,2Series,2015,100078,1434.0
-1AA100079,xiangtan,4Series,2015,100079,1098.0
-1AA10008,shenzhen,5Series,2015,10008,813.0
-1AA100080,shenzhen,9Series,2015,100080,954.0
-1AA100081,shenzhen,5Series,2015,100081,613.0
-1AA100082,xiangtan,5Series,2015,100082,2348.0
-1AA100083,zhuzhou,0Series,2015,100083,2192.0
-1AA100084,guangzhou,0Series,2015,100084,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_375.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_375.csv b/integration-testcases/src/test/resources/hiveExpected/TC_375.csv
deleted file mode 100644
index 553eff7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_375.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Count_gamePointId LongType
-1AA1,yichang,7Series,2015,1,1
-1AA10,yichang,7Series,2015,10,1
-1AA100,xiangtan,5Series,2015,100,1
-1AA1000,wuhan,5Series,2015,1000,1
-1AA10000,guangzhou,7Series,2015,10000,1
-1AA100000,wuhan,9Series,2015,100000,1
-1AA1000000,yichang,7Series,2015,1000000,1
-1AA100001,xiangtan,0Series,2015,100001,1
-1AA100002,changsha,0Series,2015,100002,1
-1AA100003,zhuzhou,5Series,2015,100003,1
-1AA100004,yichang,4Series,2015,100004,1
-1AA100005,yichang,1Series,2015,100005,1
-1AA100006,changsha,6Series,2015,100006,1
-1AA100007,changsha,9Series,2015,100007,1
-1AA100008,changsha,8Series,2015,100008,1
-1AA100009,yichang,0Series,2015,100009,1
-1AA10001,changsha,2Series,2015,10001,1
-1AA100010,zhuzhou,3Series,2015,100010,1
-1AA100011,guangzhou,0Series,2015,100011,1
-1AA100012,xiangtan,4Series,2015,100012,1
-1AA100013,changsha,1Series,2015,100013,1
-1AA100014,zhuzhou,5Series,2015,100014,1
-1AA100015,xiangtan,4Series,2015,100015,1
-1AA100016,changsha,3Series,2015,100016,1
-1AA100017,xiangtan,9Series,2015,100017,1
-1AA100018,yichang,8Series,2015,100018,1
-1AA100019,zhuzhou,5Series,2015,100019,1
-1AA10002,wuhan,0Series,2015,10002,1
-1AA100020,shenzhen,5Series,2015,100020,1
-1AA100021,changsha,0Series,2015,100021,1
-1AA100022,zhuzhou,5Series,2015,100022,1
-1AA100023,guangzhou,5Series,2015,100023,1
-1AA100024,changsha,6Series,2015,100024,1
-1AA100025,guangzhou,0Series,2015,100025,1
-1AA100026,yichang,7Series,2015,100026,1
-1AA100027,zhuzhou,0Series,2015,100027,1
-1AA100028,zhuzhou,5Series,2015,100028,1
-1AA100029,xiangtan,2Series,2015,100029,1
-1AA10003,xiangtan,7Series,2015,10003,1
-1AA100030,zhuzhou,7Series,2015,100030,1
-1AA100031,yichang,7Series,2015,100031,1
-1AA100032,shenzhen,1Series,2015,100032,1
-1AA100033,wuhan,8Series,2015,100033,1
-1AA100034,guangzhou,2Series,2015,100034,1
-1AA100035,changsha,5Series,2015,100035,1
-1AA100036,changsha,5Series,2015,100036,1
-1AA100037,xiangtan,7Series,2015,100037,1
-1AA100038,shenzhen,6Series,2015,100038,1
-1AA100039,shenzhen,8Series,2015,100039,1
-1AA10004,guangzhou,5Series,2015,10004,1
-1AA100040,yichang,8Series,2015,100040,1
-1AA100041,shenzhen,5Series,2015,100041,1
-1AA100042,shenzhen,3Series,2015,100042,1
-1AA100043,guangzhou,9Series,2015,100043,1
-1AA100044,guangzhou,8Series,2015,100044,1
-1AA100045,xiangtan,2Series,2015,100045,1
-1AA100046,guangzhou,3Series,2015,100046,1
-1AA100047,zhuzhou,9Series,2015,100047,1
-1AA100048,guangzhou,3Series,2015,100048,1
-1AA100049,guangzhou,0Series,2015,100049,1
-1AA10005,xiangtan,8Series,2015,10005,1
-1AA100050,yichang,2Series,2015,100050,1
-1AA100051,guangzhou,2Series,2015,100051,1
-1AA100052,zhuzhou,6Series,2015,100052,1
-1AA100053,wuhan,2Series,2015,100053,1
-1AA100054,shenzhen,7Series,2015,100054,1
-1AA100055,yichang,7Series,2015,100055,1
-1AA100056,wuhan,6Series,2015,100056,1
-1AA100057,zhuzhou,9Series,2015,100057,1
-1AA100058,guangzhou,5Series,2015,100058,1
-1AA100059,shenzhen,4Series,2015,100059,1
-1AA10006,guangzhou,3Series,2015,10006,1
-1AA100060,xiangtan,8Series,2015,100060,1
-1AA100061,changsha,6Series,2015,100061,1
-1AA100062,yichang,9Series,2015,100062,1
-1AA100063,yichang,2Series,2015,100063,1
-1AA100064,zhuzhou,6Series,2015,100064,1
-1AA100065,xiangtan,0Series,2015,100065,1
-1AA100066,zhuzhou,6Series,2015,100066,1
-1AA100067,wuhan,4Series,2015,100067,1
-1AA100068,guangzhou,8Series,2015,100068,1
-1AA100069,xiangtan,8Series,2015,100069,1
-1AA10007,xiangtan,8Series,2015,10007,1
-1AA100070,guangzhou,0Series,2015,100070,1
-1AA100071,guangzhou,0Series,2015,100071,1
-1AA100072,changsha,4Series,2015,100072,1
-1AA100073,zhuzhou,4Series,2015,100073,1
-1AA100074,wuhan,6Series,2015,100074,1
-1AA100075,shenzhen,3Series,2015,100075,1
-1AA100076,wuhan,0Series,2015,100076,1
-1AA100077,yichang,3Series,2015,100077,1
-1AA100078,yichang,2Series,2015,100078,1
-1AA100079,xiangtan,4Series,2015,100079,1
-1AA10008,shenzhen,5Series,2015,10008,1
-1AA100080,shenzhen,9Series,2015,100080,1
-1AA100081,shenzhen,5Series,2015,100081,1
-1AA100082,xiangtan,5Series,2015,100082,1
-1AA100083,zhuzhou,0Series,2015,100083,1
-1AA100084,guangzhou,0Series,2015,100084,1

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_376.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_376.csv b/integration-testcases/src/test/resources/hiveExpected/TC_376.csv
deleted file mode 100644
index 2fc021c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_376.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,DistinctCount_gamePointId LongType
-1AA1,yichang,7Series,2015,1,1
-1AA10,yichang,7Series,2015,10,1
-1AA100,xiangtan,5Series,2015,100,1
-1AA1000,wuhan,5Series,2015,1000,1
-1AA10000,guangzhou,7Series,2015,10000,1
-1AA100000,wuhan,9Series,2015,100000,1
-1AA1000000,yichang,7Series,2015,1000000,1
-1AA100001,xiangtan,0Series,2015,100001,1
-1AA100002,changsha,0Series,2015,100002,1
-1AA100003,zhuzhou,5Series,2015,100003,1
-1AA100004,yichang,4Series,2015,100004,1
-1AA100005,yichang,1Series,2015,100005,1
-1AA100006,changsha,6Series,2015,100006,1
-1AA100007,changsha,9Series,2015,100007,1
-1AA100008,changsha,8Series,2015,100008,1
-1AA100009,yichang,0Series,2015,100009,1
-1AA10001,changsha,2Series,2015,10001,1
-1AA100010,zhuzhou,3Series,2015,100010,1
-1AA100011,guangzhou,0Series,2015,100011,1
-1AA100012,xiangtan,4Series,2015,100012,1
-1AA100013,changsha,1Series,2015,100013,1
-1AA100014,zhuzhou,5Series,2015,100014,1
-1AA100015,xiangtan,4Series,2015,100015,1
-1AA100016,changsha,3Series,2015,100016,1
-1AA100017,xiangtan,9Series,2015,100017,1
-1AA100018,yichang,8Series,2015,100018,1
-1AA100019,zhuzhou,5Series,2015,100019,1
-1AA10002,wuhan,0Series,2015,10002,1
-1AA100020,shenzhen,5Series,2015,100020,1
-1AA100021,changsha,0Series,2015,100021,1
-1AA100022,zhuzhou,5Series,2015,100022,1
-1AA100023,guangzhou,5Series,2015,100023,1
-1AA100024,changsha,6Series,2015,100024,1
-1AA100025,guangzhou,0Series,2015,100025,1
-1AA100026,yichang,7Series,2015,100026,1
-1AA100027,zhuzhou,0Series,2015,100027,1
-1AA100028,zhuzhou,5Series,2015,100028,1
-1AA100029,xiangtan,2Series,2015,100029,1
-1AA10003,xiangtan,7Series,2015,10003,1
-1AA100030,zhuzhou,7Series,2015,100030,1
-1AA100031,yichang,7Series,2015,100031,1
-1AA100032,shenzhen,1Series,2015,100032,1
-1AA100033,wuhan,8Series,2015,100033,1
-1AA100034,guangzhou,2Series,2015,100034,1
-1AA100035,changsha,5Series,2015,100035,1
-1AA100036,changsha,5Series,2015,100036,1
-1AA100037,xiangtan,7Series,2015,100037,1
-1AA100038,shenzhen,6Series,2015,100038,1
-1AA100039,shenzhen,8Series,2015,100039,1
-1AA10004,guangzhou,5Series,2015,10004,1
-1AA100040,yichang,8Series,2015,100040,1
-1AA100041,shenzhen,5Series,2015,100041,1
-1AA100042,shenzhen,3Series,2015,100042,1
-1AA100043,guangzhou,9Series,2015,100043,1
-1AA100044,guangzhou,8Series,2015,100044,1
-1AA100045,xiangtan,2Series,2015,100045,1
-1AA100046,guangzhou,3Series,2015,100046,1
-1AA100047,zhuzhou,9Series,2015,100047,1
-1AA100048,guangzhou,3Series,2015,100048,1
-1AA100049,guangzhou,0Series,2015,100049,1
-1AA10005,xiangtan,8Series,2015,10005,1
-1AA100050,yichang,2Series,2015,100050,1
-1AA100051,guangzhou,2Series,2015,100051,1
-1AA100052,zhuzhou,6Series,2015,100052,1
-1AA100053,wuhan,2Series,2015,100053,1
-1AA100054,shenzhen,7Series,2015,100054,1
-1AA100055,yichang,7Series,2015,100055,1
-1AA100056,wuhan,6Series,2015,100056,1
-1AA100057,zhuzhou,9Series,2015,100057,1
-1AA100058,guangzhou,5Series,2015,100058,1
-1AA100059,shenzhen,4Series,2015,100059,1
-1AA10006,guangzhou,3Series,2015,10006,1
-1AA100060,xiangtan,8Series,2015,100060,1
-1AA100061,changsha,6Series,2015,100061,1
-1AA100062,yichang,9Series,2015,100062,1
-1AA100063,yichang,2Series,2015,100063,1
-1AA100064,zhuzhou,6Series,2015,100064,1
-1AA100065,xiangtan,0Series,2015,100065,1
-1AA100066,zhuzhou,6Series,2015,100066,1
-1AA100067,wuhan,4Series,2015,100067,1
-1AA100068,guangzhou,8Series,2015,100068,1
-1AA100069,xiangtan,8Series,2015,100069,1
-1AA10007,xiangtan,8Series,2015,10007,1
-1AA100070,guangzhou,0Series,2015,100070,1
-1AA100071,guangzhou,0Series,2015,100071,1
-1AA100072,changsha,4Series,2015,100072,1
-1AA100073,zhuzhou,4Series,2015,100073,1
-1AA100074,wuhan,6Series,2015,100074,1
-1AA100075,shenzhen,3Series,2015,100075,1
-1AA100076,wuhan,0Series,2015,100076,1
-1AA100077,yichang,3Series,2015,100077,1
-1AA100078,yichang,2Series,2015,100078,1
-1AA100079,xiangtan,4Series,2015,100079,1
-1AA10008,shenzhen,5Series,2015,10008,1
-1AA100080,shenzhen,9Series,2015,100080,1
-1AA100081,shenzhen,5Series,2015,100081,1
-1AA100082,xiangtan,5Series,2015,100082,1
-1AA100083,zhuzhou,0Series,2015,100083,1
-1AA100084,guangzhou,0Series,2015,100084,1

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_377.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_377.csv b/integration-testcases/src/test/resources/hiveExpected/TC_377.csv
deleted file mode 100644
index afee6ec..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_377.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Max_gamePointId DoubleType
-1AA1,yichang,7Series,2015,1,2738.562
-1AA10,yichang,7Series,2015,10,1714.635
-1AA100,xiangtan,5Series,2015,100,1271.0
-1AA1000,wuhan,5Series,2015,1000,692.0
-1AA10000,guangzhou,7Series,2015,10000,2175.0
-1AA100000,wuhan,9Series,2015,100000,136.0
-1AA1000000,yichang,7Series,2015,1000000,1600.0
-1AA100001,xiangtan,0Series,2015,100001,505.0
-1AA100002,changsha,0Series,2015,100002,1341.0
-1AA100003,zhuzhou,5Series,2015,100003,2239.0
-1AA100004,yichang,4Series,2015,100004,2970.0
-1AA100005,yichang,1Series,2015,100005,2593.0
-1AA100006,changsha,6Series,2015,100006,2572.0
-1AA100007,changsha,9Series,2015,100007,1991.0
-1AA100008,changsha,8Series,2015,100008,1442.0
-1AA100009,yichang,0Series,2015,100009,1841.0
-1AA10001,changsha,2Series,2015,10001,298.0
-1AA100010,zhuzhou,3Series,2015,100010,79.0
-1AA100011,guangzhou,0Series,2015,100011,202.0
-1AA100012,xiangtan,4Series,2015,100012,568.0
-1AA100013,changsha,1Series,2015,100013,355.0
-1AA100014,zhuzhou,5Series,2015,100014,151.0
-1AA100015,xiangtan,4Series,2015,100015,2863.0
-1AA100016,changsha,3Series,2015,100016,1873.0
-1AA100017,xiangtan,9Series,2015,100017,2205.0
-1AA100018,yichang,8Series,2015,100018,441.0
-1AA100019,zhuzhou,5Series,2015,100019,2194.0
-1AA10002,wuhan,0Series,2015,10002,2972.0
-1AA100020,shenzhen,5Series,2015,100020,256.0
-1AA100021,changsha,0Series,2015,100021,1778.0
-1AA100022,zhuzhou,5Series,2015,100022,1999.0
-1AA100023,guangzhou,5Series,2015,100023,2194.0
-1AA100024,changsha,6Series,2015,100024,2483.0
-1AA100025,guangzhou,0Series,2015,100025,1724.0
-1AA100026,yichang,7Series,2015,100026,1768.0
-1AA100027,zhuzhou,0Series,2015,100027,2436.0
-1AA100028,zhuzhou,5Series,2015,100028,2849.0
-1AA100029,xiangtan,2Series,2015,100029,1691.0
-1AA10003,xiangtan,7Series,2015,10003,2071.0
-1AA100030,zhuzhou,7Series,2015,100030,1333.0
-1AA100031,yichang,7Series,2015,100031,1080.0
-1AA100032,shenzhen,1Series,2015,100032,1053.0
-1AA100033,wuhan,8Series,2015,100033,760.0
-1AA100034,guangzhou,2Series,2015,100034,2061.0
-1AA100035,changsha,5Series,2015,100035,2142.0
-1AA100036,changsha,5Series,2015,100036,2224.0
-1AA100037,xiangtan,7Series,2015,100037,1015.0
-1AA100038,shenzhen,6Series,2015,100038,1229.0
-1AA100039,shenzhen,8Series,2015,100039,1750.0
-1AA10004,guangzhou,5Series,2015,10004,1717.0
-1AA100040,yichang,8Series,2015,100040,2078.0
-1AA100041,shenzhen,5Series,2015,100041,2734.0
-1AA100042,shenzhen,3Series,2015,100042,2745.0
-1AA100043,guangzhou,9Series,2015,100043,571.0
-1AA100044,guangzhou,8Series,2015,100044,1697.0
-1AA100045,xiangtan,2Series,2015,100045,2553.0
-1AA100046,guangzhou,3Series,2015,100046,1077.0
-1AA100047,zhuzhou,9Series,2015,100047,1823.0
-1AA100048,guangzhou,3Series,2015,100048,2399.0
-1AA100049,guangzhou,0Series,2015,100049,2890.0
-1AA10005,xiangtan,8Series,2015,10005,1608.0
-1AA100050,yichang,2Series,2015,100050,29.0
-1AA100051,guangzhou,2Series,2015,100051,1407.0
-1AA100052,zhuzhou,6Series,2015,100052,845.0
-1AA100053,wuhan,2Series,2015,100053,1655.0
-1AA100054,shenzhen,7Series,2015,100054,1368.0
-1AA100055,yichang,7Series,2015,100055,1728.0
-1AA100056,wuhan,6Series,2015,100056,750.0
-1AA100057,zhuzhou,9Series,2015,100057,2288.0
-1AA100058,guangzhou,5Series,2015,100058,2635.0
-1AA100059,shenzhen,4Series,2015,100059,1337.0
-1AA10006,guangzhou,3Series,2015,10006,2478.0
-1AA100060,xiangtan,8Series,2015,100060,538.0
-1AA100061,changsha,6Series,2015,100061,1407.0
-1AA100062,yichang,9Series,2015,100062,2952.0
-1AA100063,yichang,2Series,2015,100063,1226.0
-1AA100064,zhuzhou,6Series,2015,100064,865.0
-1AA100065,xiangtan,0Series,2015,100065,901.0
-1AA100066,zhuzhou,6Series,2015,100066,1864.0
-1AA100067,wuhan,4Series,2015,100067,572.0
-1AA100068,guangzhou,8Series,2015,100068,412.0
-1AA100069,xiangtan,8Series,2015,100069,1491.0
-1AA10007,xiangtan,8Series,2015,10007,1350.0
-1AA100070,guangzhou,0Series,2015,100070,1567.0
-1AA100071,guangzhou,0Series,2015,100071,1973.0
-1AA100072,changsha,4Series,2015,100072,448.0
-1AA100073,zhuzhou,4Series,2015,100073,2488.0
-1AA100074,wuhan,6Series,2015,100074,907.0
-1AA100075,shenzhen,3Series,2015,100075,2507.0
-1AA100076,wuhan,0Series,2015,100076,732.0
-1AA100077,yichang,3Series,2015,100077,2077.0
-1AA100078,yichang,2Series,2015,100078,1434.0
-1AA100079,xiangtan,4Series,2015,100079,1098.0
-1AA10008,shenzhen,5Series,2015,10008,813.0
-1AA100080,shenzhen,9Series,2015,100080,954.0
-1AA100081,shenzhen,5Series,2015,100081,613.0
-1AA100082,xiangtan,5Series,2015,100082,2348.0
-1AA100083,zhuzhou,0Series,2015,100083,2192.0
-1AA100084,guangzhou,0Series,2015,100084,2826.0


Mime
View raw message