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:11 UTC
[33/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_378.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_378.csv b/integration-testcases/src/test/resources/hiveExpected/TC_378.csv
deleted file mode 100644
index c5f52f0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_378.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Min_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_379.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_379.csv b/integration-testcases/src/test/resources/hiveExpected/TC_379.csv
deleted file mode 100644
index 255882e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_379.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Min_gamePointId DoubleType
-1AA100084,guangzhou,0Series,2015,100084,2826.0
-1AA100083,zhuzhou,0Series,2015,100083,2192.0
-1AA100082,xiangtan,5Series,2015,100082,2348.0
-1AA100081,shenzhen,5Series,2015,100081,613.0
-1AA100080,shenzhen,9Series,2015,100080,954.0
-1AA10008,shenzhen,5Series,2015,10008,813.0
-1AA100079,xiangtan,4Series,2015,100079,1098.0
-1AA100078,yichang,2Series,2015,100078,1434.0
-1AA100077,yichang,3Series,2015,100077,2077.0
-1AA100076,wuhan,0Series,2015,100076,732.0
-1AA100075,shenzhen,3Series,2015,100075,2507.0
-1AA100074,wuhan,6Series,2015,100074,907.0
-1AA100073,zhuzhou,4Series,2015,100073,2488.0
-1AA100072,changsha,4Series,2015,100072,448.0
-1AA100071,guangzhou,0Series,2015,100071,1973.0
-1AA100070,guangzhou,0Series,2015,100070,1567.0
-1AA10007,xiangtan,8Series,2015,10007,1350.0
-1AA100069,xiangtan,8Series,2015,100069,1491.0
-1AA100068,guangzhou,8Series,2015,100068,412.0
-1AA100067,wuhan,4Series,2015,100067,572.0
-1AA100066,zhuzhou,6Series,2015,100066,1864.0
-1AA100065,xiangtan,0Series,2015,100065,901.0
-1AA100064,zhuzhou,6Series,2015,100064,865.0
-1AA100063,yichang,2Series,2015,100063,1226.0
-1AA100062,yichang,9Series,2015,100062,2952.0
-1AA100061,changsha,6Series,2015,100061,1407.0
-1AA100060,xiangtan,8Series,2015,100060,538.0
-1AA10006,guangzhou,3Series,2015,10006,2478.0
-1AA100059,shenzhen,4Series,2015,100059,1337.0
-1AA100058,guangzhou,5Series,2015,100058,2635.0
-1AA100057,zhuzhou,9Series,2015,100057,2288.0
-1AA100056,wuhan,6Series,2015,100056,750.0
-1AA100055,yichang,7Series,2015,100055,1728.0
-1AA100054,shenzhen,7Series,2015,100054,1368.0
-1AA100053,wuhan,2Series,2015,100053,1655.0
-1AA100052,zhuzhou,6Series,2015,100052,845.0
-1AA100051,guangzhou,2Series,2015,100051,1407.0
-1AA100050,yichang,2Series,2015,100050,29.0
-1AA10005,xiangtan,8Series,2015,10005,1608.0
-1AA100049,guangzhou,0Series,2015,100049,2890.0
-1AA100048,guangzhou,3Series,2015,100048,2399.0
-1AA100047,zhuzhou,9Series,2015,100047,1823.0
-1AA100046,guangzhou,3Series,2015,100046,1077.0
-1AA100045,xiangtan,2Series,2015,100045,2553.0
-1AA100044,guangzhou,8Series,2015,100044,1697.0
-1AA100043,guangzhou,9Series,2015,100043,571.0
-1AA100042,shenzhen,3Series,2015,100042,2745.0
-1AA100041,shenzhen,5Series,2015,100041,2734.0
-1AA100040,yichang,8Series,2015,100040,2078.0
-1AA10004,guangzhou,5Series,2015,10004,1717.0
-1AA100039,shenzhen,8Series,2015,100039,1750.0
-1AA100038,shenzhen,6Series,2015,100038,1229.0
-1AA100037,xiangtan,7Series,2015,100037,1015.0
-1AA100036,changsha,5Series,2015,100036,2224.0
-1AA100035,changsha,5Series,2015,100035,2142.0
-1AA100034,guangzhou,2Series,2015,100034,2061.0
-1AA100033,wuhan,8Series,2015,100033,760.0
-1AA100032,shenzhen,1Series,2015,100032,1053.0
-1AA100031,yichang,7Series,2015,100031,1080.0
-1AA100030,zhuzhou,7Series,2015,100030,1333.0
-1AA10003,xiangtan,7Series,2015,10003,2071.0
-1AA100029,xiangtan,2Series,2015,100029,1691.0
-1AA100028,zhuzhou,5Series,2015,100028,2849.0
-1AA100027,zhuzhou,0Series,2015,100027,2436.0
-1AA100026,yichang,7Series,2015,100026,1768.0
-1AA100025,guangzhou,0Series,2015,100025,1724.0
-1AA100024,changsha,6Series,2015,100024,2483.0
-1AA100023,guangzhou,5Series,2015,100023,2194.0
-1AA100022,zhuzhou,5Series,2015,100022,1999.0
-1AA100021,changsha,0Series,2015,100021,1778.0
-1AA100020,shenzhen,5Series,2015,100020,256.0
-1AA10002,wuhan,0Series,2015,10002,2972.0
-1AA100019,zhuzhou,5Series,2015,100019,2194.0
-1AA100018,yichang,8Series,2015,100018,441.0
-1AA100017,xiangtan,9Series,2015,100017,2205.0
-1AA100016,changsha,3Series,2015,100016,1873.0
-1AA100015,xiangtan,4Series,2015,100015,2863.0
-1AA100014,zhuzhou,5Series,2015,100014,151.0
-1AA100013,changsha,1Series,2015,100013,355.0
-1AA100012,xiangtan,4Series,2015,100012,568.0
-1AA100011,guangzhou,0Series,2015,100011,202.0
-1AA100010,zhuzhou,3Series,2015,100010,79.0
-1AA10001,changsha,2Series,2015,10001,298.0
-1AA100009,yichang,0Series,2015,100009,1841.0
-1AA100008,changsha,8Series,2015,100008,1442.0
-1AA100007,changsha,9Series,2015,100007,1991.0
-1AA100006,changsha,6Series,2015,100006,2572.0
-1AA100005,yichang,1Series,2015,100005,2593.0
-1AA100004,yichang,4Series,2015,100004,2970.0
-1AA100003,zhuzhou,5Series,2015,100003,2239.0
-1AA100002,changsha,0Series,2015,100002,1341.0
-1AA100001,xiangtan,0Series,2015,100001,505.0
-1AA1000000,yichang,7Series,2015,1000000,1600.0
-1AA100000,wuhan,9Series,2015,100000,136.0
-1AA10000,guangzhou,7Series,2015,10000,2175.0
-1AA1000,wuhan,5Series,2015,1000,692.0
-1AA100,xiangtan,5Series,2015,100,1271.0
-1AA10,yichang,7Series,2015,10,1714.635
-1AA1,yichang,7Series,2015,1,2738.562
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_380.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_380.csv b/integration-testcases/src/test/resources/hiveExpected/TC_380.csv
deleted file mode 100644
index a01838b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_380.csv
+++ /dev/null
@@ -1,54 +0,0 @@
-deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Count_imei LongType,Min_gamePointId DoubleType
-changsha,0Series,4030,200023,2,1341.0
-changsha,1Series,2015,100013,1,355.0
-changsha,2Series,2015,10001,1,298.0
-changsha,3Series,2015,100016,1,1873.0
-changsha,4Series,2015,100072,1,448.0
-changsha,5Series,4030,200071,2,2142.0
-changsha,6Series,6045,300091,3,1407.0
-changsha,8Series,2015,100008,1,1442.0
-changsha,9Series,2015,100007,1,1991.0
-guangzhou,0Series,12090,600310,6,202.0
-guangzhou,2Series,4030,200085,2,1407.0
-guangzhou,3Series,6045,210100,3,1077.0
-guangzhou,5Series,6045,210085,3,1717.0
-guangzhou,7Series,2015,10000,1,2175.0
-guangzhou,8Series,4030,200112,2,412.0
-guangzhou,9Series,2015,100043,1,571.0
-shenzhen,1Series,2015,100032,1,1053.0
-shenzhen,3Series,4030,200117,2,2507.0
-shenzhen,4Series,2015,100059,1,1337.0
-shenzhen,5Series,8060,310150,4,256.0
-shenzhen,6Series,2015,100038,1,1229.0
-shenzhen,7Series,2015,100054,1,1368.0
-shenzhen,8Series,2015,100039,1,1750.0
-shenzhen,9Series,2015,100080,1,954.0
-wuhan,0Series,4030,110078,2,732.0
-wuhan,2Series,2015,100053,1,1655.0
-wuhan,4Series,2015,100067,1,572.0
-wuhan,5Series,2015,1000,1,692.0
-wuhan,6Series,4030,200130,2,750.0
-wuhan,8Series,2015,100033,1,760.0
-wuhan,9Series,2015,100000,1,136.0
-xiangtan,0Series,4030,200066,2,505.0
-xiangtan,2Series,4030,200074,2,1691.0
-xiangtan,4Series,6045,300106,3,568.0
-xiangtan,5Series,4030,100182,2,1271.0
-xiangtan,7Series,4030,110040,2,1015.0
-xiangtan,8Series,8060,220141,4,538.0
-xiangtan,9Series,2015,100017,1,2205.0
-yichang,0Series,2015,100009,1,1841.0
-yichang,1Series,2015,100005,1,2593.0
-yichang,2Series,6045,300191,3,29.0
-yichang,3Series,2015,100077,1,2077.0
-yichang,4Series,2015,100004,1,2970.0
-yichang,7Series,12090,1300123,6,1080.0
-yichang,8Series,4030,200058,2,441.0
-yichang,9Series,2015,100062,1,2952.0
-zhuzhou,0Series,4030,200110,2,2192.0
-zhuzhou,3Series,2015,100010,1,79.0
-zhuzhou,4Series,2015,100073,1,2488.0
-zhuzhou,5Series,10075,500086,5,151.0
-zhuzhou,6Series,6045,300182,3,845.0
-zhuzhou,7Series,2015,100030,1,1333.0
-zhuzhou,9Series,4030,200104,2,1823.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_381.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_381.csv b/integration-testcases/src/test/resources/hiveExpected/TC_381.csv
deleted file mode 100644
index 45740c0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_381.csv
+++ /dev/null
@@ -1,54 +0,0 @@
-deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,DistinctCount_imei LongType,Min_gamePointId DoubleType
-changsha,0Series,4030,200023,2,1341.0
-changsha,1Series,2015,100013,1,355.0
-changsha,2Series,2015,10001,1,298.0
-changsha,3Series,2015,100016,1,1873.0
-changsha,4Series,2015,100072,1,448.0
-changsha,5Series,4030,200071,2,2142.0
-changsha,6Series,6045,300091,3,1407.0
-changsha,8Series,2015,100008,1,1442.0
-changsha,9Series,2015,100007,1,1991.0
-guangzhou,0Series,12090,600310,6,202.0
-guangzhou,2Series,4030,200085,2,1407.0
-guangzhou,3Series,6045,210100,3,1077.0
-guangzhou,5Series,6045,210085,3,1717.0
-guangzhou,7Series,2015,10000,1,2175.0
-guangzhou,8Series,4030,200112,2,412.0
-guangzhou,9Series,2015,100043,1,571.0
-shenzhen,1Series,2015,100032,1,1053.0
-shenzhen,3Series,4030,200117,2,2507.0
-shenzhen,4Series,2015,100059,1,1337.0
-shenzhen,5Series,8060,310150,4,256.0
-shenzhen,6Series,2015,100038,1,1229.0
-shenzhen,7Series,2015,100054,1,1368.0
-shenzhen,8Series,2015,100039,1,1750.0
-shenzhen,9Series,2015,100080,1,954.0
-wuhan,0Series,4030,110078,2,732.0
-wuhan,2Series,2015,100053,1,1655.0
-wuhan,4Series,2015,100067,1,572.0
-wuhan,5Series,2015,1000,1,692.0
-wuhan,6Series,4030,200130,2,750.0
-wuhan,8Series,2015,100033,1,760.0
-wuhan,9Series,2015,100000,1,136.0
-xiangtan,0Series,4030,200066,2,505.0
-xiangtan,2Series,4030,200074,2,1691.0
-xiangtan,4Series,6045,300106,3,568.0
-xiangtan,5Series,4030,100182,2,1271.0
-xiangtan,7Series,4030,110040,2,1015.0
-xiangtan,8Series,8060,220141,4,538.0
-xiangtan,9Series,2015,100017,1,2205.0
-yichang,0Series,2015,100009,1,1841.0
-yichang,1Series,2015,100005,1,2593.0
-yichang,2Series,6045,300191,3,29.0
-yichang,3Series,2015,100077,1,2077.0
-yichang,4Series,2015,100004,1,2970.0
-yichang,7Series,12090,1300123,6,1080.0
-yichang,8Series,4030,200058,2,441.0
-yichang,9Series,2015,100062,1,2952.0
-zhuzhou,0Series,4030,200110,2,2192.0
-zhuzhou,3Series,2015,100010,1,79.0
-zhuzhou,4Series,2015,100073,1,2488.0
-zhuzhou,5Series,10075,500086,5,151.0
-zhuzhou,6Series,6045,300182,3,845.0
-zhuzhou,7Series,2015,100030,1,1333.0
-zhuzhou,9Series,4030,200104,2,1823.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_382.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_382.csv b/integration-testcases/src/test/resources/hiveExpected/TC_382.csv
deleted file mode 100644
index d50bc55..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_382.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-deliveryCity StringType,Latest_YEAR IntegerType,imei StringType,Sum_gamePointId DoubleType,Sum_deviceInformationId LongType
-changsha,2015,1AA100002,1341.0,100002
-changsha,2015,1AA100006,2572.0,100006
-changsha,2015,1AA100007,1991.0,100007
-changsha,2015,1AA100008,1442.0,100008
-changsha,2015,1AA10001,298.0,10001
-changsha,2015,1AA100013,355.0,100013
-changsha,2015,1AA100016,1873.0,100016
-changsha,2015,1AA100021,1778.0,100021
-changsha,2015,1AA100024,2483.0,100024
-changsha,2015,1AA100035,2142.0,100035
-changsha,2015,1AA100036,2224.0,100036
-changsha,2015,1AA100061,1407.0,100061
-changsha,2015,1AA100072,448.0,100072
-guangzhou,2015,1AA10000,2175.0,10000
-guangzhou,2015,1AA100011,202.0,100011
-guangzhou,2015,1AA100023,2194.0,100023
-guangzhou,2015,1AA100025,1724.0,100025
-guangzhou,2015,1AA100034,2061.0,100034
-guangzhou,2015,1AA10004,1717.0,10004
-guangzhou,2015,1AA100043,571.0,100043
-guangzhou,2015,1AA100044,1697.0,100044
-guangzhou,2015,1AA100046,1077.0,100046
-guangzhou,2015,1AA100048,2399.0,100048
-guangzhou,2015,1AA100049,2890.0,100049
-guangzhou,2015,1AA100051,1407.0,100051
-guangzhou,2015,1AA100058,2635.0,100058
-guangzhou,2015,1AA10006,2478.0,10006
-guangzhou,2015,1AA100068,412.0,100068
-guangzhou,2015,1AA100070,1567.0,100070
-guangzhou,2015,1AA100071,1973.0,100071
-guangzhou,2015,1AA100084,2826.0,100084
-shenzhen,2015,1AA100020,256.0,100020
-shenzhen,2015,1AA100032,1053.0,100032
-shenzhen,2015,1AA100038,1229.0,100038
-shenzhen,2015,1AA100039,1750.0,100039
-shenzhen,2015,1AA100041,2734.0,100041
-shenzhen,2015,1AA100042,2745.0,100042
-shenzhen,2015,1AA100054,1368.0,100054
-shenzhen,2015,1AA100059,1337.0,100059
-shenzhen,2015,1AA100075,2507.0,100075
-shenzhen,2015,1AA10008,813.0,10008
-shenzhen,2015,1AA100080,954.0,100080
-shenzhen,2015,1AA100081,613.0,100081
-wuhan,2015,1AA1000,692.0,1000
-wuhan,2015,1AA100000,136.0,100000
-wuhan,2015,1AA10002,2972.0,10002
-wuhan,2015,1AA100033,760.0,100033
-wuhan,2015,1AA100053,1655.0,100053
-wuhan,2015,1AA100056,750.0,100056
-wuhan,2015,1AA100067,572.0,100067
-wuhan,2015,1AA100074,907.0,100074
-wuhan,2015,1AA100076,732.0,100076
-xiangtan,2015,1AA100,1271.0,100
-xiangtan,2015,1AA100001,505.0,100001
-xiangtan,2015,1AA100012,568.0,100012
-xiangtan,2015,1AA100015,2863.0,100015
-xiangtan,2015,1AA100017,2205.0,100017
-xiangtan,2015,1AA100029,1691.0,100029
-xiangtan,2015,1AA10003,2071.0,10003
-xiangtan,2015,1AA100037,1015.0,100037
-xiangtan,2015,1AA100045,2553.0,100045
-xiangtan,2015,1AA10005,1608.0,10005
-xiangtan,2015,1AA100060,538.0,100060
-xiangtan,2015,1AA100065,901.0,100065
-xiangtan,2015,1AA100069,1491.0,100069
-xiangtan,2015,1AA10007,1350.0,10007
-xiangtan,2015,1AA100079,1098.0,100079
-xiangtan,2015,1AA100082,2348.0,100082
-yichang,2015,1AA1,2738.562,1
-yichang,2015,1AA10,1714.635,10
-yichang,2015,1AA1000000,1600.0,1000000
-yichang,2015,1AA100004,2970.0,100004
-yichang,2015,1AA100005,2593.0,100005
-yichang,2015,1AA100009,1841.0,100009
-yichang,2015,1AA100018,441.0,100018
-yichang,2015,1AA100026,1768.0,100026
-yichang,2015,1AA100031,1080.0,100031
-yichang,2015,1AA100040,2078.0,100040
-yichang,2015,1AA100050,29.0,100050
-yichang,2015,1AA100055,1728.0,100055
-yichang,2015,1AA100062,2952.0,100062
-yichang,2015,1AA100063,1226.0,100063
-yichang,2015,1AA100077,2077.0,100077
-yichang,2015,1AA100078,1434.0,100078
-zhuzhou,2015,1AA100003,2239.0,100003
-zhuzhou,2015,1AA100010,79.0,100010
-zhuzhou,2015,1AA100014,151.0,100014
-zhuzhou,2015,1AA100019,2194.0,100019
-zhuzhou,2015,1AA100022,1999.0,100022
-zhuzhou,2015,1AA100027,2436.0,100027
-zhuzhou,2015,1AA100028,2849.0,100028
-zhuzhou,2015,1AA100030,1333.0,100030
-zhuzhou,2015,1AA100047,1823.0,100047
-zhuzhou,2015,1AA100052,845.0,100052
-zhuzhou,2015,1AA100057,2288.0,100057
-zhuzhou,2015,1AA100064,865.0,100064
-zhuzhou,2015,1AA100066,1864.0,100066
-zhuzhou,2015,1AA100073,2488.0,100073
-zhuzhou,2015,1AA100083,2192.0,100083
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_383.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_383.csv b/integration-testcases/src/test/resources/hiveExpected/TC_383.csv
deleted file mode 100644
index c319a0e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_383.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-deliveryCity StringType,imei StringType,series StringType,Sum_Latest_YEAR LongType
-changsha,1AA100002,0Series,2015
-changsha,1AA100006,6Series,2015
-changsha,1AA100007,9Series,2015
-changsha,1AA100008,8Series,2015
-changsha,1AA10001,2Series,2015
-changsha,1AA100013,1Series,2015
-changsha,1AA100016,3Series,2015
-changsha,1AA100021,0Series,2015
-changsha,1AA100024,6Series,2015
-changsha,1AA100035,5Series,2015
-changsha,1AA100036,5Series,2015
-changsha,1AA100061,6Series,2015
-changsha,1AA100072,4Series,2015
-guangzhou,1AA10000,7Series,2015
-guangzhou,1AA100011,0Series,2015
-guangzhou,1AA100023,5Series,2015
-guangzhou,1AA100025,0Series,2015
-guangzhou,1AA100034,2Series,2015
-guangzhou,1AA10004,5Series,2015
-guangzhou,1AA100043,9Series,2015
-guangzhou,1AA100044,8Series,2015
-guangzhou,1AA100046,3Series,2015
-guangzhou,1AA100048,3Series,2015
-guangzhou,1AA100049,0Series,2015
-guangzhou,1AA100051,2Series,2015
-guangzhou,1AA100058,5Series,2015
-guangzhou,1AA10006,3Series,2015
-guangzhou,1AA100068,8Series,2015
-guangzhou,1AA100070,0Series,2015
-guangzhou,1AA100071,0Series,2015
-guangzhou,1AA100084,0Series,2015
-shenzhen,1AA100020,5Series,2015
-shenzhen,1AA100032,1Series,2015
-shenzhen,1AA100038,6Series,2015
-shenzhen,1AA100039,8Series,2015
-shenzhen,1AA100041,5Series,2015
-shenzhen,1AA100042,3Series,2015
-shenzhen,1AA100054,7Series,2015
-shenzhen,1AA100059,4Series,2015
-shenzhen,1AA100075,3Series,2015
-shenzhen,1AA10008,5Series,2015
-shenzhen,1AA100080,9Series,2015
-shenzhen,1AA100081,5Series,2015
-wuhan,1AA1000,5Series,2015
-wuhan,1AA100000,9Series,2015
-wuhan,1AA10002,0Series,2015
-wuhan,1AA100033,8Series,2015
-wuhan,1AA100053,2Series,2015
-wuhan,1AA100056,6Series,2015
-wuhan,1AA100067,4Series,2015
-wuhan,1AA100074,6Series,2015
-wuhan,1AA100076,0Series,2015
-xiangtan,1AA100,5Series,2015
-xiangtan,1AA100001,0Series,2015
-xiangtan,1AA100012,4Series,2015
-xiangtan,1AA100015,4Series,2015
-xiangtan,1AA100017,9Series,2015
-xiangtan,1AA100029,2Series,2015
-xiangtan,1AA10003,7Series,2015
-xiangtan,1AA100037,7Series,2015
-xiangtan,1AA100045,2Series,2015
-xiangtan,1AA10005,8Series,2015
-xiangtan,1AA100060,8Series,2015
-xiangtan,1AA100065,0Series,2015
-xiangtan,1AA100069,8Series,2015
-xiangtan,1AA10007,8Series,2015
-xiangtan,1AA100079,4Series,2015
-xiangtan,1AA100082,5Series,2015
-yichang,1AA1,7Series,2015
-yichang,1AA10,7Series,2015
-yichang,1AA1000000,7Series,2015
-yichang,1AA100004,4Series,2015
-yichang,1AA100005,1Series,2015
-yichang,1AA100009,0Series,2015
-yichang,1AA100018,8Series,2015
-yichang,1AA100026,7Series,2015
-yichang,1AA100031,7Series,2015
-yichang,1AA100040,8Series,2015
-yichang,1AA100050,2Series,2015
-yichang,1AA100055,7Series,2015
-yichang,1AA100062,9Series,2015
-yichang,1AA100063,2Series,2015
-yichang,1AA100077,3Series,2015
-yichang,1AA100078,2Series,2015
-zhuzhou,1AA100003,5Series,2015
-zhuzhou,1AA100010,3Series,2015
-zhuzhou,1AA100014,5Series,2015
-zhuzhou,1AA100019,5Series,2015
-zhuzhou,1AA100022,5Series,2015
-zhuzhou,1AA100027,0Series,2015
-zhuzhou,1AA100028,5Series,2015
-zhuzhou,1AA100030,7Series,2015
-zhuzhou,1AA100047,9Series,2015
-zhuzhou,1AA100052,6Series,2015
-zhuzhou,1AA100057,9Series,2015
-zhuzhou,1AA100064,6Series,2015
-zhuzhou,1AA100066,6Series,2015
-zhuzhou,1AA100073,4Series,2015
-zhuzhou,1AA100083,0Series,2015
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_384.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_384.csv b/integration-testcases/src/test/resources/hiveExpected/TC_384.csv
deleted file mode 100644
index 2f8f291..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_384.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-series StringType,Sum_gamePointId DoubleType
-0Series,25880.0
-1Series,4001.0
-2Series,12354.0
-3Series,15235.0
-4Series,12344.0
-5Series,29071.0
-6Series,12922.0
-7Series,18591.197
-8Series,13567.0
-9Series,12920.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_386.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_386.csv b/integration-testcases/src/test/resources/hiveExpected/TC_386.csv
deleted file mode 100644
index 72387ed..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_386.csv
+++ /dev/null
@@ -1,46 +0,0 @@
-channelsId StringType,deliveryCity StringType
-1,changsha
-1,guangzhou
-1,shenzhen
-1,xiangtan
-1,yichang
-1,zhuzhou
-2,changsha
-2,guangzhou
-2,shenzhen
-2,xiangtan
-2,yichang
-2,zhuzhou
-3,changsha
-3,guangzhou
-3,shenzhen
-3,wuhan
-3,xiangtan
-3,yichang
-3,zhuzhou
-4,guangzhou
-4,shenzhen
-4,xiangtan
-4,yichang
-4,zhuzhou
-5,changsha
-5,guangzhou
-5,shenzhen
-5,wuhan
-5,xiangtan
-5,yichang
-5,zhuzhou
-6,changsha
-6,guangzhou
-6,shenzhen
-6,wuhan
-6,xiangtan
-6,yichang
-6,zhuzhou
-7,changsha
-7,guangzhou
-7,shenzhen
-7,wuhan
-7,xiangtan
-7,yichang
-7,zhuzhou
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_387.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_387.csv b/integration-testcases/src/test/resources/hiveExpected/TC_387.csv
deleted file mode 100644
index a6e5e50..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_387.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-modelId StringType,Sum_gamepointid DoubleType
-1017,2483.0
-104,1442.0
-1062,2507.0
-1069,151.0
-1085,448.0
-109,2738.562
-1121,2239.0
-1160,572.0
-1168,901.0
-1184,2399.0
-1185,1608.0
-1195,1491.0
-1198,1053.0
-1210,1655.0
-1232,1697.0
-1234,2061.0
-1326,2071.0
-138,865.0
-1386,2194.0
-1429,2478.0
-1447,2863.0
-1511,2970.0
-155,1999.0
-1580,2205.0
-1602,2553.0
-1619,2142.0
-1624,813.0
-1650,613.0
-1683,1973.0
-1689,1368.0
-1695,1691.0
-1734,1778.0
-1741,1080.0
-1815,136.0
-1835,1750.0
-1841,2826.0
-1845,505.0
-1856,2192.0
-187,571.0
-1890,412.0
-1969,2078.0
-2008,1341.0
-2069,2572.0
-2074,907.0
-2133,2734.0
-2142,1226.0
-2151,2194.0
-2164,1098.0
-2167,355.0
-2176,538.0
-2201,2972.0
-2300,845.0
-2319,1077.0
-2320,1407.0
-2355,954.0
-2381,1015.0
-2408,2175.0
-2415,2224.0
-2457,29.0
-2479,1600.0
-2531,692.0
-2563,1407.0
-2574,256.0
-2591,1271.0
-2594,2952.0
-2597,1717.0
-2644,568.0
-2696,79.0
-2705,2890.0
-273,760.0
-2759,2593.0
-2761,2348.0
-2765,1434.0
-2797,1350.0
-2799,2077.0
-2823,1728.0
-2828,1864.0
-2930,1768.0
-2940,2436.0
-2963,1873.0
-297,2849.0
-396,1991.0
-44,1567.0
-446,441.0
-466,202.0
-47,1724.0
-477,1841.0
-499,1337.0
-513,1333.0
-546,298.0
-631,2745.0
-68,750.0
-716,2288.0
-776,2488.0
-839,1823.0
-864,2635.0
-872,1229.0
-93,1714.635
-987,732.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_388.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_388.csv b/integration-testcases/src/test/resources/hiveExpected/TC_388.csv
deleted file mode 100644
index 063016d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_388.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,channelsId StringType,Count_deliveryTime LongType
-1AA1,4,1
-1AA10,4,1
-1AA100,6,1
-1AA1000,3,1
-1AA10000,1,1
-1AA100000,6,1
-1AA1000000,6,1
-1AA100001,7,1
-1AA100002,3,1
-1AA100003,3,1
-1AA100004,2,1
-1AA100005,1,1
-1AA100006,2,1
-1AA100007,3,1
-1AA100008,1,1
-1AA100009,3,1
-1AA10001,5,1
-1AA100010,6,1
-1AA100011,1,1
-1AA100012,2,1
-1AA100013,6,1
-1AA100014,3,1
-1AA100015,1,1
-1AA100016,3,1
-1AA100017,3,1
-1AA100018,4,1
-1AA100019,3,1
-1AA10002,5,1
-1AA100020,7,1
-1AA100021,6,1
-1AA100022,5,1
-1AA100023,3,1
-1AA100024,2,1
-1AA100025,1,1
-1AA100026,7,1
-1AA100027,4,1
-1AA100028,5,1
-1AA100029,5,1
-1AA10003,4,1
-1AA100030,3,1
-1AA100031,1,1
-1AA100032,7,1
-1AA100033,6,1
-1AA100034,6,1
-1AA100035,7,1
-1AA100036,5,1
-1AA100037,6,1
-1AA100038,3,1
-1AA100039,1,1
-1AA10004,4,1
-1AA100040,7,1
-1AA100041,1,1
-1AA100042,5,1
-1AA100043,6,1
-1AA100044,2,1
-1AA100045,6,1
-1AA100046,4,1
-1AA100047,1,1
-1AA100048,1,1
-1AA100049,6,1
-1AA10005,2,1
-1AA100050,1,1
-1AA100051,7,1
-1AA100052,7,1
-1AA100053,3,1
-1AA100054,2,1
-1AA100055,7,1
-1AA100056,5,1
-1AA100057,6,1
-1AA100058,4,1
-1AA100059,7,1
-1AA10006,5,1
-1AA100060,4,1
-1AA100061,6,1
-1AA100062,6,1
-1AA100063,3,1
-1AA100064,7,1
-1AA100065,7,1
-1AA100066,4,1
-1AA100067,7,1
-1AA100068,7,1
-1AA100069,5,1
-1AA10007,3,1
-1AA100070,3,1
-1AA100071,5,1
-1AA100072,7,1
-1AA100073,2,1
-1AA100074,7,1
-1AA100075,6,1
-1AA100076,7,1
-1AA100077,6,1
-1AA100078,5,1
-1AA100079,6,1
-1AA10008,4,1
-1AA100080,6,1
-1AA100081,2,1
-1AA100082,7,1
-1AA100083,2,1
-1AA100084,4,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_389.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_389.csv b/integration-testcases/src/test/resources/hiveExpected/TC_389.csv
deleted file mode 100644
index b3788b2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_389.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,Sum_deviceInformationId LongType
-1AA1,1
-1AA10,10
-1AA100,100
-1AA1000,1000
-1AA10000,10000
-1AA100000,100000
-1AA1000000,1000000
-1AA100001,100001
-1AA100002,100002
-1AA100003,100003
-1AA100004,100004
-1AA100005,100005
-1AA100006,100006
-1AA100007,100007
-1AA100008,100008
-1AA100009,100009
-1AA10001,10001
-1AA100010,100010
-1AA100011,100011
-1AA100012,100012
-1AA100013,100013
-1AA100014,100014
-1AA100015,100015
-1AA100016,100016
-1AA100017,100017
-1AA100018,100018
-1AA100019,100019
-1AA10002,10002
-1AA100020,100020
-1AA100021,100021
-1AA100022,100022
-1AA100023,100023
-1AA100024,100024
-1AA100025,100025
-1AA100026,100026
-1AA100027,100027
-1AA100028,100028
-1AA100029,100029
-1AA10003,10003
-1AA100030,100030
-1AA100031,100031
-1AA100032,100032
-1AA100033,100033
-1AA100034,100034
-1AA100035,100035
-1AA100036,100036
-1AA100037,100037
-1AA100038,100038
-1AA100039,100039
-1AA10004,10004
-1AA100040,100040
-1AA100041,100041
-1AA100042,100042
-1AA100043,100043
-1AA100044,100044
-1AA100045,100045
-1AA100046,100046
-1AA100047,100047
-1AA100048,100048
-1AA100049,100049
-1AA10005,10005
-1AA100050,100050
-1AA100051,100051
-1AA100052,100052
-1AA100053,100053
-1AA100054,100054
-1AA100055,100055
-1AA100056,100056
-1AA100057,100057
-1AA100058,100058
-1AA100059,100059
-1AA10006,10006
-1AA100060,100060
-1AA100061,100061
-1AA100062,100062
-1AA100063,100063
-1AA100064,100064
-1AA100065,100065
-1AA100066,100066
-1AA100067,100067
-1AA100068,100068
-1AA100069,100069
-1AA10007,10007
-1AA100070,100070
-1AA100071,100071
-1AA100072,100072
-1AA100073,100073
-1AA100074,100074
-1AA100075,100075
-1AA100076,100076
-1AA100077,100077
-1AA100078,100078
-1AA100079,100079
-1AA10008,10008
-1AA100080,100080
-1AA100081,100081
-1AA100082,100082
-1AA100083,100083
-1AA100084,100084
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_390.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_390.csv b/integration-testcases/src/test/resources/hiveExpected/TC_390.csv
deleted file mode 100644
index aef39a5..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_390.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-Latest_DAY IntegerType,imei StringType,gamepointid DoubleType
-1,1AA1,2738.562
-1,1AA10,1714.635
-1,1AA100,1271.0
-1,1AA1000,692.0
-1,1AA10000,2175.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_391.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_391.csv b/integration-testcases/src/test/resources/hiveExpected/TC_391.csv
deleted file mode 100644
index 494ccff..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_391.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-gamepointid DoubleType,imei StringType
-79.0,1AA100010
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_392.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_392.csv b/integration-testcases/src/test/resources/hiveExpected/TC_392.csv
deleted file mode 100644
index 276ce95..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_392.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-deviceInformationId IntegerType,imei StringType
-100083,1AA100083
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_393.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_393.csv b/integration-testcases/src/test/resources/hiveExpected/TC_393.csv
deleted file mode 100644
index 534d435..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_393.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-channelsId StringType,imei StringType
-4,1AA1
-4,1AA10
-4,1AA100018
-4,1AA100027
-4,1AA10003
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_394.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_394.csv b/integration-testcases/src/test/resources/hiveExpected/TC_394.csv
deleted file mode 100644
index 19e57c3..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_394.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-contractNumber DoubleType,imei StringType
-507229.0,1AA100083
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_395.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_395.csv b/integration-testcases/src/test/resources/hiveExpected/TC_395.csv
deleted file mode 100644
index 9ed0801..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_395.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-Latest_YEAR IntegerType,imei StringType
-2015,1AA1
-2015,1AA10
-2015,1AA100
-2015,1AA1000
-2015,1AA10000
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_396.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_396.csv b/integration-testcases/src/test/resources/hiveExpected/TC_396.csv
deleted file mode 100644
index a25aa42..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_396.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-Latest_province StringType,imei StringType
-Guangdong Province,1AA1
-Guangdong Province,1AA1000000
-Guangdong Province,1AA100001
-Guangdong Province,1AA100002
-Guangdong Province,1AA100005
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_397.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_397.csv b/integration-testcases/src/test/resources/hiveExpected/TC_397.csv
deleted file mode 100644
index 90b8e72..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_397.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-Latest_DAY IntegerType,imei StringType
-1,1AA1
-1,1AA10
-1,1AA100
-1,1AA1000
-1,1AA10000
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_398.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_398.csv b/integration-testcases/src/test/resources/hiveExpected/TC_398.csv
deleted file mode 100644
index 90b8e72..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_398.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-Latest_DAY IntegerType,imei StringType
-1,1AA1
-1,1AA10
-1,1AA100
-1,1AA1000
-1,1AA10000
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_399.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_399.csv b/integration-testcases/src/test/resources/hiveExpected/TC_399.csv
deleted file mode 100644
index 26c11f9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_399.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-deviceInformationId IntegerType,imei StringType
-1,1AA1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_400.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_400.csv b/integration-testcases/src/test/resources/hiveExpected/TC_400.csv
deleted file mode 100644
index 26c11f9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_400.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-deviceInformationId IntegerType,imei StringType
-1,1AA1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_401.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_401.csv b/integration-testcases/src/test/resources/hiveExpected/TC_401.csv
deleted file mode 100644
index 534d435..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_401.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-channelsId StringType,imei StringType
-4,1AA1
-4,1AA10
-4,1AA100018
-4,1AA100027
-4,1AA10003
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_402.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_402.csv b/integration-testcases/src/test/resources/hiveExpected/TC_402.csv
deleted file mode 100644
index 534d435..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_402.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-channelsId StringType,imei StringType
-4,1AA1
-4,1AA10
-4,1AA100018
-4,1AA100027
-4,1AA10003
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_403.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_403.csv b/integration-testcases/src/test/resources/hiveExpected/TC_403.csv
deleted file mode 100644
index b9b615e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_403.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-gamePointId DoubleType,imei StringType
-136.0,1AA100000
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_404.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_404.csv b/integration-testcases/src/test/resources/hiveExpected/TC_404.csv
deleted file mode 100644
index b9b615e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_404.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-gamePointId DoubleType,imei StringType
-136.0,1AA100000
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_405.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_405.csv b/integration-testcases/src/test/resources/hiveExpected/TC_405.csv
deleted file mode 100644
index 5cb53d0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_405.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType
-1AA100083
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_406.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_406.csv b/integration-testcases/src/test/resources/hiveExpected/TC_406.csv
deleted file mode 100644
index 5cb53d0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_406.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType
-1AA100083
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_407.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_407.csv b/integration-testcases/src/test/resources/hiveExpected/TC_407.csv
deleted file mode 100644
index 38647fa..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_407.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-MAC StringType,imei StringType
-MAC,1AA1
-MAC,1AA10
-MAC,1AA100
-MAC,1AA1000
-MAC,1AA10000
-MAC,1AA100000
-MAC,1AA1000000
-MAC,1AA100001
-MAC,1AA100002
-MAC,1AA100003
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_408.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_408.csv b/integration-testcases/src/test/resources/hiveExpected/TC_408.csv
deleted file mode 100644
index 18d8659..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_408.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-imei StringType,series StringType
-1AA1,7Series
-1AA10,7Series
-1AA10000,7Series
-1AA1000000,7Series
-1AA100026,7Series
-1AA10003,7Series
-1AA100030,7Series
-1AA100031,7Series
-1AA100037,7Series
-1AA100054,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_409.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_409.csv b/integration-testcases/src/test/resources/hiveExpected/TC_409.csv
deleted file mode 100644
index 0bffbfb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_409.csv
+++ /dev/null
@@ -1 +0,0 @@
-gamePointId DoubleType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_410.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_410.csv b/integration-testcases/src/test/resources/hiveExpected/TC_410.csv
deleted file mode 100644
index 9035790..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_410.csv
+++ /dev/null
@@ -1 +0,0 @@
-contractNumber DoubleType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_411.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_411.csv b/integration-testcases/src/test/resources/hiveExpected/TC_411.csv
deleted file mode 100644
index ec7c4eb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_411.csv
+++ /dev/null
@@ -1 +0,0 @@
-imei StringType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_412.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_412.csv b/integration-testcases/src/test/resources/hiveExpected/TC_412.csv
deleted file mode 100644
index 3144398..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_412.csv
+++ /dev/null
@@ -1 +0,0 @@
-bomCode StringType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_413.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_413.csv b/integration-testcases/src/test/resources/hiveExpected/TC_413.csv
deleted file mode 100644
index e699474..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_413.csv
+++ /dev/null
@@ -1 +0,0 @@
-latest_day IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_414.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_414.csv b/integration-testcases/src/test/resources/hiveExpected/TC_414.csv
deleted file mode 100644
index e699474..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_414.csv
+++ /dev/null
@@ -1 +0,0 @@
-latest_day IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_415.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_415.csv b/integration-testcases/src/test/resources/hiveExpected/TC_415.csv
deleted file mode 100644
index 0dbb23b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_415.csv
+++ /dev/null
@@ -1 +0,0 @@
-deviceinformationid IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_416.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_416.csv b/integration-testcases/src/test/resources/hiveExpected/TC_416.csv
deleted file mode 100644
index 0dbb23b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_416.csv
+++ /dev/null
@@ -1 +0,0 @@
-deviceinformationid IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_417.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_417.csv b/integration-testcases/src/test/resources/hiveExpected/TC_417.csv
deleted file mode 100644
index ec7c4eb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_417.csv
+++ /dev/null
@@ -1 +0,0 @@
-imei StringType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_418.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_418.csv b/integration-testcases/src/test/resources/hiveExpected/TC_418.csv
deleted file mode 100644
index ec7c4eb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_418.csv
+++ /dev/null
@@ -1 +0,0 @@
-imei StringType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_419.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_419.csv b/integration-testcases/src/test/resources/hiveExpected/TC_419.csv
deleted file mode 100644
index fe96433..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_419.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 LongType
-0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_420.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_420.csv b/integration-testcases/src/test/resources/hiveExpected/TC_420.csv
deleted file mode 100644
index 784c96b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_420.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_421.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_421.csv b/integration-testcases/src/test/resources/hiveExpected/TC_421.csv
deleted file mode 100644
index 784c96b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_421.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_422.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_422.csv b/integration-testcases/src/test/resources/hiveExpected/TC_422.csv
deleted file mode 100644
index 948b832..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_422.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 StringType
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_423.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_423.csv b/integration-testcases/src/test/resources/hiveExpected/TC_423.csv
deleted file mode 100644
index 948b832..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_423.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 StringType
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_424.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_424.csv b/integration-testcases/src/test/resources/hiveExpected/TC_424.csv
deleted file mode 100644
index fe96433..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_424.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 LongType
-0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_425.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_425.csv b/integration-testcases/src/test/resources/hiveExpected/TC_425.csv
deleted file mode 100644
index 705aa9e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_425.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType
-1AA1
-1AA10
-1AA100
-1AA1000
-1AA10000
-1AA100000
-1AA1000000
-1AA100001
-1AA100002
-1AA100003
-1AA100004
-1AA100005
-1AA100006
-1AA100007
-1AA100008
-1AA100009
-1AA10001
-1AA100010
-1AA100011
-1AA100012
-1AA100013
-1AA100014
-1AA100015
-1AA100016
-1AA100017
-1AA100018
-1AA100019
-1AA10002
-1AA100020
-1AA100021
-1AA100022
-1AA100023
-1AA100024
-1AA100025
-1AA100026
-1AA100027
-1AA100028
-1AA100029
-1AA10003
-1AA100030
-1AA100031
-1AA100032
-1AA100033
-1AA100034
-1AA100035
-1AA100036
-1AA100037
-1AA100038
-1AA100039
-1AA10004
-1AA100040
-1AA100041
-1AA100042
-1AA100043
-1AA100044
-1AA100045
-1AA100046
-1AA100047
-1AA100048
-1AA100049
-1AA10005
-1AA100050
-1AA100051
-1AA100052
-1AA100053
-1AA100054
-1AA100055
-1AA100056
-1AA100057
-1AA100058
-1AA100059
-1AA10006
-1AA100060
-1AA100061
-1AA100062
-1AA100063
-1AA100064
-1AA100065
-1AA100066
-1AA100067
-1AA100068
-1AA100069
-1AA10007
-1AA100070
-1AA100071
-1AA100072
-1AA100073
-1AA100074
-1AA100075
-1AA100076
-1AA100077
-1AA100078
-1AA100079
-1AA10008
-1AA100080
-1AA100081
-1AA100082
-1AA100083
-1AA100084
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_426.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_426.csv b/integration-testcases/src/test/resources/hiveExpected/TC_426.csv
deleted file mode 100644
index f05eddb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_426.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-gamePointId DoubleType
-2738.562
-1714.635
-1271.0
-692.0
-2175.0
-136.0
-1600.0
-505.0
-1341.0
-2239.0
-2970.0
-2593.0
-2572.0
-1991.0
-1442.0
-1841.0
-298.0
-79.0
-202.0
-568.0
-355.0
-151.0
-2863.0
-1873.0
-2205.0
-441.0
-2194.0
-2972.0
-256.0
-1778.0
-1999.0
-2194.0
-2483.0
-1724.0
-1768.0
-2436.0
-2849.0
-1691.0
-2071.0
-1333.0
-1080.0
-1053.0
-760.0
-2061.0
-2142.0
-2224.0
-1015.0
-1229.0
-1750.0
-1717.0
-2078.0
-2734.0
-2745.0
-571.0
-1697.0
-2553.0
-1077.0
-1823.0
-2399.0
-2890.0
-1608.0
-29.0
-1407.0
-845.0
-1655.0
-1368.0
-1728.0
-750.0
-2288.0
-2635.0
-1337.0
-2478.0
-538.0
-1407.0
-2952.0
-1226.0
-865.0
-901.0
-1864.0
-572.0
-412.0
-1491.0
-1350.0
-1567.0
-1973.0
-448.0
-2488.0
-907.0
-2507.0
-732.0
-2077.0
-1434.0
-1098.0
-813.0
-954.0
-613.0
-2348.0
-2192.0
-2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_427.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_427.csv b/integration-testcases/src/test/resources/hiveExpected/TC_427.csv
deleted file mode 100644
index 87db469..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_427.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-contractnumber DoubleType
-5281803.0
-6805600.0
-8231335.0
-8978765.0
-3784858.0
-1602458.0
-9737768.0
-2919786.0
-9455612.0
-88231.0
-1439363.0
-3940720.0
-4451217.0
-335583.0
-1070757.0
-2389657.0
-5986189.0
-8543280.0
-4816260.0
-8453995.0
-2051539.0
-7610075.0
-6663091.0
-6495292.0
-2611464.0
-574375.0
-4459076.0
-5204739.0
-833654.0
-566917.0
-832387.0
-2850246.0
-6169467.0
-6533899.0
-7487134.0
-4750239.0
-8880112.0
-7774590.0
-5586718.0
-5857263.0
-6416074.0
-6994063.0
-8229807.0
-5797079.0
-6283062.0
-8431770.0
-3311312.0
-2843881.0
-1901889.0
-3077303.0
-7880439.0
-3454331.0
-23250.0
-3278167.0
-5659107.0
-9952232.0
-424923.0
-7839922.0
-9500486.0
-1952050.0
-6190068.0
-7768468.0
-7236919.0
-167725.0
-2651084.0
-6283156.0
-7342321.0
-1753823.0
-5451533.0
-5403108.0
-168757.0
-9394732.0
-7420815.0
-4358621.0
-2362114.0
-9318234.0
-5565240.0
-3166724.0
-5592457.0
-7575196.0
-3235086.0
-7917206.0
-4156339.0
-4202614.0
-2199957.0
-511128.0
-580612.0
-275342.0
-3215327.0
-8069859.0
-6383562.0
-6428516.0
-5159121.0
-3360388.0
-5152985.0
-3335480.0
-994815.0
-507229.0
-8976568.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_428.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_428.csv b/integration-testcases/src/test/resources/hiveExpected/TC_428.csv
deleted file mode 100644
index f05eddb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_428.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-gamePointId DoubleType
-2738.562
-1714.635
-1271.0
-692.0
-2175.0
-136.0
-1600.0
-505.0
-1341.0
-2239.0
-2970.0
-2593.0
-2572.0
-1991.0
-1442.0
-1841.0
-298.0
-79.0
-202.0
-568.0
-355.0
-151.0
-2863.0
-1873.0
-2205.0
-441.0
-2194.0
-2972.0
-256.0
-1778.0
-1999.0
-2194.0
-2483.0
-1724.0
-1768.0
-2436.0
-2849.0
-1691.0
-2071.0
-1333.0
-1080.0
-1053.0
-760.0
-2061.0
-2142.0
-2224.0
-1015.0
-1229.0
-1750.0
-1717.0
-2078.0
-2734.0
-2745.0
-571.0
-1697.0
-2553.0
-1077.0
-1823.0
-2399.0
-2890.0
-1608.0
-29.0
-1407.0
-845.0
-1655.0
-1368.0
-1728.0
-750.0
-2288.0
-2635.0
-1337.0
-2478.0
-538.0
-1407.0
-2952.0
-1226.0
-865.0
-901.0
-1864.0
-572.0
-412.0
-1491.0
-1350.0
-1567.0
-1973.0
-448.0
-2488.0
-907.0
-2507.0
-732.0
-2077.0
-1434.0
-1098.0
-813.0
-954.0
-613.0
-2348.0
-2192.0
-2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_429.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_429.csv b/integration-testcases/src/test/resources/hiveExpected/TC_429.csv
deleted file mode 100644
index ad426b1..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_429.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 LongType
-99
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_430.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_430.csv b/integration-testcases/src/test/resources/hiveExpected/TC_430.csv
deleted file mode 100644
index ad426b1..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_430.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 LongType
-99
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_431.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_431.csv b/integration-testcases/src/test/resources/hiveExpected/TC_431.csv
deleted file mode 100644
index 6e9676d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_431.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-channelsName StringType
-guomei
-guomei
-yidong
-shuling
-taobao
-yidong
-yidong
-liantong
-shuling
-shuling
-jingdong
-taobao
-jingdong
-shuling
-taobao
-shuling
-shishang
-yidong
-taobao
-jingdong
-yidong
-shuling
-taobao
-shuling
-shuling
-guomei
-shuling
-shishang
-liantong
-yidong
-shishang
-shuling
-jingdong
-taobao
-liantong
-guomei
-shishang
-shishang
-guomei
-shuling
-taobao
-liantong
-yidong
-yidong
-liantong
-shishang
-yidong
-shuling
-taobao
-guomei
-liantong
-taobao
-shishang
-yidong
-jingdong
-yidong
-guomei
-taobao
-taobao
-yidong
-jingdong
-taobao
-liantong
-liantong
-shuling
-jingdong
-liantong
-shishang
-yidong
-guomei
-liantong
-shishang
-guomei
-yidong
-yidong
-shuling
-liantong
-liantong
-guomei
-liantong
-liantong
-shishang
-shuling
-shuling
-shishang
-liantong
-jingdong
-liantong
-yidong
-liantong
-yidong
-shishang
-yidong
-guomei
-yidong
-jingdong
-liantong
-jingdong
-guomei
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_432.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_432.csv b/integration-testcases/src/test/resources/hiveExpected/TC_432.csv
deleted file mode 100644
index 6cb7e57..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_432.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-channelsId StringType
-4
-4
-6
-3
-1
-6
-6
-7
-3
-3
-2
-1
-2
-3
-1
-3
-5
-6
-1
-2
-6
-3
-1
-3
-3
-4
-3
-5
-7
-6
-5
-3
-2
-1
-7
-4
-5
-5
-4
-3
-1
-7
-6
-6
-7
-5
-6
-3
-1
-4
-7
-1
-5
-6
-2
-6
-4
-1
-1
-6
-2
-1
-7
-7
-3
-2
-7
-5
-6
-4
-7
-5
-4
-6
-6
-3
-7
-7
-4
-7
-7
-5
-3
-3
-5
-7
-2
-7
-6
-7
-6
-5
-6
-4
-6
-2
-7
-2
-4
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_433.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_433.csv b/integration-testcases/src/test/resources/hiveExpected/TC_433.csv
deleted file mode 100644
index 6e9676d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_433.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-channelsName StringType
-guomei
-guomei
-yidong
-shuling
-taobao
-yidong
-yidong
-liantong
-shuling
-shuling
-jingdong
-taobao
-jingdong
-shuling
-taobao
-shuling
-shishang
-yidong
-taobao
-jingdong
-yidong
-shuling
-taobao
-shuling
-shuling
-guomei
-shuling
-shishang
-liantong
-yidong
-shishang
-shuling
-jingdong
-taobao
-liantong
-guomei
-shishang
-shishang
-guomei
-shuling
-taobao
-liantong
-yidong
-yidong
-liantong
-shishang
-yidong
-shuling
-taobao
-guomei
-liantong
-taobao
-shishang
-yidong
-jingdong
-yidong
-guomei
-taobao
-taobao
-yidong
-jingdong
-taobao
-liantong
-liantong
-shuling
-jingdong
-liantong
-shishang
-yidong
-guomei
-liantong
-shishang
-guomei
-yidong
-yidong
-shuling
-liantong
-liantong
-guomei
-liantong
-liantong
-shishang
-shuling
-shuling
-shishang
-liantong
-jingdong
-liantong
-yidong
-liantong
-yidong
-shishang
-yidong
-guomei
-yidong
-jingdong
-liantong
-jingdong
-guomei
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_434.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_434.csv b/integration-testcases/src/test/resources/hiveExpected/TC_434.csv
deleted file mode 100644
index 6cb7e57..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_434.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-channelsId StringType
-4
-4
-6
-3
-1
-6
-6
-7
-3
-3
-2
-1
-2
-3
-1
-3
-5
-6
-1
-2
-6
-3
-1
-3
-3
-4
-3
-5
-7
-6
-5
-3
-2
-1
-7
-4
-5
-5
-4
-3
-1
-7
-6
-6
-7
-5
-6
-3
-1
-4
-7
-1
-5
-6
-2
-6
-4
-1
-1
-6
-2
-1
-7
-7
-3
-2
-7
-5
-6
-4
-7
-5
-4
-6
-6
-3
-7
-7
-4
-7
-7
-5
-3
-3
-5
-7
-2
-7
-6
-7
-6
-5
-6
-4
-6
-2
-7
-2
-4
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_435.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_435.csv b/integration-testcases/src/test/resources/hiveExpected/TC_435.csv
deleted file mode 100644
index 6e9676d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_435.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-channelsName StringType
-guomei
-guomei
-yidong
-shuling
-taobao
-yidong
-yidong
-liantong
-shuling
-shuling
-jingdong
-taobao
-jingdong
-shuling
-taobao
-shuling
-shishang
-yidong
-taobao
-jingdong
-yidong
-shuling
-taobao
-shuling
-shuling
-guomei
-shuling
-shishang
-liantong
-yidong
-shishang
-shuling
-jingdong
-taobao
-liantong
-guomei
-shishang
-shishang
-guomei
-shuling
-taobao
-liantong
-yidong
-yidong
-liantong
-shishang
-yidong
-shuling
-taobao
-guomei
-liantong
-taobao
-shishang
-yidong
-jingdong
-yidong
-guomei
-taobao
-taobao
-yidong
-jingdong
-taobao
-liantong
-liantong
-shuling
-jingdong
-liantong
-shishang
-yidong
-guomei
-liantong
-shishang
-guomei
-yidong
-yidong
-shuling
-liantong
-liantong
-guomei
-liantong
-liantong
-shishang
-shuling
-shuling
-shishang
-liantong
-jingdong
-liantong
-yidong
-liantong
-yidong
-shishang
-yidong
-guomei
-yidong
-jingdong
-liantong
-jingdong
-guomei
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_436.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_436.csv b/integration-testcases/src/test/resources/hiveExpected/TC_436.csv
deleted file mode 100644
index d6543bc..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_436.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 LongType
-97
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_437.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_437.csv b/integration-testcases/src/test/resources/hiveExpected/TC_437.csv
deleted file mode 100644
index 5bfaf14..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_437.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 LongType
-9594717
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_438.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_438.csv b/integration-testcases/src/test/resources/hiveExpected/TC_438.csv
deleted file mode 100644
index c2933b4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_438.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-4799897.878787879
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_439.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_439.csv b/integration-testcases/src/test/resources/hiveExpected/TC_439.csv
deleted file mode 100644
index 19d34f6..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_439.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 StringType
-0RAM size
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_440.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_440.csv b/integration-testcases/src/test/resources/hiveExpected/TC_440.csv
deleted file mode 100644
index f12fb97..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_440.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-2972.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_441.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_441.csv b/integration-testcases/src/test/resources/hiveExpected/TC_441.csv
deleted file mode 100644
index 875e6d1..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_441.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType,_c1 DoubleType
-622630.4599570761,622630.4599570761
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_442.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_442.csv b/integration-testcases/src/test/resources/hiveExpected/TC_442.csv
deleted file mode 100644
index 4d36a04..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_442.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType,_c1 DoubleType
-1.477644655616972E10,null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_443.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_443.csv b/integration-testcases/src/test/resources/hiveExpected/TC_443.csv
deleted file mode 100644
index 908a007..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_443.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType,_c1 DoubleType
-8.508651970169495E12,8.508651970169495E12
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_444.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_444.csv b/integration-testcases/src/test/resources/hiveExpected/TC_444.csv
deleted file mode 100644
index 9933746..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_444.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType,_c1 DoubleType
-null,2.148423005565863
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_445.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_445.csv b/integration-testcases/src/test/resources/hiveExpected/TC_445.csv
deleted file mode 100644
index 81255c5..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_445.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType,_c1 DoubleType
-1.4776446556169722E10,663683.3954750763
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_446.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_446.csv b/integration-testcases/src/test/resources/hiveExpected/TC_446.csv
deleted file mode 100644
index 7e3738f..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_446.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType,_c1 DoubleType
-1.477644655616972E10,1.477644655616972E10
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_447.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_447.csv b/integration-testcases/src/test/resources/hiveExpected/TC_447.csv
deleted file mode 100644
index a2ed924..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_447.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-8.247507095799066E12
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_448.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_448.csv b/integration-testcases/src/test/resources/hiveExpected/TC_448.csv
deleted file mode 100644
index d83b71d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_448.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-0.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_449.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_449.csv b/integration-testcases/src/test/resources/hiveExpected/TC_449.csv
deleted file mode 100644
index 784c96b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_449.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_450.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_450.csv b/integration-testcases/src/test/resources/hiveExpected/TC_450.csv
deleted file mode 100644
index 527bd36..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_450.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-661469.3525424678
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_451.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_451.csv b/integration-testcases/src/test/resources/hiveExpected/TC_451.csv
deleted file mode 100644
index edb6db2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_451.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-96490.49465950707
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_452.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_452.csv b/integration-testcases/src/test/resources/hiveExpected/TC_452.csv
deleted file mode 100644
index edb6db2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_452.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-96490.49465950707
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_453.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_453.csv b/integration-testcases/src/test/resources/hiveExpected/TC_453.csv
deleted file mode 100644
index 83fa102..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_453.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-809.1896217395077
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_454.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_454.csv b/integration-testcases/src/test/resources/hiveExpected/TC_454.csv
deleted file mode 100644
index 784c96b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_454.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_455.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_455.csv b/integration-testcases/src/test/resources/hiveExpected/TC_455.csv
deleted file mode 100644
index efd67b7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_455.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-2857306.2389803873
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_456.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_456.csv b/integration-testcases/src/test/resources/hiveExpected/TC_456.csv
deleted file mode 100644
index ae824ca..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_456.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-2871847.3315618755
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_457.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_457.csv b/integration-testcases/src/test/resources/hiveExpected/TC_457.csv
deleted file mode 100644
index 47abce6..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_457.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-96981.54360516652
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_458.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_458.csv b/integration-testcases/src/test/resources/hiveExpected/TC_458.csv
deleted file mode 100644
index 784c96b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_458.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_459.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_459.csv b/integration-testcases/src/test/resources/hiveExpected/TC_459.csv
deleted file mode 100644
index d83b71d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_459.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-0.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_460.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_460.csv b/integration-testcases/src/test/resources/hiveExpected/TC_460.csv
deleted file mode 100644
index ae824ca..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_460.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-2871847.3315618755
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_461.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_461.csv b/integration-testcases/src/test/resources/hiveExpected/TC_461.csv
deleted file mode 100644
index d83b71d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_461.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-0.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_462.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_462.csv b/integration-testcases/src/test/resources/hiveExpected/TC_462.csv
deleted file mode 100644
index 0562e16..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_462.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
--1.3381444931641521E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_463.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_463.csv b/integration-testcases/src/test/resources/hiveExpected/TC_463.csv
deleted file mode 100644
index d83b71d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_463.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-0.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_464.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_464.csv b/integration-testcases/src/test/resources/hiveExpected/TC_464.csv
deleted file mode 100644
index 4253155..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_464.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
--1057699.581875421
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_465.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_465.csv b/integration-testcases/src/test/resources/hiveExpected/TC_465.csv
deleted file mode 100644
index d83b71d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_465.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-0.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_466.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_466.csv b/integration-testcases/src/test/resources/hiveExpected/TC_466.csv
deleted file mode 100644
index 51b910f..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_466.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
--1.3517990288086843E7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_467.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_467.csv b/integration-testcases/src/test/resources/hiveExpected/TC_467.csv
deleted file mode 100644
index d83b71d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_467.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-0.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_468.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_468.csv b/integration-testcases/src/test/resources/hiveExpected/TC_468.csv
deleted file mode 100644
index d83b71d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_468.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-0.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_469.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_469.csv b/integration-testcases/src/test/resources/hiveExpected/TC_469.csv
deleted file mode 100644
index 29cae25..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_469.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
--1068492.4347517013
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_470.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_470.csv b/integration-testcases/src/test/resources/hiveExpected/TC_470.csv
deleted file mode 100644
index 57253b9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_470.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
--0.013546512302823152
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_471.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_471.csv b/integration-testcases/src/test/resources/hiveExpected/TC_471.csv
deleted file mode 100644
index a5caf8f..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_471.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-NaN
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_472.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_472.csv b/integration-testcases/src/test/resources/hiveExpected/TC_472.csv
deleted file mode 100644
index 7a9e5ef..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_472.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-1.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_473.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_473.csv b/integration-testcases/src/test/resources/hiveExpected/TC_473.csv
deleted file mode 100644
index 7a9e5ef..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_473.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-1.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_474.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_474.csv b/integration-testcases/src/test/resources/hiveExpected/TC_474.csv
deleted file mode 100644
index bc3b03c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_474.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-a IntegerType
-null
-null
-null
-null
-null
-null
-null
-null
-null
-null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_475.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_475.csv b/integration-testcases/src/test/resources/hiveExpected/TC_475.csv
deleted file mode 100644
index 8ba446e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_475.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-a IntegerType
-109
-93
-2591
-2531
-2408
-1815
-2479
-1845
-2008
-1121
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_476.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_476.csv b/integration-testcases/src/test/resources/hiveExpected/TC_476.csv
deleted file mode 100644
index 7a9e5ef..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_476.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-1.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_477.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_477.csv b/integration-testcases/src/test/resources/hiveExpected/TC_477.csv
deleted file mode 100644
index b0fd7ae..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_477.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 ArrayType(DoubleType,true)
-WrappedArray(1.0)
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_478.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_478.csv b/integration-testcases/src/test/resources/hiveExpected/TC_478.csv
deleted file mode 100644
index ebad59d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_478.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-a IntegerType
-2738
-1714
-1271
-692
-2175
-136
-1600
-505
-1341
-2239
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_479.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_479.csv b/integration-testcases/src/test/resources/hiveExpected/TC_479.csv
deleted file mode 100644
index b0fd7ae..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_479.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 ArrayType(DoubleType,true)
-WrappedArray(1.0)
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_480.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_480.csv b/integration-testcases/src/test/resources/hiveExpected/TC_480.csv
deleted file mode 100644
index b0fd7ae..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_480.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 ArrayType(DoubleType,true)
-WrappedArray(1.0)
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_481.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_481.csv b/integration-testcases/src/test/resources/hiveExpected/TC_481.csv
deleted file mode 100644
index 7a9e5ef..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_481.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-1.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_482.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_482.csv b/integration-testcases/src/test/resources/hiveExpected/TC_482.csv
deleted file mode 100644
index 7a9e5ef..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_482.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-_c0 DoubleType
-1.0