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:13 UTC
[35/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_330.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_330.csv b/integration-testcases/src/test/resources/hiveExpected/TC_330.csv
deleted file mode 100644
index e65a3e9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_330.csv
+++ /dev/null
@@ -1,46 +0,0 @@
-deliveryCity StringType,channelsId StringType,Sum_deviceInformationId LongType
-changsha,1,100008
-changsha,2,200030
-changsha,3,300025
-changsha,5,110037
-changsha,6,300095
-changsha,7,200107
-guangzhou,1,310084
-guangzhou,2,100044
-guangzhou,3,200093
-guangzhou,4,310192
-guangzhou,5,110077
-guangzhou,6,300126
-guangzhou,7,200119
-shenzhen,1,200080
-shenzhen,2,200135
-shenzhen,3,100038
-shenzhen,4,10008
-shenzhen,5,100042
-shenzhen,6,200155
-shenzhen,7,300111
-wuhan,3,101053
-wuhan,5,110058
-wuhan,6,200033
-wuhan,7,300217
-xiangtan,1,100015
-xiangtan,2,110017
-xiangtan,3,110024
-xiangtan,4,110063
-xiangtan,5,200098
-xiangtan,6,300261
-xiangtan,7,300148
-yichang,1,300086
-yichang,2,100004
-yichang,3,200072
-yichang,4,100029
-yichang,5,100078
-yichang,6,1200139
-yichang,7,300121
-zhuzhou,1,100047
-zhuzhou,2,200156
-zhuzhou,3,400066
-zhuzhou,4,200093
-zhuzhou,5,200050
-zhuzhou,6,200067
-zhuzhou,7,200116

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_331.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_331.csv b/integration-testcases/src/test/resources/hiveExpected/TC_331.csv
deleted file mode 100644
index 05dda46..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_331.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-series StringType,imei StringType,deliveryCity StringType,Sum_Latest_DAY LongType,Sum_Latest_MONTH LongType,Sum_Latest_YEAR LongType,Sum_contractNumber DoubleType,Sum_deviceInformationId LongType,Avg_gamePointId DoubleType,Sum_gamepointid DoubleType
-0Series,1AA100001,xiangtan,1,7,2015,2919786.0,100001,505.0,505.0
-0Series,1AA100002,changsha,1,7,2015,9455612.0,100002,1341.0,1341.0
-0Series,1AA100009,yichang,1,7,2015,2389657.0,100009,1841.0,1841.0
-0Series,1AA100011,guangzhou,1,7,2015,4816260.0,100011,202.0,202.0
-0Series,1AA10002,wuhan,1,7,2015,5204739.0,10002,2972.0,2972.0
-0Series,1AA100021,changsha,1,7,2015,566917.0,100021,1778.0,1778.0
-0Series,1AA100025,guangzhou,1,7,2015,6533899.0,100025,1724.0,1724.0
-0Series,1AA100027,zhuzhou,1,7,2015,4750239.0,100027,2436.0,2436.0
-0Series,1AA100049,guangzhou,1,7,2015,1952050.0,100049,2890.0,2890.0
-0Series,1AA100065,xiangtan,1,7,2015,3166724.0,100065,901.0,901.0
-0Series,1AA100070,guangzhou,1,7,2015,4202614.0,100070,1567.0,1567.0
-0Series,1AA100071,guangzhou,1,7,2015,2199957.0,100071,1973.0,1973.0
-0Series,1AA100076,wuhan,1,7,2015,8069859.0,100076,732.0,732.0
-0Series,1AA100083,zhuzhou,1,7,2015,507229.0,100083,2192.0,2192.0
-0Series,1AA100084,guangzhou,1,7,2015,8976568.0,100084,2826.0,2826.0
-1Series,1AA100005,yichang,1,7,2015,3940720.0,100005,2593.0,2593.0
-1Series,1AA100013,changsha,1,7,2015,2051539.0,100013,355.0,355.0
-1Series,1AA100032,shenzhen,1,7,2015,6994063.0,100032,1053.0,1053.0
-2Series,1AA10001,changsha,1,7,2015,5986189.0,10001,298.0,298.0
-2Series,1AA100029,xiangtan,1,7,2015,7774590.0,100029,1691.0,1691.0
-2Series,1AA100034,guangzhou,1,7,2015,5797079.0,100034,2061.0,2061.0
-2Series,1AA100045,xiangtan,1,7,2015,9952232.0,100045,2553.0,2553.0
-2Series,1AA100050,yichang,1,7,2015,7768468.0,100050,29.0,29.0
-2Series,1AA100051,guangzhou,1,7,2015,7236919.0,100051,1407.0,1407.0
-2Series,1AA100053,wuhan,1,7,2015,2651084.0,100053,1655.0,1655.0
-2Series,1AA100063,yichang,1,7,2015,9318234.0,100063,1226.0,1226.0
-2Series,1AA100078,yichang,1,7,2015,6428516.0,100078,1434.0,1434.0
-3Series,1AA100010,zhuzhou,1,7,2015,8543280.0,100010,79.0,79.0
-3Series,1AA100016,changsha,1,7,2015,6495292.0,100016,1873.0,1873.0
-3Series,1AA100042,shenzhen,1,7,2015,23250.0,100042,2745.0,2745.0
-3Series,1AA100046,guangzhou,1,7,2015,424923.0,100046,1077.0,1077.0
-3Series,1AA100048,guangzhou,1,7,2015,9500486.0,100048,2399.0,2399.0
-3Series,1AA10006,guangzhou,1,7,2015,9394732.0,10006,2478.0,2478.0
-3Series,1AA100075,shenzhen,1,7,2015,3215327.0,100075,2507.0,2507.0
-3Series,1AA100077,yichang,1,7,2015,6383562.0,100077,2077.0,2077.0
-4Series,1AA100004,yichang,1,7,2015,1439363.0,100004,2970.0,2970.0
-4Series,1AA100012,xiangtan,1,7,2015,8453995.0,100012,568.0,568.0
-4Series,1AA100015,xiangtan,1,7,2015,6663091.0,100015,2863.0,2863.0
-4Series,1AA100059,shenzhen,1,7,2015,168757.0,100059,1337.0,1337.0
-4Series,1AA100067,wuhan,1,7,2015,7575196.0,100067,572.0,572.0
-4Series,1AA100072,changsha,1,7,2015,511128.0,100072,448.0,448.0
-4Series,1AA100073,zhuzhou,1,7,2015,580612.0,100073,2488.0,2488.0
-4Series,1AA100079,xiangtan,1,7,2015,5159121.0,100079,1098.0,1098.0
-5Series,1AA100,xiangtan,1,7,2015,8231335.0,100,1271.0,1271.0
-5Series,1AA1000,wuhan,1,7,2015,8978765.0,1000,692.0,692.0
-5Series,1AA100003,zhuzhou,1,7,2015,88231.0,100003,2239.0,2239.0
-5Series,1AA100014,zhuzhou,1,7,2015,7610075.0,100014,151.0,151.0
-5Series,1AA100019,zhuzhou,1,7,2015,4459076.0,100019,2194.0,2194.0
-5Series,1AA100020,shenzhen,1,7,2015,833654.0,100020,256.0,256.0
-5Series,1AA100022,zhuzhou,1,7,2015,832387.0,100022,1999.0,1999.0
-5Series,1AA100023,guangzhou,1,7,2015,2850246.0,100023,2194.0,2194.0
-5Series,1AA100028,zhuzhou,1,7,2015,8880112.0,100028,2849.0,2849.0
-5Series,1AA100035,changsha,1,7,2015,6283062.0,100035,2142.0,2142.0
-5Series,1AA100036,changsha,1,7,2015,8431770.0,100036,2224.0,2224.0
-5Series,1AA10004,guangzhou,1,7,2015,3077303.0,10004,1717.0,1717.0
-5Series,1AA100041,shenzhen,1,7,2015,3454331.0,100041,2734.0,2734.0
-5Series,1AA100058,guangzhou,1,7,2015,5403108.0,100058,2635.0,2635.0
-5Series,1AA10008,shenzhen,1,7,2015,3360388.0,10008,813.0,813.0
-5Series,1AA100081,shenzhen,1,7,2015,3335480.0,100081,613.0,613.0
-5Series,1AA100082,xiangtan,1,7,2015,994815.0,100082,2348.0,2348.0
-6Series,1AA100006,changsha,1,7,2015,4451217.0,100006,2572.0,2572.0
-6Series,1AA100024,changsha,1,7,2015,6169467.0,100024,2483.0,2483.0
-6Series,1AA100038,shenzhen,1,7,2015,2843881.0,100038,1229.0,1229.0
-6Series,1AA100052,zhuzhou,1,7,2015,167725.0,100052,845.0,845.0
-6Series,1AA100056,wuhan,1,7,2015,1753823.0,100056,750.0,750.0
-6Series,1AA100061,changsha,1,7,2015,4358621.0,100061,1407.0,1407.0
-6Series,1AA100064,zhuzhou,1,7,2015,5565240.0,100064,865.0,865.0
-6Series,1AA100066,zhuzhou,1,7,2015,5592457.0,100066,1864.0,1864.0
-6Series,1AA100074,wuhan,1,7,2015,275342.0,100074,907.0,907.0
-7Series,1AA1,yichang,1,7,2015,5281803.0,1,2738.562,2738.562
-7Series,1AA10,yichang,1,7,2015,6805600.0,10,1714.635,1714.635
-7Series,1AA10000,guangzhou,1,7,2015,3784858.0,10000,2175.0,2175.0
-7Series,1AA1000000,yichang,1,7,2015,9737768.0,1000000,1600.0,1600.0
-7Series,1AA100026,yichang,1,7,2015,7487134.0,100026,1768.0,1768.0
-7Series,1AA10003,xiangtan,1,7,2015,5586718.0,10003,2071.0,2071.0
-7Series,1AA100030,zhuzhou,1,7,2015,5857263.0,100030,1333.0,1333.0
-7Series,1AA100031,yichang,1,7,2015,6416074.0,100031,1080.0,1080.0
-7Series,1AA100037,xiangtan,1,7,2015,3311312.0,100037,1015.0,1015.0
-7Series,1AA100054,shenzhen,1,7,2015,6283156.0,100054,1368.0,1368.0
-7Series,1AA100055,yichang,1,7,2015,7342321.0,100055,1728.0,1728.0
-8Series,1AA100008,changsha,1,7,2015,1070757.0,100008,1442.0,1442.0
-8Series,1AA100018,yichang,1,7,2015,574375.0,100018,441.0,441.0
-8Series,1AA100033,wuhan,1,7,2015,8229807.0,100033,760.0,760.0
-8Series,1AA100039,shenzhen,1,7,2015,1901889.0,100039,1750.0,1750.0
-8Series,1AA100040,yichang,1,7,2015,7880439.0,100040,2078.0,2078.0
-8Series,1AA100044,guangzhou,1,7,2015,5659107.0,100044,1697.0,1697.0
-8Series,1AA10005,xiangtan,1,7,2015,6190068.0,10005,1608.0,1608.0
-8Series,1AA100060,xiangtan,1,7,2015,7420815.0,100060,538.0,538.0
-8Series,1AA100068,guangzhou,1,7,2015,3235086.0,100068,412.0,412.0
-8Series,1AA100069,xiangtan,1,7,2015,7917206.0,100069,1491.0,1491.0
-8Series,1AA10007,xiangtan,1,7,2015,4156339.0,10007,1350.0,1350.0
-9Series,1AA100000,wuhan,1,7,2015,1602458.0,100000,136.0,136.0
-9Series,1AA100007,changsha,1,7,2015,335583.0,100007,1991.0,1991.0
-9Series,1AA100017,xiangtan,1,7,2015,2611464.0,100017,2205.0,2205.0
-9Series,1AA100043,guangzhou,1,7,2015,3278167.0,100043,571.0,571.0
-9Series,1AA100047,zhuzhou,1,7,2015,7839922.0,100047,1823.0,1823.0
-9Series,1AA100057,zhuzhou,1,7,2015,5451533.0,100057,2288.0,2288.0
-9Series,1AA100062,yichang,1,7,2015,2362114.0,100062,2952.0,2952.0
-9Series,1AA100080,shenzhen,1,7,2015,5152985.0,100080,954.0,954.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_332.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_332.csv b/integration-testcases/src/test/resources/hiveExpected/TC_332.csv
deleted file mode 100644
index 5f940ad..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_332.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,Sum_Latest_DAY LongType,Sum_Latest_MONTH LongType,Sum_contractNumber DoubleType,Sum_deviceInformationId LongType,Sum_gamePointId DoubleType,Sum_gamepointid DoubleType,Count_series LongType
-1AA1,yichang,1,7,5281803.0,1,2738.562,2738.562,1
-1AA10,yichang,1,7,6805600.0,10,1714.635,1714.635,1
-1AA100,xiangtan,1,7,8231335.0,100,1271.0,1271.0,1
-1AA1000,wuhan,1,7,8978765.0,1000,692.0,692.0,1
-1AA10000,guangzhou,1,7,3784858.0,10000,2175.0,2175.0,1
-1AA100000,wuhan,1,7,1602458.0,100000,136.0,136.0,1
-1AA1000000,yichang,1,7,9737768.0,1000000,1600.0,1600.0,1
-1AA100001,xiangtan,1,7,2919786.0,100001,505.0,505.0,1
-1AA100002,changsha,1,7,9455612.0,100002,1341.0,1341.0,1
-1AA100003,zhuzhou,1,7,88231.0,100003,2239.0,2239.0,1
-1AA100004,yichang,1,7,1439363.0,100004,2970.0,2970.0,1
-1AA100005,yichang,1,7,3940720.0,100005,2593.0,2593.0,1
-1AA100006,changsha,1,7,4451217.0,100006,2572.0,2572.0,1
-1AA100007,changsha,1,7,335583.0,100007,1991.0,1991.0,1
-1AA100008,changsha,1,7,1070757.0,100008,1442.0,1442.0,1
-1AA100009,yichang,1,7,2389657.0,100009,1841.0,1841.0,1
-1AA10001,changsha,1,7,5986189.0,10001,298.0,298.0,1
-1AA100010,zhuzhou,1,7,8543280.0,100010,79.0,79.0,1
-1AA100011,guangzhou,1,7,4816260.0,100011,202.0,202.0,1
-1AA100012,xiangtan,1,7,8453995.0,100012,568.0,568.0,1
-1AA100013,changsha,1,7,2051539.0,100013,355.0,355.0,1
-1AA100014,zhuzhou,1,7,7610075.0,100014,151.0,151.0,1
-1AA100015,xiangtan,1,7,6663091.0,100015,2863.0,2863.0,1
-1AA100016,changsha,1,7,6495292.0,100016,1873.0,1873.0,1
-1AA100017,xiangtan,1,7,2611464.0,100017,2205.0,2205.0,1
-1AA100018,yichang,1,7,574375.0,100018,441.0,441.0,1
-1AA100019,zhuzhou,1,7,4459076.0,100019,2194.0,2194.0,1
-1AA10002,wuhan,1,7,5204739.0,10002,2972.0,2972.0,1
-1AA100020,shenzhen,1,7,833654.0,100020,256.0,256.0,1
-1AA100021,changsha,1,7,566917.0,100021,1778.0,1778.0,1
-1AA100022,zhuzhou,1,7,832387.0,100022,1999.0,1999.0,1
-1AA100023,guangzhou,1,7,2850246.0,100023,2194.0,2194.0,1
-1AA100024,changsha,1,7,6169467.0,100024,2483.0,2483.0,1
-1AA100025,guangzhou,1,7,6533899.0,100025,1724.0,1724.0,1
-1AA100026,yichang,1,7,7487134.0,100026,1768.0,1768.0,1
-1AA100027,zhuzhou,1,7,4750239.0,100027,2436.0,2436.0,1
-1AA100028,zhuzhou,1,7,8880112.0,100028,2849.0,2849.0,1
-1AA100029,xiangtan,1,7,7774590.0,100029,1691.0,1691.0,1
-1AA10003,xiangtan,1,7,5586718.0,10003,2071.0,2071.0,1
-1AA100030,zhuzhou,1,7,5857263.0,100030,1333.0,1333.0,1
-1AA100031,yichang,1,7,6416074.0,100031,1080.0,1080.0,1
-1AA100032,shenzhen,1,7,6994063.0,100032,1053.0,1053.0,1
-1AA100033,wuhan,1,7,8229807.0,100033,760.0,760.0,1
-1AA100034,guangzhou,1,7,5797079.0,100034,2061.0,2061.0,1
-1AA100035,changsha,1,7,6283062.0,100035,2142.0,2142.0,1
-1AA100036,changsha,1,7,8431770.0,100036,2224.0,2224.0,1
-1AA100037,xiangtan,1,7,3311312.0,100037,1015.0,1015.0,1
-1AA100038,shenzhen,1,7,2843881.0,100038,1229.0,1229.0,1
-1AA100039,shenzhen,1,7,1901889.0,100039,1750.0,1750.0,1
-1AA10004,guangzhou,1,7,3077303.0,10004,1717.0,1717.0,1
-1AA100040,yichang,1,7,7880439.0,100040,2078.0,2078.0,1
-1AA100041,shenzhen,1,7,3454331.0,100041,2734.0,2734.0,1
-1AA100042,shenzhen,1,7,23250.0,100042,2745.0,2745.0,1
-1AA100043,guangzhou,1,7,3278167.0,100043,571.0,571.0,1
-1AA100044,guangzhou,1,7,5659107.0,100044,1697.0,1697.0,1
-1AA100045,xiangtan,1,7,9952232.0,100045,2553.0,2553.0,1
-1AA100046,guangzhou,1,7,424923.0,100046,1077.0,1077.0,1
-1AA100047,zhuzhou,1,7,7839922.0,100047,1823.0,1823.0,1
-1AA100048,guangzhou,1,7,9500486.0,100048,2399.0,2399.0,1
-1AA100049,guangzhou,1,7,1952050.0,100049,2890.0,2890.0,1
-1AA10005,xiangtan,1,7,6190068.0,10005,1608.0,1608.0,1
-1AA100050,yichang,1,7,7768468.0,100050,29.0,29.0,1
-1AA100051,guangzhou,1,7,7236919.0,100051,1407.0,1407.0,1
-1AA100052,zhuzhou,1,7,167725.0,100052,845.0,845.0,1
-1AA100053,wuhan,1,7,2651084.0,100053,1655.0,1655.0,1
-1AA100054,shenzhen,1,7,6283156.0,100054,1368.0,1368.0,1
-1AA100055,yichang,1,7,7342321.0,100055,1728.0,1728.0,1
-1AA100056,wuhan,1,7,1753823.0,100056,750.0,750.0,1
-1AA100057,zhuzhou,1,7,5451533.0,100057,2288.0,2288.0,1
-1AA100058,guangzhou,1,7,5403108.0,100058,2635.0,2635.0,1
-1AA100059,shenzhen,1,7,168757.0,100059,1337.0,1337.0,1
-1AA10006,guangzhou,1,7,9394732.0,10006,2478.0,2478.0,1
-1AA100060,xiangtan,1,7,7420815.0,100060,538.0,538.0,1
-1AA100061,changsha,1,7,4358621.0,100061,1407.0,1407.0,1
-1AA100062,yichang,1,7,2362114.0,100062,2952.0,2952.0,1
-1AA100063,yichang,1,7,9318234.0,100063,1226.0,1226.0,1
-1AA100064,zhuzhou,1,7,5565240.0,100064,865.0,865.0,1
-1AA100065,xiangtan,1,7,3166724.0,100065,901.0,901.0,1
-1AA100066,zhuzhou,1,7,5592457.0,100066,1864.0,1864.0,1
-1AA100067,wuhan,1,7,7575196.0,100067,572.0,572.0,1
-1AA100068,guangzhou,1,7,3235086.0,100068,412.0,412.0,1
-1AA100069,xiangtan,1,7,7917206.0,100069,1491.0,1491.0,1
-1AA10007,xiangtan,1,7,4156339.0,10007,1350.0,1350.0,1
-1AA100070,guangzhou,1,7,4202614.0,100070,1567.0,1567.0,1
-1AA100071,guangzhou,1,7,2199957.0,100071,1973.0,1973.0,1
-1AA100072,changsha,1,7,511128.0,100072,448.0,448.0,1
-1AA100073,zhuzhou,1,7,580612.0,100073,2488.0,2488.0,1
-1AA100074,wuhan,1,7,275342.0,100074,907.0,907.0,1
-1AA100075,shenzhen,1,7,3215327.0,100075,2507.0,2507.0,1
-1AA100076,wuhan,1,7,8069859.0,100076,732.0,732.0,1
-1AA100077,yichang,1,7,6383562.0,100077,2077.0,2077.0,1
-1AA100078,yichang,1,7,6428516.0,100078,1434.0,1434.0,1
-1AA100079,xiangtan,1,7,5159121.0,100079,1098.0,1098.0,1
-1AA10008,shenzhen,1,7,3360388.0,10008,813.0,813.0,1
-1AA100080,shenzhen,1,7,5152985.0,100080,954.0,954.0,1
-1AA100081,shenzhen,1,7,3335480.0,100081,613.0,613.0,1
-1AA100082,xiangtan,1,7,994815.0,100082,2348.0,2348.0,1
-1AA100083,zhuzhou,1,7,507229.0,100083,2192.0,2192.0,1
-1AA100084,guangzhou,1,7,8976568.0,100084,2826.0,2826.0,1

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_333.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_333.csv b/integration-testcases/src/test/resources/hiveExpected/TC_333.csv
deleted file mode 100644
index 7edf948..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_333.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,deliveryCity StringType,Sum_Latest_DAY LongType,Sum_Latest_MONTH LongType,Sum_contractNumber DoubleType,Sum_deviceInformationId LongType,Sum_gamePointId DoubleType,Sum_gamepointid DoubleType,DistinctCount_series LongType
-1AA1,yichang,1,7,5281803.0,1,2738.562,2738.562,1
-1AA10,yichang,1,7,6805600.0,10,1714.635,1714.635,1
-1AA100,xiangtan,1,7,8231335.0,100,1271.0,1271.0,1
-1AA1000,wuhan,1,7,8978765.0,1000,692.0,692.0,1
-1AA10000,guangzhou,1,7,3784858.0,10000,2175.0,2175.0,1
-1AA100000,wuhan,1,7,1602458.0,100000,136.0,136.0,1
-1AA1000000,yichang,1,7,9737768.0,1000000,1600.0,1600.0,1
-1AA100001,xiangtan,1,7,2919786.0,100001,505.0,505.0,1
-1AA100002,changsha,1,7,9455612.0,100002,1341.0,1341.0,1
-1AA100003,zhuzhou,1,7,88231.0,100003,2239.0,2239.0,1
-1AA100004,yichang,1,7,1439363.0,100004,2970.0,2970.0,1
-1AA100005,yichang,1,7,3940720.0,100005,2593.0,2593.0,1
-1AA100006,changsha,1,7,4451217.0,100006,2572.0,2572.0,1
-1AA100007,changsha,1,7,335583.0,100007,1991.0,1991.0,1
-1AA100008,changsha,1,7,1070757.0,100008,1442.0,1442.0,1
-1AA100009,yichang,1,7,2389657.0,100009,1841.0,1841.0,1
-1AA10001,changsha,1,7,5986189.0,10001,298.0,298.0,1
-1AA100010,zhuzhou,1,7,8543280.0,100010,79.0,79.0,1
-1AA100011,guangzhou,1,7,4816260.0,100011,202.0,202.0,1
-1AA100012,xiangtan,1,7,8453995.0,100012,568.0,568.0,1
-1AA100013,changsha,1,7,2051539.0,100013,355.0,355.0,1
-1AA100014,zhuzhou,1,7,7610075.0,100014,151.0,151.0,1
-1AA100015,xiangtan,1,7,6663091.0,100015,2863.0,2863.0,1
-1AA100016,changsha,1,7,6495292.0,100016,1873.0,1873.0,1
-1AA100017,xiangtan,1,7,2611464.0,100017,2205.0,2205.0,1
-1AA100018,yichang,1,7,574375.0,100018,441.0,441.0,1
-1AA100019,zhuzhou,1,7,4459076.0,100019,2194.0,2194.0,1
-1AA10002,wuhan,1,7,5204739.0,10002,2972.0,2972.0,1
-1AA100020,shenzhen,1,7,833654.0,100020,256.0,256.0,1
-1AA100021,changsha,1,7,566917.0,100021,1778.0,1778.0,1
-1AA100022,zhuzhou,1,7,832387.0,100022,1999.0,1999.0,1
-1AA100023,guangzhou,1,7,2850246.0,100023,2194.0,2194.0,1
-1AA100024,changsha,1,7,6169467.0,100024,2483.0,2483.0,1
-1AA100025,guangzhou,1,7,6533899.0,100025,1724.0,1724.0,1
-1AA100026,yichang,1,7,7487134.0,100026,1768.0,1768.0,1
-1AA100027,zhuzhou,1,7,4750239.0,100027,2436.0,2436.0,1
-1AA100028,zhuzhou,1,7,8880112.0,100028,2849.0,2849.0,1
-1AA100029,xiangtan,1,7,7774590.0,100029,1691.0,1691.0,1
-1AA10003,xiangtan,1,7,5586718.0,10003,2071.0,2071.0,1
-1AA100030,zhuzhou,1,7,5857263.0,100030,1333.0,1333.0,1
-1AA100031,yichang,1,7,6416074.0,100031,1080.0,1080.0,1
-1AA100032,shenzhen,1,7,6994063.0,100032,1053.0,1053.0,1
-1AA100033,wuhan,1,7,8229807.0,100033,760.0,760.0,1
-1AA100034,guangzhou,1,7,5797079.0,100034,2061.0,2061.0,1
-1AA100035,changsha,1,7,6283062.0,100035,2142.0,2142.0,1
-1AA100036,changsha,1,7,8431770.0,100036,2224.0,2224.0,1
-1AA100037,xiangtan,1,7,3311312.0,100037,1015.0,1015.0,1
-1AA100038,shenzhen,1,7,2843881.0,100038,1229.0,1229.0,1
-1AA100039,shenzhen,1,7,1901889.0,100039,1750.0,1750.0,1
-1AA10004,guangzhou,1,7,3077303.0,10004,1717.0,1717.0,1
-1AA100040,yichang,1,7,7880439.0,100040,2078.0,2078.0,1
-1AA100041,shenzhen,1,7,3454331.0,100041,2734.0,2734.0,1
-1AA100042,shenzhen,1,7,23250.0,100042,2745.0,2745.0,1
-1AA100043,guangzhou,1,7,3278167.0,100043,571.0,571.0,1
-1AA100044,guangzhou,1,7,5659107.0,100044,1697.0,1697.0,1
-1AA100045,xiangtan,1,7,9952232.0,100045,2553.0,2553.0,1
-1AA100046,guangzhou,1,7,424923.0,100046,1077.0,1077.0,1
-1AA100047,zhuzhou,1,7,7839922.0,100047,1823.0,1823.0,1
-1AA100048,guangzhou,1,7,9500486.0,100048,2399.0,2399.0,1
-1AA100049,guangzhou,1,7,1952050.0,100049,2890.0,2890.0,1
-1AA10005,xiangtan,1,7,6190068.0,10005,1608.0,1608.0,1
-1AA100050,yichang,1,7,7768468.0,100050,29.0,29.0,1
-1AA100051,guangzhou,1,7,7236919.0,100051,1407.0,1407.0,1
-1AA100052,zhuzhou,1,7,167725.0,100052,845.0,845.0,1
-1AA100053,wuhan,1,7,2651084.0,100053,1655.0,1655.0,1
-1AA100054,shenzhen,1,7,6283156.0,100054,1368.0,1368.0,1
-1AA100055,yichang,1,7,7342321.0,100055,1728.0,1728.0,1
-1AA100056,wuhan,1,7,1753823.0,100056,750.0,750.0,1
-1AA100057,zhuzhou,1,7,5451533.0,100057,2288.0,2288.0,1
-1AA100058,guangzhou,1,7,5403108.0,100058,2635.0,2635.0,1
-1AA100059,shenzhen,1,7,168757.0,100059,1337.0,1337.0,1
-1AA10006,guangzhou,1,7,9394732.0,10006,2478.0,2478.0,1
-1AA100060,xiangtan,1,7,7420815.0,100060,538.0,538.0,1
-1AA100061,changsha,1,7,4358621.0,100061,1407.0,1407.0,1
-1AA100062,yichang,1,7,2362114.0,100062,2952.0,2952.0,1
-1AA100063,yichang,1,7,9318234.0,100063,1226.0,1226.0,1
-1AA100064,zhuzhou,1,7,5565240.0,100064,865.0,865.0,1
-1AA100065,xiangtan,1,7,3166724.0,100065,901.0,901.0,1
-1AA100066,zhuzhou,1,7,5592457.0,100066,1864.0,1864.0,1
-1AA100067,wuhan,1,7,7575196.0,100067,572.0,572.0,1
-1AA100068,guangzhou,1,7,3235086.0,100068,412.0,412.0,1
-1AA100069,xiangtan,1,7,7917206.0,100069,1491.0,1491.0,1
-1AA10007,xiangtan,1,7,4156339.0,10007,1350.0,1350.0,1
-1AA100070,guangzhou,1,7,4202614.0,100070,1567.0,1567.0,1
-1AA100071,guangzhou,1,7,2199957.0,100071,1973.0,1973.0,1
-1AA100072,changsha,1,7,511128.0,100072,448.0,448.0,1
-1AA100073,zhuzhou,1,7,580612.0,100073,2488.0,2488.0,1
-1AA100074,wuhan,1,7,275342.0,100074,907.0,907.0,1
-1AA100075,shenzhen,1,7,3215327.0,100075,2507.0,2507.0,1
-1AA100076,wuhan,1,7,8069859.0,100076,732.0,732.0,1
-1AA100077,yichang,1,7,6383562.0,100077,2077.0,2077.0,1
-1AA100078,yichang,1,7,6428516.0,100078,1434.0,1434.0,1
-1AA100079,xiangtan,1,7,5159121.0,100079,1098.0,1098.0,1
-1AA10008,shenzhen,1,7,3360388.0,10008,813.0,813.0,1
-1AA100080,shenzhen,1,7,5152985.0,100080,954.0,954.0,1
-1AA100081,shenzhen,1,7,3335480.0,100081,613.0,613.0,1
-1AA100082,xiangtan,1,7,994815.0,100082,2348.0,2348.0,1
-1AA100083,zhuzhou,1,7,507229.0,100083,2192.0,2192.0,1
-1AA100084,guangzhou,1,7,8976568.0,100084,2826.0,2826.0,1

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_334.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_334.csv b/integration-testcases/src/test/resources/hiveExpected/TC_334.csv
deleted file mode 100644
index ac6ea24..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_334.csv
+++ /dev/null
@@ -1,12 +0,0 @@
-series StringType,imei StringType,deliveryCity StringType,Sum_gamePointId DoubleType,Sum_deviceInformationId LongType,Sum_Latest_YEAR LongType
-7Series,1AA1,yichang,2738.562,1,2015
-7Series,1AA10,yichang,1714.635,10,2015
-7Series,1AA10000,guangzhou,2175.0,10000,2015
-7Series,1AA1000000,yichang,1600.0,1000000,2015
-7Series,1AA100026,yichang,1768.0,100026,2015
-7Series,1AA10003,xiangtan,2071.0,10003,2015
-7Series,1AA100030,zhuzhou,1333.0,100030,2015
-7Series,1AA100031,yichang,1080.0,100031,2015
-7Series,1AA100037,xiangtan,1015.0,100037,2015
-7Series,1AA100054,shenzhen,1368.0,100054,2015
-7Series,1AA100055,yichang,1728.0,100055,2015

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_335.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_335.csv b/integration-testcases/src/test/resources/hiveExpected/TC_335.csv
deleted file mode 100644
index d733b22..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_335.csv
+++ /dev/null
@@ -1,40 +0,0 @@
-series StringType,imei StringType,deliveryCity StringType,Sum_gamePointId DoubleType,Sum_deviceInformationId LongType,Sum_Latest_YEAR LongType
-6Series,1AA100006,changsha,2572.0,100006,2015
-6Series,1AA100024,changsha,2483.0,100024,2015
-6Series,1AA100038,shenzhen,1229.0,100038,2015
-6Series,1AA100052,zhuzhou,845.0,100052,2015
-6Series,1AA100056,wuhan,750.0,100056,2015
-6Series,1AA100061,changsha,1407.0,100061,2015
-6Series,1AA100064,zhuzhou,865.0,100064,2015
-6Series,1AA100066,zhuzhou,1864.0,100066,2015
-6Series,1AA100074,wuhan,907.0,100074,2015
-7Series,1AA1,yichang,2738.562,1,2015
-7Series,1AA10,yichang,1714.635,10,2015
-7Series,1AA10000,guangzhou,2175.0,10000,2015
-7Series,1AA1000000,yichang,1600.0,1000000,2015
-7Series,1AA100026,yichang,1768.0,100026,2015
-7Series,1AA10003,xiangtan,2071.0,10003,2015
-7Series,1AA100030,zhuzhou,1333.0,100030,2015
-7Series,1AA100031,yichang,1080.0,100031,2015
-7Series,1AA100037,xiangtan,1015.0,100037,2015
-7Series,1AA100054,shenzhen,1368.0,100054,2015
-7Series,1AA100055,yichang,1728.0,100055,2015
-8Series,1AA100008,changsha,1442.0,100008,2015
-8Series,1AA100018,yichang,441.0,100018,2015
-8Series,1AA100033,wuhan,760.0,100033,2015
-8Series,1AA100039,shenzhen,1750.0,100039,2015
-8Series,1AA100040,yichang,2078.0,100040,2015
-8Series,1AA100044,guangzhou,1697.0,100044,2015
-8Series,1AA10005,xiangtan,1608.0,10005,2015
-8Series,1AA100060,xiangtan,538.0,100060,2015
-8Series,1AA100068,guangzhou,412.0,100068,2015
-8Series,1AA100069,xiangtan,1491.0,100069,2015
-8Series,1AA10007,xiangtan,1350.0,10007,2015
-9Series,1AA100000,wuhan,136.0,100000,2015
-9Series,1AA100007,changsha,1991.0,100007,2015
-9Series,1AA100017,xiangtan,2205.0,100017,2015
-9Series,1AA100043,guangzhou,571.0,100043,2015
-9Series,1AA100047,zhuzhou,1823.0,100047,2015
-9Series,1AA100057,zhuzhou,2288.0,100057,2015
-9Series,1AA100062,yichang,2952.0,100062,2015
-9Series,1AA100080,shenzhen,954.0,100080,2015

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_336.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_336.csv b/integration-testcases/src/test/resources/hiveExpected/TC_336.csv
deleted file mode 100644
index 9ef244e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_336.csv
+++ /dev/null
@@ -1,65 +0,0 @@
-series StringType,imei StringType,deliveryCity StringType,Sum_gamePointId DoubleType,Sum_deviceInformationId LongType,Sum_Latest_YEAR LongType
-4Series,1AA100004,yichang,2970.0,100004,2015
-4Series,1AA100012,xiangtan,568.0,100012,2015
-4Series,1AA100015,xiangtan,2863.0,100015,2015
-4Series,1AA100059,shenzhen,1337.0,100059,2015
-4Series,1AA100067,wuhan,572.0,100067,2015
-4Series,1AA100072,changsha,448.0,100072,2015
-4Series,1AA100073,zhuzhou,2488.0,100073,2015
-4Series,1AA100079,xiangtan,1098.0,100079,2015
-5Series,1AA100,xiangtan,1271.0,100,2015
-5Series,1AA1000,wuhan,692.0,1000,2015
-5Series,1AA100003,zhuzhou,2239.0,100003,2015
-5Series,1AA100014,zhuzhou,151.0,100014,2015
-5Series,1AA100019,zhuzhou,2194.0,100019,2015
-5Series,1AA100020,shenzhen,256.0,100020,2015
-5Series,1AA100022,zhuzhou,1999.0,100022,2015
-5Series,1AA100023,guangzhou,2194.0,100023,2015
-5Series,1AA100028,zhuzhou,2849.0,100028,2015
-5Series,1AA100035,changsha,2142.0,100035,2015
-5Series,1AA100036,changsha,2224.0,100036,2015
-5Series,1AA10004,guangzhou,1717.0,10004,2015
-5Series,1AA100041,shenzhen,2734.0,100041,2015
-5Series,1AA100058,guangzhou,2635.0,100058,2015
-5Series,1AA10008,shenzhen,813.0,10008,2015
-5Series,1AA100081,shenzhen,613.0,100081,2015
-5Series,1AA100082,xiangtan,2348.0,100082,2015
-6Series,1AA100006,changsha,2572.0,100006,2015
-6Series,1AA100024,changsha,2483.0,100024,2015
-6Series,1AA100038,shenzhen,1229.0,100038,2015
-6Series,1AA100052,zhuzhou,845.0,100052,2015
-6Series,1AA100056,wuhan,750.0,100056,2015
-6Series,1AA100061,changsha,1407.0,100061,2015
-6Series,1AA100064,zhuzhou,865.0,100064,2015
-6Series,1AA100066,zhuzhou,1864.0,100066,2015
-6Series,1AA100074,wuhan,907.0,100074,2015
-7Series,1AA1,yichang,2738.562,1,2015
-7Series,1AA10,yichang,1714.635,10,2015
-7Series,1AA10000,guangzhou,2175.0,10000,2015
-7Series,1AA1000000,yichang,1600.0,1000000,2015
-7Series,1AA100026,yichang,1768.0,100026,2015
-7Series,1AA10003,xiangtan,2071.0,10003,2015
-7Series,1AA100030,zhuzhou,1333.0,100030,2015
-7Series,1AA100031,yichang,1080.0,100031,2015
-7Series,1AA100037,xiangtan,1015.0,100037,2015
-7Series,1AA100054,shenzhen,1368.0,100054,2015
-7Series,1AA100055,yichang,1728.0,100055,2015
-8Series,1AA100008,changsha,1442.0,100008,2015
-8Series,1AA100018,yichang,441.0,100018,2015
-8Series,1AA100033,wuhan,760.0,100033,2015
-8Series,1AA100039,shenzhen,1750.0,100039,2015
-8Series,1AA100040,yichang,2078.0,100040,2015
-8Series,1AA100044,guangzhou,1697.0,100044,2015
-8Series,1AA10005,xiangtan,1608.0,10005,2015
-8Series,1AA100060,xiangtan,538.0,100060,2015
-8Series,1AA100068,guangzhou,412.0,100068,2015
-8Series,1AA100069,xiangtan,1491.0,100069,2015
-8Series,1AA10007,xiangtan,1350.0,10007,2015
-9Series,1AA100000,wuhan,136.0,100000,2015
-9Series,1AA100007,changsha,1991.0,100007,2015
-9Series,1AA100017,xiangtan,2205.0,100017,2015
-9Series,1AA100043,guangzhou,571.0,100043,2015
-9Series,1AA100047,zhuzhou,1823.0,100047,2015
-9Series,1AA100057,zhuzhou,2288.0,100057,2015
-9Series,1AA100062,yichang,2952.0,100062,2015
-9Series,1AA100080,shenzhen,954.0,100080,2015

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_337.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_337.csv b/integration-testcases/src/test/resources/hiveExpected/TC_337.csv
deleted file mode 100644
index 6b8c87a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_337.csv
+++ /dev/null
@@ -1,28 +0,0 @@
-series StringType,imei StringType,deliveryCity StringType,Sum_gamePointId DoubleType,Sum_deviceInformationId LongType,Sum_Latest_YEAR LongType
-0Series,1AA100001,xiangtan,505.0,100001,2015
-0Series,1AA100002,changsha,1341.0,100002,2015
-0Series,1AA100009,yichang,1841.0,100009,2015
-0Series,1AA100011,guangzhou,202.0,100011,2015
-0Series,1AA10002,wuhan,2972.0,10002,2015
-0Series,1AA100021,changsha,1778.0,100021,2015
-0Series,1AA100025,guangzhou,1724.0,100025,2015
-0Series,1AA100027,zhuzhou,2436.0,100027,2015
-0Series,1AA100049,guangzhou,2890.0,100049,2015
-0Series,1AA100065,xiangtan,901.0,100065,2015
-0Series,1AA100070,guangzhou,1567.0,100070,2015
-0Series,1AA100071,guangzhou,1973.0,100071,2015
-0Series,1AA100076,wuhan,732.0,100076,2015
-0Series,1AA100083,zhuzhou,2192.0,100083,2015
-0Series,1AA100084,guangzhou,2826.0,100084,2015
-1Series,1AA100005,yichang,2593.0,100005,2015
-1Series,1AA100013,changsha,355.0,100013,2015
-1Series,1AA100032,shenzhen,1053.0,100032,2015
-2Series,1AA10001,changsha,298.0,10001,2015
-2Series,1AA100029,xiangtan,1691.0,100029,2015
-2Series,1AA100034,guangzhou,2061.0,100034,2015
-2Series,1AA100045,xiangtan,2553.0,100045,2015
-2Series,1AA100050,yichang,29.0,100050,2015
-2Series,1AA100051,guangzhou,1407.0,100051,2015
-2Series,1AA100053,wuhan,1655.0,100053,2015
-2Series,1AA100063,yichang,1226.0,100063,2015
-2Series,1AA100078,yichang,1434.0,100078,2015

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_338.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_338.csv b/integration-testcases/src/test/resources/hiveExpected/TC_338.csv
deleted file mode 100644
index 1887198..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_338.csv
+++ /dev/null
@@ -1,61 +0,0 @@
-series StringType,imei StringType,deliveryCity StringType,Sum_gamePointId DoubleType,Sum_deviceInformationId LongType,Sum_Latest_YEAR LongType
-0Series,1AA100001,xiangtan,505.0,100001,2015
-0Series,1AA100002,changsha,1341.0,100002,2015
-0Series,1AA100009,yichang,1841.0,100009,2015
-0Series,1AA100011,guangzhou,202.0,100011,2015
-0Series,1AA10002,wuhan,2972.0,10002,2015
-0Series,1AA100021,changsha,1778.0,100021,2015
-0Series,1AA100025,guangzhou,1724.0,100025,2015
-0Series,1AA100027,zhuzhou,2436.0,100027,2015
-0Series,1AA100049,guangzhou,2890.0,100049,2015
-0Series,1AA100065,xiangtan,901.0,100065,2015
-0Series,1AA100070,guangzhou,1567.0,100070,2015
-0Series,1AA100071,guangzhou,1973.0,100071,2015
-0Series,1AA100076,wuhan,732.0,100076,2015
-0Series,1AA100083,zhuzhou,2192.0,100083,2015
-0Series,1AA100084,guangzhou,2826.0,100084,2015
-1Series,1AA100005,yichang,2593.0,100005,2015
-1Series,1AA100013,changsha,355.0,100013,2015
-1Series,1AA100032,shenzhen,1053.0,100032,2015
-2Series,1AA10001,changsha,298.0,10001,2015
-2Series,1AA100029,xiangtan,1691.0,100029,2015
-2Series,1AA100034,guangzhou,2061.0,100034,2015
-2Series,1AA100045,xiangtan,2553.0,100045,2015
-2Series,1AA100050,yichang,29.0,100050,2015
-2Series,1AA100051,guangzhou,1407.0,100051,2015
-2Series,1AA100053,wuhan,1655.0,100053,2015
-2Series,1AA100063,yichang,1226.0,100063,2015
-2Series,1AA100078,yichang,1434.0,100078,2015
-3Series,1AA100010,zhuzhou,79.0,100010,2015
-3Series,1AA100016,changsha,1873.0,100016,2015
-3Series,1AA100042,shenzhen,2745.0,100042,2015
-3Series,1AA100046,guangzhou,1077.0,100046,2015
-3Series,1AA100048,guangzhou,2399.0,100048,2015
-3Series,1AA10006,guangzhou,2478.0,10006,2015
-3Series,1AA100075,shenzhen,2507.0,100075,2015
-3Series,1AA100077,yichang,2077.0,100077,2015
-4Series,1AA100004,yichang,2970.0,100004,2015
-4Series,1AA100012,xiangtan,568.0,100012,2015
-4Series,1AA100015,xiangtan,2863.0,100015,2015
-4Series,1AA100059,shenzhen,1337.0,100059,2015
-4Series,1AA100067,wuhan,572.0,100067,2015
-4Series,1AA100072,changsha,448.0,100072,2015
-4Series,1AA100073,zhuzhou,2488.0,100073,2015
-4Series,1AA100079,xiangtan,1098.0,100079,2015
-5Series,1AA100,xiangtan,1271.0,100,2015
-5Series,1AA1000,wuhan,692.0,1000,2015
-5Series,1AA100003,zhuzhou,2239.0,100003,2015
-5Series,1AA100014,zhuzhou,151.0,100014,2015
-5Series,1AA100019,zhuzhou,2194.0,100019,2015
-5Series,1AA100020,shenzhen,256.0,100020,2015
-5Series,1AA100022,zhuzhou,1999.0,100022,2015
-5Series,1AA100023,guangzhou,2194.0,100023,2015
-5Series,1AA100028,zhuzhou,2849.0,100028,2015
-5Series,1AA100035,changsha,2142.0,100035,2015
-5Series,1AA100036,changsha,2224.0,100036,2015
-5Series,1AA10004,guangzhou,1717.0,10004,2015
-5Series,1AA100041,shenzhen,2734.0,100041,2015
-5Series,1AA100058,guangzhou,2635.0,100058,2015
-5Series,1AA10008,shenzhen,813.0,10008,2015
-5Series,1AA100081,shenzhen,613.0,100081,2015
-5Series,1AA100082,xiangtan,2348.0,100082,2015

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_339.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_339.csv b/integration-testcases/src/test/resources/hiveExpected/TC_339.csv
deleted file mode 100644
index 0d83839..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_339.csv
+++ /dev/null
@@ -1,10 +0,0 @@
-series StringType,imei StringType,deliveryCity StringType,Sum_gamePointId DoubleType,Sum_deviceInformationId LongType,Sum_Latest_YEAR LongType
-0Series,1AA10002,wuhan,2972.0,10002,2015
-0Series,1AA100076,wuhan,732.0,100076,2015
-2Series,1AA100053,wuhan,1655.0,100053,2015
-4Series,1AA100067,wuhan,572.0,100067,2015
-5Series,1AA1000,wuhan,692.0,1000,2015
-6Series,1AA100056,wuhan,750.0,100056,2015
-6Series,1AA100074,wuhan,907.0,100074,2015
-8Series,1AA100033,wuhan,760.0,100033,2015
-9Series,1AA100000,wuhan,136.0,100000,2015

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_340.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_340.csv b/integration-testcases/src/test/resources/hiveExpected/TC_340.csv
deleted file mode 100644
index ecea5dc..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_340.csv
+++ /dev/null
@@ -1,66 +0,0 @@
-latest_year IntegerType,latest_day IntegerType,imei StringType,gamepointid DoubleType,deviceinformationid IntegerType,series StringType,imei StringType,deliverycity StringType
-2015,1,1AA10,1714.635,10,7Series,1AA10,yichang
-2015,1,1AA100,1271.0,100,5Series,1AA100,xiangtan
-2015,1,1AA1000,692.0,1000,5Series,1AA1000,wuhan
-2015,1,1AA100000,136.0,100000,9Series,1AA100000,wuhan
-2015,1,1AA1000000,1600.0,1000000,7Series,1AA1000000,yichang
-2015,1,1AA100001,505.0,100001,0Series,1AA100001,xiangtan
-2015,1,1AA100002,1341.0,100002,0Series,1AA100002,changsha
-2015,1,1AA100007,1991.0,100007,9Series,1AA100007,changsha
-2015,1,1AA100008,1442.0,100008,8Series,1AA100008,changsha
-2015,1,1AA100009,1841.0,100009,0Series,1AA100009,yichang
-2015,1,1AA10001,298.0,10001,2Series,1AA10001,changsha
-2015,1,1AA100010,79.0,100010,3Series,1AA100010,zhuzhou
-2015,1,1AA100011,202.0,100011,0Series,1AA100011,guangzhou
-2015,1,1AA100012,568.0,100012,4Series,1AA100012,xiangtan
-2015,1,1AA100013,355.0,100013,1Series,1AA100013,changsha
-2015,1,1AA100014,151.0,100014,5Series,1AA100014,zhuzhou
-2015,1,1AA100016,1873.0,100016,3Series,1AA100016,changsha
-2015,1,1AA100018,441.0,100018,8Series,1AA100018,yichang
-2015,1,1AA100020,256.0,100020,5Series,1AA100020,shenzhen
-2015,1,1AA100021,1778.0,100021,0Series,1AA100021,changsha
-2015,1,1AA100022,1999.0,100022,5Series,1AA100022,zhuzhou
-2015,1,1AA100025,1724.0,100025,0Series,1AA100025,guangzhou
-2015,1,1AA100026,1768.0,100026,7Series,1AA100026,yichang
-2015,1,1AA100029,1691.0,100029,2Series,1AA100029,xiangtan
-2015,1,1AA100030,1333.0,100030,7Series,1AA100030,zhuzhou
-2015,1,1AA100031,1080.0,100031,7Series,1AA100031,yichang
-2015,1,1AA100032,1053.0,100032,1Series,1AA100032,shenzhen
-2015,1,1AA100033,760.0,100033,8Series,1AA100033,wuhan
-2015,1,1AA100037,1015.0,100037,7Series,1AA100037,xiangtan
-2015,1,1AA100038,1229.0,100038,6Series,1AA100038,shenzhen
-2015,1,1AA100039,1750.0,100039,8Series,1AA100039,shenzhen
-2015,1,1AA10004,1717.0,10004,5Series,1AA10004,guangzhou
-2015,1,1AA100043,571.0,100043,9Series,1AA100043,guangzhou
-2015,1,1AA100044,1697.0,100044,8Series,1AA100044,guangzhou
-2015,1,1AA100046,1077.0,100046,3Series,1AA100046,guangzhou
-2015,1,1AA100047,1823.0,100047,9Series,1AA100047,zhuzhou
-2015,1,1AA10005,1608.0,10005,8Series,1AA10005,xiangtan
-2015,1,1AA100050,29.0,100050,2Series,1AA100050,yichang
-2015,1,1AA100051,1407.0,100051,2Series,1AA100051,guangzhou
-2015,1,1AA100052,845.0,100052,6Series,1AA100052,zhuzhou
-2015,1,1AA100053,1655.0,100053,2Series,1AA100053,wuhan
-2015,1,1AA100054,1368.0,100054,7Series,1AA100054,shenzhen
-2015,1,1AA100055,1728.0,100055,7Series,1AA100055,yichang
-2015,1,1AA100056,750.0,100056,6Series,1AA100056,wuhan
-2015,1,1AA100059,1337.0,100059,4Series,1AA100059,shenzhen
-2015,1,1AA100060,538.0,100060,8Series,1AA100060,xiangtan
-2015,1,1AA100061,1407.0,100061,6Series,1AA100061,changsha
-2015,1,1AA100063,1226.0,100063,2Series,1AA100063,yichang
-2015,1,1AA100064,865.0,100064,6Series,1AA100064,zhuzhou
-2015,1,1AA100065,901.0,100065,0Series,1AA100065,xiangtan
-2015,1,1AA100066,1864.0,100066,6Series,1AA100066,zhuzhou
-2015,1,1AA100067,572.0,100067,4Series,1AA100067,wuhan
-2015,1,1AA100068,412.0,100068,8Series,1AA100068,guangzhou
-2015,1,1AA100069,1491.0,100069,8Series,1AA100069,xiangtan
-2015,1,1AA10007,1350.0,10007,8Series,1AA10007,xiangtan
-2015,1,1AA100070,1567.0,100070,0Series,1AA100070,guangzhou
-2015,1,1AA100071,1973.0,100071,0Series,1AA100071,guangzhou
-2015,1,1AA100072,448.0,100072,4Series,1AA100072,changsha
-2015,1,1AA100074,907.0,100074,6Series,1AA100074,wuhan
-2015,1,1AA100076,732.0,100076,0Series,1AA100076,wuhan
-2015,1,1AA100078,1434.0,100078,2Series,1AA100078,yichang
-2015,1,1AA100079,1098.0,100079,4Series,1AA100079,xiangtan
-2015,1,1AA10008,813.0,10008,5Series,1AA10008,shenzhen
-2015,1,1AA100080,954.0,100080,9Series,1AA100080,shenzhen
-2015,1,1AA100081,613.0,100081,5Series,1AA100081,shenzhen

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_341.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_341.csv b/integration-testcases/src/test/resources/hiveExpected/TC_341.csv
deleted file mode 100644
index 1972a64..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_341.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-gamePointId DoubleType,deviceInformationId IntegerType,Latest_YEAR IntegerType,series StringType,imei StringType,deliveryCity StringType
-2175.0,10000,2015,7Series,1AA10000,guangzhou

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

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_343.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_343.csv b/integration-testcases/src/test/resources/hiveExpected/TC_343.csv
deleted file mode 100644
index 7bfc956..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_343.csv
+++ /dev/null
@@ -1 +0,0 @@
-latest_year IntegerType,latest_day IntegerType,imei StringType,gamepointid DoubleType,deviceinformationid IntegerType,series StringType,imei StringType,deliverycity StringType

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_344.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_344.csv b/integration-testcases/src/test/resources/hiveExpected/TC_344.csv
deleted file mode 100644
index 9039ff7..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_344.csv
+++ /dev/null
@@ -1,10 +0,0 @@
-gamePointId DoubleType,deviceInformationId IntegerType,Latest_YEAR IntegerType,series StringType,imei StringType,deliveryCity StringType
-692.0,1000,2015,5Series,1AA1000,wuhan
-136.0,100000,2015,9Series,1AA100000,wuhan
-2972.0,10002,2015,0Series,1AA10002,wuhan
-760.0,100033,2015,8Series,1AA100033,wuhan
-1655.0,100053,2015,2Series,1AA100053,wuhan
-750.0,100056,2015,6Series,1AA100056,wuhan
-572.0,100067,2015,4Series,1AA100067,wuhan
-907.0,100074,2015,6Series,1AA100074,wuhan
-732.0,100076,2015,0Series,1AA100076,wuhan

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_345.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_345.csv b/integration-testcases/src/test/resources/hiveExpected/TC_345.csv
deleted file mode 100644
index 2748ac9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_345.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-gamepointid DoubleType,deviceinformationid IntegerType,latest_year IntegerType,series StringType,imei StringType,deliverycity StringType
-2738.562,1,2015,7Series,1AA1,yichang

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_346.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_346.csv b/integration-testcases/src/test/resources/hiveExpected/TC_346.csv
deleted file mode 100644
index 29e3c7d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_346.csv
+++ /dev/null
@@ -1,5 +0,0 @@
-gamepointid DoubleType,deviceinformationid IntegerType,latest_year IntegerType,series StringType,imei StringType,deliverycity StringType
-1080.0,100031,2015,7Series,1AA100031,yichang
-1053.0,100032,2015,1Series,1AA100032,shenzhen
-1015.0,100037,2015,7Series,1AA100037,xiangtan
-1077.0,100046,2015,3Series,1AA100046,guangzhou

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_347.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_347.csv b/integration-testcases/src/test/resources/hiveExpected/TC_347.csv
deleted file mode 100644
index ce9a66d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_347.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-gamepointid DoubleType,deviceinformationid IntegerType,latest_year IntegerType,series StringType,imei StringType,deliverycity StringType
-1080.0,100031,2015,7Series,1AA100031,yichang

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_348.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_348.csv b/integration-testcases/src/test/resources/hiveExpected/TC_348.csv
deleted file mode 100644
index b7d2f22..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_348.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-latest_year IntegerType,gamepointid DoubleType
-2015,2738.562
-2015,1714.635
-2015,1271.0
-2015,692.0
-2015,2175.0
-2015,136.0
-2015,1600.0
-2015,505.0
-2015,1341.0
-2015,2239.0
-2015,2970.0
-2015,2593.0
-2015,2572.0
-2015,1991.0
-2015,1442.0
-2015,1841.0
-2015,298.0
-2015,79.0
-2015,202.0
-2015,568.0
-2015,355.0
-2015,151.0
-2015,2863.0
-2015,1873.0
-2015,2205.0
-2015,441.0
-2015,2194.0
-2015,2972.0
-2015,256.0
-2015,1778.0
-2015,1999.0
-2015,2194.0
-2015,2483.0
-2015,1724.0
-2015,1768.0
-2015,2436.0
-2015,2849.0
-2015,1691.0
-2015,2071.0
-2015,1333.0
-2015,1080.0
-2015,1053.0
-2015,760.0
-2015,2061.0
-2015,2142.0
-2015,2224.0
-2015,1015.0
-2015,1229.0
-2015,1750.0
-2015,1717.0
-2015,2078.0
-2015,2734.0
-2015,2745.0
-2015,571.0
-2015,1697.0
-2015,2553.0
-2015,1077.0
-2015,1823.0
-2015,2399.0
-2015,2890.0
-2015,1608.0
-2015,29.0
-2015,1407.0
-2015,845.0
-2015,1655.0
-2015,1368.0
-2015,1728.0
-2015,750.0
-2015,2288.0
-2015,2635.0
-2015,1337.0
-2015,2478.0
-2015,538.0
-2015,1407.0
-2015,2952.0
-2015,1226.0
-2015,865.0
-2015,901.0
-2015,1864.0
-2015,572.0
-2015,412.0
-2015,1491.0
-2015,1350.0
-2015,1567.0
-2015,1973.0
-2015,448.0
-2015,2488.0
-2015,907.0
-2015,2507.0
-2015,732.0
-2015,2077.0
-2015,1434.0
-2015,1098.0
-2015,813.0
-2015,954.0
-2015,613.0
-2015,2348.0
-2015,2192.0
-2015,2826.0

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_349.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_349.csv b/integration-testcases/src/test/resources/hiveExpected/TC_349.csv
deleted file mode 100644
index 9761a7b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_349.csv
+++ /dev/null
@@ -1,4 +0,0 @@
-latest_year IntegerType,gamepointid DoubleType
-2015,298.0
-2015,202.0
-2015,256.0

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

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

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

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_353.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_353.csv b/integration-testcases/src/test/resources/hiveExpected/TC_353.csv
deleted file mode 100644
index 8adf886..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_353.csv
+++ /dev/null
@@ -1,69 +0,0 @@
-gamePointId DoubleType,Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType
-2738.562,2015,1,1AA1,yichang
-1714.635,2015,10,1AA10,yichang
-1271.0,2015,100,1AA100,xiangtan
-692.0,2015,1000,1AA1000,wuhan
-136.0,2015,100000,1AA100000,wuhan
-1600.0,2015,1000000,1AA1000000,yichang
-505.0,2015,100001,1AA100001,xiangtan
-2239.0,2015,100003,1AA100003,zhuzhou
-2970.0,2015,100004,1AA100004,yichang
-2593.0,2015,100005,1AA100005,yichang
-1841.0,2015,100009,1AA100009,yichang
-79.0,2015,100010,1AA100010,zhuzhou
-568.0,2015,100012,1AA100012,xiangtan
-151.0,2015,100014,1AA100014,zhuzhou
-2863.0,2015,100015,1AA100015,xiangtan
-2205.0,2015,100017,1AA100017,xiangtan
-441.0,2015,100018,1AA100018,yichang
-2194.0,2015,100019,1AA100019,zhuzhou
-2972.0,2015,10002,1AA10002,wuhan
-256.0,2015,100020,1AA100020,shenzhen
-1999.0,2015,100022,1AA100022,zhuzhou
-1768.0,2015,100026,1AA100026,yichang
-2436.0,2015,100027,1AA100027,zhuzhou
-2849.0,2015,100028,1AA100028,zhuzhou
-1691.0,2015,100029,1AA100029,xiangtan
-2071.0,2015,10003,1AA10003,xiangtan
-1333.0,2015,100030,1AA100030,zhuzhou
-1080.0,2015,100031,1AA100031,yichang
-1053.0,2015,100032,1AA100032,shenzhen
-760.0,2015,100033,1AA100033,wuhan
-1015.0,2015,100037,1AA100037,xiangtan
-1229.0,2015,100038,1AA100038,shenzhen
-1750.0,2015,100039,1AA100039,shenzhen
-2078.0,2015,100040,1AA100040,yichang
-2734.0,2015,100041,1AA100041,shenzhen
-2745.0,2015,100042,1AA100042,shenzhen
-2553.0,2015,100045,1AA100045,xiangtan
-1823.0,2015,100047,1AA100047,zhuzhou
-1608.0,2015,10005,1AA10005,xiangtan
-29.0,2015,100050,1AA100050,yichang
-845.0,2015,100052,1AA100052,zhuzhou
-1655.0,2015,100053,1AA100053,wuhan
-1368.0,2015,100054,1AA100054,shenzhen
-1728.0,2015,100055,1AA100055,yichang
-750.0,2015,100056,1AA100056,wuhan
-2288.0,2015,100057,1AA100057,zhuzhou
-1337.0,2015,100059,1AA100059,shenzhen
-538.0,2015,100060,1AA100060,xiangtan
-2952.0,2015,100062,1AA100062,yichang
-1226.0,2015,100063,1AA100063,yichang
-865.0,2015,100064,1AA100064,zhuzhou
-901.0,2015,100065,1AA100065,xiangtan
-1864.0,2015,100066,1AA100066,zhuzhou
-572.0,2015,100067,1AA100067,wuhan
-1491.0,2015,100069,1AA100069,xiangtan
-1350.0,2015,10007,1AA10007,xiangtan
-2488.0,2015,100073,1AA100073,zhuzhou
-907.0,2015,100074,1AA100074,wuhan
-2507.0,2015,100075,1AA100075,shenzhen
-732.0,2015,100076,1AA100076,wuhan
-2077.0,2015,100077,1AA100077,yichang
-1434.0,2015,100078,1AA100078,yichang
-1098.0,2015,100079,1AA100079,xiangtan
-813.0,2015,10008,1AA10008,shenzhen
-954.0,2015,100080,1AA100080,shenzhen
-613.0,2015,100081,1AA100081,shenzhen
-2348.0,2015,100082,1AA100082,xiangtan
-2192.0,2015,100083,1AA100083,zhuzhou

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

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_355.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_355.csv b/integration-testcases/src/test/resources/hiveExpected/TC_355.csv
deleted file mode 100644
index 85bf24c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_355.csv
+++ /dev/null
@@ -1,58 +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
-2175.0,2015,10000,1AA10000,guangzhou,7Series
-136.0,2015,100000,1AA100000,wuhan,9Series
-1600.0,2015,1000000,1AA1000000,yichang,7Series
-505.0,2015,100001,1AA100001,xiangtan,0Series
-1341.0,2015,100002,1AA100002,changsha,0Series
-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
-202.0,2015,100011,1AA100011,guangzhou,0Series
-355.0,2015,100013,1AA100013,changsha,1Series
-2205.0,2015,100017,1AA100017,xiangtan,9Series
-441.0,2015,100018,1AA100018,yichang,8Series
-2972.0,2015,10002,1AA10002,wuhan,0Series
-1778.0,2015,100021,1AA100021,changsha,0Series
-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
-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
-760.0,2015,100033,1AA100033,wuhan,8Series
-1015.0,2015,100037,1AA100037,xiangtan,7Series
-1229.0,2015,100038,1AA100038,shenzhen,6Series
-1750.0,2015,100039,1AA100039,shenzhen,8Series
-2078.0,2015,100040,1AA100040,yichang,8Series
-571.0,2015,100043,1AA100043,guangzhou,9Series
-1697.0,2015,100044,1AA100044,guangzhou,8Series
-1823.0,2015,100047,1AA100047,zhuzhou,9Series
-2890.0,2015,100049,1AA100049,guangzhou,0Series
-1608.0,2015,10005,1AA10005,xiangtan,8Series
-845.0,2015,100052,1AA100052,zhuzhou,6Series
-1368.0,2015,100054,1AA100054,shenzhen,7Series
-1728.0,2015,100055,1AA100055,yichang,7Series
-750.0,2015,100056,1AA100056,wuhan,6Series
-2288.0,2015,100057,1AA100057,zhuzhou,9Series
-538.0,2015,100060,1AA100060,xiangtan,8Series
-1407.0,2015,100061,1AA100061,changsha,6Series
-2952.0,2015,100062,1AA100062,yichang,9Series
-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
-907.0,2015,100074,1AA100074,wuhan,6Series
-732.0,2015,100076,1AA100076,wuhan,0Series
-954.0,2015,100080,1AA100080,shenzhen,9Series
-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_356.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_356.csv b/integration-testcases/src/test/resources/hiveExpected/TC_356.csv
deleted file mode 100644
index c582c68..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_356.csv
+++ /dev/null
@@ -1,28 +0,0 @@
-gamePointId DoubleType,Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType
-692.0,2015,1000,1AA1000,wuhan,5Series
-136.0,2015,100000,1AA100000,wuhan,9Series
-505.0,2015,100001,1AA100001,xiangtan,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
-441.0,2015,100018,1AA100018,yichang,8Series
-256.0,2015,100020,1AA100020,shenzhen,5Series
-760.0,2015,100033,1AA100033,wuhan,8Series
-571.0,2015,100043,1AA100043,guangzhou,9Series
-29.0,2015,100050,1AA100050,yichang,2Series
-845.0,2015,100052,1AA100052,zhuzhou,6Series
-750.0,2015,100056,1AA100056,wuhan,6Series
-538.0,2015,100060,1AA100060,xiangtan,8Series
-865.0,2015,100064,1AA100064,zhuzhou,6Series
-901.0,2015,100065,1AA100065,xiangtan,0Series
-572.0,2015,100067,1AA100067,wuhan,4Series
-412.0,2015,100068,1AA100068,guangzhou,8Series
-448.0,2015,100072,1AA100072,changsha,4Series
-907.0,2015,100074,1AA100074,wuhan,6Series
-732.0,2015,100076,1AA100076,wuhan,0Series
-813.0,2015,10008,1AA10008,shenzhen,5Series
-954.0,2015,100080,1AA100080,shenzhen,9Series
-613.0,2015,100081,1AA100081,shenzhen,5Series

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_357.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_357.csv b/integration-testcases/src/test/resources/hiveExpected/TC_357.csv
deleted file mode 100644
index 4720e34..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_357.csv
+++ /dev/null
@@ -1,89 +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
-692.0,2015,1000,1AA1000,wuhan,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
-568.0,2015,100012,1AA100012,xiangtan,4Series
-2863.0,2015,100015,1AA100015,xiangtan,4Series
-1873.0,2015,100016,1AA100016,changsha,3Series
-2205.0,2015,100017,1AA100017,xiangtan,9Series
-2194.0,2015,100019,1AA100019,zhuzhou,5Series
-2972.0,2015,10002,1AA10002,wuhan,0Series
-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
-760.0,2015,100033,1AA100033,wuhan,8Series
-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
-1407.0,2015,100051,1AA100051,guangzhou,2Series
-845.0,2015,100052,1AA100052,zhuzhou,6Series
-1655.0,2015,100053,1AA100053,wuhan,2Series
-1368.0,2015,100054,1AA100054,shenzhen,7Series
-1728.0,2015,100055,1AA100055,yichang,7Series
-750.0,2015,100056,1AA100056,wuhan,6Series
-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
-572.0,2015,100067,1AA100067,wuhan,4Series
-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
-2488.0,2015,100073,1AA100073,zhuzhou,4Series
-907.0,2015,100074,1AA100074,wuhan,6Series
-2507.0,2015,100075,1AA100075,shenzhen,3Series
-732.0,2015,100076,1AA100076,wuhan,0Series
-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_358.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_358.csv b/integration-testcases/src/test/resources/hiveExpected/TC_358.csv
deleted file mode 100644
index 44f7dba..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_358.csv
+++ /dev/null
@@ -1,84 +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
-692.0,2015,1000,1AA1000,wuhan,5Series
-2175.0,2015,10000,1AA10000,guangzhou,7Series
-1600.0,2015,1000000,1AA1000000,yichang,7Series
-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
-2863.0,2015,100015,1AA100015,xiangtan,4Series
-1873.0,2015,100016,1AA100016,changsha,3Series
-2205.0,2015,100017,1AA100017,xiangtan,9Series
-2194.0,2015,100019,1AA100019,zhuzhou,5Series
-2972.0,2015,10002,1AA10002,wuhan,0Series
-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
-760.0,2015,100033,1AA100033,wuhan,8Series
-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
-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
-1407.0,2015,100051,1AA100051,guangzhou,2Series
-845.0,2015,100052,1AA100052,zhuzhou,6Series
-1655.0,2015,100053,1AA100053,wuhan,2Series
-1368.0,2015,100054,1AA100054,shenzhen,7Series
-1728.0,2015,100055,1AA100055,yichang,7Series
-750.0,2015,100056,1AA100056,wuhan,6Series
-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
-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
-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
-2488.0,2015,100073,1AA100073,zhuzhou,4Series
-907.0,2015,100074,1AA100074,wuhan,6Series
-2507.0,2015,100075,1AA100075,shenzhen,3Series
-732.0,2015,100076,1AA100076,wuhan,0Series
-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_359.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_359.csv b/integration-testcases/src/test/resources/hiveExpected/TC_359.csv
deleted file mode 100644
index d56473e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_359.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