Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 18C88200BEB for ; Wed, 28 Dec 2016 11:53:06 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 16E0A160B2E; Wed, 28 Dec 2016 10:53:06 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id C6BE4160B45 for ; Wed, 28 Dec 2016 11:53:03 +0100 (CET) Received: (qmail 6898 invoked by uid 500); 28 Dec 2016 10:53:03 -0000 Mailing-List: contact commits-help@carbondata.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@carbondata.incubator.apache.org Delivered-To: mailing list commits@carbondata.incubator.apache.org Received: (qmail 6856 invoked by uid 99); 28 Dec 2016 10:53:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Dec 2016 10:53:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 4FBE0C1EB4 for ; Wed, 28 Dec 2016 10:53:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -6.219 X-Spam-Level: X-Spam-Status: No, score=-6.219 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id iQX9l1SnIJu3 for ; Wed, 28 Dec 2016 10:52:54 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id AA1706102A for ; Wed, 28 Dec 2016 10:52:41 +0000 (UTC) Received: (qmail 5501 invoked by uid 99); 28 Dec 2016 10:52:40 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Dec 2016 10:52:40 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id AA49AF1769; Wed, 28 Dec 2016 10:52:40 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: ravipesala@apache.org To: commits@carbondata.incubator.apache.org Date: Wed, 28 Dec 2016 10:53:12 -0000 Message-Id: <8d1c848bd51543069b8c0d14a7f7c0f9@git.apache.org> In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [34/52] [partial] incubator-carbondata git commit: remove integration-testcases archived-at: Wed, 28 Dec 2016 10:53:06 -0000 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_360.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_360.csv b/integration-testcases/src/test/resources/hiveExpected/TC_360.csv deleted file mode 100644 index d56473e..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_360.csv +++ /dev/null @@ -1,91 +0,0 @@ -gamePointId DoubleType,Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType -2738.562,2015,1,1AA1,yichang,7Series -1714.635,2015,10,1AA10,yichang,7Series -1271.0,2015,100,1AA100,xiangtan,5Series -2175.0,2015,10000,1AA10000,guangzhou,7Series -1600.0,2015,1000000,1AA1000000,yichang,7Series -505.0,2015,100001,1AA100001,xiangtan,0Series -1341.0,2015,100002,1AA100002,changsha,0Series -2239.0,2015,100003,1AA100003,zhuzhou,5Series -2970.0,2015,100004,1AA100004,yichang,4Series -2593.0,2015,100005,1AA100005,yichang,1Series -2572.0,2015,100006,1AA100006,changsha,6Series -1991.0,2015,100007,1AA100007,changsha,9Series -1442.0,2015,100008,1AA100008,changsha,8Series -1841.0,2015,100009,1AA100009,yichang,0Series -298.0,2015,10001,1AA10001,changsha,2Series -79.0,2015,100010,1AA100010,zhuzhou,3Series -202.0,2015,100011,1AA100011,guangzhou,0Series -568.0,2015,100012,1AA100012,xiangtan,4Series -355.0,2015,100013,1AA100013,changsha,1Series -151.0,2015,100014,1AA100014,zhuzhou,5Series -2863.0,2015,100015,1AA100015,xiangtan,4Series -1873.0,2015,100016,1AA100016,changsha,3Series -2205.0,2015,100017,1AA100017,xiangtan,9Series -441.0,2015,100018,1AA100018,yichang,8Series -2194.0,2015,100019,1AA100019,zhuzhou,5Series -256.0,2015,100020,1AA100020,shenzhen,5Series -1778.0,2015,100021,1AA100021,changsha,0Series -1999.0,2015,100022,1AA100022,zhuzhou,5Series -2194.0,2015,100023,1AA100023,guangzhou,5Series -2483.0,2015,100024,1AA100024,changsha,6Series -1724.0,2015,100025,1AA100025,guangzhou,0Series -1768.0,2015,100026,1AA100026,yichang,7Series -2436.0,2015,100027,1AA100027,zhuzhou,0Series -2849.0,2015,100028,1AA100028,zhuzhou,5Series -1691.0,2015,100029,1AA100029,xiangtan,2Series -2071.0,2015,10003,1AA10003,xiangtan,7Series -1333.0,2015,100030,1AA100030,zhuzhou,7Series -1080.0,2015,100031,1AA100031,yichang,7Series -1053.0,2015,100032,1AA100032,shenzhen,1Series -2061.0,2015,100034,1AA100034,guangzhou,2Series -2142.0,2015,100035,1AA100035,changsha,5Series -2224.0,2015,100036,1AA100036,changsha,5Series -1015.0,2015,100037,1AA100037,xiangtan,7Series -1229.0,2015,100038,1AA100038,shenzhen,6Series -1750.0,2015,100039,1AA100039,shenzhen,8Series -1717.0,2015,10004,1AA10004,guangzhou,5Series -2078.0,2015,100040,1AA100040,yichang,8Series -2734.0,2015,100041,1AA100041,shenzhen,5Series -2745.0,2015,100042,1AA100042,shenzhen,3Series -571.0,2015,100043,1AA100043,guangzhou,9Series -1697.0,2015,100044,1AA100044,guangzhou,8Series -2553.0,2015,100045,1AA100045,xiangtan,2Series -1077.0,2015,100046,1AA100046,guangzhou,3Series -1823.0,2015,100047,1AA100047,zhuzhou,9Series -2399.0,2015,100048,1AA100048,guangzhou,3Series -2890.0,2015,100049,1AA100049,guangzhou,0Series -1608.0,2015,10005,1AA10005,xiangtan,8Series -29.0,2015,100050,1AA100050,yichang,2Series -1407.0,2015,100051,1AA100051,guangzhou,2Series -845.0,2015,100052,1AA100052,zhuzhou,6Series -1368.0,2015,100054,1AA100054,shenzhen,7Series -1728.0,2015,100055,1AA100055,yichang,7Series -2288.0,2015,100057,1AA100057,zhuzhou,9Series -2635.0,2015,100058,1AA100058,guangzhou,5Series -1337.0,2015,100059,1AA100059,shenzhen,4Series -2478.0,2015,10006,1AA10006,guangzhou,3Series -538.0,2015,100060,1AA100060,xiangtan,8Series -1407.0,2015,100061,1AA100061,changsha,6Series -2952.0,2015,100062,1AA100062,yichang,9Series -1226.0,2015,100063,1AA100063,yichang,2Series -865.0,2015,100064,1AA100064,zhuzhou,6Series -901.0,2015,100065,1AA100065,xiangtan,0Series -1864.0,2015,100066,1AA100066,zhuzhou,6Series -412.0,2015,100068,1AA100068,guangzhou,8Series -1491.0,2015,100069,1AA100069,xiangtan,8Series -1350.0,2015,10007,1AA10007,xiangtan,8Series -1567.0,2015,100070,1AA100070,guangzhou,0Series -1973.0,2015,100071,1AA100071,guangzhou,0Series -448.0,2015,100072,1AA100072,changsha,4Series -2488.0,2015,100073,1AA100073,zhuzhou,4Series -2507.0,2015,100075,1AA100075,shenzhen,3Series -2077.0,2015,100077,1AA100077,yichang,3Series -1434.0,2015,100078,1AA100078,yichang,2Series -1098.0,2015,100079,1AA100079,xiangtan,4Series -813.0,2015,10008,1AA10008,shenzhen,5Series -954.0,2015,100080,1AA100080,shenzhen,9Series -613.0,2015,100081,1AA100081,shenzhen,5Series -2348.0,2015,100082,1AA100082,xiangtan,5Series -2192.0,2015,100083,1AA100083,zhuzhou,0Series -2826.0,2015,100084,1AA100084,guangzhou,0Series http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_361.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_361.csv b/integration-testcases/src/test/resources/hiveExpected/TC_361.csv deleted file mode 100644 index 0153e44..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_361.csv +++ /dev/null @@ -1,14 +0,0 @@ -gamePointId DoubleType,Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType -1341.0,2015,100002,1AA100002,changsha,0Series -2572.0,2015,100006,1AA100006,changsha,6Series -1991.0,2015,100007,1AA100007,changsha,9Series -1442.0,2015,100008,1AA100008,changsha,8Series -298.0,2015,10001,1AA10001,changsha,2Series -355.0,2015,100013,1AA100013,changsha,1Series -1873.0,2015,100016,1AA100016,changsha,3Series -1778.0,2015,100021,1AA100021,changsha,0Series -2483.0,2015,100024,1AA100024,changsha,6Series -2142.0,2015,100035,1AA100035,changsha,5Series -2224.0,2015,100036,1AA100036,changsha,5Series -1407.0,2015,100061,1AA100061,changsha,6Series -448.0,2015,100072,1AA100072,changsha,4Series http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_362.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_362.csv b/integration-testcases/src/test/resources/hiveExpected/TC_362.csv deleted file mode 100644 index 7f9a637..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_362.csv +++ /dev/null @@ -1,100 +0,0 @@ -Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType -2015,1,1AA1,yichang,7Series,2738.562 -2015,10,1AA10,yichang,7Series,1714.635 -2015,100,1AA100,xiangtan,5Series,1271.0 -2015,1000,1AA1000,wuhan,5Series,692.0 -2015,10000,1AA10000,guangzhou,7Series,2175.0 -2015,100000,1AA100000,wuhan,9Series,136.0 -2015,1000000,1AA1000000,yichang,7Series,1600.0 -2015,100001,1AA100001,xiangtan,0Series,505.0 -2015,100002,1AA100002,changsha,0Series,1341.0 -2015,100003,1AA100003,zhuzhou,5Series,2239.0 -2015,100004,1AA100004,yichang,4Series,2970.0 -2015,100005,1AA100005,yichang,1Series,2593.0 -2015,100006,1AA100006,changsha,6Series,2572.0 -2015,100007,1AA100007,changsha,9Series,1991.0 -2015,100008,1AA100008,changsha,8Series,1442.0 -2015,100009,1AA100009,yichang,0Series,1841.0 -2015,10001,1AA10001,changsha,2Series,298.0 -2015,100010,1AA100010,zhuzhou,3Series,79.0 -2015,100011,1AA100011,guangzhou,0Series,202.0 -2015,100012,1AA100012,xiangtan,4Series,568.0 -2015,100013,1AA100013,changsha,1Series,355.0 -2015,100014,1AA100014,zhuzhou,5Series,151.0 -2015,100015,1AA100015,xiangtan,4Series,2863.0 -2015,100016,1AA100016,changsha,3Series,1873.0 -2015,100017,1AA100017,xiangtan,9Series,2205.0 -2015,100018,1AA100018,yichang,8Series,441.0 -2015,100019,1AA100019,zhuzhou,5Series,2194.0 -2015,10002,1AA10002,wuhan,0Series,2972.0 -2015,100020,1AA100020,shenzhen,5Series,256.0 -2015,100021,1AA100021,changsha,0Series,1778.0 -2015,100022,1AA100022,zhuzhou,5Series,1999.0 -2015,100023,1AA100023,guangzhou,5Series,2194.0 -2015,100024,1AA100024,changsha,6Series,2483.0 -2015,100025,1AA100025,guangzhou,0Series,1724.0 -2015,100026,1AA100026,yichang,7Series,1768.0 -2015,100027,1AA100027,zhuzhou,0Series,2436.0 -2015,100028,1AA100028,zhuzhou,5Series,2849.0 -2015,100029,1AA100029,xiangtan,2Series,1691.0 -2015,10003,1AA10003,xiangtan,7Series,2071.0 -2015,100030,1AA100030,zhuzhou,7Series,1333.0 -2015,100031,1AA100031,yichang,7Series,1080.0 -2015,100032,1AA100032,shenzhen,1Series,1053.0 -2015,100033,1AA100033,wuhan,8Series,760.0 -2015,100034,1AA100034,guangzhou,2Series,2061.0 -2015,100035,1AA100035,changsha,5Series,2142.0 -2015,100036,1AA100036,changsha,5Series,2224.0 -2015,100037,1AA100037,xiangtan,7Series,1015.0 -2015,100038,1AA100038,shenzhen,6Series,1229.0 -2015,100039,1AA100039,shenzhen,8Series,1750.0 -2015,10004,1AA10004,guangzhou,5Series,1717.0 -2015,100040,1AA100040,yichang,8Series,2078.0 -2015,100041,1AA100041,shenzhen,5Series,2734.0 -2015,100042,1AA100042,shenzhen,3Series,2745.0 -2015,100043,1AA100043,guangzhou,9Series,571.0 -2015,100044,1AA100044,guangzhou,8Series,1697.0 -2015,100045,1AA100045,xiangtan,2Series,2553.0 -2015,100046,1AA100046,guangzhou,3Series,1077.0 -2015,100047,1AA100047,zhuzhou,9Series,1823.0 -2015,100048,1AA100048,guangzhou,3Series,2399.0 -2015,100049,1AA100049,guangzhou,0Series,2890.0 -2015,10005,1AA10005,xiangtan,8Series,1608.0 -2015,100050,1AA100050,yichang,2Series,29.0 -2015,100051,1AA100051,guangzhou,2Series,1407.0 -2015,100052,1AA100052,zhuzhou,6Series,845.0 -2015,100053,1AA100053,wuhan,2Series,1655.0 -2015,100054,1AA100054,shenzhen,7Series,1368.0 -2015,100055,1AA100055,yichang,7Series,1728.0 -2015,100056,1AA100056,wuhan,6Series,750.0 -2015,100057,1AA100057,zhuzhou,9Series,2288.0 -2015,100058,1AA100058,guangzhou,5Series,2635.0 -2015,100059,1AA100059,shenzhen,4Series,1337.0 -2015,10006,1AA10006,guangzhou,3Series,2478.0 -2015,100060,1AA100060,xiangtan,8Series,538.0 -2015,100061,1AA100061,changsha,6Series,1407.0 -2015,100062,1AA100062,yichang,9Series,2952.0 -2015,100063,1AA100063,yichang,2Series,1226.0 -2015,100064,1AA100064,zhuzhou,6Series,865.0 -2015,100065,1AA100065,xiangtan,0Series,901.0 -2015,100066,1AA100066,zhuzhou,6Series,1864.0 -2015,100067,1AA100067,wuhan,4Series,572.0 -2015,100068,1AA100068,guangzhou,8Series,412.0 -2015,100069,1AA100069,xiangtan,8Series,1491.0 -2015,10007,1AA10007,xiangtan,8Series,1350.0 -2015,100070,1AA100070,guangzhou,0Series,1567.0 -2015,100071,1AA100071,guangzhou,0Series,1973.0 -2015,100072,1AA100072,changsha,4Series,448.0 -2015,100073,1AA100073,zhuzhou,4Series,2488.0 -2015,100074,1AA100074,wuhan,6Series,907.0 -2015,100075,1AA100075,shenzhen,3Series,2507.0 -2015,100076,1AA100076,wuhan,0Series,732.0 -2015,100077,1AA100077,yichang,3Series,2077.0 -2015,100078,1AA100078,yichang,2Series,1434.0 -2015,100079,1AA100079,xiangtan,4Series,1098.0 -2015,10008,1AA10008,shenzhen,5Series,813.0 -2015,100080,1AA100080,shenzhen,9Series,954.0 -2015,100081,1AA100081,shenzhen,5Series,613.0 -2015,100082,1AA100082,xiangtan,5Series,2348.0 -2015,100083,1AA100083,zhuzhou,0Series,2192.0 -2015,100084,1AA100084,guangzhou,0Series,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_363.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_363.csv b/integration-testcases/src/test/resources/hiveExpected/TC_363.csv deleted file mode 100644 index 96dc76f..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_363.csv +++ /dev/null @@ -1,100 +0,0 @@ -Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType -2015,1,1AA1,yichang,7Series,2738.562 -2015,10,1AA10,yichang,7Series,1714.635 -2015,100,1AA100,xiangtan,5Series,1271.0 -2015,1000,1AA1000,wuhan,5Series,692.0 -2015,10000,1AA10000,guangzhou,7Series,2175.0 -2015,10001,1AA10001,changsha,2Series,298.0 -2015,10002,1AA10002,wuhan,0Series,2972.0 -2015,10003,1AA10003,xiangtan,7Series,2071.0 -2015,10004,1AA10004,guangzhou,5Series,1717.0 -2015,10005,1AA10005,xiangtan,8Series,1608.0 -2015,10006,1AA10006,guangzhou,3Series,2478.0 -2015,10007,1AA10007,xiangtan,8Series,1350.0 -2015,10008,1AA10008,shenzhen,5Series,813.0 -2015,100000,1AA100000,wuhan,9Series,136.0 -2015,100001,1AA100001,xiangtan,0Series,505.0 -2015,100002,1AA100002,changsha,0Series,1341.0 -2015,100003,1AA100003,zhuzhou,5Series,2239.0 -2015,100004,1AA100004,yichang,4Series,2970.0 -2015,100005,1AA100005,yichang,1Series,2593.0 -2015,100006,1AA100006,changsha,6Series,2572.0 -2015,100007,1AA100007,changsha,9Series,1991.0 -2015,100008,1AA100008,changsha,8Series,1442.0 -2015,100009,1AA100009,yichang,0Series,1841.0 -2015,100010,1AA100010,zhuzhou,3Series,79.0 -2015,100011,1AA100011,guangzhou,0Series,202.0 -2015,100012,1AA100012,xiangtan,4Series,568.0 -2015,100013,1AA100013,changsha,1Series,355.0 -2015,100014,1AA100014,zhuzhou,5Series,151.0 -2015,100015,1AA100015,xiangtan,4Series,2863.0 -2015,100016,1AA100016,changsha,3Series,1873.0 -2015,100017,1AA100017,xiangtan,9Series,2205.0 -2015,100018,1AA100018,yichang,8Series,441.0 -2015,100019,1AA100019,zhuzhou,5Series,2194.0 -2015,100020,1AA100020,shenzhen,5Series,256.0 -2015,100021,1AA100021,changsha,0Series,1778.0 -2015,100022,1AA100022,zhuzhou,5Series,1999.0 -2015,100023,1AA100023,guangzhou,5Series,2194.0 -2015,100024,1AA100024,changsha,6Series,2483.0 -2015,100025,1AA100025,guangzhou,0Series,1724.0 -2015,100026,1AA100026,yichang,7Series,1768.0 -2015,100027,1AA100027,zhuzhou,0Series,2436.0 -2015,100028,1AA100028,zhuzhou,5Series,2849.0 -2015,100029,1AA100029,xiangtan,2Series,1691.0 -2015,100030,1AA100030,zhuzhou,7Series,1333.0 -2015,100031,1AA100031,yichang,7Series,1080.0 -2015,100032,1AA100032,shenzhen,1Series,1053.0 -2015,100033,1AA100033,wuhan,8Series,760.0 -2015,100034,1AA100034,guangzhou,2Series,2061.0 -2015,100035,1AA100035,changsha,5Series,2142.0 -2015,100036,1AA100036,changsha,5Series,2224.0 -2015,100037,1AA100037,xiangtan,7Series,1015.0 -2015,100038,1AA100038,shenzhen,6Series,1229.0 -2015,100039,1AA100039,shenzhen,8Series,1750.0 -2015,100040,1AA100040,yichang,8Series,2078.0 -2015,100041,1AA100041,shenzhen,5Series,2734.0 -2015,100042,1AA100042,shenzhen,3Series,2745.0 -2015,100043,1AA100043,guangzhou,9Series,571.0 -2015,100044,1AA100044,guangzhou,8Series,1697.0 -2015,100045,1AA100045,xiangtan,2Series,2553.0 -2015,100046,1AA100046,guangzhou,3Series,1077.0 -2015,100047,1AA100047,zhuzhou,9Series,1823.0 -2015,100048,1AA100048,guangzhou,3Series,2399.0 -2015,100049,1AA100049,guangzhou,0Series,2890.0 -2015,100050,1AA100050,yichang,2Series,29.0 -2015,100051,1AA100051,guangzhou,2Series,1407.0 -2015,100052,1AA100052,zhuzhou,6Series,845.0 -2015,100053,1AA100053,wuhan,2Series,1655.0 -2015,100054,1AA100054,shenzhen,7Series,1368.0 -2015,100055,1AA100055,yichang,7Series,1728.0 -2015,100056,1AA100056,wuhan,6Series,750.0 -2015,100057,1AA100057,zhuzhou,9Series,2288.0 -2015,100058,1AA100058,guangzhou,5Series,2635.0 -2015,100059,1AA100059,shenzhen,4Series,1337.0 -2015,100060,1AA100060,xiangtan,8Series,538.0 -2015,100061,1AA100061,changsha,6Series,1407.0 -2015,100062,1AA100062,yichang,9Series,2952.0 -2015,100063,1AA100063,yichang,2Series,1226.0 -2015,100064,1AA100064,zhuzhou,6Series,865.0 -2015,100065,1AA100065,xiangtan,0Series,901.0 -2015,100066,1AA100066,zhuzhou,6Series,1864.0 -2015,100067,1AA100067,wuhan,4Series,572.0 -2015,100068,1AA100068,guangzhou,8Series,412.0 -2015,100069,1AA100069,xiangtan,8Series,1491.0 -2015,100070,1AA100070,guangzhou,0Series,1567.0 -2015,100071,1AA100071,guangzhou,0Series,1973.0 -2015,100072,1AA100072,changsha,4Series,448.0 -2015,100073,1AA100073,zhuzhou,4Series,2488.0 -2015,100074,1AA100074,wuhan,6Series,907.0 -2015,100075,1AA100075,shenzhen,3Series,2507.0 -2015,100076,1AA100076,wuhan,0Series,732.0 -2015,100077,1AA100077,yichang,3Series,2077.0 -2015,100078,1AA100078,yichang,2Series,1434.0 -2015,100079,1AA100079,xiangtan,4Series,1098.0 -2015,100080,1AA100080,shenzhen,9Series,954.0 -2015,100081,1AA100081,shenzhen,5Series,613.0 -2015,100082,1AA100082,xiangtan,5Series,2348.0 -2015,100083,1AA100083,zhuzhou,0Series,2192.0 -2015,100084,1AA100084,guangzhou,0Series,2826.0 -2015,1000000,1AA1000000,yichang,7Series,1600.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_364.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_364.csv b/integration-testcases/src/test/resources/hiveExpected/TC_364.csv deleted file mode 100644 index 49407bd..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_364.csv +++ /dev/null @@ -1,100 +0,0 @@ -Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType -2015,1000000,1AA1000000,yichang,7Series,1600.0 -2015,100084,1AA100084,guangzhou,0Series,2826.0 -2015,100083,1AA100083,zhuzhou,0Series,2192.0 -2015,100082,1AA100082,xiangtan,5Series,2348.0 -2015,100081,1AA100081,shenzhen,5Series,613.0 -2015,100080,1AA100080,shenzhen,9Series,954.0 -2015,100079,1AA100079,xiangtan,4Series,1098.0 -2015,100078,1AA100078,yichang,2Series,1434.0 -2015,100077,1AA100077,yichang,3Series,2077.0 -2015,100076,1AA100076,wuhan,0Series,732.0 -2015,100075,1AA100075,shenzhen,3Series,2507.0 -2015,100074,1AA100074,wuhan,6Series,907.0 -2015,100073,1AA100073,zhuzhou,4Series,2488.0 -2015,100072,1AA100072,changsha,4Series,448.0 -2015,100071,1AA100071,guangzhou,0Series,1973.0 -2015,100070,1AA100070,guangzhou,0Series,1567.0 -2015,100069,1AA100069,xiangtan,8Series,1491.0 -2015,100068,1AA100068,guangzhou,8Series,412.0 -2015,100067,1AA100067,wuhan,4Series,572.0 -2015,100066,1AA100066,zhuzhou,6Series,1864.0 -2015,100065,1AA100065,xiangtan,0Series,901.0 -2015,100064,1AA100064,zhuzhou,6Series,865.0 -2015,100063,1AA100063,yichang,2Series,1226.0 -2015,100062,1AA100062,yichang,9Series,2952.0 -2015,100061,1AA100061,changsha,6Series,1407.0 -2015,100060,1AA100060,xiangtan,8Series,538.0 -2015,100059,1AA100059,shenzhen,4Series,1337.0 -2015,100058,1AA100058,guangzhou,5Series,2635.0 -2015,100057,1AA100057,zhuzhou,9Series,2288.0 -2015,100056,1AA100056,wuhan,6Series,750.0 -2015,100055,1AA100055,yichang,7Series,1728.0 -2015,100054,1AA100054,shenzhen,7Series,1368.0 -2015,100053,1AA100053,wuhan,2Series,1655.0 -2015,100052,1AA100052,zhuzhou,6Series,845.0 -2015,100051,1AA100051,guangzhou,2Series,1407.0 -2015,100050,1AA100050,yichang,2Series,29.0 -2015,100049,1AA100049,guangzhou,0Series,2890.0 -2015,100048,1AA100048,guangzhou,3Series,2399.0 -2015,100047,1AA100047,zhuzhou,9Series,1823.0 -2015,100046,1AA100046,guangzhou,3Series,1077.0 -2015,100045,1AA100045,xiangtan,2Series,2553.0 -2015,100044,1AA100044,guangzhou,8Series,1697.0 -2015,100043,1AA100043,guangzhou,9Series,571.0 -2015,100042,1AA100042,shenzhen,3Series,2745.0 -2015,100041,1AA100041,shenzhen,5Series,2734.0 -2015,100040,1AA100040,yichang,8Series,2078.0 -2015,100039,1AA100039,shenzhen,8Series,1750.0 -2015,100038,1AA100038,shenzhen,6Series,1229.0 -2015,100037,1AA100037,xiangtan,7Series,1015.0 -2015,100036,1AA100036,changsha,5Series,2224.0 -2015,100035,1AA100035,changsha,5Series,2142.0 -2015,100034,1AA100034,guangzhou,2Series,2061.0 -2015,100033,1AA100033,wuhan,8Series,760.0 -2015,100032,1AA100032,shenzhen,1Series,1053.0 -2015,100031,1AA100031,yichang,7Series,1080.0 -2015,100030,1AA100030,zhuzhou,7Series,1333.0 -2015,100029,1AA100029,xiangtan,2Series,1691.0 -2015,100028,1AA100028,zhuzhou,5Series,2849.0 -2015,100027,1AA100027,zhuzhou,0Series,2436.0 -2015,100026,1AA100026,yichang,7Series,1768.0 -2015,100025,1AA100025,guangzhou,0Series,1724.0 -2015,100024,1AA100024,changsha,6Series,2483.0 -2015,100023,1AA100023,guangzhou,5Series,2194.0 -2015,100022,1AA100022,zhuzhou,5Series,1999.0 -2015,100021,1AA100021,changsha,0Series,1778.0 -2015,100020,1AA100020,shenzhen,5Series,256.0 -2015,100019,1AA100019,zhuzhou,5Series,2194.0 -2015,100018,1AA100018,yichang,8Series,441.0 -2015,100017,1AA100017,xiangtan,9Series,2205.0 -2015,100016,1AA100016,changsha,3Series,1873.0 -2015,100015,1AA100015,xiangtan,4Series,2863.0 -2015,100014,1AA100014,zhuzhou,5Series,151.0 -2015,100013,1AA100013,changsha,1Series,355.0 -2015,100012,1AA100012,xiangtan,4Series,568.0 -2015,100011,1AA100011,guangzhou,0Series,202.0 -2015,100010,1AA100010,zhuzhou,3Series,79.0 -2015,100009,1AA100009,yichang,0Series,1841.0 -2015,100008,1AA100008,changsha,8Series,1442.0 -2015,100007,1AA100007,changsha,9Series,1991.0 -2015,100006,1AA100006,changsha,6Series,2572.0 -2015,100005,1AA100005,yichang,1Series,2593.0 -2015,100004,1AA100004,yichang,4Series,2970.0 -2015,100003,1AA100003,zhuzhou,5Series,2239.0 -2015,100002,1AA100002,changsha,0Series,1341.0 -2015,100001,1AA100001,xiangtan,0Series,505.0 -2015,100000,1AA100000,wuhan,9Series,136.0 -2015,10008,1AA10008,shenzhen,5Series,813.0 -2015,10007,1AA10007,xiangtan,8Series,1350.0 -2015,10006,1AA10006,guangzhou,3Series,2478.0 -2015,10005,1AA10005,xiangtan,8Series,1608.0 -2015,10004,1AA10004,guangzhou,5Series,1717.0 -2015,10003,1AA10003,xiangtan,7Series,2071.0 -2015,10002,1AA10002,wuhan,0Series,2972.0 -2015,10001,1AA10001,changsha,2Series,298.0 -2015,10000,1AA10000,guangzhou,7Series,2175.0 -2015,1000,1AA1000,wuhan,5Series,692.0 -2015,100,1AA100,xiangtan,5Series,1271.0 -2015,10,1AA10,yichang,7Series,1714.635 -2015,1,1AA1,yichang,7Series,2738.562 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_365.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_365.csv b/integration-testcases/src/test/resources/hiveExpected/TC_365.csv deleted file mode 100644 index aae08e4..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_365.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Sum_gamePointId DoubleType -1AA1,yichang,7Series,2015,1,2738.562 -1AA10,yichang,7Series,2015,10,1714.635 -1AA100,xiangtan,5Series,2015,100,1271.0 -1AA1000,wuhan,5Series,2015,1000,692.0 -1AA10000,guangzhou,7Series,2015,10000,2175.0 -1AA100000,wuhan,9Series,2015,100000,136.0 -1AA1000000,yichang,7Series,2015,1000000,1600.0 -1AA100001,xiangtan,0Series,2015,100001,505.0 -1AA100002,changsha,0Series,2015,100002,1341.0 -1AA100003,zhuzhou,5Series,2015,100003,2239.0 -1AA100004,yichang,4Series,2015,100004,2970.0 -1AA100005,yichang,1Series,2015,100005,2593.0 -1AA100006,changsha,6Series,2015,100006,2572.0 -1AA100007,changsha,9Series,2015,100007,1991.0 -1AA100008,changsha,8Series,2015,100008,1442.0 -1AA100009,yichang,0Series,2015,100009,1841.0 -1AA10001,changsha,2Series,2015,10001,298.0 -1AA100010,zhuzhou,3Series,2015,100010,79.0 -1AA100011,guangzhou,0Series,2015,100011,202.0 -1AA100012,xiangtan,4Series,2015,100012,568.0 -1AA100013,changsha,1Series,2015,100013,355.0 -1AA100014,zhuzhou,5Series,2015,100014,151.0 -1AA100015,xiangtan,4Series,2015,100015,2863.0 -1AA100016,changsha,3Series,2015,100016,1873.0 -1AA100017,xiangtan,9Series,2015,100017,2205.0 -1AA100018,yichang,8Series,2015,100018,441.0 -1AA100019,zhuzhou,5Series,2015,100019,2194.0 -1AA10002,wuhan,0Series,2015,10002,2972.0 -1AA100020,shenzhen,5Series,2015,100020,256.0 -1AA100021,changsha,0Series,2015,100021,1778.0 -1AA100022,zhuzhou,5Series,2015,100022,1999.0 -1AA100023,guangzhou,5Series,2015,100023,2194.0 -1AA100024,changsha,6Series,2015,100024,2483.0 -1AA100025,guangzhou,0Series,2015,100025,1724.0 -1AA100026,yichang,7Series,2015,100026,1768.0 -1AA100027,zhuzhou,0Series,2015,100027,2436.0 -1AA100028,zhuzhou,5Series,2015,100028,2849.0 -1AA100029,xiangtan,2Series,2015,100029,1691.0 -1AA10003,xiangtan,7Series,2015,10003,2071.0 -1AA100030,zhuzhou,7Series,2015,100030,1333.0 -1AA100031,yichang,7Series,2015,100031,1080.0 -1AA100032,shenzhen,1Series,2015,100032,1053.0 -1AA100033,wuhan,8Series,2015,100033,760.0 -1AA100034,guangzhou,2Series,2015,100034,2061.0 -1AA100035,changsha,5Series,2015,100035,2142.0 -1AA100036,changsha,5Series,2015,100036,2224.0 -1AA100037,xiangtan,7Series,2015,100037,1015.0 -1AA100038,shenzhen,6Series,2015,100038,1229.0 -1AA100039,shenzhen,8Series,2015,100039,1750.0 -1AA10004,guangzhou,5Series,2015,10004,1717.0 -1AA100040,yichang,8Series,2015,100040,2078.0 -1AA100041,shenzhen,5Series,2015,100041,2734.0 -1AA100042,shenzhen,3Series,2015,100042,2745.0 -1AA100043,guangzhou,9Series,2015,100043,571.0 -1AA100044,guangzhou,8Series,2015,100044,1697.0 -1AA100045,xiangtan,2Series,2015,100045,2553.0 -1AA100046,guangzhou,3Series,2015,100046,1077.0 -1AA100047,zhuzhou,9Series,2015,100047,1823.0 -1AA100048,guangzhou,3Series,2015,100048,2399.0 -1AA100049,guangzhou,0Series,2015,100049,2890.0 -1AA10005,xiangtan,8Series,2015,10005,1608.0 -1AA100050,yichang,2Series,2015,100050,29.0 -1AA100051,guangzhou,2Series,2015,100051,1407.0 -1AA100052,zhuzhou,6Series,2015,100052,845.0 -1AA100053,wuhan,2Series,2015,100053,1655.0 -1AA100054,shenzhen,7Series,2015,100054,1368.0 -1AA100055,yichang,7Series,2015,100055,1728.0 -1AA100056,wuhan,6Series,2015,100056,750.0 -1AA100057,zhuzhou,9Series,2015,100057,2288.0 -1AA100058,guangzhou,5Series,2015,100058,2635.0 -1AA100059,shenzhen,4Series,2015,100059,1337.0 -1AA10006,guangzhou,3Series,2015,10006,2478.0 -1AA100060,xiangtan,8Series,2015,100060,538.0 -1AA100061,changsha,6Series,2015,100061,1407.0 -1AA100062,yichang,9Series,2015,100062,2952.0 -1AA100063,yichang,2Series,2015,100063,1226.0 -1AA100064,zhuzhou,6Series,2015,100064,865.0 -1AA100065,xiangtan,0Series,2015,100065,901.0 -1AA100066,zhuzhou,6Series,2015,100066,1864.0 -1AA100067,wuhan,4Series,2015,100067,572.0 -1AA100068,guangzhou,8Series,2015,100068,412.0 -1AA100069,xiangtan,8Series,2015,100069,1491.0 -1AA10007,xiangtan,8Series,2015,10007,1350.0 -1AA100070,guangzhou,0Series,2015,100070,1567.0 -1AA100071,guangzhou,0Series,2015,100071,1973.0 -1AA100072,changsha,4Series,2015,100072,448.0 -1AA100073,zhuzhou,4Series,2015,100073,2488.0 -1AA100074,wuhan,6Series,2015,100074,907.0 -1AA100075,shenzhen,3Series,2015,100075,2507.0 -1AA100076,wuhan,0Series,2015,100076,732.0 -1AA100077,yichang,3Series,2015,100077,2077.0 -1AA100078,yichang,2Series,2015,100078,1434.0 -1AA100079,xiangtan,4Series,2015,100079,1098.0 -1AA10008,shenzhen,5Series,2015,10008,813.0 -1AA100080,shenzhen,9Series,2015,100080,954.0 -1AA100081,shenzhen,5Series,2015,100081,613.0 -1AA100082,xiangtan,5Series,2015,100082,2348.0 -1AA100083,zhuzhou,0Series,2015,100083,2192.0 -1AA100084,guangzhou,0Series,2015,100084,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_366.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_366.csv b/integration-testcases/src/test/resources/hiveExpected/TC_366.csv deleted file mode 100644 index f2d9c82..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_366.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Avg_deviceInformationId DoubleType,Sum_gamePointId DoubleType -1AA1,yichang,7Series,2015,1.0,2738.562 -1AA10,yichang,7Series,2015,10.0,1714.635 -1AA100,xiangtan,5Series,2015,100.0,1271.0 -1AA1000,wuhan,5Series,2015,1000.0,692.0 -1AA10000,guangzhou,7Series,2015,10000.0,2175.0 -1AA100000,wuhan,9Series,2015,100000.0,136.0 -1AA1000000,yichang,7Series,2015,1000000.0,1600.0 -1AA100001,xiangtan,0Series,2015,100001.0,505.0 -1AA100002,changsha,0Series,2015,100002.0,1341.0 -1AA100003,zhuzhou,5Series,2015,100003.0,2239.0 -1AA100004,yichang,4Series,2015,100004.0,2970.0 -1AA100005,yichang,1Series,2015,100005.0,2593.0 -1AA100006,changsha,6Series,2015,100006.0,2572.0 -1AA100007,changsha,9Series,2015,100007.0,1991.0 -1AA100008,changsha,8Series,2015,100008.0,1442.0 -1AA100009,yichang,0Series,2015,100009.0,1841.0 -1AA10001,changsha,2Series,2015,10001.0,298.0 -1AA100010,zhuzhou,3Series,2015,100010.0,79.0 -1AA100011,guangzhou,0Series,2015,100011.0,202.0 -1AA100012,xiangtan,4Series,2015,100012.0,568.0 -1AA100013,changsha,1Series,2015,100013.0,355.0 -1AA100014,zhuzhou,5Series,2015,100014.0,151.0 -1AA100015,xiangtan,4Series,2015,100015.0,2863.0 -1AA100016,changsha,3Series,2015,100016.0,1873.0 -1AA100017,xiangtan,9Series,2015,100017.0,2205.0 -1AA100018,yichang,8Series,2015,100018.0,441.0 -1AA100019,zhuzhou,5Series,2015,100019.0,2194.0 -1AA10002,wuhan,0Series,2015,10002.0,2972.0 -1AA100020,shenzhen,5Series,2015,100020.0,256.0 -1AA100021,changsha,0Series,2015,100021.0,1778.0 -1AA100022,zhuzhou,5Series,2015,100022.0,1999.0 -1AA100023,guangzhou,5Series,2015,100023.0,2194.0 -1AA100024,changsha,6Series,2015,100024.0,2483.0 -1AA100025,guangzhou,0Series,2015,100025.0,1724.0 -1AA100026,yichang,7Series,2015,100026.0,1768.0 -1AA100027,zhuzhou,0Series,2015,100027.0,2436.0 -1AA100028,zhuzhou,5Series,2015,100028.0,2849.0 -1AA100029,xiangtan,2Series,2015,100029.0,1691.0 -1AA10003,xiangtan,7Series,2015,10003.0,2071.0 -1AA100030,zhuzhou,7Series,2015,100030.0,1333.0 -1AA100031,yichang,7Series,2015,100031.0,1080.0 -1AA100032,shenzhen,1Series,2015,100032.0,1053.0 -1AA100033,wuhan,8Series,2015,100033.0,760.0 -1AA100034,guangzhou,2Series,2015,100034.0,2061.0 -1AA100035,changsha,5Series,2015,100035.0,2142.0 -1AA100036,changsha,5Series,2015,100036.0,2224.0 -1AA100037,xiangtan,7Series,2015,100037.0,1015.0 -1AA100038,shenzhen,6Series,2015,100038.0,1229.0 -1AA100039,shenzhen,8Series,2015,100039.0,1750.0 -1AA10004,guangzhou,5Series,2015,10004.0,1717.0 -1AA100040,yichang,8Series,2015,100040.0,2078.0 -1AA100041,shenzhen,5Series,2015,100041.0,2734.0 -1AA100042,shenzhen,3Series,2015,100042.0,2745.0 -1AA100043,guangzhou,9Series,2015,100043.0,571.0 -1AA100044,guangzhou,8Series,2015,100044.0,1697.0 -1AA100045,xiangtan,2Series,2015,100045.0,2553.0 -1AA100046,guangzhou,3Series,2015,100046.0,1077.0 -1AA100047,zhuzhou,9Series,2015,100047.0,1823.0 -1AA100048,guangzhou,3Series,2015,100048.0,2399.0 -1AA100049,guangzhou,0Series,2015,100049.0,2890.0 -1AA10005,xiangtan,8Series,2015,10005.0,1608.0 -1AA100050,yichang,2Series,2015,100050.0,29.0 -1AA100051,guangzhou,2Series,2015,100051.0,1407.0 -1AA100052,zhuzhou,6Series,2015,100052.0,845.0 -1AA100053,wuhan,2Series,2015,100053.0,1655.0 -1AA100054,shenzhen,7Series,2015,100054.0,1368.0 -1AA100055,yichang,7Series,2015,100055.0,1728.0 -1AA100056,wuhan,6Series,2015,100056.0,750.0 -1AA100057,zhuzhou,9Series,2015,100057.0,2288.0 -1AA100058,guangzhou,5Series,2015,100058.0,2635.0 -1AA100059,shenzhen,4Series,2015,100059.0,1337.0 -1AA10006,guangzhou,3Series,2015,10006.0,2478.0 -1AA100060,xiangtan,8Series,2015,100060.0,538.0 -1AA100061,changsha,6Series,2015,100061.0,1407.0 -1AA100062,yichang,9Series,2015,100062.0,2952.0 -1AA100063,yichang,2Series,2015,100063.0,1226.0 -1AA100064,zhuzhou,6Series,2015,100064.0,865.0 -1AA100065,xiangtan,0Series,2015,100065.0,901.0 -1AA100066,zhuzhou,6Series,2015,100066.0,1864.0 -1AA100067,wuhan,4Series,2015,100067.0,572.0 -1AA100068,guangzhou,8Series,2015,100068.0,412.0 -1AA100069,xiangtan,8Series,2015,100069.0,1491.0 -1AA10007,xiangtan,8Series,2015,10007.0,1350.0 -1AA100070,guangzhou,0Series,2015,100070.0,1567.0 -1AA100071,guangzhou,0Series,2015,100071.0,1973.0 -1AA100072,changsha,4Series,2015,100072.0,448.0 -1AA100073,zhuzhou,4Series,2015,100073.0,2488.0 -1AA100074,wuhan,6Series,2015,100074.0,907.0 -1AA100075,shenzhen,3Series,2015,100075.0,2507.0 -1AA100076,wuhan,0Series,2015,100076.0,732.0 -1AA100077,yichang,3Series,2015,100077.0,2077.0 -1AA100078,yichang,2Series,2015,100078.0,1434.0 -1AA100079,xiangtan,4Series,2015,100079.0,1098.0 -1AA10008,shenzhen,5Series,2015,10008.0,813.0 -1AA100080,shenzhen,9Series,2015,100080.0,954.0 -1AA100081,shenzhen,5Series,2015,100081.0,613.0 -1AA100082,xiangtan,5Series,2015,100082.0,2348.0 -1AA100083,zhuzhou,0Series,2015,100083.0,2192.0 -1AA100084,guangzhou,0Series,2015,100084.0,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_367.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_367.csv b/integration-testcases/src/test/resources/hiveExpected/TC_367.csv deleted file mode 100644 index 3714f21..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_367.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Count_deviceInformationId LongType,Sum_gamePointId DoubleType -1AA1,yichang,7Series,2015,1,2738.562 -1AA10,yichang,7Series,2015,1,1714.635 -1AA100,xiangtan,5Series,2015,1,1271.0 -1AA1000,wuhan,5Series,2015,1,692.0 -1AA10000,guangzhou,7Series,2015,1,2175.0 -1AA100000,wuhan,9Series,2015,1,136.0 -1AA1000000,yichang,7Series,2015,1,1600.0 -1AA100001,xiangtan,0Series,2015,1,505.0 -1AA100002,changsha,0Series,2015,1,1341.0 -1AA100003,zhuzhou,5Series,2015,1,2239.0 -1AA100004,yichang,4Series,2015,1,2970.0 -1AA100005,yichang,1Series,2015,1,2593.0 -1AA100006,changsha,6Series,2015,1,2572.0 -1AA100007,changsha,9Series,2015,1,1991.0 -1AA100008,changsha,8Series,2015,1,1442.0 -1AA100009,yichang,0Series,2015,1,1841.0 -1AA10001,changsha,2Series,2015,1,298.0 -1AA100010,zhuzhou,3Series,2015,1,79.0 -1AA100011,guangzhou,0Series,2015,1,202.0 -1AA100012,xiangtan,4Series,2015,1,568.0 -1AA100013,changsha,1Series,2015,1,355.0 -1AA100014,zhuzhou,5Series,2015,1,151.0 -1AA100015,xiangtan,4Series,2015,1,2863.0 -1AA100016,changsha,3Series,2015,1,1873.0 -1AA100017,xiangtan,9Series,2015,1,2205.0 -1AA100018,yichang,8Series,2015,1,441.0 -1AA100019,zhuzhou,5Series,2015,1,2194.0 -1AA10002,wuhan,0Series,2015,1,2972.0 -1AA100020,shenzhen,5Series,2015,1,256.0 -1AA100021,changsha,0Series,2015,1,1778.0 -1AA100022,zhuzhou,5Series,2015,1,1999.0 -1AA100023,guangzhou,5Series,2015,1,2194.0 -1AA100024,changsha,6Series,2015,1,2483.0 -1AA100025,guangzhou,0Series,2015,1,1724.0 -1AA100026,yichang,7Series,2015,1,1768.0 -1AA100027,zhuzhou,0Series,2015,1,2436.0 -1AA100028,zhuzhou,5Series,2015,1,2849.0 -1AA100029,xiangtan,2Series,2015,1,1691.0 -1AA10003,xiangtan,7Series,2015,1,2071.0 -1AA100030,zhuzhou,7Series,2015,1,1333.0 -1AA100031,yichang,7Series,2015,1,1080.0 -1AA100032,shenzhen,1Series,2015,1,1053.0 -1AA100033,wuhan,8Series,2015,1,760.0 -1AA100034,guangzhou,2Series,2015,1,2061.0 -1AA100035,changsha,5Series,2015,1,2142.0 -1AA100036,changsha,5Series,2015,1,2224.0 -1AA100037,xiangtan,7Series,2015,1,1015.0 -1AA100038,shenzhen,6Series,2015,1,1229.0 -1AA100039,shenzhen,8Series,2015,1,1750.0 -1AA10004,guangzhou,5Series,2015,1,1717.0 -1AA100040,yichang,8Series,2015,1,2078.0 -1AA100041,shenzhen,5Series,2015,1,2734.0 -1AA100042,shenzhen,3Series,2015,1,2745.0 -1AA100043,guangzhou,9Series,2015,1,571.0 -1AA100044,guangzhou,8Series,2015,1,1697.0 -1AA100045,xiangtan,2Series,2015,1,2553.0 -1AA100046,guangzhou,3Series,2015,1,1077.0 -1AA100047,zhuzhou,9Series,2015,1,1823.0 -1AA100048,guangzhou,3Series,2015,1,2399.0 -1AA100049,guangzhou,0Series,2015,1,2890.0 -1AA10005,xiangtan,8Series,2015,1,1608.0 -1AA100050,yichang,2Series,2015,1,29.0 -1AA100051,guangzhou,2Series,2015,1,1407.0 -1AA100052,zhuzhou,6Series,2015,1,845.0 -1AA100053,wuhan,2Series,2015,1,1655.0 -1AA100054,shenzhen,7Series,2015,1,1368.0 -1AA100055,yichang,7Series,2015,1,1728.0 -1AA100056,wuhan,6Series,2015,1,750.0 -1AA100057,zhuzhou,9Series,2015,1,2288.0 -1AA100058,guangzhou,5Series,2015,1,2635.0 -1AA100059,shenzhen,4Series,2015,1,1337.0 -1AA10006,guangzhou,3Series,2015,1,2478.0 -1AA100060,xiangtan,8Series,2015,1,538.0 -1AA100061,changsha,6Series,2015,1,1407.0 -1AA100062,yichang,9Series,2015,1,2952.0 -1AA100063,yichang,2Series,2015,1,1226.0 -1AA100064,zhuzhou,6Series,2015,1,865.0 -1AA100065,xiangtan,0Series,2015,1,901.0 -1AA100066,zhuzhou,6Series,2015,1,1864.0 -1AA100067,wuhan,4Series,2015,1,572.0 -1AA100068,guangzhou,8Series,2015,1,412.0 -1AA100069,xiangtan,8Series,2015,1,1491.0 -1AA10007,xiangtan,8Series,2015,1,1350.0 -1AA100070,guangzhou,0Series,2015,1,1567.0 -1AA100071,guangzhou,0Series,2015,1,1973.0 -1AA100072,changsha,4Series,2015,1,448.0 -1AA100073,zhuzhou,4Series,2015,1,2488.0 -1AA100074,wuhan,6Series,2015,1,907.0 -1AA100075,shenzhen,3Series,2015,1,2507.0 -1AA100076,wuhan,0Series,2015,1,732.0 -1AA100077,yichang,3Series,2015,1,2077.0 -1AA100078,yichang,2Series,2015,1,1434.0 -1AA100079,xiangtan,4Series,2015,1,1098.0 -1AA10008,shenzhen,5Series,2015,1,813.0 -1AA100080,shenzhen,9Series,2015,1,954.0 -1AA100081,shenzhen,5Series,2015,1,613.0 -1AA100082,xiangtan,5Series,2015,1,2348.0 -1AA100083,zhuzhou,0Series,2015,1,2192.0 -1AA100084,guangzhou,0Series,2015,1,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_368.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_368.csv b/integration-testcases/src/test/resources/hiveExpected/TC_368.csv deleted file mode 100644 index 9f4f844..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_368.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,LONG_COL_0 LongType,Sum_gamePointId DoubleType -1AA1,yichang,7Series,2015,1,2738.562 -1AA10,yichang,7Series,2015,1,1714.635 -1AA100,xiangtan,5Series,2015,1,1271.0 -1AA1000,wuhan,5Series,2015,1,692.0 -1AA10000,guangzhou,7Series,2015,1,2175.0 -1AA100000,wuhan,9Series,2015,1,136.0 -1AA1000000,yichang,7Series,2015,1,1600.0 -1AA100001,xiangtan,0Series,2015,1,505.0 -1AA100002,changsha,0Series,2015,1,1341.0 -1AA100003,zhuzhou,5Series,2015,1,2239.0 -1AA100004,yichang,4Series,2015,1,2970.0 -1AA100005,yichang,1Series,2015,1,2593.0 -1AA100006,changsha,6Series,2015,1,2572.0 -1AA100007,changsha,9Series,2015,1,1991.0 -1AA100008,changsha,8Series,2015,1,1442.0 -1AA100009,yichang,0Series,2015,1,1841.0 -1AA10001,changsha,2Series,2015,1,298.0 -1AA100010,zhuzhou,3Series,2015,1,79.0 -1AA100011,guangzhou,0Series,2015,1,202.0 -1AA100012,xiangtan,4Series,2015,1,568.0 -1AA100013,changsha,1Series,2015,1,355.0 -1AA100014,zhuzhou,5Series,2015,1,151.0 -1AA100015,xiangtan,4Series,2015,1,2863.0 -1AA100016,changsha,3Series,2015,1,1873.0 -1AA100017,xiangtan,9Series,2015,1,2205.0 -1AA100018,yichang,8Series,2015,1,441.0 -1AA100019,zhuzhou,5Series,2015,1,2194.0 -1AA10002,wuhan,0Series,2015,1,2972.0 -1AA100020,shenzhen,5Series,2015,1,256.0 -1AA100021,changsha,0Series,2015,1,1778.0 -1AA100022,zhuzhou,5Series,2015,1,1999.0 -1AA100023,guangzhou,5Series,2015,1,2194.0 -1AA100024,changsha,6Series,2015,1,2483.0 -1AA100025,guangzhou,0Series,2015,1,1724.0 -1AA100026,yichang,7Series,2015,1,1768.0 -1AA100027,zhuzhou,0Series,2015,1,2436.0 -1AA100028,zhuzhou,5Series,2015,1,2849.0 -1AA100029,xiangtan,2Series,2015,1,1691.0 -1AA10003,xiangtan,7Series,2015,1,2071.0 -1AA100030,zhuzhou,7Series,2015,1,1333.0 -1AA100031,yichang,7Series,2015,1,1080.0 -1AA100032,shenzhen,1Series,2015,1,1053.0 -1AA100033,wuhan,8Series,2015,1,760.0 -1AA100034,guangzhou,2Series,2015,1,2061.0 -1AA100035,changsha,5Series,2015,1,2142.0 -1AA100036,changsha,5Series,2015,1,2224.0 -1AA100037,xiangtan,7Series,2015,1,1015.0 -1AA100038,shenzhen,6Series,2015,1,1229.0 -1AA100039,shenzhen,8Series,2015,1,1750.0 -1AA10004,guangzhou,5Series,2015,1,1717.0 -1AA100040,yichang,8Series,2015,1,2078.0 -1AA100041,shenzhen,5Series,2015,1,2734.0 -1AA100042,shenzhen,3Series,2015,1,2745.0 -1AA100043,guangzhou,9Series,2015,1,571.0 -1AA100044,guangzhou,8Series,2015,1,1697.0 -1AA100045,xiangtan,2Series,2015,1,2553.0 -1AA100046,guangzhou,3Series,2015,1,1077.0 -1AA100047,zhuzhou,9Series,2015,1,1823.0 -1AA100048,guangzhou,3Series,2015,1,2399.0 -1AA100049,guangzhou,0Series,2015,1,2890.0 -1AA10005,xiangtan,8Series,2015,1,1608.0 -1AA100050,yichang,2Series,2015,1,29.0 -1AA100051,guangzhou,2Series,2015,1,1407.0 -1AA100052,zhuzhou,6Series,2015,1,845.0 -1AA100053,wuhan,2Series,2015,1,1655.0 -1AA100054,shenzhen,7Series,2015,1,1368.0 -1AA100055,yichang,7Series,2015,1,1728.0 -1AA100056,wuhan,6Series,2015,1,750.0 -1AA100057,zhuzhou,9Series,2015,1,2288.0 -1AA100058,guangzhou,5Series,2015,1,2635.0 -1AA100059,shenzhen,4Series,2015,1,1337.0 -1AA10006,guangzhou,3Series,2015,1,2478.0 -1AA100060,xiangtan,8Series,2015,1,538.0 -1AA100061,changsha,6Series,2015,1,1407.0 -1AA100062,yichang,9Series,2015,1,2952.0 -1AA100063,yichang,2Series,2015,1,1226.0 -1AA100064,zhuzhou,6Series,2015,1,865.0 -1AA100065,xiangtan,0Series,2015,1,901.0 -1AA100066,zhuzhou,6Series,2015,1,1864.0 -1AA100067,wuhan,4Series,2015,1,572.0 -1AA100068,guangzhou,8Series,2015,1,412.0 -1AA100069,xiangtan,8Series,2015,1,1491.0 -1AA10007,xiangtan,8Series,2015,1,1350.0 -1AA100070,guangzhou,0Series,2015,1,1567.0 -1AA100071,guangzhou,0Series,2015,1,1973.0 -1AA100072,changsha,4Series,2015,1,448.0 -1AA100073,zhuzhou,4Series,2015,1,2488.0 -1AA100074,wuhan,6Series,2015,1,907.0 -1AA100075,shenzhen,3Series,2015,1,2507.0 -1AA100076,wuhan,0Series,2015,1,732.0 -1AA100077,yichang,3Series,2015,1,2077.0 -1AA100078,yichang,2Series,2015,1,1434.0 -1AA100079,xiangtan,4Series,2015,1,1098.0 -1AA10008,shenzhen,5Series,2015,1,813.0 -1AA100080,shenzhen,9Series,2015,1,954.0 -1AA100081,shenzhen,5Series,2015,1,613.0 -1AA100082,xiangtan,5Series,2015,1,2348.0 -1AA100083,zhuzhou,0Series,2015,1,2192.0 -1AA100084,guangzhou,0Series,2015,1,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_369.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_369.csv b/integration-testcases/src/test/resources/hiveExpected/TC_369.csv deleted file mode 100644 index 4675f10..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_369.csv +++ /dev/null @@ -1,100 +0,0 @@ -series StringType,gamePointId DoubleType,deviceInformationId IntegerType,Latest_YEAR IntegerType,imei StringType,deliveryCity StringType -7Series,2738.562,1,2015,1AA1,yichang -7Series,1714.635,10,2015,1AA10,yichang -5Series,1271.0,100,2015,1AA100,xiangtan -5Series,692.0,1000,2015,1AA1000,wuhan -7Series,2175.0,10000,2015,1AA10000,guangzhou -9Series,136.0,100000,2015,1AA100000,wuhan -7Series,1600.0,1000000,2015,1AA1000000,yichang -0Series,505.0,100001,2015,1AA100001,xiangtan -0Series,1341.0,100002,2015,1AA100002,changsha -5Series,2239.0,100003,2015,1AA100003,zhuzhou -4Series,2970.0,100004,2015,1AA100004,yichang -1Series,2593.0,100005,2015,1AA100005,yichang -6Series,2572.0,100006,2015,1AA100006,changsha -9Series,1991.0,100007,2015,1AA100007,changsha -8Series,1442.0,100008,2015,1AA100008,changsha -0Series,1841.0,100009,2015,1AA100009,yichang -2Series,298.0,10001,2015,1AA10001,changsha -3Series,79.0,100010,2015,1AA100010,zhuzhou -0Series,202.0,100011,2015,1AA100011,guangzhou -4Series,568.0,100012,2015,1AA100012,xiangtan -1Series,355.0,100013,2015,1AA100013,changsha -5Series,151.0,100014,2015,1AA100014,zhuzhou -4Series,2863.0,100015,2015,1AA100015,xiangtan -3Series,1873.0,100016,2015,1AA100016,changsha -9Series,2205.0,100017,2015,1AA100017,xiangtan -8Series,441.0,100018,2015,1AA100018,yichang -5Series,2194.0,100019,2015,1AA100019,zhuzhou -0Series,2972.0,10002,2015,1AA10002,wuhan -5Series,256.0,100020,2015,1AA100020,shenzhen -0Series,1778.0,100021,2015,1AA100021,changsha -5Series,1999.0,100022,2015,1AA100022,zhuzhou -5Series,2194.0,100023,2015,1AA100023,guangzhou -6Series,2483.0,100024,2015,1AA100024,changsha -0Series,1724.0,100025,2015,1AA100025,guangzhou -7Series,1768.0,100026,2015,1AA100026,yichang -0Series,2436.0,100027,2015,1AA100027,zhuzhou -5Series,2849.0,100028,2015,1AA100028,zhuzhou -2Series,1691.0,100029,2015,1AA100029,xiangtan -7Series,2071.0,10003,2015,1AA10003,xiangtan -7Series,1333.0,100030,2015,1AA100030,zhuzhou -7Series,1080.0,100031,2015,1AA100031,yichang -1Series,1053.0,100032,2015,1AA100032,shenzhen -8Series,760.0,100033,2015,1AA100033,wuhan -2Series,2061.0,100034,2015,1AA100034,guangzhou -5Series,2142.0,100035,2015,1AA100035,changsha -5Series,2224.0,100036,2015,1AA100036,changsha -7Series,1015.0,100037,2015,1AA100037,xiangtan -6Series,1229.0,100038,2015,1AA100038,shenzhen -8Series,1750.0,100039,2015,1AA100039,shenzhen -5Series,1717.0,10004,2015,1AA10004,guangzhou -8Series,2078.0,100040,2015,1AA100040,yichang -5Series,2734.0,100041,2015,1AA100041,shenzhen -3Series,2745.0,100042,2015,1AA100042,shenzhen -9Series,571.0,100043,2015,1AA100043,guangzhou -8Series,1697.0,100044,2015,1AA100044,guangzhou -2Series,2553.0,100045,2015,1AA100045,xiangtan -3Series,1077.0,100046,2015,1AA100046,guangzhou -9Series,1823.0,100047,2015,1AA100047,zhuzhou -3Series,2399.0,100048,2015,1AA100048,guangzhou -0Series,2890.0,100049,2015,1AA100049,guangzhou -8Series,1608.0,10005,2015,1AA10005,xiangtan -2Series,29.0,100050,2015,1AA100050,yichang -2Series,1407.0,100051,2015,1AA100051,guangzhou -6Series,845.0,100052,2015,1AA100052,zhuzhou -2Series,1655.0,100053,2015,1AA100053,wuhan -7Series,1368.0,100054,2015,1AA100054,shenzhen -7Series,1728.0,100055,2015,1AA100055,yichang -6Series,750.0,100056,2015,1AA100056,wuhan -9Series,2288.0,100057,2015,1AA100057,zhuzhou -5Series,2635.0,100058,2015,1AA100058,guangzhou -4Series,1337.0,100059,2015,1AA100059,shenzhen -3Series,2478.0,10006,2015,1AA10006,guangzhou -8Series,538.0,100060,2015,1AA100060,xiangtan -6Series,1407.0,100061,2015,1AA100061,changsha -9Series,2952.0,100062,2015,1AA100062,yichang -2Series,1226.0,100063,2015,1AA100063,yichang -6Series,865.0,100064,2015,1AA100064,zhuzhou -0Series,901.0,100065,2015,1AA100065,xiangtan -6Series,1864.0,100066,2015,1AA100066,zhuzhou -4Series,572.0,100067,2015,1AA100067,wuhan -8Series,412.0,100068,2015,1AA100068,guangzhou -8Series,1491.0,100069,2015,1AA100069,xiangtan -8Series,1350.0,10007,2015,1AA10007,xiangtan -0Series,1567.0,100070,2015,1AA100070,guangzhou -0Series,1973.0,100071,2015,1AA100071,guangzhou -4Series,448.0,100072,2015,1AA100072,changsha -4Series,2488.0,100073,2015,1AA100073,zhuzhou -6Series,907.0,100074,2015,1AA100074,wuhan -3Series,2507.0,100075,2015,1AA100075,shenzhen -0Series,732.0,100076,2015,1AA100076,wuhan -3Series,2077.0,100077,2015,1AA100077,yichang -2Series,1434.0,100078,2015,1AA100078,yichang -4Series,1098.0,100079,2015,1AA100079,xiangtan -5Series,813.0,10008,2015,1AA10008,shenzhen -9Series,954.0,100080,2015,1AA100080,shenzhen -5Series,613.0,100081,2015,1AA100081,shenzhen -5Series,2348.0,100082,2015,1AA100082,xiangtan -0Series,2192.0,100083,2015,1AA100083,zhuzhou -0Series,2826.0,100084,2015,1AA100084,guangzhou http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_370.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_370.csv b/integration-testcases/src/test/resources/hiveExpected/TC_370.csv deleted file mode 100644 index bd0ebee..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_370.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Max_deviceInformationId IntegerType,Sum_gamePointId DoubleType -1AA1,yichang,7Series,2015,1,2738.562 -1AA10,yichang,7Series,2015,10,1714.635 -1AA100,xiangtan,5Series,2015,100,1271.0 -1AA1000,wuhan,5Series,2015,1000,692.0 -1AA10000,guangzhou,7Series,2015,10000,2175.0 -1AA100000,wuhan,9Series,2015,100000,136.0 -1AA1000000,yichang,7Series,2015,1000000,1600.0 -1AA100001,xiangtan,0Series,2015,100001,505.0 -1AA100002,changsha,0Series,2015,100002,1341.0 -1AA100003,zhuzhou,5Series,2015,100003,2239.0 -1AA100004,yichang,4Series,2015,100004,2970.0 -1AA100005,yichang,1Series,2015,100005,2593.0 -1AA100006,changsha,6Series,2015,100006,2572.0 -1AA100007,changsha,9Series,2015,100007,1991.0 -1AA100008,changsha,8Series,2015,100008,1442.0 -1AA100009,yichang,0Series,2015,100009,1841.0 -1AA10001,changsha,2Series,2015,10001,298.0 -1AA100010,zhuzhou,3Series,2015,100010,79.0 -1AA100011,guangzhou,0Series,2015,100011,202.0 -1AA100012,xiangtan,4Series,2015,100012,568.0 -1AA100013,changsha,1Series,2015,100013,355.0 -1AA100014,zhuzhou,5Series,2015,100014,151.0 -1AA100015,xiangtan,4Series,2015,100015,2863.0 -1AA100016,changsha,3Series,2015,100016,1873.0 -1AA100017,xiangtan,9Series,2015,100017,2205.0 -1AA100018,yichang,8Series,2015,100018,441.0 -1AA100019,zhuzhou,5Series,2015,100019,2194.0 -1AA10002,wuhan,0Series,2015,10002,2972.0 -1AA100020,shenzhen,5Series,2015,100020,256.0 -1AA100021,changsha,0Series,2015,100021,1778.0 -1AA100022,zhuzhou,5Series,2015,100022,1999.0 -1AA100023,guangzhou,5Series,2015,100023,2194.0 -1AA100024,changsha,6Series,2015,100024,2483.0 -1AA100025,guangzhou,0Series,2015,100025,1724.0 -1AA100026,yichang,7Series,2015,100026,1768.0 -1AA100027,zhuzhou,0Series,2015,100027,2436.0 -1AA100028,zhuzhou,5Series,2015,100028,2849.0 -1AA100029,xiangtan,2Series,2015,100029,1691.0 -1AA10003,xiangtan,7Series,2015,10003,2071.0 -1AA100030,zhuzhou,7Series,2015,100030,1333.0 -1AA100031,yichang,7Series,2015,100031,1080.0 -1AA100032,shenzhen,1Series,2015,100032,1053.0 -1AA100033,wuhan,8Series,2015,100033,760.0 -1AA100034,guangzhou,2Series,2015,100034,2061.0 -1AA100035,changsha,5Series,2015,100035,2142.0 -1AA100036,changsha,5Series,2015,100036,2224.0 -1AA100037,xiangtan,7Series,2015,100037,1015.0 -1AA100038,shenzhen,6Series,2015,100038,1229.0 -1AA100039,shenzhen,8Series,2015,100039,1750.0 -1AA10004,guangzhou,5Series,2015,10004,1717.0 -1AA100040,yichang,8Series,2015,100040,2078.0 -1AA100041,shenzhen,5Series,2015,100041,2734.0 -1AA100042,shenzhen,3Series,2015,100042,2745.0 -1AA100043,guangzhou,9Series,2015,100043,571.0 -1AA100044,guangzhou,8Series,2015,100044,1697.0 -1AA100045,xiangtan,2Series,2015,100045,2553.0 -1AA100046,guangzhou,3Series,2015,100046,1077.0 -1AA100047,zhuzhou,9Series,2015,100047,1823.0 -1AA100048,guangzhou,3Series,2015,100048,2399.0 -1AA100049,guangzhou,0Series,2015,100049,2890.0 -1AA10005,xiangtan,8Series,2015,10005,1608.0 -1AA100050,yichang,2Series,2015,100050,29.0 -1AA100051,guangzhou,2Series,2015,100051,1407.0 -1AA100052,zhuzhou,6Series,2015,100052,845.0 -1AA100053,wuhan,2Series,2015,100053,1655.0 -1AA100054,shenzhen,7Series,2015,100054,1368.0 -1AA100055,yichang,7Series,2015,100055,1728.0 -1AA100056,wuhan,6Series,2015,100056,750.0 -1AA100057,zhuzhou,9Series,2015,100057,2288.0 -1AA100058,guangzhou,5Series,2015,100058,2635.0 -1AA100059,shenzhen,4Series,2015,100059,1337.0 -1AA10006,guangzhou,3Series,2015,10006,2478.0 -1AA100060,xiangtan,8Series,2015,100060,538.0 -1AA100061,changsha,6Series,2015,100061,1407.0 -1AA100062,yichang,9Series,2015,100062,2952.0 -1AA100063,yichang,2Series,2015,100063,1226.0 -1AA100064,zhuzhou,6Series,2015,100064,865.0 -1AA100065,xiangtan,0Series,2015,100065,901.0 -1AA100066,zhuzhou,6Series,2015,100066,1864.0 -1AA100067,wuhan,4Series,2015,100067,572.0 -1AA100068,guangzhou,8Series,2015,100068,412.0 -1AA100069,xiangtan,8Series,2015,100069,1491.0 -1AA10007,xiangtan,8Series,2015,10007,1350.0 -1AA100070,guangzhou,0Series,2015,100070,1567.0 -1AA100071,guangzhou,0Series,2015,100071,1973.0 -1AA100072,changsha,4Series,2015,100072,448.0 -1AA100073,zhuzhou,4Series,2015,100073,2488.0 -1AA100074,wuhan,6Series,2015,100074,907.0 -1AA100075,shenzhen,3Series,2015,100075,2507.0 -1AA100076,wuhan,0Series,2015,100076,732.0 -1AA100077,yichang,3Series,2015,100077,2077.0 -1AA100078,yichang,2Series,2015,100078,1434.0 -1AA100079,xiangtan,4Series,2015,100079,1098.0 -1AA10008,shenzhen,5Series,2015,10008,813.0 -1AA100080,shenzhen,9Series,2015,100080,954.0 -1AA100081,shenzhen,5Series,2015,100081,613.0 -1AA100082,xiangtan,5Series,2015,100082,2348.0 -1AA100083,zhuzhou,0Series,2015,100083,2192.0 -1AA100084,guangzhou,0Series,2015,100084,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_371.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_371.csv b/integration-testcases/src/test/resources/hiveExpected/TC_371.csv deleted file mode 100644 index f1d9494..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_371.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Min_deviceInformationId IntegerType,Sum_gamePointId DoubleType -1AA1,yichang,7Series,2015,1,2738.562 -1AA10,yichang,7Series,2015,10,1714.635 -1AA100,xiangtan,5Series,2015,100,1271.0 -1AA1000,wuhan,5Series,2015,1000,692.0 -1AA10000,guangzhou,7Series,2015,10000,2175.0 -1AA100000,wuhan,9Series,2015,100000,136.0 -1AA1000000,yichang,7Series,2015,1000000,1600.0 -1AA100001,xiangtan,0Series,2015,100001,505.0 -1AA100002,changsha,0Series,2015,100002,1341.0 -1AA100003,zhuzhou,5Series,2015,100003,2239.0 -1AA100004,yichang,4Series,2015,100004,2970.0 -1AA100005,yichang,1Series,2015,100005,2593.0 -1AA100006,changsha,6Series,2015,100006,2572.0 -1AA100007,changsha,9Series,2015,100007,1991.0 -1AA100008,changsha,8Series,2015,100008,1442.0 -1AA100009,yichang,0Series,2015,100009,1841.0 -1AA10001,changsha,2Series,2015,10001,298.0 -1AA100010,zhuzhou,3Series,2015,100010,79.0 -1AA100011,guangzhou,0Series,2015,100011,202.0 -1AA100012,xiangtan,4Series,2015,100012,568.0 -1AA100013,changsha,1Series,2015,100013,355.0 -1AA100014,zhuzhou,5Series,2015,100014,151.0 -1AA100015,xiangtan,4Series,2015,100015,2863.0 -1AA100016,changsha,3Series,2015,100016,1873.0 -1AA100017,xiangtan,9Series,2015,100017,2205.0 -1AA100018,yichang,8Series,2015,100018,441.0 -1AA100019,zhuzhou,5Series,2015,100019,2194.0 -1AA10002,wuhan,0Series,2015,10002,2972.0 -1AA100020,shenzhen,5Series,2015,100020,256.0 -1AA100021,changsha,0Series,2015,100021,1778.0 -1AA100022,zhuzhou,5Series,2015,100022,1999.0 -1AA100023,guangzhou,5Series,2015,100023,2194.0 -1AA100024,changsha,6Series,2015,100024,2483.0 -1AA100025,guangzhou,0Series,2015,100025,1724.0 -1AA100026,yichang,7Series,2015,100026,1768.0 -1AA100027,zhuzhou,0Series,2015,100027,2436.0 -1AA100028,zhuzhou,5Series,2015,100028,2849.0 -1AA100029,xiangtan,2Series,2015,100029,1691.0 -1AA10003,xiangtan,7Series,2015,10003,2071.0 -1AA100030,zhuzhou,7Series,2015,100030,1333.0 -1AA100031,yichang,7Series,2015,100031,1080.0 -1AA100032,shenzhen,1Series,2015,100032,1053.0 -1AA100033,wuhan,8Series,2015,100033,760.0 -1AA100034,guangzhou,2Series,2015,100034,2061.0 -1AA100035,changsha,5Series,2015,100035,2142.0 -1AA100036,changsha,5Series,2015,100036,2224.0 -1AA100037,xiangtan,7Series,2015,100037,1015.0 -1AA100038,shenzhen,6Series,2015,100038,1229.0 -1AA100039,shenzhen,8Series,2015,100039,1750.0 -1AA10004,guangzhou,5Series,2015,10004,1717.0 -1AA100040,yichang,8Series,2015,100040,2078.0 -1AA100041,shenzhen,5Series,2015,100041,2734.0 -1AA100042,shenzhen,3Series,2015,100042,2745.0 -1AA100043,guangzhou,9Series,2015,100043,571.0 -1AA100044,guangzhou,8Series,2015,100044,1697.0 -1AA100045,xiangtan,2Series,2015,100045,2553.0 -1AA100046,guangzhou,3Series,2015,100046,1077.0 -1AA100047,zhuzhou,9Series,2015,100047,1823.0 -1AA100048,guangzhou,3Series,2015,100048,2399.0 -1AA100049,guangzhou,0Series,2015,100049,2890.0 -1AA10005,xiangtan,8Series,2015,10005,1608.0 -1AA100050,yichang,2Series,2015,100050,29.0 -1AA100051,guangzhou,2Series,2015,100051,1407.0 -1AA100052,zhuzhou,6Series,2015,100052,845.0 -1AA100053,wuhan,2Series,2015,100053,1655.0 -1AA100054,shenzhen,7Series,2015,100054,1368.0 -1AA100055,yichang,7Series,2015,100055,1728.0 -1AA100056,wuhan,6Series,2015,100056,750.0 -1AA100057,zhuzhou,9Series,2015,100057,2288.0 -1AA100058,guangzhou,5Series,2015,100058,2635.0 -1AA100059,shenzhen,4Series,2015,100059,1337.0 -1AA10006,guangzhou,3Series,2015,10006,2478.0 -1AA100060,xiangtan,8Series,2015,100060,538.0 -1AA100061,changsha,6Series,2015,100061,1407.0 -1AA100062,yichang,9Series,2015,100062,2952.0 -1AA100063,yichang,2Series,2015,100063,1226.0 -1AA100064,zhuzhou,6Series,2015,100064,865.0 -1AA100065,xiangtan,0Series,2015,100065,901.0 -1AA100066,zhuzhou,6Series,2015,100066,1864.0 -1AA100067,wuhan,4Series,2015,100067,572.0 -1AA100068,guangzhou,8Series,2015,100068,412.0 -1AA100069,xiangtan,8Series,2015,100069,1491.0 -1AA10007,xiangtan,8Series,2015,10007,1350.0 -1AA100070,guangzhou,0Series,2015,100070,1567.0 -1AA100071,guangzhou,0Series,2015,100071,1973.0 -1AA100072,changsha,4Series,2015,100072,448.0 -1AA100073,zhuzhou,4Series,2015,100073,2488.0 -1AA100074,wuhan,6Series,2015,100074,907.0 -1AA100075,shenzhen,3Series,2015,100075,2507.0 -1AA100076,wuhan,0Series,2015,100076,732.0 -1AA100077,yichang,3Series,2015,100077,2077.0 -1AA100078,yichang,2Series,2015,100078,1434.0 -1AA100079,xiangtan,4Series,2015,100079,1098.0 -1AA10008,shenzhen,5Series,2015,10008,813.0 -1AA100080,shenzhen,9Series,2015,100080,954.0 -1AA100081,shenzhen,5Series,2015,100081,613.0 -1AA100082,xiangtan,5Series,2015,100082,2348.0 -1AA100083,zhuzhou,0Series,2015,100083,2192.0 -1AA100084,guangzhou,0Series,2015,100084,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_372.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_372.csv b/integration-testcases/src/test/resources/hiveExpected/TC_372.csv deleted file mode 100644 index d0111b4..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_372.csv +++ /dev/null @@ -1,100 +0,0 @@ -Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType -2015,100050,1AA100050,yichang,2Series,29.0 -2015,100010,1AA100010,zhuzhou,3Series,79.0 -2015,100000,1AA100000,wuhan,9Series,136.0 -2015,100014,1AA100014,zhuzhou,5Series,151.0 -2015,100011,1AA100011,guangzhou,0Series,202.0 -2015,100020,1AA100020,shenzhen,5Series,256.0 -2015,10001,1AA10001,changsha,2Series,298.0 -2015,100013,1AA100013,changsha,1Series,355.0 -2015,100068,1AA100068,guangzhou,8Series,412.0 -2015,100018,1AA100018,yichang,8Series,441.0 -2015,100072,1AA100072,changsha,4Series,448.0 -2015,100001,1AA100001,xiangtan,0Series,505.0 -2015,100060,1AA100060,xiangtan,8Series,538.0 -2015,100012,1AA100012,xiangtan,4Series,568.0 -2015,100043,1AA100043,guangzhou,9Series,571.0 -2015,100067,1AA100067,wuhan,4Series,572.0 -2015,100081,1AA100081,shenzhen,5Series,613.0 -2015,1000,1AA1000,wuhan,5Series,692.0 -2015,100076,1AA100076,wuhan,0Series,732.0 -2015,100056,1AA100056,wuhan,6Series,750.0 -2015,100033,1AA100033,wuhan,8Series,760.0 -2015,10008,1AA10008,shenzhen,5Series,813.0 -2015,100052,1AA100052,zhuzhou,6Series,845.0 -2015,100064,1AA100064,zhuzhou,6Series,865.0 -2015,100065,1AA100065,xiangtan,0Series,901.0 -2015,100074,1AA100074,wuhan,6Series,907.0 -2015,100080,1AA100080,shenzhen,9Series,954.0 -2015,100037,1AA100037,xiangtan,7Series,1015.0 -2015,100032,1AA100032,shenzhen,1Series,1053.0 -2015,100046,1AA100046,guangzhou,3Series,1077.0 -2015,100031,1AA100031,yichang,7Series,1080.0 -2015,100079,1AA100079,xiangtan,4Series,1098.0 -2015,100063,1AA100063,yichang,2Series,1226.0 -2015,100038,1AA100038,shenzhen,6Series,1229.0 -2015,100,1AA100,xiangtan,5Series,1271.0 -2015,100030,1AA100030,zhuzhou,7Series,1333.0 -2015,100059,1AA100059,shenzhen,4Series,1337.0 -2015,100002,1AA100002,changsha,0Series,1341.0 -2015,10007,1AA10007,xiangtan,8Series,1350.0 -2015,100054,1AA100054,shenzhen,7Series,1368.0 -2015,100051,1AA100051,guangzhou,2Series,1407.0 -2015,100061,1AA100061,changsha,6Series,1407.0 -2015,100078,1AA100078,yichang,2Series,1434.0 -2015,100008,1AA100008,changsha,8Series,1442.0 -2015,100069,1AA100069,xiangtan,8Series,1491.0 -2015,100070,1AA100070,guangzhou,0Series,1567.0 -2015,1000000,1AA1000000,yichang,7Series,1600.0 -2015,10005,1AA10005,xiangtan,8Series,1608.0 -2015,100053,1AA100053,wuhan,2Series,1655.0 -2015,100029,1AA100029,xiangtan,2Series,1691.0 -2015,100044,1AA100044,guangzhou,8Series,1697.0 -2015,10,1AA10,yichang,7Series,1714.635 -2015,10004,1AA10004,guangzhou,5Series,1717.0 -2015,100025,1AA100025,guangzhou,0Series,1724.0 -2015,100055,1AA100055,yichang,7Series,1728.0 -2015,100039,1AA100039,shenzhen,8Series,1750.0 -2015,100026,1AA100026,yichang,7Series,1768.0 -2015,100021,1AA100021,changsha,0Series,1778.0 -2015,100047,1AA100047,zhuzhou,9Series,1823.0 -2015,100009,1AA100009,yichang,0Series,1841.0 -2015,100066,1AA100066,zhuzhou,6Series,1864.0 -2015,100016,1AA100016,changsha,3Series,1873.0 -2015,100071,1AA100071,guangzhou,0Series,1973.0 -2015,100007,1AA100007,changsha,9Series,1991.0 -2015,100022,1AA100022,zhuzhou,5Series,1999.0 -2015,100034,1AA100034,guangzhou,2Series,2061.0 -2015,10003,1AA10003,xiangtan,7Series,2071.0 -2015,100077,1AA100077,yichang,3Series,2077.0 -2015,100040,1AA100040,yichang,8Series,2078.0 -2015,100035,1AA100035,changsha,5Series,2142.0 -2015,10000,1AA10000,guangzhou,7Series,2175.0 -2015,100083,1AA100083,zhuzhou,0Series,2192.0 -2015,100019,1AA100019,zhuzhou,5Series,2194.0 -2015,100023,1AA100023,guangzhou,5Series,2194.0 -2015,100017,1AA100017,xiangtan,9Series,2205.0 -2015,100036,1AA100036,changsha,5Series,2224.0 -2015,100003,1AA100003,zhuzhou,5Series,2239.0 -2015,100057,1AA100057,zhuzhou,9Series,2288.0 -2015,100082,1AA100082,xiangtan,5Series,2348.0 -2015,100048,1AA100048,guangzhou,3Series,2399.0 -2015,100027,1AA100027,zhuzhou,0Series,2436.0 -2015,10006,1AA10006,guangzhou,3Series,2478.0 -2015,100024,1AA100024,changsha,6Series,2483.0 -2015,100073,1AA100073,zhuzhou,4Series,2488.0 -2015,100075,1AA100075,shenzhen,3Series,2507.0 -2015,100045,1AA100045,xiangtan,2Series,2553.0 -2015,100006,1AA100006,changsha,6Series,2572.0 -2015,100005,1AA100005,yichang,1Series,2593.0 -2015,100058,1AA100058,guangzhou,5Series,2635.0 -2015,100041,1AA100041,shenzhen,5Series,2734.0 -2015,1,1AA1,yichang,7Series,2738.562 -2015,100042,1AA100042,shenzhen,3Series,2745.0 -2015,100084,1AA100084,guangzhou,0Series,2826.0 -2015,100028,1AA100028,zhuzhou,5Series,2849.0 -2015,100015,1AA100015,xiangtan,4Series,2863.0 -2015,100049,1AA100049,guangzhou,0Series,2890.0 -2015,100062,1AA100062,yichang,9Series,2952.0 -2015,100004,1AA100004,yichang,4Series,2970.0 -2015,10002,1AA10002,wuhan,0Series,2972.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_373.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_373.csv b/integration-testcases/src/test/resources/hiveExpected/TC_373.csv deleted file mode 100644 index cf1a4bb..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_373.csv +++ /dev/null @@ -1,100 +0,0 @@ -Latest_YEAR IntegerType,deviceInformationId IntegerType,imei StringType,deliveryCity StringType,series StringType,gamePointId DoubleType -2015,10002,1AA10002,wuhan,0Series,2972.0 -2015,100004,1AA100004,yichang,4Series,2970.0 -2015,100062,1AA100062,yichang,9Series,2952.0 -2015,100049,1AA100049,guangzhou,0Series,2890.0 -2015,100015,1AA100015,xiangtan,4Series,2863.0 -2015,100028,1AA100028,zhuzhou,5Series,2849.0 -2015,100084,1AA100084,guangzhou,0Series,2826.0 -2015,100042,1AA100042,shenzhen,3Series,2745.0 -2015,1,1AA1,yichang,7Series,2738.562 -2015,100041,1AA100041,shenzhen,5Series,2734.0 -2015,100058,1AA100058,guangzhou,5Series,2635.0 -2015,100005,1AA100005,yichang,1Series,2593.0 -2015,100006,1AA100006,changsha,6Series,2572.0 -2015,100045,1AA100045,xiangtan,2Series,2553.0 -2015,100075,1AA100075,shenzhen,3Series,2507.0 -2015,100073,1AA100073,zhuzhou,4Series,2488.0 -2015,100024,1AA100024,changsha,6Series,2483.0 -2015,10006,1AA10006,guangzhou,3Series,2478.0 -2015,100027,1AA100027,zhuzhou,0Series,2436.0 -2015,100048,1AA100048,guangzhou,3Series,2399.0 -2015,100082,1AA100082,xiangtan,5Series,2348.0 -2015,100057,1AA100057,zhuzhou,9Series,2288.0 -2015,100003,1AA100003,zhuzhou,5Series,2239.0 -2015,100036,1AA100036,changsha,5Series,2224.0 -2015,100017,1AA100017,xiangtan,9Series,2205.0 -2015,100019,1AA100019,zhuzhou,5Series,2194.0 -2015,100023,1AA100023,guangzhou,5Series,2194.0 -2015,100083,1AA100083,zhuzhou,0Series,2192.0 -2015,10000,1AA10000,guangzhou,7Series,2175.0 -2015,100035,1AA100035,changsha,5Series,2142.0 -2015,100040,1AA100040,yichang,8Series,2078.0 -2015,100077,1AA100077,yichang,3Series,2077.0 -2015,10003,1AA10003,xiangtan,7Series,2071.0 -2015,100034,1AA100034,guangzhou,2Series,2061.0 -2015,100022,1AA100022,zhuzhou,5Series,1999.0 -2015,100007,1AA100007,changsha,9Series,1991.0 -2015,100071,1AA100071,guangzhou,0Series,1973.0 -2015,100016,1AA100016,changsha,3Series,1873.0 -2015,100066,1AA100066,zhuzhou,6Series,1864.0 -2015,100009,1AA100009,yichang,0Series,1841.0 -2015,100047,1AA100047,zhuzhou,9Series,1823.0 -2015,100021,1AA100021,changsha,0Series,1778.0 -2015,100026,1AA100026,yichang,7Series,1768.0 -2015,100039,1AA100039,shenzhen,8Series,1750.0 -2015,100055,1AA100055,yichang,7Series,1728.0 -2015,100025,1AA100025,guangzhou,0Series,1724.0 -2015,10004,1AA10004,guangzhou,5Series,1717.0 -2015,10,1AA10,yichang,7Series,1714.635 -2015,100044,1AA100044,guangzhou,8Series,1697.0 -2015,100029,1AA100029,xiangtan,2Series,1691.0 -2015,100053,1AA100053,wuhan,2Series,1655.0 -2015,10005,1AA10005,xiangtan,8Series,1608.0 -2015,1000000,1AA1000000,yichang,7Series,1600.0 -2015,100070,1AA100070,guangzhou,0Series,1567.0 -2015,100069,1AA100069,xiangtan,8Series,1491.0 -2015,100008,1AA100008,changsha,8Series,1442.0 -2015,100078,1AA100078,yichang,2Series,1434.0 -2015,100051,1AA100051,guangzhou,2Series,1407.0 -2015,100061,1AA100061,changsha,6Series,1407.0 -2015,100054,1AA100054,shenzhen,7Series,1368.0 -2015,10007,1AA10007,xiangtan,8Series,1350.0 -2015,100002,1AA100002,changsha,0Series,1341.0 -2015,100059,1AA100059,shenzhen,4Series,1337.0 -2015,100030,1AA100030,zhuzhou,7Series,1333.0 -2015,100,1AA100,xiangtan,5Series,1271.0 -2015,100038,1AA100038,shenzhen,6Series,1229.0 -2015,100063,1AA100063,yichang,2Series,1226.0 -2015,100079,1AA100079,xiangtan,4Series,1098.0 -2015,100031,1AA100031,yichang,7Series,1080.0 -2015,100046,1AA100046,guangzhou,3Series,1077.0 -2015,100032,1AA100032,shenzhen,1Series,1053.0 -2015,100037,1AA100037,xiangtan,7Series,1015.0 -2015,100080,1AA100080,shenzhen,9Series,954.0 -2015,100074,1AA100074,wuhan,6Series,907.0 -2015,100065,1AA100065,xiangtan,0Series,901.0 -2015,100064,1AA100064,zhuzhou,6Series,865.0 -2015,100052,1AA100052,zhuzhou,6Series,845.0 -2015,10008,1AA10008,shenzhen,5Series,813.0 -2015,100033,1AA100033,wuhan,8Series,760.0 -2015,100056,1AA100056,wuhan,6Series,750.0 -2015,100076,1AA100076,wuhan,0Series,732.0 -2015,1000,1AA1000,wuhan,5Series,692.0 -2015,100081,1AA100081,shenzhen,5Series,613.0 -2015,100067,1AA100067,wuhan,4Series,572.0 -2015,100043,1AA100043,guangzhou,9Series,571.0 -2015,100012,1AA100012,xiangtan,4Series,568.0 -2015,100060,1AA100060,xiangtan,8Series,538.0 -2015,100001,1AA100001,xiangtan,0Series,505.0 -2015,100072,1AA100072,changsha,4Series,448.0 -2015,100018,1AA100018,yichang,8Series,441.0 -2015,100068,1AA100068,guangzhou,8Series,412.0 -2015,100013,1AA100013,changsha,1Series,355.0 -2015,10001,1AA10001,changsha,2Series,298.0 -2015,100020,1AA100020,shenzhen,5Series,256.0 -2015,100011,1AA100011,guangzhou,0Series,202.0 -2015,100014,1AA100014,zhuzhou,5Series,151.0 -2015,100000,1AA100000,wuhan,9Series,136.0 -2015,100010,1AA100010,zhuzhou,3Series,79.0 -2015,100050,1AA100050,yichang,2Series,29.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_374.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_374.csv b/integration-testcases/src/test/resources/hiveExpected/TC_374.csv deleted file mode 100644 index 7d87ec6..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_374.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Avg_gamePointId DoubleType -1AA1,yichang,7Series,2015,1,2738.562 -1AA10,yichang,7Series,2015,10,1714.635 -1AA100,xiangtan,5Series,2015,100,1271.0 -1AA1000,wuhan,5Series,2015,1000,692.0 -1AA10000,guangzhou,7Series,2015,10000,2175.0 -1AA100000,wuhan,9Series,2015,100000,136.0 -1AA1000000,yichang,7Series,2015,1000000,1600.0 -1AA100001,xiangtan,0Series,2015,100001,505.0 -1AA100002,changsha,0Series,2015,100002,1341.0 -1AA100003,zhuzhou,5Series,2015,100003,2239.0 -1AA100004,yichang,4Series,2015,100004,2970.0 -1AA100005,yichang,1Series,2015,100005,2593.0 -1AA100006,changsha,6Series,2015,100006,2572.0 -1AA100007,changsha,9Series,2015,100007,1991.0 -1AA100008,changsha,8Series,2015,100008,1442.0 -1AA100009,yichang,0Series,2015,100009,1841.0 -1AA10001,changsha,2Series,2015,10001,298.0 -1AA100010,zhuzhou,3Series,2015,100010,79.0 -1AA100011,guangzhou,0Series,2015,100011,202.0 -1AA100012,xiangtan,4Series,2015,100012,568.0 -1AA100013,changsha,1Series,2015,100013,355.0 -1AA100014,zhuzhou,5Series,2015,100014,151.0 -1AA100015,xiangtan,4Series,2015,100015,2863.0 -1AA100016,changsha,3Series,2015,100016,1873.0 -1AA100017,xiangtan,9Series,2015,100017,2205.0 -1AA100018,yichang,8Series,2015,100018,441.0 -1AA100019,zhuzhou,5Series,2015,100019,2194.0 -1AA10002,wuhan,0Series,2015,10002,2972.0 -1AA100020,shenzhen,5Series,2015,100020,256.0 -1AA100021,changsha,0Series,2015,100021,1778.0 -1AA100022,zhuzhou,5Series,2015,100022,1999.0 -1AA100023,guangzhou,5Series,2015,100023,2194.0 -1AA100024,changsha,6Series,2015,100024,2483.0 -1AA100025,guangzhou,0Series,2015,100025,1724.0 -1AA100026,yichang,7Series,2015,100026,1768.0 -1AA100027,zhuzhou,0Series,2015,100027,2436.0 -1AA100028,zhuzhou,5Series,2015,100028,2849.0 -1AA100029,xiangtan,2Series,2015,100029,1691.0 -1AA10003,xiangtan,7Series,2015,10003,2071.0 -1AA100030,zhuzhou,7Series,2015,100030,1333.0 -1AA100031,yichang,7Series,2015,100031,1080.0 -1AA100032,shenzhen,1Series,2015,100032,1053.0 -1AA100033,wuhan,8Series,2015,100033,760.0 -1AA100034,guangzhou,2Series,2015,100034,2061.0 -1AA100035,changsha,5Series,2015,100035,2142.0 -1AA100036,changsha,5Series,2015,100036,2224.0 -1AA100037,xiangtan,7Series,2015,100037,1015.0 -1AA100038,shenzhen,6Series,2015,100038,1229.0 -1AA100039,shenzhen,8Series,2015,100039,1750.0 -1AA10004,guangzhou,5Series,2015,10004,1717.0 -1AA100040,yichang,8Series,2015,100040,2078.0 -1AA100041,shenzhen,5Series,2015,100041,2734.0 -1AA100042,shenzhen,3Series,2015,100042,2745.0 -1AA100043,guangzhou,9Series,2015,100043,571.0 -1AA100044,guangzhou,8Series,2015,100044,1697.0 -1AA100045,xiangtan,2Series,2015,100045,2553.0 -1AA100046,guangzhou,3Series,2015,100046,1077.0 -1AA100047,zhuzhou,9Series,2015,100047,1823.0 -1AA100048,guangzhou,3Series,2015,100048,2399.0 -1AA100049,guangzhou,0Series,2015,100049,2890.0 -1AA10005,xiangtan,8Series,2015,10005,1608.0 -1AA100050,yichang,2Series,2015,100050,29.0 -1AA100051,guangzhou,2Series,2015,100051,1407.0 -1AA100052,zhuzhou,6Series,2015,100052,845.0 -1AA100053,wuhan,2Series,2015,100053,1655.0 -1AA100054,shenzhen,7Series,2015,100054,1368.0 -1AA100055,yichang,7Series,2015,100055,1728.0 -1AA100056,wuhan,6Series,2015,100056,750.0 -1AA100057,zhuzhou,9Series,2015,100057,2288.0 -1AA100058,guangzhou,5Series,2015,100058,2635.0 -1AA100059,shenzhen,4Series,2015,100059,1337.0 -1AA10006,guangzhou,3Series,2015,10006,2478.0 -1AA100060,xiangtan,8Series,2015,100060,538.0 -1AA100061,changsha,6Series,2015,100061,1407.0 -1AA100062,yichang,9Series,2015,100062,2952.0 -1AA100063,yichang,2Series,2015,100063,1226.0 -1AA100064,zhuzhou,6Series,2015,100064,865.0 -1AA100065,xiangtan,0Series,2015,100065,901.0 -1AA100066,zhuzhou,6Series,2015,100066,1864.0 -1AA100067,wuhan,4Series,2015,100067,572.0 -1AA100068,guangzhou,8Series,2015,100068,412.0 -1AA100069,xiangtan,8Series,2015,100069,1491.0 -1AA10007,xiangtan,8Series,2015,10007,1350.0 -1AA100070,guangzhou,0Series,2015,100070,1567.0 -1AA100071,guangzhou,0Series,2015,100071,1973.0 -1AA100072,changsha,4Series,2015,100072,448.0 -1AA100073,zhuzhou,4Series,2015,100073,2488.0 -1AA100074,wuhan,6Series,2015,100074,907.0 -1AA100075,shenzhen,3Series,2015,100075,2507.0 -1AA100076,wuhan,0Series,2015,100076,732.0 -1AA100077,yichang,3Series,2015,100077,2077.0 -1AA100078,yichang,2Series,2015,100078,1434.0 -1AA100079,xiangtan,4Series,2015,100079,1098.0 -1AA10008,shenzhen,5Series,2015,10008,813.0 -1AA100080,shenzhen,9Series,2015,100080,954.0 -1AA100081,shenzhen,5Series,2015,100081,613.0 -1AA100082,xiangtan,5Series,2015,100082,2348.0 -1AA100083,zhuzhou,0Series,2015,100083,2192.0 -1AA100084,guangzhou,0Series,2015,100084,2826.0 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_375.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_375.csv b/integration-testcases/src/test/resources/hiveExpected/TC_375.csv deleted file mode 100644 index 553eff7..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_375.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Count_gamePointId LongType -1AA1,yichang,7Series,2015,1,1 -1AA10,yichang,7Series,2015,10,1 -1AA100,xiangtan,5Series,2015,100,1 -1AA1000,wuhan,5Series,2015,1000,1 -1AA10000,guangzhou,7Series,2015,10000,1 -1AA100000,wuhan,9Series,2015,100000,1 -1AA1000000,yichang,7Series,2015,1000000,1 -1AA100001,xiangtan,0Series,2015,100001,1 -1AA100002,changsha,0Series,2015,100002,1 -1AA100003,zhuzhou,5Series,2015,100003,1 -1AA100004,yichang,4Series,2015,100004,1 -1AA100005,yichang,1Series,2015,100005,1 -1AA100006,changsha,6Series,2015,100006,1 -1AA100007,changsha,9Series,2015,100007,1 -1AA100008,changsha,8Series,2015,100008,1 -1AA100009,yichang,0Series,2015,100009,1 -1AA10001,changsha,2Series,2015,10001,1 -1AA100010,zhuzhou,3Series,2015,100010,1 -1AA100011,guangzhou,0Series,2015,100011,1 -1AA100012,xiangtan,4Series,2015,100012,1 -1AA100013,changsha,1Series,2015,100013,1 -1AA100014,zhuzhou,5Series,2015,100014,1 -1AA100015,xiangtan,4Series,2015,100015,1 -1AA100016,changsha,3Series,2015,100016,1 -1AA100017,xiangtan,9Series,2015,100017,1 -1AA100018,yichang,8Series,2015,100018,1 -1AA100019,zhuzhou,5Series,2015,100019,1 -1AA10002,wuhan,0Series,2015,10002,1 -1AA100020,shenzhen,5Series,2015,100020,1 -1AA100021,changsha,0Series,2015,100021,1 -1AA100022,zhuzhou,5Series,2015,100022,1 -1AA100023,guangzhou,5Series,2015,100023,1 -1AA100024,changsha,6Series,2015,100024,1 -1AA100025,guangzhou,0Series,2015,100025,1 -1AA100026,yichang,7Series,2015,100026,1 -1AA100027,zhuzhou,0Series,2015,100027,1 -1AA100028,zhuzhou,5Series,2015,100028,1 -1AA100029,xiangtan,2Series,2015,100029,1 -1AA10003,xiangtan,7Series,2015,10003,1 -1AA100030,zhuzhou,7Series,2015,100030,1 -1AA100031,yichang,7Series,2015,100031,1 -1AA100032,shenzhen,1Series,2015,100032,1 -1AA100033,wuhan,8Series,2015,100033,1 -1AA100034,guangzhou,2Series,2015,100034,1 -1AA100035,changsha,5Series,2015,100035,1 -1AA100036,changsha,5Series,2015,100036,1 -1AA100037,xiangtan,7Series,2015,100037,1 -1AA100038,shenzhen,6Series,2015,100038,1 -1AA100039,shenzhen,8Series,2015,100039,1 -1AA10004,guangzhou,5Series,2015,10004,1 -1AA100040,yichang,8Series,2015,100040,1 -1AA100041,shenzhen,5Series,2015,100041,1 -1AA100042,shenzhen,3Series,2015,100042,1 -1AA100043,guangzhou,9Series,2015,100043,1 -1AA100044,guangzhou,8Series,2015,100044,1 -1AA100045,xiangtan,2Series,2015,100045,1 -1AA100046,guangzhou,3Series,2015,100046,1 -1AA100047,zhuzhou,9Series,2015,100047,1 -1AA100048,guangzhou,3Series,2015,100048,1 -1AA100049,guangzhou,0Series,2015,100049,1 -1AA10005,xiangtan,8Series,2015,10005,1 -1AA100050,yichang,2Series,2015,100050,1 -1AA100051,guangzhou,2Series,2015,100051,1 -1AA100052,zhuzhou,6Series,2015,100052,1 -1AA100053,wuhan,2Series,2015,100053,1 -1AA100054,shenzhen,7Series,2015,100054,1 -1AA100055,yichang,7Series,2015,100055,1 -1AA100056,wuhan,6Series,2015,100056,1 -1AA100057,zhuzhou,9Series,2015,100057,1 -1AA100058,guangzhou,5Series,2015,100058,1 -1AA100059,shenzhen,4Series,2015,100059,1 -1AA10006,guangzhou,3Series,2015,10006,1 -1AA100060,xiangtan,8Series,2015,100060,1 -1AA100061,changsha,6Series,2015,100061,1 -1AA100062,yichang,9Series,2015,100062,1 -1AA100063,yichang,2Series,2015,100063,1 -1AA100064,zhuzhou,6Series,2015,100064,1 -1AA100065,xiangtan,0Series,2015,100065,1 -1AA100066,zhuzhou,6Series,2015,100066,1 -1AA100067,wuhan,4Series,2015,100067,1 -1AA100068,guangzhou,8Series,2015,100068,1 -1AA100069,xiangtan,8Series,2015,100069,1 -1AA10007,xiangtan,8Series,2015,10007,1 -1AA100070,guangzhou,0Series,2015,100070,1 -1AA100071,guangzhou,0Series,2015,100071,1 -1AA100072,changsha,4Series,2015,100072,1 -1AA100073,zhuzhou,4Series,2015,100073,1 -1AA100074,wuhan,6Series,2015,100074,1 -1AA100075,shenzhen,3Series,2015,100075,1 -1AA100076,wuhan,0Series,2015,100076,1 -1AA100077,yichang,3Series,2015,100077,1 -1AA100078,yichang,2Series,2015,100078,1 -1AA100079,xiangtan,4Series,2015,100079,1 -1AA10008,shenzhen,5Series,2015,10008,1 -1AA100080,shenzhen,9Series,2015,100080,1 -1AA100081,shenzhen,5Series,2015,100081,1 -1AA100082,xiangtan,5Series,2015,100082,1 -1AA100083,zhuzhou,0Series,2015,100083,1 -1AA100084,guangzhou,0Series,2015,100084,1 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_376.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_376.csv b/integration-testcases/src/test/resources/hiveExpected/TC_376.csv deleted file mode 100644 index 2fc021c..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_376.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,DistinctCount_gamePointId LongType -1AA1,yichang,7Series,2015,1,1 -1AA10,yichang,7Series,2015,10,1 -1AA100,xiangtan,5Series,2015,100,1 -1AA1000,wuhan,5Series,2015,1000,1 -1AA10000,guangzhou,7Series,2015,10000,1 -1AA100000,wuhan,9Series,2015,100000,1 -1AA1000000,yichang,7Series,2015,1000000,1 -1AA100001,xiangtan,0Series,2015,100001,1 -1AA100002,changsha,0Series,2015,100002,1 -1AA100003,zhuzhou,5Series,2015,100003,1 -1AA100004,yichang,4Series,2015,100004,1 -1AA100005,yichang,1Series,2015,100005,1 -1AA100006,changsha,6Series,2015,100006,1 -1AA100007,changsha,9Series,2015,100007,1 -1AA100008,changsha,8Series,2015,100008,1 -1AA100009,yichang,0Series,2015,100009,1 -1AA10001,changsha,2Series,2015,10001,1 -1AA100010,zhuzhou,3Series,2015,100010,1 -1AA100011,guangzhou,0Series,2015,100011,1 -1AA100012,xiangtan,4Series,2015,100012,1 -1AA100013,changsha,1Series,2015,100013,1 -1AA100014,zhuzhou,5Series,2015,100014,1 -1AA100015,xiangtan,4Series,2015,100015,1 -1AA100016,changsha,3Series,2015,100016,1 -1AA100017,xiangtan,9Series,2015,100017,1 -1AA100018,yichang,8Series,2015,100018,1 -1AA100019,zhuzhou,5Series,2015,100019,1 -1AA10002,wuhan,0Series,2015,10002,1 -1AA100020,shenzhen,5Series,2015,100020,1 -1AA100021,changsha,0Series,2015,100021,1 -1AA100022,zhuzhou,5Series,2015,100022,1 -1AA100023,guangzhou,5Series,2015,100023,1 -1AA100024,changsha,6Series,2015,100024,1 -1AA100025,guangzhou,0Series,2015,100025,1 -1AA100026,yichang,7Series,2015,100026,1 -1AA100027,zhuzhou,0Series,2015,100027,1 -1AA100028,zhuzhou,5Series,2015,100028,1 -1AA100029,xiangtan,2Series,2015,100029,1 -1AA10003,xiangtan,7Series,2015,10003,1 -1AA100030,zhuzhou,7Series,2015,100030,1 -1AA100031,yichang,7Series,2015,100031,1 -1AA100032,shenzhen,1Series,2015,100032,1 -1AA100033,wuhan,8Series,2015,100033,1 -1AA100034,guangzhou,2Series,2015,100034,1 -1AA100035,changsha,5Series,2015,100035,1 -1AA100036,changsha,5Series,2015,100036,1 -1AA100037,xiangtan,7Series,2015,100037,1 -1AA100038,shenzhen,6Series,2015,100038,1 -1AA100039,shenzhen,8Series,2015,100039,1 -1AA10004,guangzhou,5Series,2015,10004,1 -1AA100040,yichang,8Series,2015,100040,1 -1AA100041,shenzhen,5Series,2015,100041,1 -1AA100042,shenzhen,3Series,2015,100042,1 -1AA100043,guangzhou,9Series,2015,100043,1 -1AA100044,guangzhou,8Series,2015,100044,1 -1AA100045,xiangtan,2Series,2015,100045,1 -1AA100046,guangzhou,3Series,2015,100046,1 -1AA100047,zhuzhou,9Series,2015,100047,1 -1AA100048,guangzhou,3Series,2015,100048,1 -1AA100049,guangzhou,0Series,2015,100049,1 -1AA10005,xiangtan,8Series,2015,10005,1 -1AA100050,yichang,2Series,2015,100050,1 -1AA100051,guangzhou,2Series,2015,100051,1 -1AA100052,zhuzhou,6Series,2015,100052,1 -1AA100053,wuhan,2Series,2015,100053,1 -1AA100054,shenzhen,7Series,2015,100054,1 -1AA100055,yichang,7Series,2015,100055,1 -1AA100056,wuhan,6Series,2015,100056,1 -1AA100057,zhuzhou,9Series,2015,100057,1 -1AA100058,guangzhou,5Series,2015,100058,1 -1AA100059,shenzhen,4Series,2015,100059,1 -1AA10006,guangzhou,3Series,2015,10006,1 -1AA100060,xiangtan,8Series,2015,100060,1 -1AA100061,changsha,6Series,2015,100061,1 -1AA100062,yichang,9Series,2015,100062,1 -1AA100063,yichang,2Series,2015,100063,1 -1AA100064,zhuzhou,6Series,2015,100064,1 -1AA100065,xiangtan,0Series,2015,100065,1 -1AA100066,zhuzhou,6Series,2015,100066,1 -1AA100067,wuhan,4Series,2015,100067,1 -1AA100068,guangzhou,8Series,2015,100068,1 -1AA100069,xiangtan,8Series,2015,100069,1 -1AA10007,xiangtan,8Series,2015,10007,1 -1AA100070,guangzhou,0Series,2015,100070,1 -1AA100071,guangzhou,0Series,2015,100071,1 -1AA100072,changsha,4Series,2015,100072,1 -1AA100073,zhuzhou,4Series,2015,100073,1 -1AA100074,wuhan,6Series,2015,100074,1 -1AA100075,shenzhen,3Series,2015,100075,1 -1AA100076,wuhan,0Series,2015,100076,1 -1AA100077,yichang,3Series,2015,100077,1 -1AA100078,yichang,2Series,2015,100078,1 -1AA100079,xiangtan,4Series,2015,100079,1 -1AA10008,shenzhen,5Series,2015,10008,1 -1AA100080,shenzhen,9Series,2015,100080,1 -1AA100081,shenzhen,5Series,2015,100081,1 -1AA100082,xiangtan,5Series,2015,100082,1 -1AA100083,zhuzhou,0Series,2015,100083,1 -1AA100084,guangzhou,0Series,2015,100084,1 http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/9cfe7c91/integration-testcases/src/test/resources/hiveExpected/TC_377.csv ---------------------------------------------------------------------- diff --git a/integration-testcases/src/test/resources/hiveExpected/TC_377.csv b/integration-testcases/src/test/resources/hiveExpected/TC_377.csv deleted file mode 100644 index afee6ec..0000000 --- a/integration-testcases/src/test/resources/hiveExpected/TC_377.csv +++ /dev/null @@ -1,100 +0,0 @@ -imei StringType,deliveryCity StringType,series StringType,Sum_Latest_YEAR LongType,Sum_deviceInformationId LongType,Max_gamePointId DoubleType -1AA1,yichang,7Series,2015,1,2738.562 -1AA10,yichang,7Series,2015,10,1714.635 -1AA100,xiangtan,5Series,2015,100,1271.0 -1AA1000,wuhan,5Series,2015,1000,692.0 -1AA10000,guangzhou,7Series,2015,10000,2175.0 -1AA100000,wuhan,9Series,2015,100000,136.0 -1AA1000000,yichang,7Series,2015,1000000,1600.0 -1AA100001,xiangtan,0Series,2015,100001,505.0 -1AA100002,changsha,0Series,2015,100002,1341.0 -1AA100003,zhuzhou,5Series,2015,100003,2239.0 -1AA100004,yichang,4Series,2015,100004,2970.0 -1AA100005,yichang,1Series,2015,100005,2593.0 -1AA100006,changsha,6Series,2015,100006,2572.0 -1AA100007,changsha,9Series,2015,100007,1991.0 -1AA100008,changsha,8Series,2015,100008,1442.0 -1AA100009,yichang,0Series,2015,100009,1841.0 -1AA10001,changsha,2Series,2015,10001,298.0 -1AA100010,zhuzhou,3Series,2015,100010,79.0 -1AA100011,guangzhou,0Series,2015,100011,202.0 -1AA100012,xiangtan,4Series,2015,100012,568.0 -1AA100013,changsha,1Series,2015,100013,355.0 -1AA100014,zhuzhou,5Series,2015,100014,151.0 -1AA100015,xiangtan,4Series,2015,100015,2863.0 -1AA100016,changsha,3Series,2015,100016,1873.0 -1AA100017,xiangtan,9Series,2015,100017,2205.0 -1AA100018,yichang,8Series,2015,100018,441.0 -1AA100019,zhuzhou,5Series,2015,100019,2194.0 -1AA10002,wuhan,0Series,2015,10002,2972.0 -1AA100020,shenzhen,5Series,2015,100020,256.0 -1AA100021,changsha,0Series,2015,100021,1778.0 -1AA100022,zhuzhou,5Series,2015,100022,1999.0 -1AA100023,guangzhou,5Series,2015,100023,2194.0 -1AA100024,changsha,6Series,2015,100024,2483.0 -1AA100025,guangzhou,0Series,2015,100025,1724.0 -1AA100026,yichang,7Series,2015,100026,1768.0 -1AA100027,zhuzhou,0Series,2015,100027,2436.0 -1AA100028,zhuzhou,5Series,2015,100028,2849.0 -1AA100029,xiangtan,2Series,2015,100029,1691.0 -1AA10003,xiangtan,7Series,2015,10003,2071.0 -1AA100030,zhuzhou,7Series,2015,100030,1333.0 -1AA100031,yichang,7Series,2015,100031,1080.0 -1AA100032,shenzhen,1Series,2015,100032,1053.0 -1AA100033,wuhan,8Series,2015,100033,760.0 -1AA100034,guangzhou,2Series,2015,100034,2061.0 -1AA100035,changsha,5Series,2015,100035,2142.0 -1AA100036,changsha,5Series,2015,100036,2224.0 -1AA100037,xiangtan,7Series,2015,100037,1015.0 -1AA100038,shenzhen,6Series,2015,100038,1229.0 -1AA100039,shenzhen,8Series,2015,100039,1750.0 -1AA10004,guangzhou,5Series,2015,10004,1717.0 -1AA100040,yichang,8Series,2015,100040,2078.0 -1AA100041,shenzhen,5Series,2015,100041,2734.0 -1AA100042,shenzhen,3Series,2015,100042,2745.0 -1AA100043,guangzhou,9Series,2015,100043,571.0 -1AA100044,guangzhou,8Series,2015,100044,1697.0 -1AA100045,xiangtan,2Series,2015,100045,2553.0 -1AA100046,guangzhou,3Series,2015,100046,1077.0 -1AA100047,zhuzhou,9Series,2015,100047,1823.0 -1AA100048,guangzhou,3Series,2015,100048,2399.0 -1AA100049,guangzhou,0Series,2015,100049,2890.0 -1AA10005,xiangtan,8Series,2015,10005,1608.0 -1AA100050,yichang,2Series,2015,100050,29.0 -1AA100051,guangzhou,2Series,2015,100051,1407.0 -1AA100052,zhuzhou,6Series,2015,100052,845.0 -1AA100053,wuhan,2Series,2015,100053,1655.0 -1AA100054,shenzhen,7Series,2015,100054,1368.0 -1AA100055,yichang,7Series,2015,100055,1728.0 -1AA100056,wuhan,6Series,2015,100056,750.0 -1AA100057,zhuzhou,9Series,2015,100057,2288.0 -1AA100058,guangzhou,5Series,2015,100058,2635.0 -1AA100059,shenzhen,4Series,2015,100059,1337.0 -1AA10006,guangzhou,3Series,2015,10006,2478.0 -1AA100060,xiangtan,8Series,2015,100060,538.0 -1AA100061,changsha,6Series,2015,100061,1407.0 -1AA100062,yichang,9Series,2015,100062,2952.0 -1AA100063,yichang,2Series,2015,100063,1226.0 -1AA100064,zhuzhou,6Series,2015,100064,865.0 -1AA100065,xiangtan,0Series,2015,100065,901.0 -1AA100066,zhuzhou,6Series,2015,100066,1864.0 -1AA100067,wuhan,4Series,2015,100067,572.0 -1AA100068,guangzhou,8Series,2015,100068,412.0 -1AA100069,xiangtan,8Series,2015,100069,1491.0 -1AA10007,xiangtan,8Series,2015,10007,1350.0 -1AA100070,guangzhou,0Series,2015,100070,1567.0 -1AA100071,guangzhou,0Series,2015,100071,1973.0 -1AA100072,changsha,4Series,2015,100072,448.0 -1AA100073,zhuzhou,4Series,2015,100073,2488.0 -1AA100074,wuhan,6Series,2015,100074,907.0 -1AA100075,shenzhen,3Series,2015,100075,2507.0 -1AA100076,wuhan,0Series,2015,100076,732.0 -1AA100077,yichang,3Series,2015,100077,2077.0 -1AA100078,yichang,2Series,2015,100078,1434.0 -1AA100079,xiangtan,4Series,2015,100079,1098.0 -1AA10008,shenzhen,5Series,2015,10008,813.0 -1AA100080,shenzhen,9Series,2015,100080,954.0 -1AA100081,shenzhen,5Series,2015,100081,613.0 -1AA100082,xiangtan,5Series,2015,100082,2348.0 -1AA100083,zhuzhou,0Series,2015,100083,2192.0 -1AA100084,guangzhou,0Series,2015,100084,2826.0