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:15 UTC
[37/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_192.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_192.csv b/integration-testcases/src/test/resources/hiveExpected/TC_192.csv
deleted file mode 100644
index 973f11a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_192.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType
-1AA1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_193.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_193.csv b/integration-testcases/src/test/resources/hiveExpected/TC_193.csv
deleted file mode 100644
index 72e803a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_193.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_194.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_194.csv b/integration-testcases/src/test/resources/hiveExpected/TC_194.csv
deleted file mode 100644
index 02ddf4f..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_194.csv
+++ /dev/null
@@ -1,12 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-1070757.0,1442.0,8Series
-574375.0,441.0,8Series
-8229807.0,760.0,8Series
-1901889.0,1750.0,8Series
-7880439.0,2078.0,8Series
-5659107.0,1697.0,8Series
-6190068.0,1608.0,8Series
-7420815.0,538.0,8Series
-3235086.0,412.0,8Series
-7917206.0,1491.0,8Series
-4156339.0,1350.0,8Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_195.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_195.csv b/integration-testcases/src/test/resources/hiveExpected/TC_195.csv
deleted file mode 100644
index b9bc930..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_195.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-1070757.0,1442.0,8Series
-7880439.0,2078.0,8Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_196.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_196.csv b/integration-testcases/src/test/resources/hiveExpected/TC_196.csv
deleted file mode 100644
index df8d46c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_196.csv
+++ /dev/null
@@ -1,21 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-88231.0,2239.0,5Series
-335583.0,1991.0,9Series
-1070757.0,1442.0,8Series
-574375.0,441.0,8Series
-833654.0,256.0,5Series
-6533899.0,1724.0,0Series
-8229807.0,760.0,8Series
-1901889.0,1750.0,8Series
-7880439.0,2078.0,8Series
-5659107.0,1697.0,8Series
-7839922.0,1823.0,9Series
-9500486.0,2399.0,3Series
-6190068.0,1608.0,8Series
-7236919.0,1407.0,2Series
-7342321.0,1728.0,7Series
-7420815.0,538.0,8Series
-9318234.0,1226.0,2Series
-3235086.0,412.0,8Series
-7917206.0,1491.0,8Series
-4156339.0,1350.0,8Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_197.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_197.csv b/integration-testcases/src/test/resources/hiveExpected/TC_197.csv
deleted file mode 100644
index 7cf1c07..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_197.csv
+++ /dev/null
@@ -1,23 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
-6805600.0,1714.635,7Series
-3784858.0,2175.0,7Series
-9737768.0,1600.0,7Series
-1070757.0,1442.0,8Series
-574375.0,441.0,8Series
-7487134.0,1768.0,7Series
-5586718.0,2071.0,7Series
-5857263.0,1333.0,7Series
-6416074.0,1080.0,7Series
-8229807.0,760.0,8Series
-3311312.0,1015.0,7Series
-1901889.0,1750.0,8Series
-7880439.0,2078.0,8Series
-5659107.0,1697.0,8Series
-6190068.0,1608.0,8Series
-6283156.0,1368.0,7Series
-7342321.0,1728.0,7Series
-7420815.0,538.0,8Series
-3235086.0,412.0,8Series
-7917206.0,1491.0,8Series
-4156339.0,1350.0,8Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_198.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_198.csv b/integration-testcases/src/test/resources/hiveExpected/TC_198.csv
deleted file mode 100644
index 72e803a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_198.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_199.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_199.csv b/integration-testcases/src/test/resources/hiveExpected/TC_199.csv
deleted file mode 100644
index 93cb334..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_199.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-6805600.0,1714.635,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_200.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_200.csv b/integration-testcases/src/test/resources/hiveExpected/TC_200.csv
deleted file mode 100644
index d6d27bf..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_200.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-6805600.0,1714.635,7Series
-8231335.0,1271.0,5Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_201.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_201.csv b/integration-testcases/src/test/resources/hiveExpected/TC_201.csv
deleted file mode 100644
index 22687aa..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_201.csv
+++ /dev/null
@@ -1,89 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
-6805600.0,1714.635,7Series
-8231335.0,1271.0,5Series
-8978765.0,692.0,5Series
-3784858.0,2175.0,7Series
-1602458.0,136.0,9Series
-9737768.0,1600.0,7Series
-2919786.0,505.0,0Series
-9455612.0,1341.0,0Series
-88231.0,2239.0,5Series
-1439363.0,2970.0,4Series
-3940720.0,2593.0,1Series
-4451217.0,2572.0,6Series
-335583.0,1991.0,9Series
-2389657.0,1841.0,0Series
-5986189.0,298.0,2Series
-8543280.0,79.0,3Series
-4816260.0,202.0,0Series
-8453995.0,568.0,4Series
-2051539.0,355.0,1Series
-7610075.0,151.0,5Series
-6663091.0,2863.0,4Series
-6495292.0,1873.0,3Series
-2611464.0,2205.0,9Series
-4459076.0,2194.0,5Series
-5204739.0,2972.0,0Series
-833654.0,256.0,5Series
-566917.0,1778.0,0Series
-832387.0,1999.0,5Series
-2850246.0,2194.0,5Series
-6169467.0,2483.0,6Series
-6533899.0,1724.0,0Series
-7487134.0,1768.0,7Series
-4750239.0,2436.0,0Series
-8880112.0,2849.0,5Series
-7774590.0,1691.0,2Series
-5586718.0,2071.0,7Series
-5857263.0,1333.0,7Series
-6416074.0,1080.0,7Series
-6994063.0,1053.0,1Series
-5797079.0,2061.0,2Series
-6283062.0,2142.0,5Series
-8431770.0,2224.0,5Series
-3311312.0,1015.0,7Series
-2843881.0,1229.0,6Series
-3077303.0,1717.0,5Series
-3454331.0,2734.0,5Series
-23250.0,2745.0,3Series
-3278167.0,571.0,9Series
-9952232.0,2553.0,2Series
-424923.0,1077.0,3Series
-7839922.0,1823.0,9Series
-9500486.0,2399.0,3Series
-1952050.0,2890.0,0Series
-7768468.0,29.0,2Series
-7236919.0,1407.0,2Series
-167725.0,845.0,6Series
-2651084.0,1655.0,2Series
-6283156.0,1368.0,7Series
-7342321.0,1728.0,7Series
-1753823.0,750.0,6Series
-5451533.0,2288.0,9Series
-5403108.0,2635.0,5Series
-168757.0,1337.0,4Series
-9394732.0,2478.0,3Series
-4358621.0,1407.0,6Series
-2362114.0,2952.0,9Series
-9318234.0,1226.0,2Series
-5565240.0,865.0,6Series
-3166724.0,901.0,0Series
-5592457.0,1864.0,6Series
-7575196.0,572.0,4Series
-4202614.0,1567.0,0Series
-2199957.0,1973.0,0Series
-511128.0,448.0,4Series
-580612.0,2488.0,4Series
-275342.0,907.0,6Series
-3215327.0,2507.0,3Series
-8069859.0,732.0,0Series
-6383562.0,2077.0,3Series
-6428516.0,1434.0,2Series
-5159121.0,1098.0,4Series
-3360388.0,813.0,5Series
-5152985.0,954.0,9Series
-3335480.0,613.0,5Series
-994815.0,2348.0,5Series
-507229.0,2192.0,0Series
-8976568.0,2826.0,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_202.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_202.csv b/integration-testcases/src/test/resources/hiveExpected/TC_202.csv
deleted file mode 100644
index 402aca4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_202.csv
+++ /dev/null
@@ -1,80 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
-6805600.0,1714.635,7Series
-8231335.0,1271.0,5Series
-8978765.0,692.0,5Series
-3784858.0,2175.0,7Series
-1602458.0,136.0,9Series
-9737768.0,1600.0,7Series
-2919786.0,505.0,0Series
-9455612.0,1341.0,0Series
-1439363.0,2970.0,4Series
-3940720.0,2593.0,1Series
-4451217.0,2572.0,6Series
-2389657.0,1841.0,0Series
-5986189.0,298.0,2Series
-8543280.0,79.0,3Series
-4816260.0,202.0,0Series
-8453995.0,568.0,4Series
-2051539.0,355.0,1Series
-7610075.0,151.0,5Series
-6663091.0,2863.0,4Series
-6495292.0,1873.0,3Series
-2611464.0,2205.0,9Series
-4459076.0,2194.0,5Series
-5204739.0,2972.0,0Series
-566917.0,1778.0,0Series
-832387.0,1999.0,5Series
-2850246.0,2194.0,5Series
-6169467.0,2483.0,6Series
-7487134.0,1768.0,7Series
-4750239.0,2436.0,0Series
-8880112.0,2849.0,5Series
-7774590.0,1691.0,2Series
-5586718.0,2071.0,7Series
-5857263.0,1333.0,7Series
-6416074.0,1080.0,7Series
-6994063.0,1053.0,1Series
-5797079.0,2061.0,2Series
-6283062.0,2142.0,5Series
-8431770.0,2224.0,5Series
-3311312.0,1015.0,7Series
-2843881.0,1229.0,6Series
-3077303.0,1717.0,5Series
-3454331.0,2734.0,5Series
-23250.0,2745.0,3Series
-3278167.0,571.0,9Series
-9952232.0,2553.0,2Series
-424923.0,1077.0,3Series
-1952050.0,2890.0,0Series
-7768468.0,29.0,2Series
-167725.0,845.0,6Series
-2651084.0,1655.0,2Series
-6283156.0,1368.0,7Series
-1753823.0,750.0,6Series
-5451533.0,2288.0,9Series
-5403108.0,2635.0,5Series
-168757.0,1337.0,4Series
-9394732.0,2478.0,3Series
-4358621.0,1407.0,6Series
-2362114.0,2952.0,9Series
-5565240.0,865.0,6Series
-3166724.0,901.0,0Series
-5592457.0,1864.0,6Series
-7575196.0,572.0,4Series
-4202614.0,1567.0,0Series
-2199957.0,1973.0,0Series
-511128.0,448.0,4Series
-580612.0,2488.0,4Series
-275342.0,907.0,6Series
-3215327.0,2507.0,3Series
-8069859.0,732.0,0Series
-6383562.0,2077.0,3Series
-6428516.0,1434.0,2Series
-5159121.0,1098.0,4Series
-3360388.0,813.0,5Series
-5152985.0,954.0,9Series
-3335480.0,613.0,5Series
-994815.0,2348.0,5Series
-507229.0,2192.0,0Series
-8976568.0,2826.0,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_203.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_203.csv b/integration-testcases/src/test/resources/hiveExpected/TC_203.csv
deleted file mode 100644
index 60da2b8..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_203.csv
+++ /dev/null
@@ -1,98 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
-6805600.0,1714.635,7Series
-8231335.0,1271.0,5Series
-8978765.0,692.0,5Series
-3784858.0,2175.0,7Series
-1602458.0,136.0,9Series
-9737768.0,1600.0,7Series
-2919786.0,505.0,0Series
-9455612.0,1341.0,0Series
-88231.0,2239.0,5Series
-1439363.0,2970.0,4Series
-3940720.0,2593.0,1Series
-4451217.0,2572.0,6Series
-335583.0,1991.0,9Series
-2389657.0,1841.0,0Series
-5986189.0,298.0,2Series
-8543280.0,79.0,3Series
-4816260.0,202.0,0Series
-8453995.0,568.0,4Series
-2051539.0,355.0,1Series
-7610075.0,151.0,5Series
-6663091.0,2863.0,4Series
-6495292.0,1873.0,3Series
-2611464.0,2205.0,9Series
-574375.0,441.0,8Series
-4459076.0,2194.0,5Series
-5204739.0,2972.0,0Series
-833654.0,256.0,5Series
-566917.0,1778.0,0Series
-832387.0,1999.0,5Series
-2850246.0,2194.0,5Series
-6169467.0,2483.0,6Series
-6533899.0,1724.0,0Series
-7487134.0,1768.0,7Series
-4750239.0,2436.0,0Series
-8880112.0,2849.0,5Series
-7774590.0,1691.0,2Series
-5586718.0,2071.0,7Series
-5857263.0,1333.0,7Series
-6416074.0,1080.0,7Series
-6994063.0,1053.0,1Series
-8229807.0,760.0,8Series
-5797079.0,2061.0,2Series
-6283062.0,2142.0,5Series
-8431770.0,2224.0,5Series
-3311312.0,1015.0,7Series
-2843881.0,1229.0,6Series
-1901889.0,1750.0,8Series
-3077303.0,1717.0,5Series
-3454331.0,2734.0,5Series
-23250.0,2745.0,3Series
-3278167.0,571.0,9Series
-5659107.0,1697.0,8Series
-9952232.0,2553.0,2Series
-424923.0,1077.0,3Series
-7839922.0,1823.0,9Series
-9500486.0,2399.0,3Series
-1952050.0,2890.0,0Series
-6190068.0,1608.0,8Series
-7768468.0,29.0,2Series
-7236919.0,1407.0,2Series
-167725.0,845.0,6Series
-2651084.0,1655.0,2Series
-6283156.0,1368.0,7Series
-7342321.0,1728.0,7Series
-1753823.0,750.0,6Series
-5451533.0,2288.0,9Series
-5403108.0,2635.0,5Series
-168757.0,1337.0,4Series
-9394732.0,2478.0,3Series
-7420815.0,538.0,8Series
-4358621.0,1407.0,6Series
-2362114.0,2952.0,9Series
-9318234.0,1226.0,2Series
-5565240.0,865.0,6Series
-3166724.0,901.0,0Series
-5592457.0,1864.0,6Series
-7575196.0,572.0,4Series
-3235086.0,412.0,8Series
-7917206.0,1491.0,8Series
-4156339.0,1350.0,8Series
-4202614.0,1567.0,0Series
-2199957.0,1973.0,0Series
-511128.0,448.0,4Series
-580612.0,2488.0,4Series
-275342.0,907.0,6Series
-3215327.0,2507.0,3Series
-8069859.0,732.0,0Series
-6383562.0,2077.0,3Series
-6428516.0,1434.0,2Series
-5159121.0,1098.0,4Series
-3360388.0,813.0,5Series
-5152985.0,954.0,9Series
-3335480.0,613.0,5Series
-994815.0,2348.0,5Series
-507229.0,2192.0,0Series
-8976568.0,2826.0,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_204.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_204.csv b/integration-testcases/src/test/resources/hiveExpected/TC_204.csv
deleted file mode 100644
index 22ea1ee..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_204.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
-6805600.0,1714.635,7Series
-8231335.0,1271.0,5Series
-8978765.0,692.0,5Series
-3784858.0,2175.0,7Series
-1602458.0,136.0,9Series
-9737768.0,1600.0,7Series
-2919786.0,505.0,0Series
-9455612.0,1341.0,0Series
-88231.0,2239.0,5Series
-1439363.0,2970.0,4Series
-3940720.0,2593.0,1Series
-4451217.0,2572.0,6Series
-335583.0,1991.0,9Series
-1070757.0,1442.0,8Series
-2389657.0,1841.0,0Series
-5986189.0,298.0,2Series
-8543280.0,79.0,3Series
-4816260.0,202.0,0Series
-8453995.0,568.0,4Series
-2051539.0,355.0,1Series
-7610075.0,151.0,5Series
-6663091.0,2863.0,4Series
-6495292.0,1873.0,3Series
-2611464.0,2205.0,9Series
-574375.0,441.0,8Series
-4459076.0,2194.0,5Series
-5204739.0,2972.0,0Series
-833654.0,256.0,5Series
-566917.0,1778.0,0Series
-832387.0,1999.0,5Series
-2850246.0,2194.0,5Series
-6169467.0,2483.0,6Series
-6533899.0,1724.0,0Series
-7487134.0,1768.0,7Series
-4750239.0,2436.0,0Series
-8880112.0,2849.0,5Series
-7774590.0,1691.0,2Series
-5586718.0,2071.0,7Series
-5857263.0,1333.0,7Series
-6416074.0,1080.0,7Series
-6994063.0,1053.0,1Series
-8229807.0,760.0,8Series
-5797079.0,2061.0,2Series
-6283062.0,2142.0,5Series
-8431770.0,2224.0,5Series
-3311312.0,1015.0,7Series
-2843881.0,1229.0,6Series
-1901889.0,1750.0,8Series
-3077303.0,1717.0,5Series
-7880439.0,2078.0,8Series
-3454331.0,2734.0,5Series
-23250.0,2745.0,3Series
-3278167.0,571.0,9Series
-5659107.0,1697.0,8Series
-9952232.0,2553.0,2Series
-424923.0,1077.0,3Series
-7839922.0,1823.0,9Series
-9500486.0,2399.0,3Series
-1952050.0,2890.0,0Series
-6190068.0,1608.0,8Series
-7768468.0,29.0,2Series
-7236919.0,1407.0,2Series
-167725.0,845.0,6Series
-2651084.0,1655.0,2Series
-6283156.0,1368.0,7Series
-7342321.0,1728.0,7Series
-1753823.0,750.0,6Series
-5451533.0,2288.0,9Series
-5403108.0,2635.0,5Series
-168757.0,1337.0,4Series
-9394732.0,2478.0,3Series
-7420815.0,538.0,8Series
-4358621.0,1407.0,6Series
-2362114.0,2952.0,9Series
-9318234.0,1226.0,2Series
-5565240.0,865.0,6Series
-3166724.0,901.0,0Series
-5592457.0,1864.0,6Series
-7575196.0,572.0,4Series
-3235086.0,412.0,8Series
-7917206.0,1491.0,8Series
-4156339.0,1350.0,8Series
-4202614.0,1567.0,0Series
-2199957.0,1973.0,0Series
-511128.0,448.0,4Series
-580612.0,2488.0,4Series
-275342.0,907.0,6Series
-3215327.0,2507.0,3Series
-8069859.0,732.0,0Series
-6383562.0,2077.0,3Series
-6428516.0,1434.0,2Series
-5159121.0,1098.0,4Series
-3360388.0,813.0,5Series
-5152985.0,954.0,9Series
-3335480.0,613.0,5Series
-994815.0,2348.0,5Series
-507229.0,2192.0,0Series
-8976568.0,2826.0,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_205.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_205.csv b/integration-testcases/src/test/resources/hiveExpected/TC_205.csv
deleted file mode 100644
index 7a9585a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_205.csv
+++ /dev/null
@@ -1,99 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-6805600.0,1714.635,7Series
-8231335.0,1271.0,5Series
-8978765.0,692.0,5Series
-3784858.0,2175.0,7Series
-1602458.0,136.0,9Series
-9737768.0,1600.0,7Series
-2919786.0,505.0,0Series
-9455612.0,1341.0,0Series
-88231.0,2239.0,5Series
-1439363.0,2970.0,4Series
-3940720.0,2593.0,1Series
-4451217.0,2572.0,6Series
-335583.0,1991.0,9Series
-1070757.0,1442.0,8Series
-2389657.0,1841.0,0Series
-5986189.0,298.0,2Series
-8543280.0,79.0,3Series
-4816260.0,202.0,0Series
-8453995.0,568.0,4Series
-2051539.0,355.0,1Series
-7610075.0,151.0,5Series
-6663091.0,2863.0,4Series
-6495292.0,1873.0,3Series
-2611464.0,2205.0,9Series
-574375.0,441.0,8Series
-4459076.0,2194.0,5Series
-5204739.0,2972.0,0Series
-833654.0,256.0,5Series
-566917.0,1778.0,0Series
-832387.0,1999.0,5Series
-2850246.0,2194.0,5Series
-6169467.0,2483.0,6Series
-6533899.0,1724.0,0Series
-7487134.0,1768.0,7Series
-4750239.0,2436.0,0Series
-8880112.0,2849.0,5Series
-7774590.0,1691.0,2Series
-5586718.0,2071.0,7Series
-5857263.0,1333.0,7Series
-6416074.0,1080.0,7Series
-6994063.0,1053.0,1Series
-8229807.0,760.0,8Series
-5797079.0,2061.0,2Series
-6283062.0,2142.0,5Series
-8431770.0,2224.0,5Series
-3311312.0,1015.0,7Series
-2843881.0,1229.0,6Series
-1901889.0,1750.0,8Series
-3077303.0,1717.0,5Series
-7880439.0,2078.0,8Series
-3454331.0,2734.0,5Series
-23250.0,2745.0,3Series
-3278167.0,571.0,9Series
-5659107.0,1697.0,8Series
-9952232.0,2553.0,2Series
-424923.0,1077.0,3Series
-7839922.0,1823.0,9Series
-9500486.0,2399.0,3Series
-1952050.0,2890.0,0Series
-6190068.0,1608.0,8Series
-7768468.0,29.0,2Series
-7236919.0,1407.0,2Series
-167725.0,845.0,6Series
-2651084.0,1655.0,2Series
-6283156.0,1368.0,7Series
-7342321.0,1728.0,7Series
-1753823.0,750.0,6Series
-5451533.0,2288.0,9Series
-5403108.0,2635.0,5Series
-168757.0,1337.0,4Series
-9394732.0,2478.0,3Series
-7420815.0,538.0,8Series
-4358621.0,1407.0,6Series
-2362114.0,2952.0,9Series
-9318234.0,1226.0,2Series
-5565240.0,865.0,6Series
-3166724.0,901.0,0Series
-5592457.0,1864.0,6Series
-7575196.0,572.0,4Series
-3235086.0,412.0,8Series
-7917206.0,1491.0,8Series
-4156339.0,1350.0,8Series
-4202614.0,1567.0,0Series
-2199957.0,1973.0,0Series
-511128.0,448.0,4Series
-580612.0,2488.0,4Series
-275342.0,907.0,6Series
-3215327.0,2507.0,3Series
-8069859.0,732.0,0Series
-6383562.0,2077.0,3Series
-6428516.0,1434.0,2Series
-5159121.0,1098.0,4Series
-3360388.0,813.0,5Series
-5152985.0,954.0,9Series
-3335480.0,613.0,5Series
-994815.0,2348.0,5Series
-507229.0,2192.0,0Series
-8976568.0,2826.0,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_206.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_206.csv b/integration-testcases/src/test/resources/hiveExpected/TC_206.csv
deleted file mode 100644
index eada300..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_206.csv
+++ /dev/null
@@ -1,99 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-5281803.0,2738.562,7Series
-8231335.0,1271.0,5Series
-8978765.0,692.0,5Series
-3784858.0,2175.0,7Series
-1602458.0,136.0,9Series
-9737768.0,1600.0,7Series
-2919786.0,505.0,0Series
-9455612.0,1341.0,0Series
-88231.0,2239.0,5Series
-1439363.0,2970.0,4Series
-3940720.0,2593.0,1Series
-4451217.0,2572.0,6Series
-335583.0,1991.0,9Series
-1070757.0,1442.0,8Series
-2389657.0,1841.0,0Series
-5986189.0,298.0,2Series
-8543280.0,79.0,3Series
-4816260.0,202.0,0Series
-8453995.0,568.0,4Series
-2051539.0,355.0,1Series
-7610075.0,151.0,5Series
-6663091.0,2863.0,4Series
-6495292.0,1873.0,3Series
-2611464.0,2205.0,9Series
-574375.0,441.0,8Series
-4459076.0,2194.0,5Series
-5204739.0,2972.0,0Series
-833654.0,256.0,5Series
-566917.0,1778.0,0Series
-832387.0,1999.0,5Series
-2850246.0,2194.0,5Series
-6169467.0,2483.0,6Series
-6533899.0,1724.0,0Series
-7487134.0,1768.0,7Series
-4750239.0,2436.0,0Series
-8880112.0,2849.0,5Series
-7774590.0,1691.0,2Series
-5586718.0,2071.0,7Series
-5857263.0,1333.0,7Series
-6416074.0,1080.0,7Series
-6994063.0,1053.0,1Series
-8229807.0,760.0,8Series
-5797079.0,2061.0,2Series
-6283062.0,2142.0,5Series
-8431770.0,2224.0,5Series
-3311312.0,1015.0,7Series
-2843881.0,1229.0,6Series
-1901889.0,1750.0,8Series
-3077303.0,1717.0,5Series
-7880439.0,2078.0,8Series
-3454331.0,2734.0,5Series
-23250.0,2745.0,3Series
-3278167.0,571.0,9Series
-5659107.0,1697.0,8Series
-9952232.0,2553.0,2Series
-424923.0,1077.0,3Series
-7839922.0,1823.0,9Series
-9500486.0,2399.0,3Series
-1952050.0,2890.0,0Series
-6190068.0,1608.0,8Series
-7768468.0,29.0,2Series
-7236919.0,1407.0,2Series
-167725.0,845.0,6Series
-2651084.0,1655.0,2Series
-6283156.0,1368.0,7Series
-7342321.0,1728.0,7Series
-1753823.0,750.0,6Series
-5451533.0,2288.0,9Series
-5403108.0,2635.0,5Series
-168757.0,1337.0,4Series
-9394732.0,2478.0,3Series
-7420815.0,538.0,8Series
-4358621.0,1407.0,6Series
-2362114.0,2952.0,9Series
-9318234.0,1226.0,2Series
-5565240.0,865.0,6Series
-3166724.0,901.0,0Series
-5592457.0,1864.0,6Series
-7575196.0,572.0,4Series
-3235086.0,412.0,8Series
-7917206.0,1491.0,8Series
-4156339.0,1350.0,8Series
-4202614.0,1567.0,0Series
-2199957.0,1973.0,0Series
-511128.0,448.0,4Series
-580612.0,2488.0,4Series
-275342.0,907.0,6Series
-3215327.0,2507.0,3Series
-8069859.0,732.0,0Series
-6383562.0,2077.0,3Series
-6428516.0,1434.0,2Series
-5159121.0,1098.0,4Series
-3360388.0,813.0,5Series
-5152985.0,954.0,9Series
-3335480.0,613.0,5Series
-994815.0,2348.0,5Series
-507229.0,2192.0,0Series
-8976568.0,2826.0,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_207.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_207.csv b/integration-testcases/src/test/resources/hiveExpected/TC_207.csv
deleted file mode 100644
index 2e8fa16..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_207.csv
+++ /dev/null
@@ -1,9 +0,0 @@
-contractNumber DoubleType,gamePointId DoubleType,series StringType
-1439363.0,2970.0,4Series
-6663091.0,2863.0,4Series
-5204739.0,2972.0,0Series
-8880112.0,2849.0,5Series
-23250.0,2745.0,3Series
-1952050.0,2890.0,0Series
-2362114.0,2952.0,9Series
-8976568.0,2826.0,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_208.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_208.csv b/integration-testcases/src/test/resources/hiveExpected/TC_208.csv
deleted file mode 100644
index c2bcb74..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_208.csv
+++ /dev/null
@@ -1,13 +0,0 @@
-a IntegerType
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_209.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_209.csv b/integration-testcases/src/test/resources/hiveExpected/TC_209.csv
deleted file mode 100644
index d90c505..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_209.csv
+++ /dev/null
@@ -1,17 +0,0 @@
-babu StringType,a NullType
-null,null
-null,null
-null,null
-null,null
-null,null
-null,null
-null,null
-null,null
-null,null
-null,null
-null,null
-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_210.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_210.csv b/integration-testcases/src/test/resources/hiveExpected/TC_210.csv
deleted file mode 100644
index 46f710a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_210.csv
+++ /dev/null
@@ -1,88 +0,0 @@
-Latest_DAY IntegerType
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_211.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_211.csv b/integration-testcases/src/test/resources/hiveExpected/TC_211.csv
deleted file mode 100644
index 46f710a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_211.csv
+++ /dev/null
@@ -1,88 +0,0 @@
-Latest_DAY IntegerType
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_212.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_212.csv b/integration-testcases/src/test/resources/hiveExpected/TC_212.csv
deleted file mode 100644
index 8fce686..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_212.csv
+++ /dev/null
@@ -1,88 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1,1
-1AA10,1
-1AA100,1
-1AA1000,1
-1AA10000,1
-1AA100000,1
-1AA100001,1
-1AA100002,1
-1AA100003,1
-1AA100004,1
-1AA100006,1
-1AA100007,1
-1AA100008,1
-1AA100009,1
-1AA10001,1
-1AA100010,1
-1AA100011,1
-1AA100012,1
-1AA100013,1
-1AA100014,1
-1AA100015,1
-1AA100016,1
-1AA100017,1
-1AA100018,1
-1AA100019,1
-1AA10002,1
-1AA100020,1
-1AA100021,1
-1AA100022,1
-1AA100023,1
-1AA100024,1
-1AA100029,1
-1AA10003,1
-1AA100030,1
-1AA100031,1
-1AA100032,1
-1AA100033,1
-1AA100035,1
-1AA100036,1
-1AA100037,1
-1AA100038,1
-1AA10004,1
-1AA100040,1
-1AA100041,1
-1AA100042,1
-1AA100043,1
-1AA100044,1
-1AA100045,1
-1AA100046,1
-1AA100047,1
-1AA100048,1
-1AA100049,1
-1AA10005,1
-1AA100051,1
-1AA100053,1
-1AA100054,1
-1AA100055,1
-1AA100056,1
-1AA100057,1
-1AA100058,1
-1AA100059,1
-1AA10006,1
-1AA100060,1
-1AA100062,1
-1AA100063,1
-1AA100064,1
-1AA100065,1
-1AA100066,1
-1AA100067,1
-1AA100068,1
-1AA100069,1
-1AA10007,1
-1AA100070,1
-1AA100071,1
-1AA100072,1
-1AA100073,1
-1AA100075,1
-1AA100076,1
-1AA100077,1
-1AA100078,1
-1AA100079,1
-1AA10008,1
-1AA100080,1
-1AA100081,1
-1AA100082,1
-1AA100083,1
-1AA100084,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_213.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_213.csv b/integration-testcases/src/test/resources/hiveExpected/TC_213.csv
deleted file mode 100644
index 05c187e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_213.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1,1
-1AA10,1
-1AA100,1
-1AA1000,1
-1AA10000,1
-1AA100000,1
-1AA1000000,1
-1AA100001,1
-1AA100002,1
-1AA100003,1
-1AA100004,1
-1AA100005,1
-1AA100006,1
-1AA100007,1
-1AA100008,1
-1AA100009,1
-1AA10001,1
-1AA100010,1
-1AA100011,1
-1AA100012,1
-1AA100013,1
-1AA100014,1
-1AA100015,1
-1AA100016,1
-1AA100017,1
-1AA100018,1
-1AA100019,1
-1AA10002,1
-1AA100020,1
-1AA100021,1
-1AA100022,1
-1AA100023,1
-1AA100024,1
-1AA100025,1
-1AA100026,1
-1AA100027,1
-1AA100028,1
-1AA100029,1
-1AA10003,1
-1AA100030,1
-1AA100031,1
-1AA100032,1
-1AA100033,1
-1AA100034,1
-1AA100035,1
-1AA100036,1
-1AA100037,1
-1AA100038,1
-1AA100039,1
-1AA10004,1
-1AA100040,1
-1AA100041,1
-1AA100042,1
-1AA100043,1
-1AA100044,1
-1AA100045,1
-1AA100046,1
-1AA100047,1
-1AA100048,1
-1AA100049,1
-1AA10005,1
-1AA100050,1
-1AA100051,1
-1AA100052,1
-1AA100053,1
-1AA100054,1
-1AA100055,1
-1AA100056,1
-1AA100057,1
-1AA100058,1
-1AA100059,1
-1AA10006,1
-1AA100060,1
-1AA100061,1
-1AA100062,1
-1AA100063,1
-1AA100064,1
-1AA100065,1
-1AA100066,1
-1AA100067,1
-1AA100068,1
-1AA100069,1
-1AA10007,1
-1AA100070,1
-1AA100071,1
-1AA100072,1
-1AA100073,1
-1AA100074,1
-1AA100075,1
-1AA100076,1
-1AA100077,1
-1AA100078,1
-1AA100079,1
-1AA10008,1
-1AA100080,1
-1AA100081,1
-1AA100082,1
-1AA100083,1
-1AA100084,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_214.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_214.csv b/integration-testcases/src/test/resources/hiveExpected/TC_214.csv
deleted file mode 100644
index a9212ac..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_214.csv
+++ /dev/null
@@ -1 +0,0 @@
-imei StringType,Latest_DAY IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_215.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_215.csv b/integration-testcases/src/test/resources/hiveExpected/TC_215.csv
deleted file mode 100644
index 6388411..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_215.csv
+++ /dev/null
@@ -1,13 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1000000,1
-1AA100005,1
-1AA100025,1
-1AA100026,1
-1AA100027,1
-1AA100028,1
-1AA100034,1
-1AA100039,1
-1AA100050,1
-1AA100052,1
-1AA100061,1
-1AA100074,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_216.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_216.csv b/integration-testcases/src/test/resources/hiveExpected/TC_216.csv
deleted file mode 100644
index 8fce686..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_216.csv
+++ /dev/null
@@ -1,88 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1,1
-1AA10,1
-1AA100,1
-1AA1000,1
-1AA10000,1
-1AA100000,1
-1AA100001,1
-1AA100002,1
-1AA100003,1
-1AA100004,1
-1AA100006,1
-1AA100007,1
-1AA100008,1
-1AA100009,1
-1AA10001,1
-1AA100010,1
-1AA100011,1
-1AA100012,1
-1AA100013,1
-1AA100014,1
-1AA100015,1
-1AA100016,1
-1AA100017,1
-1AA100018,1
-1AA100019,1
-1AA10002,1
-1AA100020,1
-1AA100021,1
-1AA100022,1
-1AA100023,1
-1AA100024,1
-1AA100029,1
-1AA10003,1
-1AA100030,1
-1AA100031,1
-1AA100032,1
-1AA100033,1
-1AA100035,1
-1AA100036,1
-1AA100037,1
-1AA100038,1
-1AA10004,1
-1AA100040,1
-1AA100041,1
-1AA100042,1
-1AA100043,1
-1AA100044,1
-1AA100045,1
-1AA100046,1
-1AA100047,1
-1AA100048,1
-1AA100049,1
-1AA10005,1
-1AA100051,1
-1AA100053,1
-1AA100054,1
-1AA100055,1
-1AA100056,1
-1AA100057,1
-1AA100058,1
-1AA100059,1
-1AA10006,1
-1AA100060,1
-1AA100062,1
-1AA100063,1
-1AA100064,1
-1AA100065,1
-1AA100066,1
-1AA100067,1
-1AA100068,1
-1AA100069,1
-1AA10007,1
-1AA100070,1
-1AA100071,1
-1AA100072,1
-1AA100073,1
-1AA100075,1
-1AA100076,1
-1AA100077,1
-1AA100078,1
-1AA100079,1
-1AA10008,1
-1AA100080,1
-1AA100081,1
-1AA100082,1
-1AA100083,1
-1AA100084,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_217.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_217.csv b/integration-testcases/src/test/resources/hiveExpected/TC_217.csv
deleted file mode 100644
index 6388411..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_217.csv
+++ /dev/null
@@ -1,13 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1000000,1
-1AA100005,1
-1AA100025,1
-1AA100026,1
-1AA100027,1
-1AA100028,1
-1AA100034,1
-1AA100039,1
-1AA100050,1
-1AA100052,1
-1AA100061,1
-1AA100074,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_218.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_218.csv b/integration-testcases/src/test/resources/hiveExpected/TC_218.csv
deleted file mode 100644
index a9212ac..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_218.csv
+++ /dev/null
@@ -1 +0,0 @@
-imei StringType,Latest_DAY IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_219.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_219.csv b/integration-testcases/src/test/resources/hiveExpected/TC_219.csv
deleted file mode 100644
index 05c187e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_219.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1,1
-1AA10,1
-1AA100,1
-1AA1000,1
-1AA10000,1
-1AA100000,1
-1AA1000000,1
-1AA100001,1
-1AA100002,1
-1AA100003,1
-1AA100004,1
-1AA100005,1
-1AA100006,1
-1AA100007,1
-1AA100008,1
-1AA100009,1
-1AA10001,1
-1AA100010,1
-1AA100011,1
-1AA100012,1
-1AA100013,1
-1AA100014,1
-1AA100015,1
-1AA100016,1
-1AA100017,1
-1AA100018,1
-1AA100019,1
-1AA10002,1
-1AA100020,1
-1AA100021,1
-1AA100022,1
-1AA100023,1
-1AA100024,1
-1AA100025,1
-1AA100026,1
-1AA100027,1
-1AA100028,1
-1AA100029,1
-1AA10003,1
-1AA100030,1
-1AA100031,1
-1AA100032,1
-1AA100033,1
-1AA100034,1
-1AA100035,1
-1AA100036,1
-1AA100037,1
-1AA100038,1
-1AA100039,1
-1AA10004,1
-1AA100040,1
-1AA100041,1
-1AA100042,1
-1AA100043,1
-1AA100044,1
-1AA100045,1
-1AA100046,1
-1AA100047,1
-1AA100048,1
-1AA100049,1
-1AA10005,1
-1AA100050,1
-1AA100051,1
-1AA100052,1
-1AA100053,1
-1AA100054,1
-1AA100055,1
-1AA100056,1
-1AA100057,1
-1AA100058,1
-1AA100059,1
-1AA10006,1
-1AA100060,1
-1AA100061,1
-1AA100062,1
-1AA100063,1
-1AA100064,1
-1AA100065,1
-1AA100066,1
-1AA100067,1
-1AA100068,1
-1AA100069,1
-1AA10007,1
-1AA100070,1
-1AA100071,1
-1AA100072,1
-1AA100073,1
-1AA100074,1
-1AA100075,1
-1AA100076,1
-1AA100077,1
-1AA100078,1
-1AA100079,1
-1AA10008,1
-1AA100080,1
-1AA100081,1
-1AA100082,1
-1AA100083,1
-1AA100084,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_220.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_220.csv b/integration-testcases/src/test/resources/hiveExpected/TC_220.csv
deleted file mode 100644
index 05c187e..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_220.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1,1
-1AA10,1
-1AA100,1
-1AA1000,1
-1AA10000,1
-1AA100000,1
-1AA1000000,1
-1AA100001,1
-1AA100002,1
-1AA100003,1
-1AA100004,1
-1AA100005,1
-1AA100006,1
-1AA100007,1
-1AA100008,1
-1AA100009,1
-1AA10001,1
-1AA100010,1
-1AA100011,1
-1AA100012,1
-1AA100013,1
-1AA100014,1
-1AA100015,1
-1AA100016,1
-1AA100017,1
-1AA100018,1
-1AA100019,1
-1AA10002,1
-1AA100020,1
-1AA100021,1
-1AA100022,1
-1AA100023,1
-1AA100024,1
-1AA100025,1
-1AA100026,1
-1AA100027,1
-1AA100028,1
-1AA100029,1
-1AA10003,1
-1AA100030,1
-1AA100031,1
-1AA100032,1
-1AA100033,1
-1AA100034,1
-1AA100035,1
-1AA100036,1
-1AA100037,1
-1AA100038,1
-1AA100039,1
-1AA10004,1
-1AA100040,1
-1AA100041,1
-1AA100042,1
-1AA100043,1
-1AA100044,1
-1AA100045,1
-1AA100046,1
-1AA100047,1
-1AA100048,1
-1AA100049,1
-1AA10005,1
-1AA100050,1
-1AA100051,1
-1AA100052,1
-1AA100053,1
-1AA100054,1
-1AA100055,1
-1AA100056,1
-1AA100057,1
-1AA100058,1
-1AA100059,1
-1AA10006,1
-1AA100060,1
-1AA100061,1
-1AA100062,1
-1AA100063,1
-1AA100064,1
-1AA100065,1
-1AA100066,1
-1AA100067,1
-1AA100068,1
-1AA100069,1
-1AA10007,1
-1AA100070,1
-1AA100071,1
-1AA100072,1
-1AA100073,1
-1AA100074,1
-1AA100075,1
-1AA100076,1
-1AA100077,1
-1AA100078,1
-1AA100079,1
-1AA10008,1
-1AA100080,1
-1AA100081,1
-1AA100082,1
-1AA100083,1
-1AA100084,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_221.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_221.csv b/integration-testcases/src/test/resources/hiveExpected/TC_221.csv
deleted file mode 100644
index 8fce686..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_221.csv
+++ /dev/null
@@ -1,88 +0,0 @@
-imei StringType,Latest_DAY IntegerType
-1AA1,1
-1AA10,1
-1AA100,1
-1AA1000,1
-1AA10000,1
-1AA100000,1
-1AA100001,1
-1AA100002,1
-1AA100003,1
-1AA100004,1
-1AA100006,1
-1AA100007,1
-1AA100008,1
-1AA100009,1
-1AA10001,1
-1AA100010,1
-1AA100011,1
-1AA100012,1
-1AA100013,1
-1AA100014,1
-1AA100015,1
-1AA100016,1
-1AA100017,1
-1AA100018,1
-1AA100019,1
-1AA10002,1
-1AA100020,1
-1AA100021,1
-1AA100022,1
-1AA100023,1
-1AA100024,1
-1AA100029,1
-1AA10003,1
-1AA100030,1
-1AA100031,1
-1AA100032,1
-1AA100033,1
-1AA100035,1
-1AA100036,1
-1AA100037,1
-1AA100038,1
-1AA10004,1
-1AA100040,1
-1AA100041,1
-1AA100042,1
-1AA100043,1
-1AA100044,1
-1AA100045,1
-1AA100046,1
-1AA100047,1
-1AA100048,1
-1AA100049,1
-1AA10005,1
-1AA100051,1
-1AA100053,1
-1AA100054,1
-1AA100055,1
-1AA100056,1
-1AA100057,1
-1AA100058,1
-1AA100059,1
-1AA10006,1
-1AA100060,1
-1AA100062,1
-1AA100063,1
-1AA100064,1
-1AA100065,1
-1AA100066,1
-1AA100067,1
-1AA100068,1
-1AA100069,1
-1AA10007,1
-1AA100070,1
-1AA100071,1
-1AA100072,1
-1AA100073,1
-1AA100075,1
-1AA100076,1
-1AA100077,1
-1AA100078,1
-1AA100079,1
-1AA10008,1
-1AA100080,1
-1AA100081,1
-1AA100082,1
-1AA100083,1
-1AA100084,1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_222.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_222.csv b/integration-testcases/src/test/resources/hiveExpected/TC_222.csv
deleted file mode 100644
index a9212ac..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_222.csv
+++ /dev/null
@@ -1 +0,0 @@
-imei StringType,Latest_DAY IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_223.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_223.csv b/integration-testcases/src/test/resources/hiveExpected/TC_223.csv
deleted file mode 100644
index 3a5785d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_223.csv
+++ /dev/null
@@ -1,18 +0,0 @@
-babu IntegerType,Latest_MONTH IntegerType
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
-7,7
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_224.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_224.csv b/integration-testcases/src/test/resources/hiveExpected/TC_224.csv
deleted file mode 100644
index c1c238d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_224.csv
+++ /dev/null
@@ -1 +0,0 @@
-babu IntegerType,Latest_MONTH IntegerType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_225.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_225.csv b/integration-testcases/src/test/resources/hiveExpected/TC_225.csv
deleted file mode 100644
index 5ce051c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_225.csv
+++ /dev/null
@@ -1,88 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA1,2738.562
-1AA10,1714.635
-1AA100,1271.0
-1AA1000,692.0
-1AA10000,2175.0
-1AA1000000,1600.0
-1AA100002,1341.0
-1AA100003,2239.0
-1AA100004,2970.0
-1AA100005,2593.0
-1AA100006,2572.0
-1AA100007,1991.0
-1AA100008,1442.0
-1AA100009,1841.0
-1AA100012,568.0
-1AA100015,2863.0
-1AA100016,1873.0
-1AA100017,2205.0
-1AA100019,2194.0
-1AA10002,2972.0
-1AA100021,1778.0
-1AA100022,1999.0
-1AA100023,2194.0
-1AA100024,2483.0
-1AA100025,1724.0
-1AA100026,1768.0
-1AA100027,2436.0
-1AA100028,2849.0
-1AA100029,1691.0
-1AA10003,2071.0
-1AA100030,1333.0
-1AA100031,1080.0
-1AA100032,1053.0
-1AA100033,760.0
-1AA100034,2061.0
-1AA100035,2142.0
-1AA100036,2224.0
-1AA100037,1015.0
-1AA100038,1229.0
-1AA100039,1750.0
-1AA10004,1717.0
-1AA100040,2078.0
-1AA100041,2734.0
-1AA100042,2745.0
-1AA100043,571.0
-1AA100044,1697.0
-1AA100045,2553.0
-1AA100046,1077.0
-1AA100047,1823.0
-1AA100048,2399.0
-1AA100049,2890.0
-1AA10005,1608.0
-1AA100051,1407.0
-1AA100052,845.0
-1AA100053,1655.0
-1AA100054,1368.0
-1AA100055,1728.0
-1AA100056,750.0
-1AA100057,2288.0
-1AA100058,2635.0
-1AA100059,1337.0
-1AA10006,2478.0
-1AA100060,538.0
-1AA100061,1407.0
-1AA100062,2952.0
-1AA100063,1226.0
-1AA100064,865.0
-1AA100065,901.0
-1AA100066,1864.0
-1AA100067,572.0
-1AA100069,1491.0
-1AA10007,1350.0
-1AA100070,1567.0
-1AA100071,1973.0
-1AA100073,2488.0
-1AA100074,907.0
-1AA100075,2507.0
-1AA100076,732.0
-1AA100077,2077.0
-1AA100078,1434.0
-1AA100079,1098.0
-1AA10008,813.0
-1AA100080,954.0
-1AA100081,613.0
-1AA100082,2348.0
-1AA100083,2192.0
-1AA100084,2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_226.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_226.csv b/integration-testcases/src/test/resources/hiveExpected/TC_226.csv
deleted file mode 100644
index 0dd50dc..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_226.csv
+++ /dev/null
@@ -1,12 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA100000,136.0
-1AA10001,298.0
-1AA100010,79.0
-1AA100011,202.0
-1AA100013,355.0
-1AA100014,151.0
-1AA100018,441.0
-1AA100020,256.0
-1AA100050,29.0
-1AA100068,412.0
-1AA100072,448.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_227.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_227.csv b/integration-testcases/src/test/resources/hiveExpected/TC_227.csv
deleted file mode 100644
index 879fac2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_227.csv
+++ /dev/null
@@ -1,13 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA10000,2175.0
-1AA100005,2593.0
-1AA100008,1442.0
-1AA100011,202.0
-1AA100015,2863.0
-1AA100025,1724.0
-1AA100031,1080.0
-1AA100039,1750.0
-1AA100041,2734.0
-1AA100047,1823.0
-1AA100048,2399.0
-1AA100050,29.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_228.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_228.csv b/integration-testcases/src/test/resources/hiveExpected/TC_228.csv
deleted file mode 100644
index b252681..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_228.csv
+++ /dev/null
@@ -1,78 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA1,2738.562
-1AA10,1714.635
-1AA100,1271.0
-1AA1000,692.0
-1AA100000,136.0
-1AA1000000,1600.0
-1AA100001,505.0
-1AA100002,1341.0
-1AA100003,2239.0
-1AA100007,1991.0
-1AA100009,1841.0
-1AA10001,298.0
-1AA100010,79.0
-1AA100013,355.0
-1AA100014,151.0
-1AA100016,1873.0
-1AA100017,2205.0
-1AA100018,441.0
-1AA100019,2194.0
-1AA10002,2972.0
-1AA100020,256.0
-1AA100021,1778.0
-1AA100022,1999.0
-1AA100023,2194.0
-1AA100026,1768.0
-1AA100027,2436.0
-1AA100028,2849.0
-1AA100029,1691.0
-1AA10003,2071.0
-1AA100030,1333.0
-1AA100032,1053.0
-1AA100033,760.0
-1AA100034,2061.0
-1AA100035,2142.0
-1AA100036,2224.0
-1AA100037,1015.0
-1AA100038,1229.0
-1AA10004,1717.0
-1AA100040,2078.0
-1AA100042,2745.0
-1AA100043,571.0
-1AA100045,2553.0
-1AA100046,1077.0
-1AA100049,2890.0
-1AA100051,1407.0
-1AA100052,845.0
-1AA100053,1655.0
-1AA100055,1728.0
-1AA100056,750.0
-1AA100057,2288.0
-1AA100058,2635.0
-1AA100059,1337.0
-1AA10006,2478.0
-1AA100060,538.0
-1AA100061,1407.0
-1AA100062,2952.0
-1AA100063,1226.0
-1AA100064,865.0
-1AA100065,901.0
-1AA100066,1864.0
-1AA100067,572.0
-1AA100068,412.0
-1AA100069,1491.0
-1AA10007,1350.0
-1AA100070,1567.0
-1AA100071,1973.0
-1AA100072,448.0
-1AA100074,907.0
-1AA100075,2507.0
-1AA100076,732.0
-1AA100077,2077.0
-1AA100078,1434.0
-1AA100079,1098.0
-1AA10008,813.0
-1AA100080,954.0
-1AA100082,2348.0
-1AA100084,2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_229.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_229.csv b/integration-testcases/src/test/resources/hiveExpected/TC_229.csv
deleted file mode 100644
index 51794e8..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_229.csv
+++ /dev/null
@@ -1,89 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA1,2738.562
-1AA10,1714.635
-1AA100,1271.0
-1AA1000,692.0
-1AA10000,2175.0
-1AA1000000,1600.0
-1AA100001,505.0
-1AA100002,1341.0
-1AA100003,2239.0
-1AA100004,2970.0
-1AA100005,2593.0
-1AA100006,2572.0
-1AA100007,1991.0
-1AA100008,1442.0
-1AA100009,1841.0
-1AA100012,568.0
-1AA100015,2863.0
-1AA100016,1873.0
-1AA100017,2205.0
-1AA100019,2194.0
-1AA10002,2972.0
-1AA100021,1778.0
-1AA100022,1999.0
-1AA100023,2194.0
-1AA100024,2483.0
-1AA100025,1724.0
-1AA100026,1768.0
-1AA100027,2436.0
-1AA100028,2849.0
-1AA100029,1691.0
-1AA10003,2071.0
-1AA100030,1333.0
-1AA100031,1080.0
-1AA100032,1053.0
-1AA100033,760.0
-1AA100034,2061.0
-1AA100035,2142.0
-1AA100036,2224.0
-1AA100037,1015.0
-1AA100038,1229.0
-1AA100039,1750.0
-1AA10004,1717.0
-1AA100040,2078.0
-1AA100041,2734.0
-1AA100042,2745.0
-1AA100043,571.0
-1AA100044,1697.0
-1AA100045,2553.0
-1AA100046,1077.0
-1AA100047,1823.0
-1AA100048,2399.0
-1AA100049,2890.0
-1AA10005,1608.0
-1AA100051,1407.0
-1AA100052,845.0
-1AA100053,1655.0
-1AA100054,1368.0
-1AA100055,1728.0
-1AA100056,750.0
-1AA100057,2288.0
-1AA100058,2635.0
-1AA100059,1337.0
-1AA10006,2478.0
-1AA100060,538.0
-1AA100061,1407.0
-1AA100062,2952.0
-1AA100063,1226.0
-1AA100064,865.0
-1AA100065,901.0
-1AA100066,1864.0
-1AA100067,572.0
-1AA100069,1491.0
-1AA10007,1350.0
-1AA100070,1567.0
-1AA100071,1973.0
-1AA100073,2488.0
-1AA100074,907.0
-1AA100075,2507.0
-1AA100076,732.0
-1AA100077,2077.0
-1AA100078,1434.0
-1AA100079,1098.0
-1AA10008,813.0
-1AA100080,954.0
-1AA100081,613.0
-1AA100082,2348.0
-1AA100083,2192.0
-1AA100084,2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_230.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_230.csv b/integration-testcases/src/test/resources/hiveExpected/TC_230.csv
deleted file mode 100644
index 11ccfa0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_230.csv
+++ /dev/null
@@ -1,13 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA100000,136.0
-1AA100001,505.0
-1AA10001,298.0
-1AA100010,79.0
-1AA100011,202.0
-1AA100013,355.0
-1AA100014,151.0
-1AA100018,441.0
-1AA100020,256.0
-1AA100050,29.0
-1AA100068,412.0
-1AA100072,448.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_231.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_231.csv b/integration-testcases/src/test/resources/hiveExpected/TC_231.csv
deleted file mode 100644
index d4a4cc2..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_231.csv
+++ /dev/null
@@ -1,23 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA10000,2175.0
-1AA100004,2970.0
-1AA100005,2593.0
-1AA100006,2572.0
-1AA100008,1442.0
-1AA100011,202.0
-1AA100012,568.0
-1AA100015,2863.0
-1AA100024,2483.0
-1AA100025,1724.0
-1AA100031,1080.0
-1AA100039,1750.0
-1AA100041,2734.0
-1AA100044,1697.0
-1AA100047,1823.0
-1AA100048,2399.0
-1AA10005,1608.0
-1AA100050,29.0
-1AA100054,1368.0
-1AA100073,2488.0
-1AA100081,613.0
-1AA100083,2192.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_232.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_232.csv b/integration-testcases/src/test/resources/hiveExpected/TC_232.csv
deleted file mode 100644
index c2a9656..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_232.csv
+++ /dev/null
@@ -1,88 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA1,2738.562
-1AA10,1714.635
-1AA100,1271.0
-1AA1000,692.0
-1AA100000,136.0
-1AA1000000,1600.0
-1AA100001,505.0
-1AA100002,1341.0
-1AA100003,2239.0
-1AA100004,2970.0
-1AA100006,2572.0
-1AA100007,1991.0
-1AA100009,1841.0
-1AA10001,298.0
-1AA100010,79.0
-1AA100012,568.0
-1AA100013,355.0
-1AA100014,151.0
-1AA100016,1873.0
-1AA100017,2205.0
-1AA100018,441.0
-1AA100019,2194.0
-1AA10002,2972.0
-1AA100020,256.0
-1AA100021,1778.0
-1AA100022,1999.0
-1AA100023,2194.0
-1AA100024,2483.0
-1AA100026,1768.0
-1AA100027,2436.0
-1AA100028,2849.0
-1AA100029,1691.0
-1AA10003,2071.0
-1AA100030,1333.0
-1AA100032,1053.0
-1AA100033,760.0
-1AA100034,2061.0
-1AA100035,2142.0
-1AA100036,2224.0
-1AA100037,1015.0
-1AA100038,1229.0
-1AA10004,1717.0
-1AA100040,2078.0
-1AA100042,2745.0
-1AA100043,571.0
-1AA100044,1697.0
-1AA100045,2553.0
-1AA100046,1077.0
-1AA100049,2890.0
-1AA10005,1608.0
-1AA100051,1407.0
-1AA100052,845.0
-1AA100053,1655.0
-1AA100054,1368.0
-1AA100055,1728.0
-1AA100056,750.0
-1AA100057,2288.0
-1AA100058,2635.0
-1AA100059,1337.0
-1AA10006,2478.0
-1AA100060,538.0
-1AA100061,1407.0
-1AA100062,2952.0
-1AA100063,1226.0
-1AA100064,865.0
-1AA100065,901.0
-1AA100066,1864.0
-1AA100067,572.0
-1AA100068,412.0
-1AA100069,1491.0
-1AA10007,1350.0
-1AA100070,1567.0
-1AA100071,1973.0
-1AA100072,448.0
-1AA100073,2488.0
-1AA100074,907.0
-1AA100075,2507.0
-1AA100076,732.0
-1AA100077,2077.0
-1AA100078,1434.0
-1AA100079,1098.0
-1AA10008,813.0
-1AA100080,954.0
-1AA100081,613.0
-1AA100082,2348.0
-1AA100083,2192.0
-1AA100084,2826.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_233.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_233.csv b/integration-testcases/src/test/resources/hiveExpected/TC_233.csv
deleted file mode 100644
index ab0ed73..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_233.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA10000,2175.0,1,7Series
-1AA100031,1080.0,1,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_234.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_234.csv b/integration-testcases/src/test/resources/hiveExpected/TC_234.csv
deleted file mode 100644
index 55a2ac9..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_234.csv
+++ /dev/null
@@ -1,22 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA1,2738.562,4,7Series
-1AA10,1714.635,4,7Series
-1AA10000,2175.0,1,7Series
-1AA1000000,1600.0,6,7Series
-1AA100005,2593.0,1,1Series
-1AA100008,1442.0,1,8Series
-1AA100011,202.0,1,0Series
-1AA100015,2863.0,1,4Series
-1AA100025,1724.0,1,0Series
-1AA100026,1768.0,7,7Series
-1AA10003,2071.0,4,7Series
-1AA100030,1333.0,3,7Series
-1AA100031,1080.0,1,7Series
-1AA100037,1015.0,6,7Series
-1AA100039,1750.0,1,8Series
-1AA100041,2734.0,1,5Series
-1AA100047,1823.0,1,9Series
-1AA100048,2399.0,1,3Series
-1AA100050,29.0,1,2Series
-1AA100054,1368.0,2,7Series
-1AA100055,1728.0,7,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_235.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_235.csv b/integration-testcases/src/test/resources/hiveExpected/TC_235.csv
deleted file mode 100644
index 6f2dbd0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_235.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100005,2593.0,1,1Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_236.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_236.csv b/integration-testcases/src/test/resources/hiveExpected/TC_236.csv
deleted file mode 100644
index 95138c0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_236.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-a DoubleType
-2593.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_237.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_237.csv b/integration-testcases/src/test/resources/hiveExpected/TC_237.csv
deleted file mode 100644
index dd9c60b..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_237.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType,a StringType
-1AA100060,null
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_238.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_238.csv b/integration-testcases/src/test/resources/hiveExpected/TC_238.csv
deleted file mode 100644
index 973f11a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_238.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType
-1AA1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_239.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_239.csv b/integration-testcases/src/test/resources/hiveExpected/TC_239.csv
deleted file mode 100644
index 2680d9d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_239.csv
+++ /dev/null
@@ -1,17 +0,0 @@
-deliveryCity StringType
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_240.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_240.csv b/integration-testcases/src/test/resources/hiveExpected/TC_240.csv
deleted file mode 100644
index d685675..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_240.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-channelsId StringType
-4
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_241.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_241.csv b/integration-testcases/src/test/resources/hiveExpected/TC_241.csv
deleted file mode 100644
index 973f11a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_241.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType
-1AA1
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_242.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_242.csv b/integration-testcases/src/test/resources/hiveExpected/TC_242.csv
deleted file mode 100644
index 171c047..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_242.csv
+++ /dev/null
@@ -1,13 +0,0 @@
-channelsId StringType
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_243.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_243.csv b/integration-testcases/src/test/resources/hiveExpected/TC_243.csv
deleted file mode 100644
index 2680d9d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_243.csv
+++ /dev/null
@@ -1,17 +0,0 @@
-deliveryCity StringType
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_244.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_244.csv b/integration-testcases/src/test/resources/hiveExpected/TC_244.csv
deleted file mode 100644
index 5c19a95..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_244.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-imei StringType,gamePointId DoubleType
-1AA1,2738.562
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_245.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_245.csv b/integration-testcases/src/test/resources/hiveExpected/TC_245.csv
deleted file mode 100644
index 171c047..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_245.csv
+++ /dev/null
@@ -1,13 +0,0 @@
-channelsId StringType
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
-4
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_246.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_246.csv b/integration-testcases/src/test/resources/hiveExpected/TC_246.csv
deleted file mode 100644
index 2680d9d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_246.csv
+++ /dev/null
@@ -1,17 +0,0 @@
-deliveryCity StringType
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
-yichang
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_247.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_247.csv b/integration-testcases/src/test/resources/hiveExpected/TC_247.csv
deleted file mode 100644
index e9beed4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_247.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100010,79.0,6,3Series
-1AA100000,136.0,6,9Series
-1AA100020,256.0,7,5Series
-1AA10001,298.0,5,2Series
-1AA100013,355.0,6,1Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_248.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_248.csv b/integration-testcases/src/test/resources/hiveExpected/TC_248.csv
deleted file mode 100644
index 40689c1..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_248.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100050,29.0,1,2Series
-1AA100014,151.0,3,5Series
-1AA100011,202.0,1,0Series
-1AA100012,568.0,2,4Series
-1AA100081,613.0,2,5Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_249.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_249.csv b/integration-testcases/src/test/resources/hiveExpected/TC_249.csv
deleted file mode 100644
index e9beed4..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_249.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100010,79.0,6,3Series
-1AA100000,136.0,6,9Series
-1AA100020,256.0,7,5Series
-1AA10001,298.0,5,2Series
-1AA100013,355.0,6,1Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_250.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_250.csv b/integration-testcases/src/test/resources/hiveExpected/TC_250.csv
deleted file mode 100644
index 5aa8ff8..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_250.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100050,29.0,1,2Series
-1AA100014,151.0,3,5Series
-1AA100011,202.0,1,0Series
-1AA100018,441.0,4,8Series
-1AA100060,538.0,4,8Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_251.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_251.csv b/integration-testcases/src/test/resources/hiveExpected/TC_251.csv
deleted file mode 100644
index 6319e94..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_251.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA10001,298.0,5,2Series
-1AA100018,441.0,4,8Series
-1AA100060,538.0,4,8Series
-1AA100056,750.0,5,6Series
-1AA10008,813.0,4,5Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_252.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_252.csv b/integration-testcases/src/test/resources/hiveExpected/TC_252.csv
deleted file mode 100644
index 5c156eb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_252.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100050,29.0,1,2Series
-1AA100010,79.0,6,3Series
-1AA100000,136.0,6,9Series
-1AA100014,151.0,3,5Series
-1AA100011,202.0,1,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_253.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_253.csv b/integration-testcases/src/test/resources/hiveExpected/TC_253.csv
deleted file mode 100644
index 244191a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_253.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100018,441.0,4,8Series
-1AA100060,538.0,4,8Series
-1AA10008,813.0,4,5Series
-1AA100046,1077.0,4,3Series
-1AA10,1714.635,4,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_254.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_254.csv b/integration-testcases/src/test/resources/hiveExpected/TC_254.csv
deleted file mode 100644
index 5c156eb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_254.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100050,29.0,1,2Series
-1AA100010,79.0,6,3Series
-1AA100000,136.0,6,9Series
-1AA100014,151.0,3,5Series
-1AA100011,202.0,1,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_255.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_255.csv b/integration-testcases/src/test/resources/hiveExpected/TC_255.csv
deleted file mode 100644
index 244191a..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_255.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100018,441.0,4,8Series
-1AA100060,538.0,4,8Series
-1AA10008,813.0,4,5Series
-1AA100046,1077.0,4,3Series
-1AA10,1714.635,4,7Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_256.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_256.csv b/integration-testcases/src/test/resources/hiveExpected/TC_256.csv
deleted file mode 100644
index 5c156eb..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_256.csv
+++ /dev/null
@@ -1,6 +0,0 @@
-imei StringType,gamePointId DoubleType,channelsId StringType,series StringType
-1AA100050,29.0,1,2Series
-1AA100010,79.0,6,3Series
-1AA100000,136.0,6,9Series
-1AA100014,151.0,3,5Series
-1AA100011,202.0,1,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_257.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_257.csv b/integration-testcases/src/test/resources/hiveExpected/TC_257.csv
deleted file mode 100644
index b47c9ad..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_257.csv
+++ /dev/null
@@ -1,4 +0,0 @@
-imei StringType,internalModels StringType,series StringType
-1AA1000000,7Internal models,7Series
-1AA100008,8Internal models,8Series
-1AA100040,8Internal models,8Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_258.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_258.csv b/integration-testcases/src/test/resources/hiveExpected/TC_258.csv
deleted file mode 100644
index 217fe72..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_258.csv
+++ /dev/null
@@ -1,40 +0,0 @@
-imei StringType,internalModels StringType,series StringType
-1AA1,9Internal models,7Series
-1AA10,2Internal models,7Series
-1AA1000,7Internal models,5Series
-1AA10000,4Internal models,7Series
-1AA1000000,7Internal models,7Series
-1AA100003,8Internal models,5Series
-1AA100007,8Internal models,9Series
-1AA100008,8Internal models,8Series
-1AA100011,7Internal models,0Series
-1AA100018,3Internal models,8Series
-1AA100020,8Internal models,5Series
-1AA100021,7Internal models,0Series
-1AA100022,7Internal models,5Series
-1AA100025,8Internal models,0Series
-1AA100026,5Internal models,7Series
-1AA100029,7Internal models,2Series
-1AA10003,2Internal models,7Series
-1AA100030,1Internal models,7Series
-1AA100031,4Internal models,7Series
-1AA100033,1Internal models,8Series
-1AA100037,4Internal models,7Series
-1AA100039,9Internal models,8Series
-1AA100040,8Internal models,8Series
-1AA100044,4Internal models,8Series
-1AA100047,8Internal models,9Series
-1AA100048,8Internal models,3Series
-1AA10005,5Internal models,8Series
-1AA100051,8Internal models,2Series
-1AA100054,2Internal models,7Series
-1AA100055,8Internal models,7Series
-1AA100060,0Internal models,8Series
-1AA100063,8Internal models,2Series
-1AA100064,7Internal models,6Series
-1AA100068,6Internal models,8Series
-1AA100069,1Internal models,8Series
-1AA10007,7Internal models,8Series
-1AA100078,7Internal models,2Series
-1AA10008,7Internal models,5Series
-1AA100084,7Internal models,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_259.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_259.csv b/integration-testcases/src/test/resources/hiveExpected/TC_259.csv
deleted file mode 100644
index 63c22fa..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_259.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-imei StringType,internalModels StringType,series StringType
-1AA100055,8Internal models,7Series
-1AA10007,7Internal models,8Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_260.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_260.csv b/integration-testcases/src/test/resources/hiveExpected/TC_260.csv
deleted file mode 100644
index f48aef0..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_260.csv
+++ /dev/null
@@ -1,100 +0,0 @@
-imei StringType,internalModels StringType,series StringType
-1AA1,9Internal models,7Series
-1AA10,2Internal models,7Series
-1AA100,0Internal models,5Series
-1AA1000,7Internal models,5Series
-1AA10000,4Internal models,7Series
-1AA100000,9Internal models,9Series
-1AA1000000,7Internal models,7Series
-1AA100001,2Internal models,0Series
-1AA100002,2Internal models,0Series
-1AA100003,8Internal models,5Series
-1AA100004,0Internal models,4Series
-1AA100005,9Internal models,1Series
-1AA100006,9Internal models,6Series
-1AA100007,8Internal models,9Series
-1AA100008,8Internal models,8Series
-1AA100009,1Internal models,0Series
-1AA10001,2Internal models,2Series
-1AA100010,6Internal models,3Series
-1AA100011,7Internal models,0Series
-1AA100012,5Internal models,4Series
-1AA100013,3Internal models,1Series
-1AA100014,5Internal models,5Series
-1AA100015,0Internal models,4Series
-1AA100016,9Internal models,3Series
-1AA100017,1Internal models,9Series
-1AA100018,3Internal models,8Series
-1AA100019,2Internal models,5Series
-1AA10002,6Internal models,0Series
-1AA100020,8Internal models,5Series
-1AA100021,7Internal models,0Series
-1AA100022,7Internal models,5Series
-1AA100023,0Internal models,5Series
-1AA100024,6Internal models,6Series
-1AA100025,8Internal models,0Series
-1AA100026,5Internal models,7Series
-1AA100027,2Internal models,0Series
-1AA100028,1Internal models,5Series
-1AA100029,7Internal models,2Series
-1AA10003,2Internal models,7Series
-1AA100030,1Internal models,7Series
-1AA100031,4Internal models,7Series
-1AA100032,3Internal models,1Series
-1AA100033,1Internal models,8Series
-1AA100034,5Internal models,2Series
-1AA100035,0Internal models,5Series
-1AA100036,6Internal models,5Series
-1AA100037,4Internal models,7Series
-1AA100038,3Internal models,6Series
-1AA100039,9Internal models,8Series
-1AA10004,1Internal models,5Series
-1AA100040,8Internal models,8Series
-1AA100041,1Internal models,5Series
-1AA100042,1Internal models,3Series
-1AA100043,3Internal models,9Series
-1AA100044,4Internal models,8Series
-1AA100045,0Internal models,2Series
-1AA100046,4Internal models,3Series
-1AA100047,8Internal models,9Series
-1AA100048,8Internal models,3Series
-1AA100049,2Internal models,0Series
-1AA10005,5Internal models,8Series
-1AA100050,9Internal models,2Series
-1AA100051,8Internal models,2Series
-1AA100052,3Internal models,6Series
-1AA100053,1Internal models,2Series
-1AA100054,2Internal models,7Series
-1AA100055,8Internal models,7Series
-1AA100056,3Internal models,6Series
-1AA100057,3Internal models,9Series
-1AA100058,9Internal models,5Series
-1AA100059,3Internal models,4Series
-1AA10006,6Internal models,3Series
-1AA100060,0Internal models,8Series
-1AA100061,2Internal models,6Series
-1AA100062,3Internal models,9Series
-1AA100063,8Internal models,2Series
-1AA100064,7Internal models,6Series
-1AA100065,5Internal models,0Series
-1AA100066,3Internal models,6Series
-1AA100067,3Internal models,4Series
-1AA100068,6Internal models,8Series
-1AA100069,1Internal models,8Series
-1AA10007,7Internal models,8Series
-1AA100070,2Internal models,0Series
-1AA100071,0Internal models,0Series
-1AA100072,0Internal models,4Series
-1AA100073,5Internal models,4Series
-1AA100074,3Internal models,6Series
-1AA100075,3Internal models,3Series
-1AA100076,0Internal models,0Series
-1AA100077,5Internal models,3Series
-1AA100078,7Internal models,2Series
-1AA100079,5Internal models,4Series
-1AA10008,7Internal models,5Series
-1AA100080,4Internal models,9Series
-1AA100081,4Internal models,5Series
-1AA100082,9Internal models,5Series
-1AA100083,9Internal models,0Series
-1AA100084,7Internal models,0Series
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_261.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_261.csv b/integration-testcases/src/test/resources/hiveExpected/TC_261.csv
deleted file mode 100644
index 30edeac..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_261.csv
+++ /dev/null
@@ -1,32 +0,0 @@
-imei StringType
-1AA1
-1AA1000000
-1AA100001
-1AA100002
-1AA100005
-1AA100008
-1AA100015
-1AA100019
-1AA100020
-1AA100022
-1AA100025
-1AA100026
-1AA100027
-1AA100028
-1AA100032
-1AA100033
-1AA100034
-1AA100037
-1AA100039
-1AA100044
-1AA100048
-1AA10005
-1AA100050
-1AA100052
-1AA100054
-1AA100061
-1AA10007
-1AA100074
-1AA100075
-1AA100077
-1AA100082
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_262.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_262.csv b/integration-testcases/src/test/resources/hiveExpected/TC_262.csv
deleted file mode 100644
index 0916c05..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_262.csv
+++ /dev/null
@@ -1 +0,0 @@
-_c0 LongType,series StringType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_263.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_263.csv b/integration-testcases/src/test/resources/hiveExpected/TC_263.csv
deleted file mode 100644
index eb63c6d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_263.csv
+++ /dev/null
@@ -1,50 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType
-0RAM size,1,2849.0
-0RAM size,2,79.0
-0RAM size,3,7663.0
-0RAM size,5,1341.0
-0RAM size,6,6082.0
-1RAM size,1,256.0
-1RAM size,2,1333.0
-1RAM size,4,7510.0
-1RAM size,5,2745.0
-1RAM size,7,3942.0
-2RAM size,3,1973.0
-2RAM size,4,1350.0
-3RAM size,1,6640.0
-3RAM size,2,1999.0
-3RAM size,3,2863.0
-3RAM size,4,3824.0
-3RAM size,5,5699.0
-3RAM size,6,2635.0
-3RAM size,7,1491.0
-4RAM size,1,2255.0
-4RAM size,2,1728.0
-4RAM size,3,9130.0
-4RAM size,4,11560.0
-4RAM size,6,5344.635
-4RAM size,7,1338.0
-5RAM size,2,4712.0
-5RAM size,3,2769.0
-5RAM size,6,2478.0
-6RAM size,1,2142.0
-6RAM size,2,1768.0
-6RAM size,3,2633.0
-6RAM size,4,866.0
-6RAM size,5,2952.0
-6RAM size,6,3257.0
-7RAM size,3,151.0
-7RAM size,5,2239.0
-7RAM size,6,3979.0
-7RAM size,7,2031.0
-8RAM size,1,355.0
-8RAM size,2,2738.562
-8RAM size,4,3102.0
-8RAM size,5,2684.0
-8RAM size,6,2970.0
-8RAM size,7,5166.0
-9RAM size,1,3065.0
-9RAM size,3,3239.0
-9RAM size,4,5821.0
-9RAM size,6,1567.0
-9RAM size,7,571.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_264.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_264.csv b/integration-testcases/src/test/resources/hiveExpected/TC_264.csv
deleted file mode 100644
index 35b7f04..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_264.csv
+++ /dev/null
@@ -1 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_265.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_265.csv b/integration-testcases/src/test/resources/hiveExpected/TC_265.csv
deleted file mode 100644
index eb63c6d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_265.csv
+++ /dev/null
@@ -1,50 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType
-0RAM size,1,2849.0
-0RAM size,2,79.0
-0RAM size,3,7663.0
-0RAM size,5,1341.0
-0RAM size,6,6082.0
-1RAM size,1,256.0
-1RAM size,2,1333.0
-1RAM size,4,7510.0
-1RAM size,5,2745.0
-1RAM size,7,3942.0
-2RAM size,3,1973.0
-2RAM size,4,1350.0
-3RAM size,1,6640.0
-3RAM size,2,1999.0
-3RAM size,3,2863.0
-3RAM size,4,3824.0
-3RAM size,5,5699.0
-3RAM size,6,2635.0
-3RAM size,7,1491.0
-4RAM size,1,2255.0
-4RAM size,2,1728.0
-4RAM size,3,9130.0
-4RAM size,4,11560.0
-4RAM size,6,5344.635
-4RAM size,7,1338.0
-5RAM size,2,4712.0
-5RAM size,3,2769.0
-5RAM size,6,2478.0
-6RAM size,1,2142.0
-6RAM size,2,1768.0
-6RAM size,3,2633.0
-6RAM size,4,866.0
-6RAM size,5,2952.0
-6RAM size,6,3257.0
-7RAM size,3,151.0
-7RAM size,5,2239.0
-7RAM size,6,3979.0
-7RAM size,7,2031.0
-8RAM size,1,355.0
-8RAM size,2,2738.562
-8RAM size,4,3102.0
-8RAM size,5,2684.0
-8RAM size,6,2970.0
-8RAM size,7,5166.0
-9RAM size,1,3065.0
-9RAM size,3,3239.0
-9RAM size,4,5821.0
-9RAM size,6,1567.0
-9RAM size,7,571.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_266.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_266.csv b/integration-testcases/src/test/resources/hiveExpected/TC_266.csv
deleted file mode 100644
index eb63c6d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_266.csv
+++ /dev/null
@@ -1,50 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType
-0RAM size,1,2849.0
-0RAM size,2,79.0
-0RAM size,3,7663.0
-0RAM size,5,1341.0
-0RAM size,6,6082.0
-1RAM size,1,256.0
-1RAM size,2,1333.0
-1RAM size,4,7510.0
-1RAM size,5,2745.0
-1RAM size,7,3942.0
-2RAM size,3,1973.0
-2RAM size,4,1350.0
-3RAM size,1,6640.0
-3RAM size,2,1999.0
-3RAM size,3,2863.0
-3RAM size,4,3824.0
-3RAM size,5,5699.0
-3RAM size,6,2635.0
-3RAM size,7,1491.0
-4RAM size,1,2255.0
-4RAM size,2,1728.0
-4RAM size,3,9130.0
-4RAM size,4,11560.0
-4RAM size,6,5344.635
-4RAM size,7,1338.0
-5RAM size,2,4712.0
-5RAM size,3,2769.0
-5RAM size,6,2478.0
-6RAM size,1,2142.0
-6RAM size,2,1768.0
-6RAM size,3,2633.0
-6RAM size,4,866.0
-6RAM size,5,2952.0
-6RAM size,6,3257.0
-7RAM size,3,151.0
-7RAM size,5,2239.0
-7RAM size,6,3979.0
-7RAM size,7,2031.0
-8RAM size,1,355.0
-8RAM size,2,2738.562
-8RAM size,4,3102.0
-8RAM size,5,2684.0
-8RAM size,6,2970.0
-8RAM size,7,5166.0
-9RAM size,1,3065.0
-9RAM size,3,3239.0
-9RAM size,4,5821.0
-9RAM size,6,1567.0
-9RAM size,7,571.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_267.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_267.csv b/integration-testcases/src/test/resources/hiveExpected/TC_267.csv
deleted file mode 100644
index 1c57a4c..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_267.csv
+++ /dev/null
@@ -1,40 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType
-2RAM size,3,1973.0
-2RAM size,4,1350.0
-3RAM size,1,6640.0
-3RAM size,2,1999.0
-3RAM size,3,2863.0
-3RAM size,4,3824.0
-3RAM size,5,5699.0
-3RAM size,6,2635.0
-3RAM size,7,1491.0
-4RAM size,1,2255.0
-4RAM size,2,1728.0
-4RAM size,3,9130.0
-4RAM size,4,11560.0
-4RAM size,6,5344.635
-4RAM size,7,1338.0
-5RAM size,2,4712.0
-5RAM size,3,2769.0
-5RAM size,6,2478.0
-6RAM size,1,2142.0
-6RAM size,2,1768.0
-6RAM size,3,2633.0
-6RAM size,4,866.0
-6RAM size,5,2952.0
-6RAM size,6,3257.0
-7RAM size,3,151.0
-7RAM size,5,2239.0
-7RAM size,6,3979.0
-7RAM size,7,2031.0
-8RAM size,1,355.0
-8RAM size,2,2738.562
-8RAM size,4,3102.0
-8RAM size,5,2684.0
-8RAM size,6,2970.0
-8RAM size,7,5166.0
-9RAM size,1,3065.0
-9RAM size,3,3239.0
-9RAM size,4,5821.0
-9RAM size,6,1567.0
-9RAM size,7,571.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_268.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_268.csv b/integration-testcases/src/test/resources/hiveExpected/TC_268.csv
deleted file mode 100644
index eb63c6d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_268.csv
+++ /dev/null
@@ -1,50 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType
-0RAM size,1,2849.0
-0RAM size,2,79.0
-0RAM size,3,7663.0
-0RAM size,5,1341.0
-0RAM size,6,6082.0
-1RAM size,1,256.0
-1RAM size,2,1333.0
-1RAM size,4,7510.0
-1RAM size,5,2745.0
-1RAM size,7,3942.0
-2RAM size,3,1973.0
-2RAM size,4,1350.0
-3RAM size,1,6640.0
-3RAM size,2,1999.0
-3RAM size,3,2863.0
-3RAM size,4,3824.0
-3RAM size,5,5699.0
-3RAM size,6,2635.0
-3RAM size,7,1491.0
-4RAM size,1,2255.0
-4RAM size,2,1728.0
-4RAM size,3,9130.0
-4RAM size,4,11560.0
-4RAM size,6,5344.635
-4RAM size,7,1338.0
-5RAM size,2,4712.0
-5RAM size,3,2769.0
-5RAM size,6,2478.0
-6RAM size,1,2142.0
-6RAM size,2,1768.0
-6RAM size,3,2633.0
-6RAM size,4,866.0
-6RAM size,5,2952.0
-6RAM size,6,3257.0
-7RAM size,3,151.0
-7RAM size,5,2239.0
-7RAM size,6,3979.0
-7RAM size,7,2031.0
-8RAM size,1,355.0
-8RAM size,2,2738.562
-8RAM size,4,3102.0
-8RAM size,5,2684.0
-8RAM size,6,2970.0
-8RAM size,7,5166.0
-9RAM size,1,3065.0
-9RAM size,3,3239.0
-9RAM size,4,5821.0
-9RAM size,6,1567.0
-9RAM size,7,571.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_269.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_269.csv b/integration-testcases/src/test/resources/hiveExpected/TC_269.csv
deleted file mode 100644
index eb63c6d..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_269.csv
+++ /dev/null
@@ -1,50 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType
-0RAM size,1,2849.0
-0RAM size,2,79.0
-0RAM size,3,7663.0
-0RAM size,5,1341.0
-0RAM size,6,6082.0
-1RAM size,1,256.0
-1RAM size,2,1333.0
-1RAM size,4,7510.0
-1RAM size,5,2745.0
-1RAM size,7,3942.0
-2RAM size,3,1973.0
-2RAM size,4,1350.0
-3RAM size,1,6640.0
-3RAM size,2,1999.0
-3RAM size,3,2863.0
-3RAM size,4,3824.0
-3RAM size,5,5699.0
-3RAM size,6,2635.0
-3RAM size,7,1491.0
-4RAM size,1,2255.0
-4RAM size,2,1728.0
-4RAM size,3,9130.0
-4RAM size,4,11560.0
-4RAM size,6,5344.635
-4RAM size,7,1338.0
-5RAM size,2,4712.0
-5RAM size,3,2769.0
-5RAM size,6,2478.0
-6RAM size,1,2142.0
-6RAM size,2,1768.0
-6RAM size,3,2633.0
-6RAM size,4,866.0
-6RAM size,5,2952.0
-6RAM size,6,3257.0
-7RAM size,3,151.0
-7RAM size,5,2239.0
-7RAM size,6,3979.0
-7RAM size,7,2031.0
-8RAM size,1,355.0
-8RAM size,2,2738.562
-8RAM size,4,3102.0
-8RAM size,5,2684.0
-8RAM size,6,2970.0
-8RAM size,7,5166.0
-9RAM size,1,3065.0
-9RAM size,3,3239.0
-9RAM size,4,5821.0
-9RAM size,6,1567.0
-9RAM size,7,571.0
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_270.csv
----------------------------------------------------------------------
diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_270.csv b/integration-testcases/src/test/resources/hiveExpected/TC_270.csv
deleted file mode 100644
index 35b7f04..0000000
--- a/integration-testcases/src/test/resources/hiveExpected/TC_270.csv
+++ /dev/null
@@ -1 +0,0 @@
-AMSize StringType,ActiveAreaId StringType,Sum_gamePointId DoubleType