You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ja...@apache.org on 2017/03/27 15:04:26 UTC
[1/2] incubator-carbondata git commit: Fixed NPE for double data type
without fraction
Repository: incubator-carbondata
Updated Branches:
refs/heads/master b615892a8 -> e81dec7f7
Fixed NPE for double data type without fraction
added test case for double data type
Project: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/commit/852ab804
Tree: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/tree/852ab804
Diff: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/diff/852ab804
Branch: refs/heads/master
Commit: 852ab804bcb47b890c5f73feae9a4d2e3b8ef321
Parents: b615892
Author: kunal642 <ku...@knoldus.in>
Authored: Fri Mar 24 10:44:32 2017 +0530
Committer: jackylk <ja...@huawei.com>
Committed: Mon Mar 27 20:33:44 2017 +0530
----------------------------------------------------------------------
.../CompressionNonDecimalMaxMinInt.java | 9 -----
.../none/CompressionNoneDefault.java | 6 ---
.../compression/none/CompressionNoneLong.java | 6 ---
.../src/test/resources/oscon_10.csv | 12 ++++++
.../allqueries/DoubleDataTypeTest.scala | 40 ++++++++++++++++++++
5 files changed, 52 insertions(+), 21 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/852ab804/core/src/main/java/org/apache/carbondata/core/datastore/compression/nondecimal/CompressionNonDecimalMaxMinInt.java
----------------------------------------------------------------------
diff --git a/core/src/main/java/org/apache/carbondata/core/datastore/compression/nondecimal/CompressionNonDecimalMaxMinInt.java b/core/src/main/java/org/apache/carbondata/core/datastore/compression/nondecimal/CompressionNonDecimalMaxMinInt.java
index 3df2948..40b1099 100644
--- a/core/src/main/java/org/apache/carbondata/core/datastore/compression/nondecimal/CompressionNonDecimalMaxMinInt.java
+++ b/core/src/main/java/org/apache/carbondata/core/datastore/compression/nondecimal/CompressionNonDecimalMaxMinInt.java
@@ -72,7 +72,6 @@ public class CompressionNonDecimalMaxMinInt extends ValueCompressionHolder<int[]
int decimalPlaces, Object maxValueObject, int numberOfRows) {
super.unCompress(compressor, dataType, compressedData, offset, length, numberOfRows,
maxValueObject, decimalPlaces);
- setUncompressedValues(value, decimalPlaces, maxValueObject);
}
@Override public long getLongValue(int index) {
@@ -91,14 +90,6 @@ public class CompressionNonDecimalMaxMinInt extends ValueCompressionHolder<int[]
"Big decimal value is not defined for CompressionNonDecimalMaxMinInt");
}
- private void setUncompressedValues(int[] data, int decimalPlaces, Object maxValueObject) {
- this.measureChunkStore =
- MeasureChunkStoreFactory.INSTANCE.getMeasureDataChunkStore(DataType.DATA_INT, data.length);
- this.measureChunkStore.putData(data);
- this.maxValue = BigDecimal.valueOf((double) maxValueObject);
- this.divisionFactor = Math.pow(10, decimalPlaces);
- }
-
@Override public void freeMemory() {
this.measureChunkStore.freeMemory();
}
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/852ab804/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneDefault.java
----------------------------------------------------------------------
diff --git a/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneDefault.java b/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneDefault.java
index 41245f4..8e02fd8 100644
--- a/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneDefault.java
+++ b/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneDefault.java
@@ -90,12 +90,6 @@ public class CompressionNoneDefault extends ValueCompressionHolder<double[]> {
"Big decimal is not defined for CompressionNoneDefault");
}
- private void setUncompressedValues(double[] data) {
- this.measureChunkStore = MeasureChunkStoreFactory.INSTANCE
- .getMeasureDataChunkStore(DataType.DATA_DOUBLE, data.length);
- this.measureChunkStore.putData(data);
- }
-
@Override public void freeMemory() {
this.measureChunkStore.freeMemory();
}
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/852ab804/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneLong.java
----------------------------------------------------------------------
diff --git a/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneLong.java b/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneLong.java
index 6e13bb9..ee72c8a 100644
--- a/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneLong.java
+++ b/core/src/main/java/org/apache/carbondata/core/datastore/compression/none/CompressionNoneLong.java
@@ -89,12 +89,6 @@ public class CompressionNoneLong extends ValueCompressionHolder<long[]> {
throw new UnsupportedOperationException("Get big decimal is not supported");
}
- private void setUncompressedValues(long[] data) {
- this.measureChunkStore =
- MeasureChunkStoreFactory.INSTANCE.getMeasureDataChunkStore(DataType.DATA_LONG, data.length);
- this.measureChunkStore.putData(data);
- }
-
@Override public void freeMemory() {
this.measureChunkStore.freeMemory();
}
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/852ab804/integration/spark-common-test/src/test/resources/oscon_10.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/oscon_10.csv b/integration/spark-common-test/src/test/resources/oscon_10.csv
new file mode 100644
index 0000000..a7e0d80
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/oscon_10.csv
@@ -0,0 +1,12 @@
+AA00000,1,1,1,2015-01-01 00:00:00,2011,AC00000,AC000,AD00000,EMUI_VER000,AFV000000,AN0000000,AO000,AP00000,B00000000,2015-01-01 00:00:00,1,1,1,2015,CA00000,20,CNT000,1,1,1951,10K - 30K,CC000,CS0000,CC000,Argentina,L00000000@gmail.com,2011-02-02 00:00:00,CFN000000,ID00000000000,Appraisal Coordinator,CLN000000,L00000000,N000000,Y,M,CSN000,CSN000,CSN00,600000,DC00000,DS00000,DC000,DD00000,DP00000,DN0000000,IN0000000,IB0000000,IBN000000,IC000,ICI000,IC00000,IC00000,IC00,IC00,IF000,IM00,IM00,IMI00,ITM001,Antenna Back Covers,2015-10-01 00:00:00,2015-10-01 00:00:00,LA00000,1,1,1,2015-01-01 00:00:00,2015,LC00000,LC000,LD00000,LEV000000,LFV000000,LN0000000,LO00000,LP00000,2015-01-01 00:00:00,OL_OR_00000000,ON0000000,2015-01-01 00:00:00,www.amazon.in,OS_DES_0000,2015-01-01 00:00:00,1,1,PL0000000,1,2015,CON,Contests,PC00,PCD00,PCD00,L00000000@dmail.com,L00000000@email.com,PCE00,PCP00,PCR00,PT00,PDA00,2015-10-01 00:00:00,PP00000,2015-10-01 00:00:00,PI00000,BAR000000,Acer,Acer Liquid X2,Liquid X
2,LIQUIDX2,BLACK,BLACK,CC00000,PI00,PL00000,PL000,PLD0000,RM00000,RO00000,SE00000,PS00,PT00,add000000,IMEI0000000000000,2015-01-01 00:00:00,UID000000,SC00,SC00,SC00,A,MAIL,31-12-2015 00:00,STR_OR_0000000,TN0000000,WC00,WC00,WC00,WI00,Argentina Warehouse,WS00,WSN00,WS00,10 Hillsborough Dr.,WSN0,500000,2246619.2939,1549622.5278,1218583.4871,1575614.6392,2112779.8010,1949519.6803,1765729.7409,1028956.2678,1325329.9152,1246873.6702,1448976.3920,1000000,2301452.0933,677002426,1574296.84734,2215967.35668,1487129.44735,1019187.65203,1207315.08602,1861853.82287,1541729.18198,1160171.70115,2294954.21121,2113180.25049,1093267.49143,2266364.34842,1913965.15152,1217025.41012,1814178.13759,1426209.17552,1379184.99105,1518589.22124,2151563.30117,1273244.39958,1146664.03961,1176189.4056,1999181.9978,1620208.0024,1365251.8080,1772420.9364,1600069.9523,1798096.1465,2416261.62696,1540040.36259,1803449.70305,1076414.2738,1890039.5634,2076854.054162,2142798.717433,1937093.982983,1389521.384126,1798971.
703037,1433355.474183,2190596.935659,2146010.515458,2501702.773187,2328342.541408,1343218.695544,1796738.775972,2414023.580984,1671799.973790,1336028.742872,2477601.834605,1176411.113372,2506440.392551,1480985.0384812,2086979.1823409,1419515.8037617,1807810.2120234,2207791.9223453,1657710.2013940,2131398.5218440,1852413.2470634,1182927.5997578,2417328.8820591,2167706.9961121,1305782.2530397,2347155.9088361,1488382.6527767,1181548.0939109,1251905.9030056,1567090.1551516,2044777.6397191,2277349.1348524,2247568.5584164,1921832.8260678,1512231.5392571,2416139.9234547,2394884.6996344,2370460.328,1724998.624,2274657.102,2083297.154,1532571.580,2406229.643,1688361.595,1682941.015,1129955.799,1962396.150,1897306.781,1074035.558,1573532.301,1838338.645,1365068.21,1795302.81,2383650.25,2211439.85,1341758.79,2242733.61,1513967.64,1971290.54,2228679.26,1718252.39,1077695.48,1787264.33,1397494.29,1970344.24,1421354.66,1097618.02332150,1569363.91702848,1340752.53488492,1460310.82384934,2321858.57
193967,1969235.14993927,1053812.19520157,2110453.18201409,1987709.81682849,1319158.61819563,1865624.38996417,1123895.81053781,1040902.32945477,1244402.85534477,1165562.04402291,2002068.69481447,1500441.07943299,1040870.54845156,1160483.16247316,1774240.30282926,1875550.04533795,1041740.502414,1103971.102494,2379994.797060,2325033.007650,1597030.741187,2094377.036661,1760336.457987,1409091.059912,2450059.799937,2433015.8943,1270634.8876
+AA00001,2,2,2,2015-01-02 00:00:00,2012,AC00001,AC001,AD00001,EMUI_VER001,AFV000001,AN0000001,AO001,AP00001,B00000001,2015-01-02 00:00:00,2,2,2,2015,CA00001,21,CNT001,2,2,1952,110K - 130K,CC001,CS0001,CC001,Australia,L00000001@gmail.com,2011-02-03 00:00:00,CFN000001,ID00000000001,Appraisals Assistant,CLN000001,L00000001,N000001,Y,M,CSN001,CSN001,CSN01,600001,DC00001,DS00001,DC001,DD00001,DP00001,DN0000001,IN0000001,IB0000001,IBN000001,IC001,ICI001,IC00001,IC00001,IC01,IC01,IF001,IM01,IM01,IMI01,ITM002,Battery Back Covers,2015-10-02 00:00:00,2015-10-02 00:00:00,LA00001,2,2,2,2015-01-02 00:00:00,2015,LC00001,LC001,LD00001,LEV000001,LFV000001,LN0000001,LO00001,LP00001,2015-01-02 00:00:00,OL_OR_00000001,ON0000001,2015-01-02 00:00:00,www.flipkart.com,OS_DES_0001,2015-01-02 00:00:00,2,2,PL0000001,2,2015,SM,Social Media,PC01,PCD01,PCD01,L00000001@dmail.com,L00000001@email.com,PCE01,PCP01,PCR01,PT01,PDA01,2015-10-02 00:00:00,PP00001,2015-10-02 00:00:00,PI00001,BAR000001,Acer,Acer Liquid Jade
2,Liquid Jade 2,LIQUIDJADE2,WHITE,WHITE,CC00001,PI01,PL00001,PL001,PLD0001,RM00001,RO00001,SE00001,PS01,PT01,add000001,IMEI0000000000001,2015-01-02 00:00:00,UID000001,SC01,SC01,SC01,B,SHIP,30-12-2015 00:00,STR_OR_0000001,TN0000001,WC01,WC01,WC01,WI01,Australia Warehouse,WS01,WSN01,WS01,1000 Bidweld Street,WSN1,500001,2188526.1504,1751044.3985,1382953.3930,1234579.4060,2333269.9935,2128671.1241,1881694.9867,2064695.5009,1680462.0602,2363852.0314,1908015.4722,1000000,1347909.6488,1278264145,1128432.67601,2167198.30893,2462357.67332,1077327.63428,2244542.68942,1370697.61059,2420810.20065,1846263.83702,1946980.89138,1054790.79090,1300028.40519,1463494.60190,1469593.89158,1034205.06540,1895995.64266,1445035.63490,1880291.20914,2435120.58718,1728806.09509,1206399.60595,2482661.39395,1555390.4253,2493555.8665,1895247.0089,1559543.4005,1337623.2617,1241292.4180,2288298.9883,2301338.29969,2387925.04594,1913376.03422,1787808.1544,2396650.5777,1541273.020956,1391071.515378,1239805.877776,1219
461.515979,1805264.718404,1926925.265223,1751590.987553,2090437.703955,1080811.570670,1513857.271051,1484629.054475,2065043.774618,1485663.002267,2133905.446919,2158389.802891,1554697.831798,2365330.004314,1596486.054910,1959308.4185421,1948190.3654499,1294037.4812486,1698177.9406381,2361207.5033284,1438659.1109731,1556977.5704364,1687390.2614429,1815933.5473033,2462944.1082078,1078345.6251469,1163656.8694082,1356914.5847704,1328414.0264559,1312408.1671248,2492934.0806605,1815758.8764284,2315819.3893837,1126337.9575562,1560468.8990207,2350635.0032426,1098427.5297560,2397383.0404212,2496313.8326763,1327566.976,1341821.298,1759595.002,2155383.295,1899915.424,1058569.050,1440997.245,1991095.063,1164538.722,1039537.231,2468953.238,1987832.463,2462055.757,1130902.117,1206433.66,2329966.78,1702127.73,1622809.72,1654165.96,2307985.35,1413971.18,1138415.84,1680649.82,1940683.64,1150213.56,2323478.12,1638413.83,1864595.05,1406464.18,1345329.81569248,1066434.72752090,2136769.41370151,1238512.
17854061,1452359.00440669,2466766.39192637,1884803.79938778,2278142.15935211,2240381.97779893,1990975.96476861,1737779.35090794,1590386.49960418,1648680.95540197,2461467.37896039,1454898.46244962,1691137.23707545,2357120.90788970,2022476.10634367,2448141.03404308,1559029.87177805,1165771.06137737,1766861.737615,1240711.982438,2040542.175005,1161317.332798,2021061.930114,1901310.054399,1185349.920548,2358607.575630,1687071.202231,1423872.1604,1470070.0081
+AA00002,3,3,3,2015-01-03 00:00:00,2013,AC00002,AC002,AD00002,EMUI_VER002,AFV000002,AN0000002,AO002,AP00002,B00000002,2015-01-03 00:00:00,3,3,3,2015,CA00002,22,CNT002,3,3,1953,130K - 150K,CC002,CS0002,CC002,Austria,L00000002@gmail.com,2011-02-04 00:00:00,CFN000002,ID00000000002,Art Handler,CLN000002,L00000002,N000002,Y,M,CSN002,CSN002,CSN02,600002,DC00002,DS00002,DC002,DD00002,DP00002,DN0000002,IN0000002,IB0000002,IBN000002,IC002,ICI002,IC00002,IC00002,IC02,IC02,IF002,IM02,IM02,IMI02,ITM003,Camera Lenses,2015-10-03 00:00:00,2015-10-03 00:00:00,LA00002,3,3,3,2015-01-03 00:00:00,2015,LC00002,LC002,LD00002,LEV000002,LFV000002,LN0000002,LO00002,LP00002,2015-01-03 00:00:00,OL_OR_00000002,ON0000002,2015-01-03 00:00:00,www.nearbuy.com,OS_DES_0002,2015-01-03 00:00:00,3,3,PL0000002,3,2015,MOM,Mail Order Marketing,PC02,PCD02,PCD02,L00000002@dmail.com,L00000002@email.com,PCE02,PCP02,PCR02,PT02,PDA02,2015-10-03 00:00:00,PP00002,2015-10-03 00:00:00,PI00002,BAR000002,Acer,Acer Liquid Zest Plus,Liq
uid Zest Plus,LIQUIDZESTPLUS,SILVER,SILVER,CC00002,PI02,PL00002,PL002,PLD0002,RM00002,RO00002,SE00002,PS02,PT02,add000002,IMEI0000000000002,2015-01-03 00:00:00,UID000002,SC02,SC02,SC02,C,FOB,29-12-2015 00:00,STR_OR_0000002,TN0000002,WC02,WC02,WC02,WI02,Austria Warehouse,WS02,WSN02,WS02,1002 N. Spoonwood Court,WSN2,500002,1745848.5038,2164661.5030,1184161.0601,2161865.3703,1239755.2331,2432697.4655,1565177.9892,2004707.2859,1144251.9929,1976078.7730,2445249.3059,1000000,1388899.5044,1051553143,1085028.59405,2479987.92273,1345697.83084,1827444.46212,1561861.53910,1756847.66822,1111894.42569,1211095.97607,2439775.36288,1463055.08771,1659931.60463,1584901.97276,1260427.92490,2488196.75295,1946330.49593,1520318.80663,2054699.87153,1842068.58174,2263541.76277,2213603.05241,1082950.06231,1081239.9843,2114487.0282,2381408.0527,1604582.9897,2230767.3330,1341093.7414,1799743.7319,1347293.45287,1118883.96105,1389517.20787,2129358.6979,1762399.9089,2273823.995313,1251353.553870,1938856.524334,2
048121.949584,1040773.678322,2115189.113048,1183886.606682,2198713.687101,2286807.698393,1572953.934602,2412905.148275,1134183.829276,2143798.633582,1251851.460848,2210291.385045,1375020.172127,2271031.377839,2357791.402475,2028484.4803905,2068600.0889956,2140108.2311021,1605646.6135255,2102566.4505530,2326004.6874033,2032740.1700250,2510038.5834264,1641309.3010235,1969829.4990963,1526539.4500131,1249681.2781730,1665335.1718089,1579817.8432882,1766243.3115542,2452077.2448188,1958270.9698936,2120948.9533001,1777937.0569184,2184674.9075634,1844090.5942388,1359362.4342959,1834875.4612292,1244230.6682411,2463997.836,2021296.466,2060818.525,1383080.956,1342646.237,2229465.197,1959894.684,2297860.235,2042125.433,2017079.797,1432993.616,1006961.445,1526418.997,1756714.334,2324948.97,2195503.70,1602016.56,2167390.10,1044785.77,1452359.07,1305889.35,1003527.13,2055510.54,2509593.15,2109408.90,2435806.49,1299961.29,2109945.75,1758913.78,1824258.15132328,1207968.78419895,2380760.32884289,16823
43.77576034,1410550.68586520,1139818.82094579,2039325.44746187,1726446.06174297,1891517.00618516,1972987.58740713,1363396.06606942,1045138.85376910,1845038.84328180,1995455.89296706,1035693.00549202,1907198.06797074,1697393.49753890,1653554.90695559,1314289.04111808,1189194.37021535,1057932.12668729,2444647.235113,2266039.058392,1993648.524801,1141903.032345,2045918.313673,1917474.006418,1526698.198099,2052878.614181,2110834.555167,2369004.9793,2314950.4028
+AA00003,4,4,4,2015-01-04 00:00:00,2014,AC00003,AC003,AD00003,EMUI_VER003,AFV000003,AN0000003,AO003,AP00003,B00000003,2015-01-04 00:00:00,4,4,4,2015,CA00003,23,CNT003,4,4,1954,150K +,CC003,CS0003,CC003,Bahrain,L00000003@gmail.com,2011-02-05 00:00:00,CFN000003,ID00000000003,Marketing Manager,CLN000003,L00000003,N000003,Y,M,CSN003,CSN003,CSN03,600003,DC00003,DS00003,DC003,DD00003,DP00003,DN0000003,IN0000003,IB0000003,IBN000003,IC003,ICI003,IC00003,IC00003,IC03,IC03,IF003,IM03,IM03,IMI03,ITM004,Decorative PanelsHousing,2015-10-04 00:00:00,2015-10-04 00:00:00,LA00003,4,4,4,2015-01-04 00:00:00,2015,LC00003,LC003,LD00003,LEV000003,LFV000003,LN0000003,LO00003,LP00003,2015-01-04 00:00:00,OL_OR_00000003,ON0000003,2015-01-04 00:00:00,www.paytm.com,OS_DES_0003,2015-01-04 00:00:00,4,4,PL0000003,4,2015,PG,Product Giveaways,PC03,PCD03,PCD03,L00000003@dmail.com,L00000003@email.com,PCE03,PCP03,PCR03,PT03,PDA03,2015-10-04 00:00:00,PP00003,2015-10-04 00:00:00,PI00003,BAR000003,Acer,Acer Liquid Zest,Li
quid Zest,LIQUIDZEST,GOLD,GOLD,CC00003,PI03,PL00003,PL003,PLD0003,RM00003,RO00003,SE00003,PS03,PT03,add000003,IMEI0000000000003,2015-01-04 00:00:00,UID000003,SC03,SC03,SC03,D,REG AIR,28-12-2015 00:00,STR_OR_0000003,TN0000003,WC03,WC03,WC03,WI03,Bahrain Warehouse,WS03,WSN03,WS03,1003 Matterhorn Ct,WSN3,500003,1581090.7744,1265157.9390,1220030.5349,2037758.0824,1637826.2741,1045424.3276,1805906.5140,1938630.3043,2205595.4998,2419222.5883,1251438.0607,1000000,1752558.6680,1458736648,1790947.24403,1614381.25273,1884455.54709,2219636.69553,2244732.23960,1264257.76917,1805227.72064,1497074.78514,1546545.50979,2172945.35296,2112094.28563,1967317.55909,2089445.65438,1489314.42755,2503076.27359,1321522.88752,2473424.24724,2222179.05378,1200587.10745,1113310.24295,1396703.53324,1783420.6040,1836302.2674,1360710.6540,1177416.1701,1371505.8061,1286028.5370,1021329.1731,1092762.17302,1898909.54636,2416592.07488,2192414.3530,1170581.9449,2138041.837370,1111725.703768,2332107.489721,2013987.245818
,1965514.569005,1944111.921234,1389762.073458,1063554.768393,2191076.732008,1534185.439186,1793943.903267,1898329.001152,1384449.777472,1245627.785394,1989592.551354,2440961.482375,1014669.899524,2150175.592430,1930063.0720201,1613415.1632933,1364898.9910400,2209350.2125741,1962794.9295855,1454736.3067766,1273308.1130009,1515395.9702136,2306096.6976903,2222118.5897929,2457093.6171160,2195376.2354386,1385441.0666820,1087088.2059861,1715543.0837766,1397552.9677786,1556996.5510534,1819690.0137549,1642546.3634100,1800824.1113241,2065067.6141136,2082352.0473895,1168857.4129000,1575177.7937250,1431518.936,1279666.644,1126378.389,2503557.738,1610922.395,1381663.628,2268815.187,2172550.727,1835321.301,2042263.619,1516954.800,2362442.896,1947094.587,1333288.861,1327182.01,1320172.11,1604970.11,1687950.22,1472230.46,1644656.53,1430375.19,2171818.44,1549687.73,1735905.23,2070184.68,2289561.98,1420851.45,1081989.44,1102770.28,2347368.66523216,2402726.31063484,2489787.41379363,2160342.66647333,2
373079.83953064,2149453.32232071,2167200.77200723,1557306.54726694,1478813.25362404,1284588.92972912,1023438.25915412,1027095.81066566,2192913.55549925,2494903.28911474,1322379.62132762,2280948.20678492,1724948.91879548,1460179.46570984,2390233.76975352,1936145.50213325,2055382.94794085,2440155.038898,2137845.620814,1275102.784339,1868693.614354,1533672.448857,1030588.641209,1058446.069081,2474701.626251,2331398.099478,2098263.2353,1797228.5108
+AA00004,5,5,5,2015-01-05 00:00:00,2015,AC00004,AC004,AD00004,EMUI_VER004,AFV000004,AN0000004,AO004,AP00004,B00000004,2015-01-05 00:00:00,5,5,5,2015,CA00004,24,CNT004,5,5,1955,30K - 50K,CC004,CS0004,CC004,Belgium,L00000004@gmail.com,2011-02-06 00:00:00,CFN000004,ID00000000004,Associate Specialist,CLN000004,L00000004,N000004,Y,M,CSN004,CSN004,CSN04,600004,DC00004,DS00004,DC004,DD00004,DP00004,DN0000004,IN0000004,IB0000004,IBN000004,IC004,ICI004,IC00004,IC00004,IC04,IC04,IF004,IM04,IM04,IMI04,ITM005,Back CoversHousing,2015-10-05 00:00:00,2015-10-05 00:00:00,LA00004,5,5,5,2015-01-05 00:00:00,2015,LC00004,LC004,LD00004,LEV000004,LFV000004,LN0000004,LO00004,LP00004,2015-01-05 00:00:00,OL_OR_00000004,ON0000004,2015-01-05 00:00:00,www.askmebazaar.com,OS_DES_0004,2015-01-05 00:00:00,5,5,PL0000004,5,2015,POSPECM,Point-of-Sale Promotion and End-Cap Marketing,PC04,PCD04,PCD04,L00000004@dmail.com,L00000004@email.com,PCE04,PCP04,PCR04,PT04,PDA04,2015-10-05 00:00:00,PP00004,2015-10-05 00:00:00,PI0
0004,BAR000004,Acer,Acer Predator 8 Android tablet,Predator 8,PREDATOR8,GRAY,GRAY,CC00004,PI04,PL00004,PL004,PLD0004,RM00004,RO00004,SE00004,PS04,PT04,add000004,IMEI0000000000004,2015-01-05 00:00:00,UID000004,SC04,SC04,SC04,E,RAIL,27-12-2015 00:00,STR_OR_0000004,TN0000004,WC04,WC04,WC04,WI04,Belgium Warehouse,WS04,WSN04,WS04,1005 Fremont Street,WSN4,500004,1040778.9230,2310377.9087,2317420.1227,1954850.9808,2238119.3924,1654542.1281,1560277.1587,1428545.0641,1747819.6806,1819302.0101,1151992.4060,1000000,1917148.9947,1092535148,1089694.04989,1441065.10483,1649067.19727,1792822.53735,2040744.89073,2100361.64420,2436698.13550,1049401.48907,2289981.65598,1026381.04429,1235485.84212,1706505.03616,1962606.88772,2461929.56572,2429225.01056,2162032.94649,2084868.57432,1141845.46664,1018687.38885,1930811.61809,1403251.66460,1824046.3366,1438994.3279,1597267.1255,2315991.9156,1850945.2019,2096597.5930,1933788.7198,1702570.58918,1469146.45653,1052734.89585,1841814.4893,1133019.6165,2448530.63
2215,1090095.273913,1927428.215840,1569025.020114,1647579.993314,1917769.941229,2205061.096991,1301724.365170,1709042.829265,1654105.553045,2255088.801060,2364894.254320,2209521.310843,1243905.900455,1597057.414099,1593853.634382,1870722.325613,1680341.688861,1223570.1544134,1660759.7981643,1316011.4567232,1455163.7474591,1249252.4419328,2500890.9200083,1659786.5426141,1643475.7155441,1388652.5549637,2226683.5742448,2047983.4671761,1897839.0183158,2269114.7327183,2263913.1066888,1487753.5045496,2065865.6956668,2438098.9018435,2236983.2273488,1684462.4973586,1300933.0401089,1523610.7466001,1967817.4760653,2227799.6205781,2326431.2361433,2425875.138,1232525.904,1830964.059,1998181.353,1829503.045,2259238.523,1998774.741,1796774.257,1017718.350,2281940.388,1340338.429,1063642.722,2328885.897,1446600.676,2239815.99,1639879.72,2467982.14,1355319.20,2480268.19,2036578.10,1400952.46,1658346.59,1783526.55,1181077.83,2201834.34,1617906.12,1372729.61,2493022.76,2104983.97,1942457.71894476,217
7615.34934794,1644329.00846932,1523941.18667100,1805453.37329926,2305506.16015261,1938549.96810515,1255650.00883140,2101321.44176434,2298259.29471157,1540704.79982654,2303312.18055402,1878062.12632980,1573862.25964932,1954564.53354260,1028086.23145766,2252357.06395071,1536690.75885485,2161120.44020354,1122392.86422513,2370825.52607015,1820762.160533,1089755.667661,1043765.393306,1330555.074282,2098941.448173,2025990.510533,1503871.583092,1512282.590830,2128916.098084,2274042.0237,1556076.8969
+AA00005,6,6,6,2015-01-06 00:00:00,2011,AC00005,AC005,AD00005,EMUI_VER005,AFV000005,AN0000005,AO005,AP00005,B00000005,2015-01-06 00:00:00,6,6,6,2015,CA00005,25,CNT005,6,6,1956,50K - 70K,CC005,CS0005,CC005,Bermuda,L00000005@gmail.com,2011-02-07 00:00:00,CFN000005,ID00000000005,Auctioneer,CLN000005,L00000005,N000005,Y,M,CSN005,CSN005,CSN05,600005,DC00005,DS00005,DC005,DD00005,DP00005,DN0000005,IN0000005,IB0000005,IBN000005,IC005,ICI005,IC00005,IC00005,IC05,IC05,IF005,IM05,IM05,IMI05,ITM006,FrameHousing,2015-10-06 00:00:00,2015-10-06 00:00:00,LA00005,6,6,6,2015-01-06 00:00:00,2015,LC00005,LC005,LD00005,LEV000005,LFV000005,LN0000005,LO00005,LP00005,2015-01-06 00:00:00,OL_OR_00000005,ON0000005,2015-01-06 00:00:00,www.shopclues.com,OS_DES_0005,2015-01-06 00:00:00,6,6,PL0000005,6,2015,CRIP,Customer Referral Incentive Program,PC05,PCD05,PCD05,L00000005@dmail.com,L00000005@email.com,PCE05,PCP05,PCR05,PT05,PDA05,2015-10-06 00:00:00,PP00005,2015-10-06 00:00:00,PI00005,BAR000005,Acer,Acer Liquid
Jade Primo Windows Mobile smartphone,Liquid Jade Primo,LIQUIDJADEPRIMO,BLUE,BLUE,CC00005,PI05,PL00005,PL005,PLD0005,RM00005,RO00005,SE00005,PS05,PT05,add000005,IMEI0000000000005,2015-01-06 00:00:00,UID000005,SC05,SC05,SC05,F,AIR,26-12-2015 00:00,STR_OR_0000005,TN0000005,WC05,WC05,WC05,WI05,Bermuda Warehouse,WS05,WSN05,WS05,1005 Matterhorn Ct.,WSN5,500005,1982563.7262,2101838.8578,2095336.2903,1983799.2059,1939181.1760,2444513.8109,2027481.6830,1839529.2840,2240317.8163,2117004.6610,2100230.7914,1000000,1661478.2766,1356990956,1518052.89794,1582638.76438,2257318.99999,1532032.34252,2495409.83123,1699524.90463,2255406.70745,1292691.99244,2075156.09748,1194305.46110,2121713.74130,1245487.99558,1301752.12845,2221356.74168,1494097.76661,1950319.83285,1776569.08316,2295986.74607,2280970.73958,2099412.27683,2092529.55620,1288880.7384,1426496.9417,2093994.3342,2337937.1079,1651583.7820,1380982.7877,1222204.8185,2433577.02040,1475947.28805,2351650.39195,2170366.3554,2087073.9819,1864384.586
349,2187035.193311,1856965.305656,2374046.238171,1851292.044066,1118637.417786,1330485.123880,1758847.909411,2314233.501263,1763730.009044,2043558.296904,1515104.119268,1115444.840453,2149164.382488,1344412.331846,1268008.677965,2339070.348153,1786225.401986,2447858.3455938,2326617.6632300,1819216.0523759,2100822.6585798,1250650.7810150,1963545.6478758,1060191.8893268,2115699.4997332,1699225.4085571,2341705.3980368,2323962.0575002,1874108.4479085,1396329.5759678,1529190.1595761,2031670.6732901,1255538.4367996,1469585.3350581,1638787.7364091,2048254.3928039,1782451.4379954,1912816.0179668,1154638.1128562,1146476.9304147,2457624.3935202,2158714.828,1089315.549,2041998.213,1468344.854,1615636.764,1472187.750,2429794.707,2188072.934,1634052.705,1624136.040,2379695.174,1325243.727,1070011.896,1181266.680,2371409.17,2223212.22,1472897.60,2352793.52,1592434.53,2199501.20,1730991.38,1607084.30,1634325.10,1988192.00,1923519.69,1451074.77,2325399.20,1558279.51,2495015.01,2088064.97421545,1411
427.30911039,1918211.84519349,2140077.19972407,2207963.27016382,1532080.85929823,1714606.12893152,1282415.34855030,1278926.25642449,2110740.64515658,1431414.76973664,1304806.94583218,2275087.47375155,1784925.09679569,2095266.91643714,1631553.60928684,1748210.03696770,1741847.19541115,2004860.85544929,1689607.82521601,2442897.04063692,2073552.724641,2471483.855609,2235416.682837,1636044.094762,2336635.063614,1603820.355786,1951762.908015,2258966.853892,1188482.345179,1442157.3103,2213464.1550
+AA00006,7,7,7,2015-01-07 00:00:00,2012,AC00006,AC006,AD00006,EMUI_VER006,AFV000006,AN0000006,AO006,AP00006,B00000006,2015-01-07 00:00:00,7,7,7,2015,CA00006,26,CNT006,7,7,1957,70K - 90K,CC006,CS0006,CC006,Brazil,L00000006@gmail.com,2011-02-08 00:00:00,CFN000006,ID00000000006,Acquisition Manager,CLN000006,L00000006,N000006,Y,M,CSN006,CSN006,CSN06,600006,DC00006,DS00006,DC006,DD00006,DP00006,DN0000006,IN0000006,IB0000006,IBN000006,IC006,ICI006,IC00006,IC00006,IC06,IC06,IF006,IM06,IM06,IMI06,ITM007,GlassesHousing,2015-10-07 00:00:00,2015-10-07 00:00:00,LA00006,7,7,7,2015-01-07 00:00:00,2015,LC00006,LC006,LD00006,LEV000006,LFV000006,LN0000006,LO00006,LP00006,2015-01-07 00:00:00,OL_OR_00000006,ON0000006,2015-01-07 00:00:00,www.snapdeal.com,OS_DES_0006,2015-01-07 00:00:00,7,7,PL0000006,7,2015,CC,Causes and Charity,PC06,PCD06,PCD06,L00000006@dmail.com,L00000006@email.com,PCE06,PCP06,PCR06,PT06,PDA06,2015-10-07 00:00:00,PP00006,2015-10-07 00:00:00,PI00006,BAR000006,Acer,Acer Liquid Z330,Liqu
id Z330,LIQUIDZ330,RED,RED,CC00006,PI06,PL00006,PL006,PLD0006,RM00006,RO00006,SE00006,PS06,PT06,add000006,IMEI0000000000006,2015-01-07 00:00:00,UID000006,SC06,SC06,SC06,G,TRUCK,25-12-2015 00:00,STR_OR_0000006,TN0000006,WC06,WC06,WC06,WI06,Brazil Warehouse,WS06,WSN06,WS06,1005 Tanager Court,WSN6,500006,2326097.9941,1902303.0025,1704083.7834,2182885.5922,1491109.6037,2294208.9999,2028051.8739,1986005.8654,1431625.5511,2193354.7559,2476872.6489,1000000,1094054.8934,2048707088,1947246.88590,1660979.26550,1616730.32648,1663994.36970,2065147.82290,2330104.39734,2109571.93416,1112051.65986,1938863.38574,1239536.18304,1327269.37878,1054444.97805,2035628.24833,2274477.34111,1325298.80972,1317943.69867,1123791.75921,1784035.25598,2458137.65523,2276014.96744,1007768.51698,2106590.4680,2453385.6196,2163157.2037,1204520.0039,2450712.5176,1547813.4943,1113696.8207,2416046.95153,1028011.57574,1911012.45695,2268887.8140,2102259.1990,2092714.054598,1843771.683207,1750274.821729,2504465.553021,204085
9.006054,2493963.609253,2045428.625037,1019901.044120,1110746.592424,2027282.177205,1602592.513919,1433654.484693,1661211.990782,1099791.331360,1862807.955915,1415191.633077,1602850.993001,1052998.804392,2208612.5351769,1649385.0573941,1821157.9485178,2186704.0184135,2005017.7348276,2113630.4028792,1006426.6900023,1586830.6108914,1332188.0301072,2160627.2850963,2493379.3310693,1264019.5848003,1470678.8187239,1375435.2696018,2230858.4248469,2363364.5004564,1721395.8606395,1790434.8771337,1422231.9718703,2077431.4943544,2319164.9960290,2135392.9859165,2291420.3558416,1151935.9165128,1679249.966,1003097.657,1132284.577,1941431.119,2048239.696,2228658.319,2111665.967,1728882.699,1972135.223,1755227.139,1337699.179,1845893.793,1916260.132,1906291.300,1161626.79,2084935.31,1033497.04,2367614.81,1545966.53,1305227.10,1121221.46,1230217.22,2227555.69,1668263.60,1471339.70,2131602.78,1566177.72,2077649.93,1347157.86,1274329.37413011,1928536.51535115,1556629.39951140,1091875.00294666,2457699.
79502677,1815937.49421295,1991902.63712718,1344687.37840963,1983161.07063837,1907701.09612969,2304767.94298486,1469081.75180836,2280091.25429863,1467662.69599663,1366648.35744346,2405048.60711920,2511402.20604491,1423809.51652564,1330289.05424858,1159305.85939754,1356339.35000005,1280883.864539,1173780.630776,1912916.466834,1687301.547577,1905862.886156,1691928.070688,1667708.041371,2384654.096682,1424176.930933,2341913.6338,1033964.6226
+AA00007,8,8,8,2015-01-08 00:00:00,2013,AC00007,AC007,AD00007,EMUI_VER007,AFV000007,AN0000007,AO007,AP00007,B00000007,2015-01-08 00:00:00,8,8,8,2015,CA00007,27,CNT007,8,8,1958,10K - 30K,CC007,CS0007,CC007,Bulgaria,L00000007@gmail.com,2011-02-09 00:00:00,CFN000007,ID00000000007,Bid Coordinator,CLN000007,L00000007,N000007,Y,M,CSN007,CSN007,CSN07,600007,DC00007,DS00007,DC007,DD00007,DP00007,DN0000007,IN0000007,IB0000007,IBN000007,IC007,ICI007,IC00007,IC00007,IC07,IC07,IF007,IM07,IM07,IMI07,ITM008,Side Button,2015-10-08 00:00:00,2015-10-08 00:00:00,LA00007,8,8,8,2015-01-08 00:00:00,2015,LC00007,LC007,LD00007,LEV000007,LFV000007,LN0000007,LO00007,LP00007,2015-01-08 00:00:00,OL_OR_00000007,ON0000007,2015-01-08 00:00:00,www.yepme.com,OS_DES_0007,2015-01-08 00:00:00,8,8,PL0000007,8,2015,BPG,Branded Promotional Gifts,PC07,PCD07,PCD07,L00000007@dmail.com,L00000007@email.com,PCE07,PCP07,PCR07,PT07,PDA07,2015-10-08 00:00:00,PP00007,2015-10-08 00:00:00,PI00007,BAR000007,Acer,Acer Liquid Z320,Liqu
id Z320,LIQUIDZ320,ORANGE,ORANGE,CC00007,PI07,PL00007,PL007,PLD0007,RM00007,RO00007,SE00007,PS07,PT07,add000007,IMEI0000000000007,2015-01-08 00:00:00,UID000007,SC07,SC07,SC07,H,COD,24-12-2015 00:00,STR_OR_0000007,TN0000007,WC07,WC07,WC07,WI07,Bulgaria Warehouse,WS07,WSN07,WS07,1005 Valley Oak Plaza,WSN7,500007,1010691.9546,2065634.0815,1780584.3177,1374973.8464,1710250.5731,2183106.2594,1019129.0652,1997906.9534,1093289.1027,1518142.0315,2064389.7779,1000000,1615114.8376,1430142647,2357287.21816,1154355.84800,1172782.74681,1369412.08714,1089812.06018,1013521.50999,1545228.69384,1213953.12533,1259445.76731,1559144.10365,1628767.07498,1850987.34665,2332054.22050,1324920.23804,2180233.24952,2043177.22942,1910116.20007,2023594.97399,1777023.39526,1322299.25951,2470111.55447,1605910.0698,2002826.9131,1666231.6276,1321861.8510,2261683.3590,1742410.9500,2500638.3194,1204257.57352,1417041.38818,2149640.93383,1579945.4698,1379259.3966,1505931.982057,1611551.044468,1517426.669680,1721658.7590
68,1382502.199991,1848978.737117,1999285.770138,1544733.718201,1273956.402266,1497964.738365,1110215.831419,1773969.428259,2181624.679163,1600675.638379,2317879.944741,1971182.066253,1723003.806095,1033916.451364,2317506.3078851,1687932.3677008,2127134.3976947,1978179.0983527,1972314.8987100,1396435.3727671,1585141.1287504,2180863.0255861,1821679.2785719,1848191.6011952,2330265.4302627,2229565.3141393,1732333.5466483,1585747.8317682,1515478.0824791,1868680.2270872,1638443.7538481,1955624.8712581,2446759.5951821,1612004.7173617,1108858.3301937,1489200.7686890,2017045.9554479,1903340.6887616,1163616.589,1116722.258,1388778.997,1447182.554,1324156.275,1903035.165,1365583.320,1379825.499,1816605.169,1744034.203,1687560.492,2114189.836,1167266.576,1740747.533,1241864.98,1009538.65,1065911.63,1872650.51,2508051.44,1999313.46,1837347.32,1968499.34,1890071.31,1507794.30,1272521.75,1110777.74,1716860.04,2066612.84,2355134.31,2477432.49279966,1022830.60336133,1088106.36595465,1368657.33819501
,2344109.22454046,1043076.53191147,2390520.16958299,1408681.58317478,1212451.74446123,2189434.73417553,1444597.00785372,1231726.88023118,1404820.61104150,1852545.39084483,1122329.33950966,1935436.76032372,1427291.94606722,2477703.49672535,2381508.65890912,1989285.83965994,1524713.47593011,1444164.209151,2480800.399427,2168285.703958,1310437.728960,1248355.795862,1201731.211762,2448113.890432,2049796.315306,1407289.931799,2330520.6647,2214074.1665
+AA00008,9,9,9,2015-01-09 00:00:00,2014,AC00008,AC008,AD00008,EMUI_VER008,AFV000008,AN0000008,AO008,AP00008,B00000008,2015-01-09 00:00:00,9,9,9,2015,CA00008,28,CNT008,9,9,1959,110K - 130K,CC008,CS0008,CC008,Canada,L00000008@gmail.com,2011-02-10 00:00:00,CFN000008,ID00000000008,Business Analyst ,CLN000008,L00000008,N000008,Y,M,CSN008,CSN008,CSN08,600008,DC00008,DS00008,DC008,DD00008,DP00008,DN0000008,IN0000008,IB0000008,IBN000008,IC008,ICI008,IC00008,IC00008,IC08,IC08,IF008,IM08,IM08,IMI08,ITM009,PlasticsHousings,2015-10-09 00:00:00,2015-10-09 00:00:00,LA00008,9,9,9,2015-01-09 00:00:00,2015,LC00008,LC008,LD00008,LEV000008,LFV000008,LN0000008,LO00008,LP00008,2015-01-09 00:00:00,OL_OR_00000008,ON0000008,2015-01-09 00:00:00,www.jabong.com,OS_DES_0008,2015-01-09 00:00:00,9,9,PL0000008,9,2015,CAE,Customer Appreciation Events,PC08,PCD08,PCD08,L00000008@dmail.com,L00000008@email.com,PCE08,PCP08,PCR08,PT08,PDA08,2015-10-09 00:00:00,PP00008,2015-10-09 00:00:00,PI00008,BAR000008,Acer,Acer Liqui
d Z630S,Liquid Z630S,LIQUIDZ630S,PURPLE,PURPLE,CC00008,PI08,PL00008,PL008,PLD0008,RM00008,RO00008,SE00008,PS08,PT08,add000008,IMEI0000000000008,2015-01-09 00:00:00,UID000008,SC08,SC08,SC08,I,COLLECT COD,23-12-2015 00:00,STR_OR_0000008,TN0000008,WC08,WC08,WC08,WI08,Canada Warehouse,WS08,WSN08,WS08,1006 Deercreek Ln,WSN8,500008,1821967.8152,1301676.2120,1732124.6692,1046733.6267,2392490.7869,1080250.3624,1883640.7235,1761045.4550,2080945.9717,2306056.5491,1277334.5794,1000000,1372164.7345,747465962,1392292.18263,2219981.42655,1118939.10841,1747861.07529,1671494.61667,1251543.67659,1513401.03373,1379349.99570,1995082.98568,1533084.96311,2409310.74946,1615131.70496,1189476.45968,2091064.75903,1374667.39913,2101597.11427,2060168.51313,1359480.90037,1247827.48691,1316734.79683,2268902.20460,2408429.6156,2223996.7220,1629641.3934,2066346.7528,1561569.4861,2270885.7034,2117758.0328,2051693.04368,2509118.44573,2272971.27153,1286327.4667,1334928.4664,1314902.277546,1638671.871045,1823260.5624
09,1947767.636768,1512890.817009,1232851.163268,2311994.674528,2167647.579713,1715583.864212,2509986.233311,1400148.149051,1390744.904013,2306098.428243,1620901.413681,2472779.228457,2185305.723579,1308041.481710,1855568.506007,1993785.4427312,1125297.7384121,1389528.2535324,2220345.7222511,1454764.4131803,1633838.3361977,2480840.7771738,1532627.5222785,2064344.7245562,2414929.1932292,2285671.8088976,2443914.1464794,1313537.6360983,1019948.9519286,1013824.2101517,2508766.1890328,2251558.9541934,1267141.7747022,1353313.3075753,1723158.3777691,1851434.3568759,1665149.4656266,1473980.1475361,1036414.1346258,1603963.611,1444796.561,1229707.915,1769794.821,1391326.327,1438666.429,2512436.518,2460708.871,1081076.813,1408091.910,1567662.257,1094387.688,1920833.601,1988054.883,1095720.46,1423651.48,1698704.26,2265130.37,1288124.39,2311252.39,1845465.50,2358351.54,1581547.81,2284407.86,2396952.56,2044903.94,1226080.05,2502238.37,1258522.87,1909164.77580140,2258188.69441370,2107763.02937363,1
916851.92123935,1116949.49246432,1673761.55026788,1044427.16137198,1126667.58134365,1029206.67471691,2007154.85874945,1444861.54928773,1064150.46189008,1370147.47157086,1803329.37804488,1746207.04895074,1791546.69438348,1494661.01766549,1919824.76717559,1742298.61230469,2376841.60101653,1291752.35873888,1110620.764924,1993763.687780,1675254.227759,1220350.711242,1444996.865799,2310913.318113,1177558.198792,1397719.823840,1776410.941352,1340651.1466,2426472.4355
+AA00009,10,10,10,2015-01-10 00:00:00,2015,AC00009,AC009,AD00009,EMUI_VER009,AFV000009,AN0000009,AO009,AP00009,B00000009,2015-01-10 00:00:00,10,10,10,2015,CA00009,29,CNT009,10,10,1960,130K - 150K,CC009,CS0009,CC009,Cayman Isls,L00000009@gmail.com,2011-02-11 00:00:00,CFN000009,ID00000000009,Business Coordinator,CLN000009,L00000009,N000009,Y,M,CSN009,CSN009,CSN09,600009,DC00009,DS00009,DC009,DD00009,DP00009,DN0000009,IN0000009,IB0000009,IBN000009,IC009,ICI009,IC00009,IC00009,IC09,IC09,IF009,IM09,IM09,IMI09,ITM010,Joystick,2015-10-10 00:00:00,2015-10-10 00:00:00,LA00009,10,10,10,2015-01-10 00:00:00,2015,LC00009,LC009,LD00009,LEV000009,LFV000009,LN0000009,LO00009,LP00009,2015-01-10 00:00:00,OL_OR_00000009,ON0000009,2015-01-10 00:00:00,www.fashionandyou.com,OS_DES_0009,2015-01-10 00:00:00,10,10,PL0000009,10,2015,ASCS,After-Sale Customer Surveys,PC09,PCD09,PCD09,L00000009@dmail.com,L00000009@email.com,PCE09,PCP00,PCR00,PT09,PDA00,2015-10-10 00:00:00,PP00000,2015-10-10 00:00:00,PI00009,BAR0
00009,Acer,Acer Liquid Z630,Liquid Z630,LIQUIDZ630,BLACK,GREEN,CC00009,PI09,PL00009,PL009,PLD0009,RM00009,RO00009,SE00009,PS09,PT09,add000009,IMEI0000000000009,2015-01-10 00:00:00,UID000009,SC00,SC00,SC00,J,TAKE BACK RETURN,22-12-2015 00:00,STR_OR_0000009,TN0000009,WC09,WC09,WC00,WI00,Cayman Isls Warehouse,WS09,WSN09,WS00,10 Hillsborough Dr.,WSN0,500009,1452953.6720,2314603.9870,1222779.6381,2320413.8152,1578491.9168,2285541.4945,2202108.7816,1243812.1695,2229251.0306,2493003.4913,1168134.0620,1000000,1928504.7895,1346138159,1918389.33412,1989844.88434,2126013.76979,2090048.45721,1499415.10510,1943624.87703,2340003.36956,1506332.54130,1362444.24804,2486379.85514,2070814.40254,2173814.07883,1800470.17191,1059916.19316,2066386.36357,1830802.71478,1962583.63070,1358702.35214,1721744.07738,1501348.16010,1051098.43457,2217082.5875,1554497.5269,1504990.1361,1949356.3074,2461761.7195,1075070.4195,1597450.5695,1766683.29652,1765354.98715,2185476.35760,1885696.8867,2309831.8383,1186426.50562
1,1110828.946257,1470573.754233,1388575.794703,2258877.069027,1307252.263936,1961870.543428,2382728.317845,1658513.055994,1876861.908581,1492929.820985,2254934.040687,1092976.567038,2071728.724024,1648259.973504,2296814.861489,1562550.553092,1208281.469954,1974345.5043859,2026109.9944002,1146004.1094795,2449271.5691025,1864686.1114164,2237047.1326712,1219915.7372022,2498944.2141263,1284367.0239240,2199724.3709461,2270925.5132309,1837014.1466995,1159821.8278437,2137689.0501441,1527406.4309605,1117102.7026943,2261293.0725694,1270693.5845418,2481499.2240283,1783731.4342730,1357482.0377244,1678541.3336666,2003901.9234079,1335728.0714173,1434248.328,2242943.902,1814892.592,1610872.564,1222116.417,1989150.632,1518290.706,1675254.673,1757626.825,1896122.310,1009365.169,2412563.489,1424975.066,1907138.450,1525577.52,1921453.63,1125283.64,1916703.84,1427795.62,1546975.49,2364969.16,1942660.66,1766270.27,2115726.30,1643977.40,2470505.44,1570260.92,1439741.41,1670629.88,1603051.78386946,205298
6.12234826,1326768.78127210,2190656.39439025,2478096.89864534,2429530.34943324,1545639.35662141,2112036.73895961,1268350.71269970,1123757.35080650,2236841.88472704,1182531.48584431,2238670.93670464,2124265.02579352,1261448.98032114,1552262.12454988,2425447.53658805,2032769.33149468,2037686.21267210,1058885.91554945,1497751.29524797,1404543.713181,1759393.380752,2239534.577643,2420906.938505,2479251.659581,2146028.017045,1858217.402024,1727861.591991,2449680.361319,1778085.9750,2432808.7897
+AA00010,11,11,11,2015-01-11 00:00:00,2011,AC00010,AC010,AD00010,EMUI_VER010,AFV000010,AN0000010,AO010,AP00010,B00000010,2015-01-11 00:00:00,11,11,11,2015,CA00010,30,CNT010,11,11,1961,150K +,CC010,CS0010,CC010,China,L00000010@gmail.com,2011-02-12 00:00:00,CFN000010,ID00000000010,Business Manager ,CLN000010,L00000010,N000010,Y,M,CSN010,CSN010,CSN10,600010,DC00010,DS00010,DC010,DD00010,DP00010,DN0000010,IN0000010,IB0000010,IBN000010,IC010,ICI010,IC00010,IC00010,IC10,IC10,IF010,IM10,IM10,IMI10,ITM011,Plasctics,2015-10-11 00:00:00,2015-10-11 00:00:00,LA00010,11,11,11,2015-01-11 00:00:00,2015,LC00010,LC010,LD00010,LEV000010,LFV000010,LN0000010,LO00010,LP00010,2015-01-11 00:00:00,OL_OR_00000010,ON0000010,2015-01-11 00:00:00,www.fashionara.com,OS_DES_0010,2015-01-11 00:00:00,11,11,PL0000010,11,2015,ADV,Advertising,PC10,PCD10,PCD10,L00000010@dmail.com,L00000010@email.com,PCE10,PCP01,PCR01,PT10,PDA01,2015-10-11 00:00:00,PP00001,2015-10-11 00:00:00,PI00010,BAR000010,Acer,Acer Liquid Z530S,Liqu
id Z530S,LIQUIDZ530S,WHITE,BLACK,CC00010,PI10,PL00010,PL010,PLD0010,RM00010,RO00010,SE00010,PS10,PT10,add000010,IMEI0000000000010,2015-01-11 00:00:00,UID000010,SC01,SC01,SC01,K,DELIVER IN PERSON,21-12-2015 00:00,STR_OR_0000010,TN0000010,WC10,WC10,WC01,WI01,China Warehouse,WS10,WSN10,WS01,1000 Bidweld Street,WSN1,500010,2307290.2668,1982586.2720,1960009.0054,1214220.8120,1115906.8437,2416583.4397,2212796.0895,1594669.3698,1426365.3470,1961604.2382,1647318.5239,1000000,1718410.6932,1595676811,1418177.83432,2080228.91422,2210601.29071,1438131.37431,1028076.55261,1989980.44251,1052579.12019,1704867.56838,1021561.60659,2250986.32934,1066481.81520,1776621.99170,1324196.24368,1379026.85963,2380422.69496,1780145.65180,2258032.08749,2234620.70787,2143020.57937,1311615.04350,1397911.19002,2067960.1203,2021710.5711,2099989.7676,1208124.8342,1545308.6772,2337012.9615,1337590.3866,1856648.43765,2395970.29480,1068924.45987,1681015.2033,2425382.0266,1231334.474863,2183439.561330,1792415.171425,125
9805.100957,2419631.183760,1499744.176658,1486120.046496,1859884.080587,2020743.669185,1581213.895469,1901138.822807,1856506.483142,1658732.412384,1889060.623095,1098455.347128,1037428.005950,1679980.835803,2034577.070663,1611612.1865258,1716342.4914766,1491472.0942950,2462966.6912378,2377369.6826164,2329349.6038955,1596851.1412652,1337156.8898344,1185297.8915909,2017519.4265870,2124197.8830123,1400897.2832344,1983345.0540284,1411735.9644693,1308583.8277068,1534335.0477889,1331005.2545096,1739724.6226874,1894147.2193571,2085725.0362266,2053193.7350865,1155324.7000565,1420194.4448634,1525244.4112519,1723937.047,1826017.000,1810880.865,1271907.658,1639587.959,1369716.111,2020055.827,1243320.097,1695185.545,2026436.939,2220807.362,1896508.965,1896417.488,1704152.397,2499047.52,2508258.10,1449909.56,1785308.10,2186466.42,2031272.69,1790944.62,1977300.92,2412950.81,1943329.05,2499192.64,1823299.92,2067799.55,1045270.29,1730765.39,1180775.93012266,2446125.06852611,2371916.32245336,2321908
.37023596,2492634.22567508,1114436.92644283,1630366.43296648,1171173.88331225,1229000.25289327,2279906.62807629,1661159.76013015,1690936.54492800,2345093.26861125,1792991.29824348,2358393.80783000,1792291.11067496,2352941.89148416,1557640.33161339,1235175.17856819,2352961.71455594,1486773.78632214,2404300.253619,1223676.113563,2213819.198364,2512310.444111,1614049.975443,1821430.295254,1795510.086755,2370187.492879,1349093.053436,2369881.3787,1927534.9470
+AA00011,12,12,1,2015-01-12 00:00:00,2012,AC00011,AC011,AD00011,EMUI_VER011,AFV000011,AN0000011,AO011,AP00011,B00000011,2015-01-12 00:00:00,12,12,1,2015,CA00011,31,CNT011,12,1,1962,30K - 50K,CC011,CS0011,CC011,Costa Rica,L00000011@gmail.com,2011-02-13 00:00:00,CFN000011,ID00000000011,Business Supervisor,CLN000011,L00000011,N000011,Y,M,CSN011,CSN011,CSN11,600011,DC00011,DS00011,DC011,DD00011,DP00011,DN0000011,IN0000011,IB0000011,IBN000011,IC011,ICI011,IC00011,IC00011,IC11,IC11,IF011,IM11,IM11,IMI11,ITM012,KeyboardsMetal,2015-10-12 00:00:00,2015-10-12 00:00:00,LA00011,12,12,1,2015-01-12 00:00:00,2015,LC00011,LC011,LD00011,LEV000011,LFV000011,LN0000011,LO00011,LP00011,2015-01-12 00:00:00,OL_OR_00000011,ON0000011,2015-01-12 00:00:00,www.homeshop18.com,OS_DES_0011,2015-01-12 00:00:00,12,12,PL0000011,1,2015,SP,Sales promotion,PC11,PCD11,PCD11,L00000011@dmail.com,L00000011@email.com,PCE11,PCP02,PCR02,PT11,PDA02,2015-10-12 00:00:00,PP00002,2015-10-12 00:00:00,PI00011,BAR000011,Acer,Acer Liqu
id Z530,Liquid Z530,LIQUIDZ530,SILVER,WHITE,CC00011,PI11,PL00011,PL011,PLD0011,RM00011,RO00011,SE00011,PS11,PT11,add000011,IMEI0000000000011,2015-01-12 00:00:00,UID000011,SC02,SC02,SC02,L,EXPRESS MAIL,20-12-2015 00:00,STR_OR_0000011,TN0000011,WC11,WC11,WC02,WI02,Costa Rica Warehouse,WS11,WSN11,WS02,1002 N. Spoonwood Court,WSN2,500011,1743305.2881,2027319.1156,2485409.2487,2024394.1711,1663655.1606,2371944.8897,1108614.3235,1299792.8665,2025164.1870,1517712.5590,1690102.4809,1000000,1481687.9138,1896374320,1050233.48150,1645650.49639,1523552.31028,1517843.09099,1603179.78323,2401713.36731,2340904.35047,1664459.62465,1406495.84106,1583523.27244,1254064.27672,2496427.23253,2050983.25234,1556353.19209,1130771.56735,1111966.24909,1198861.86346,2504695.10159,1513057.87590,1860334.22901,2451373.82927,1924684.9565,1233190.5102,2171325.9911,1136569.2226,1579201.5081,2151111.6092,1499405.9400,1791948.89377,1411073.27587,1186194.93140,2473181.2936,2335239.9144,1993338.434941,1539624.385826,102
5589.128476,1600257.180970,1682539.865120,2007350.414235,2104216.382153,2338875.714872,2409192.227495,1482900.372348,1952240.780275,1239715.653485,2036098.527604,1358214.179843,1433247.076146,1884937.586786,2036057.058369,1458386.910364,1278494.6308738,2196626.3607030,1033580.8255997,1346741.8725247,1618013.5308136,1159808.2338434,1483126.7999777,1988358.4606498,1517757.1297741,1674488.2183598,1336047.2025361,1985227.1660857,1880436.3310523,1514355.9351600,1221602.4400754,1296134.6942912,1514906.3345872,2458179.2535450,1277963.9723948,1900217.6778340,1043014.3362627,1488034.2893394,1497707.0952350,2104578.9370387,1394748.271,1546212.942,1326368.805,1926408.410,1896987.014,1631913.214,1083182.108,1410123.792,1431107.991,1230782.147,2069960.518,1687656.114,1438276.925,1419603.711,1147211.62,1877468.61,1471077.20,1714304.63,1166734.03,1512501.47,1455071.93,1950863.30,1362020.21,1614729.93,1674563.09,2149374.89,1240418.77,2454205.35,2406096.68,2309223.69426766,1288793.79112082,1343996.1
5305165,1012718.19642432,1157591.83960170,1502625.83486233,2504285.19832955,1174568.00795294,1036357.53555723,1121132.26264253,1078250.90950547,1866913.86053660,1692594.31169361,1539893.08492016,1639109.28701891,1084400.12594957,1838767.22982591,1726745.92517659,1691642.67561423,1728401.73472339,2308252.40482377,1479335.553359,2381209.095112,2039290.696104,1279533.294124,2513132.275350,2104804.779693,2074081.399006,2361282.428771,1040262.276438,1643135.3814,2196947.4173
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/852ab804/integration/spark-common-test/src/test/scala/org/apache/carbondata/spark/testsuite/allqueries/DoubleDataTypeTest.scala
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/scala/org/apache/carbondata/spark/testsuite/allqueries/DoubleDataTypeTest.scala b/integration/spark-common-test/src/test/scala/org/apache/carbondata/spark/testsuite/allqueries/DoubleDataTypeTest.scala
new file mode 100644
index 0000000..052ee45
--- /dev/null
+++ b/integration/spark-common-test/src/test/scala/org/apache/carbondata/spark/testsuite/allqueries/DoubleDataTypeTest.scala
@@ -0,0 +1,40 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.carbondata.spark.testsuite.allqueries
+
+import org.apache.spark.sql.common.util.QueryTest
+import org.scalatest.BeforeAndAfterAll
+
+class DoubleDataTypeTest extends QueryTest with BeforeAndAfterAll {
+
+ override def beforeAll: Unit = {
+ sql("DROP TABLE IF EXISTS oscon_carbon_old")
+ sql("""create table oscon_carbon_old (CUST_PRFRD_FLG String,PROD_BRAND_NAME String,PROD_COLOR String,CUST_LAST_RVW_DATE String,CUST_COUNTRY String,CUST_CITY String,PRODUCT_NAME String,CUST_JOB_TITLE String,CUST_STATE String,CUST_BUY_POTENTIAL String,PRODUCT_MODEL String,ITM_ID String,ITM_NAME String,PRMTION_ID String,PRMTION_NAME String,SHP_MODE_ID String,SHP_MODE String,DELIVERY_COUNTRY String,DELIVERY_STATE String,DELIVERY_CITY String,DELIVERY_DISTRICT String,ACTIVE_EMUI_VERSION String,WH_NAME String,STR_ORDER_DATE String,OL_ORDER_NO String,OL_ORDER_DATE String,OL_SITE String,CUST_FIRST_NAME String,CUST_LAST_NAME String,CUST_BIRTH_DY String,CUST_BIRTH_MM String,CUST_BIRTH_YR String,CUST_BIRTH_COUNTRY String,CUST_SEX String,CUST_ADDRESS_ID String,CUST_STREET_NO String,CUST_STREET_NAME String,CUST_AGE String,CUST_SUITE_NO String,CUST_ZIP String,CUST_COUNTY String,PRODUCT_ID String,PROD_SHELL_COLOR String,DEVICE_NAME String,PROD_SHORT_DESC String,PROD_LONG_DESC String,PROD_THUMB
String,PROD_IMAGE String,PROD_UPDATE_DATE String,PROD_LIVE String,PROD_LOC String,PROD_RAM String,PROD_ROM String,PROD_CPU_CLOCK String,PROD_SERIES String,ITM_REC_START_DATE String,ITM_REC_END_DATE String,ITM_BRAND_ID String,ITM_BRAND String,ITM_CLASS_ID String,ITM_CLASS String,ITM_CATEGORY_ID String,ITM_CATEGORY String,ITM_MANUFACT_ID String,ITM_MANUFACT String,ITM_FORMULATION String,ITM_COLOR String,ITM_CONTAINER String,ITM_MANAGER_ID String,PRM_START_DATE String,PRM_END_DATE String,PRM_CHANNEL_DMAIL String,PRM_CHANNEL_EMAIL String,PRM_CHANNEL_CAT String,PRM_CHANNEL_TV String,PRM_CHANNEL_RADIO String,PRM_CHANNEL_PRESS String,PRM_CHANNEL_EVENT String,PRM_CHANNEL_DEMO String,PRM_CHANNEL_DETAILS String,PRM_PURPOSE String,PRM_DSCNT_ACTIVE String,SHP_CODE String,SHP_CARRIER String,SHP_CONTRACT String,CHECK_DATE String,CHECK_YR String,CHECK_MM String,CHECK_DY String,CHECK_HOUR String,BOM String,INSIDE_NAME String,PACKING_DATE String,PACKING_YR String,PACKING_MM String,PACKING_DY String,
PACKING_HOUR String,DELIVERY_PROVINCE String,PACKING_LIST_NO String,ACTIVE_CHECK_TIME String,ACTIVE_CHECK_YR String,ACTIVE_CHECK_MM String,ACTIVE_CHECK_DY String,ACTIVE_CHECK_HOUR String,ACTIVE_AREA_ID String,ACTIVE_COUNTRY String,ACTIVE_PROVINCE String,ACTIVE_CITY String,ACTIVE_DISTRICT String,ACTIVE_NETWORK String,ACTIVE_FIRMWARE_VER String,ACTIVE_OS_VERSION String,LATEST_CHECK_TIME String,LATEST_CHECK_YR String,LATEST_CHECK_MM String,LATEST_CHECK_DY String,LATEST_CHECK_HOUR String,LATEST_AREAID String,LATEST_COUNTRY String,LATEST_PROVINCE String,LATEST_CITY String,LATEST_DISTRICT String,LATEST_FIRMWARE_VER String,LATEST_EMUI_VERSION String,LATEST_OS_VERSION String,LATEST_NETWORK String,WH_ID String,WH_STREET_NO String,WH_STREET_NAME String,WH_STREET_TYPE String,WH_SUITE_NO String,WH_CITY String,WH_COUNTY String,WH_STATE String,WH_ZIP String,WH_COUNTRY String,OL_SITE_DESC String,OL_RET_ORDER_NO String,OL_RET_DATE String,PROD_MODEL_ID String,CUST_ID String,PROD_UNQ_MDL_ID String,CU
ST_NICK_NAME String,CUST_LOGIN String,CUST_EMAIL_ADDR String,PROD_UNQ_DEVICE_ADDR String,PROD_UQ_UUID String,PROD_BAR_CODE String,TRACKING_NO String,STR_ORDER_NO String,CUST_DEP_COUNT double,CUST_VEHICLE_COUNT double,CUST_ADDRESS_CNT double,CUST_CRNT_CDEMO_CNT double,CUST_CRNT_HDEMO_CNT double,CUST_CRNT_ADDR_DM double,CUST_FIRST_SHIPTO_CNT double,CUST_FIRST_SALES_CNT double,CUST_GMT_OFFSET double,CUST_DEMO_CNT double,CUST_INCOME double,PROD_UNLIMITED double,PROD_OFF_PRICE double,PROD_UNITS double,TOTAL_PRD_COST double,TOTAL_PRD_DISC double,PROD_WEIGHT double,REG_UNIT_PRICE double,EXTENDED_AMT double,UNIT_PRICE_DSCNT_PCT double,DSCNT_AMT double,PROD_STD_CST double,TOTAL_TX_AMT double,FREIGHT_CHRG double,WAITING_PERIOD double,DELIVERY_PERIOD double,ITM_CRNT_PRICE double,ITM_UNITS double,ITM_WSLE_CST double,ITM_SIZE double,PRM_CST double,PRM_RESPONSE_TARGET double,PRM_ITM_DM double,SHP_MODE_CNT double,WH_GMT_OFFSET double,WH_SQ_FT double,STR_ORD_QTY double,STR_WSLE_CST double,STR_LIST_
PRICE double,STR_SALES_PRICE double,STR_EXT_DSCNT_AMT double,STR_EXT_SALES_PRICE double,STR_EXT_WSLE_CST double,STR_EXT_LIST_PRICE double,STR_EXT_TX double,STR_COUPON_AMT double,STR_NET_PAID double,STR_NET_PAID_INC_TX double,STR_NET_PRFT double,STR_SOLD_YR_CNT double,STR_SOLD_MM_CNT double,STR_SOLD_ITM_CNT double,STR_TOTAL_CUST_CNT double,STR_AREA_CNT double,STR_DEMO_CNT double,STR_OFFER_CNT double,STR_PRM_CNT double,STR_TICKET_CNT double,STR_NET_PRFT_DM_A double,STR_NET_PRFT_DM_B double,STR_NET_PRFT_DM_C double,STR_NET_PRFT_DM_D double,STR_NET_PRFT_DM_E double,STR_RET_STR_ID double,STR_RET_REASON_CNT double,STR_RET_TICKET_NO double,STR_RTRN_QTY double,STR_RTRN_AMT double,STR_RTRN_TX double,STR_RTRN_AMT_INC_TX double,STR_RET_FEE double,STR_RTRN_SHIP_CST double,STR_RFNDD_CSH double,STR_REVERSED_CHRG double,STR_STR_CREDIT double,STR_RET_NET_LOSS double,STR_RTRNED_YR_CNT double,STR_RTRN_MM_CNT double,STR_RET_ITM_CNT double,STR_RET_CUST_CNT double,STR_RET_AREA_CNT double,STR_RET_OFFER_C
NT double,STR_RET_PRM_CNT double,STR_RET_NET_LOSS_DM_A double,STR_RET_NET_LOSS_DM_B double,STR_RET_NET_LOSS_DM_C double,STR_RET_NET_LOSS_DM_D double,OL_ORD_QTY double,OL_WSLE_CST double,OL_LIST_PRICE double,OL_SALES_PRICE double,OL_EXT_DSCNT_AMT double,OL_EXT_SALES_PRICE double,OL_EXT_WSLE_CST double,OL_EXT_LIST_PRICE double,OL_EXT_TX double,OL_COUPON_AMT double,OL_EXT_SHIP_CST double,OL_NET_PAID double,OL_NET_PAID_INC_TX double,OL_NET_PAID_INC_SHIP double,OL_NET_PAID_INC_SHIP_TX double,OL_NET_PRFT double,OL_SOLD_YR_CNT double,OL_SOLD_MM_CNT double,OL_SHIP_DATE_CNT double,OL_ITM_CNT double,OL_BILL_CUST_CNT double,OL_BILL_AREA_CNT double,OL_BILL_DEMO_CNT double,OL_BILL_OFFER_CNT double,OL_SHIP_CUST_CNT double,OL_SHIP_AREA_CNT double,OL_SHIP_DEMO_CNT double,OL_SHIP_OFFER_CNT double,OL_WEB_PAGE_CNT double,OL_WEB_SITE_CNT double,OL_SHIP_MODE_CNT double,OL_WH_CNT double,OL_PRM_CNT double,OL_NET_PRFT_DM_A double,OL_NET_PRFT_DM_B double,OL_NET_PRFT_DM_C double,OL_NET_PRFT_DM_D double,OL_RE
T_RTRN_QTY double,OL_RTRN_AMT double,OL_RTRN_TX double,OL_RTRN_AMT_INC_TX double,OL_RET_FEE double,OL_RTRN_SHIP_CST double,OL_RFNDD_CSH double,OL_REVERSED_CHRG double,OL_ACCOUNT_CREDIT double,OL_RTRNED_YR_CNT double,OL_RTRNED_MM_CNT double,OL_RTRITM_CNT double,OL_RFNDD_CUST_CNT double,OL_RFNDD_AREA_CNT double,OL_RFNDD_DEMO_CNT double,OL_RFNDD_OFFER_CNT double,OL_RTRNING_CUST_CNT double,OL_RTRNING_AREA_CNT double,OL_RTRNING_DEMO_CNT double,OL_RTRNING_OFFER_CNT double,OL_RTRWEB_PAGE_CNT double,OL_REASON_CNT double,OL_NET_LOSS double,OL_NET_LOSS_DM_A double,OL_NET_LOSS_DM_B double,OL_NET_LOSS_DM_C double) STORED BY 'org.apache.carbondata.format' tblproperties('DICTIONARY_EXCLUDE'='CUST_ID,CUST_NICK_NAME,CUST_FIRST_NAME,CUST_LAST_NAME,CUST_LOGIN,CUST_EMAIL_ADDR,PROD_UNQ_MDL_ID,PROD_UNQ_DEVICE_ADDR,PROD_UQ_UUID,DEVICE_NAME,PROD_BAR_CODE,ITM_ID,ITM_NAME,ITM_BRAND_ID,ITM_BRAND,BOM,PACKING_LIST_NO,TRACKING_NO,ACTIVE_FIRMWARE_VER,LATEST_FIRMWARE_VER,LATEST_EMUI_VERSION,LATEST_NETWORK,STR_ORD
ER_NO','table_blocksize'='256')""")
+ sql(s"""load data LOCAL inpath '$resourcesPath/oscon_10.csv' into table oscon_carbon_old options('USE_KETTLE'='true','DELIMITER'=',', 'QUOTECHAR'='\"','FILEHEADER'='ACTIVE_AREA_ID, ACTIVE_CHECK_DY, ACTIVE_CHECK_HOUR, ACTIVE_CHECK_MM, ACTIVE_CHECK_TIME, ACTIVE_CHECK_YR, ACTIVE_CITY, ACTIVE_COUNTRY, ACTIVE_DISTRICT, ACTIVE_EMUI_VERSION, ACTIVE_FIRMWARE_VER, ACTIVE_NETWORK, ACTIVE_OS_VERSION, ACTIVE_PROVINCE, BOM, CHECK_DATE, CHECK_DY, CHECK_HOUR, CHECK_MM, CHECK_YR, CUST_ADDRESS_ID, CUST_AGE, CUST_BIRTH_COUNTRY, CUST_BIRTH_DY, CUST_BIRTH_MM, CUST_BIRTH_YR, CUST_BUY_POTENTIAL, CUST_CITY, CUST_STATE, CUST_COUNTRY, CUST_COUNTY, CUST_EMAIL_ADDR, CUST_LAST_RVW_DATE, CUST_FIRST_NAME, CUST_ID, CUST_JOB_TITLE, CUST_LAST_NAME, CUST_LOGIN, CUST_NICK_NAME, CUST_PRFRD_FLG, CUST_SEX, CUST_STREET_NAME, CUST_STREET_NO, CUST_SUITE_NO, CUST_ZIP, DELIVERY_CITY, DELIVERY_STATE, DELIVERY_COUNTRY, DELIVERY_DISTRICT, DELIVERY_PROVINCE, DEVICE_NAME, INSIDE_NAME, ITM_BRAND, ITM_BRAND_ID, ITM_CATEGORY, IT
M_CATEGORY_ID, ITM_CLASS, ITM_CLASS_ID, ITM_COLOR, ITM_CONTAINER, ITM_FORMULATION, ITM_MANAGER_ID, ITM_MANUFACT, ITM_MANUFACT_ID, ITM_ID, ITM_NAME, ITM_REC_END_DATE, ITM_REC_START_DATE, LATEST_AREAID, LATEST_CHECK_DY, LATEST_CHECK_HOUR, LATEST_CHECK_MM, LATEST_CHECK_TIME, LATEST_CHECK_YR, LATEST_CITY, LATEST_COUNTRY, LATEST_DISTRICT, LATEST_EMUI_VERSION, LATEST_FIRMWARE_VER, LATEST_NETWORK, LATEST_OS_VERSION, LATEST_PROVINCE, OL_ORDER_DATE, OL_ORDER_NO, OL_RET_ORDER_NO, OL_RET_DATE, OL_SITE, OL_SITE_DESC, PACKING_DATE, PACKING_DY, PACKING_HOUR, PACKING_LIST_NO, PACKING_MM, PACKING_YR, PRMTION_ID, PRMTION_NAME, PRM_CHANNEL_CAT, PRM_CHANNEL_DEMO, PRM_CHANNEL_DETAILS, PRM_CHANNEL_DMAIL, PRM_CHANNEL_EMAIL, PRM_CHANNEL_EVENT, PRM_CHANNEL_PRESS, PRM_CHANNEL_RADIO, PRM_CHANNEL_TV, PRM_DSCNT_ACTIVE, PRM_END_DATE, PRM_PURPOSE, PRM_START_DATE, PRODUCT_ID, PROD_BAR_CODE, PROD_BRAND_NAME, PRODUCT_NAME, PRODUCT_MODEL, PROD_MODEL_ID, PROD_COLOR, PROD_SHELL_COLOR, PROD_CPU_CLOCK, PROD_IMAGE, PROD_
LIVE, PROD_LOC, PROD_LONG_DESC, PROD_RAM, PROD_ROM, PROD_SERIES, PROD_SHORT_DESC, PROD_THUMB, PROD_UNQ_DEVICE_ADDR, PROD_UNQ_MDL_ID, PROD_UPDATE_DATE, PROD_UQ_UUID, SHP_CARRIER, SHP_CODE, SHP_CONTRACT, SHP_MODE_ID, SHP_MODE, STR_ORDER_DATE, STR_ORDER_NO, TRACKING_NO, WH_CITY, WH_COUNTRY, WH_COUNTY, WH_ID, WH_NAME, WH_STATE, WH_STREET_NAME, WH_STREET_NO, WH_STREET_TYPE, WH_SUITE_NO, WH_ZIP, CUST_DEP_COUNT, CUST_VEHICLE_COUNT, CUST_ADDRESS_CNT, CUST_CRNT_CDEMO_CNT, CUST_CRNT_HDEMO_CNT, CUST_CRNT_ADDR_DM, CUST_FIRST_SHIPTO_CNT, CUST_FIRST_SALES_CNT, CUST_GMT_OFFSET, CUST_DEMO_CNT, CUST_INCOME, PROD_UNLIMITED, PROD_OFF_PRICE, PROD_UNITS, TOTAL_PRD_COST, TOTAL_PRD_DISC, PROD_WEIGHT, REG_UNIT_PRICE, EXTENDED_AMT, UNIT_PRICE_DSCNT_PCT, DSCNT_AMT, PROD_STD_CST, TOTAL_TX_AMT, FREIGHT_CHRG, WAITING_PERIOD, DELIVERY_PERIOD, ITM_CRNT_PRICE, ITM_UNITS, ITM_WSLE_CST, ITM_SIZE, PRM_CST, PRM_RESPONSE_TARGET, PRM_ITM_DM, SHP_MODE_CNT, WH_GMT_OFFSET, WH_SQ_FT, STR_ORD_QTY, STR_WSLE_CST, STR_LIST_PRIC
E, STR_SALES_PRICE, STR_EXT_DSCNT_AMT, STR_EXT_SALES_PRICE, STR_EXT_WSLE_CST, STR_EXT_LIST_PRICE, STR_EXT_TX, STR_COUPON_AMT, STR_NET_PAID, STR_NET_PAID_INC_TX, STR_NET_PRFT, STR_SOLD_YR_CNT, STR_SOLD_MM_CNT, STR_SOLD_ITM_CNT, STR_TOTAL_CUST_CNT, STR_AREA_CNT, STR_DEMO_CNT, STR_OFFER_CNT, STR_PRM_CNT, STR_TICKET_CNT, STR_NET_PRFT_DM_A, STR_NET_PRFT_DM_B, STR_NET_PRFT_DM_C, STR_NET_PRFT_DM_D, STR_NET_PRFT_DM_E, STR_RET_STR_ID, STR_RET_REASON_CNT, STR_RET_TICKET_NO, STR_RTRN_QTY, STR_RTRN_AMT, STR_RTRN_TX, STR_RTRN_AMT_INC_TX, STR_RET_FEE, STR_RTRN_SHIP_CST, STR_RFNDD_CSH, STR_REVERSED_CHRG, STR_STR_CREDIT, STR_RET_NET_LOSS, STR_RTRNED_YR_CNT, STR_RTRN_MM_CNT, STR_RET_ITM_CNT, STR_RET_CUST_CNT, STR_RET_AREA_CNT, STR_RET_OFFER_CNT, STR_RET_PRM_CNT, STR_RET_NET_LOSS_DM_A, STR_RET_NET_LOSS_DM_B, STR_RET_NET_LOSS_DM_C, STR_RET_NET_LOSS_DM_D, OL_ORD_QTY, OL_WSLE_CST, OL_LIST_PRICE, OL_SALES_PRICE, OL_EXT_DSCNT_AMT, OL_EXT_SALES_PRICE, OL_EXT_WSLE_CST, OL_EXT_LIST_PRICE, OL_EXT_TX, OL_COUPO
N_AMT, OL_EXT_SHIP_CST, OL_NET_PAID, OL_NET_PAID_INC_TX, OL_NET_PAID_INC_SHIP, OL_NET_PAID_INC_SHIP_TX, OL_NET_PRFT, OL_SOLD_YR_CNT, OL_SOLD_MM_CNT, OL_SHIP_DATE_CNT, OL_ITM_CNT, OL_BILL_CUST_CNT, OL_BILL_AREA_CNT, OL_BILL_DEMO_CNT, OL_BILL_OFFER_CNT, OL_SHIP_CUST_CNT, OL_SHIP_AREA_CNT, OL_SHIP_DEMO_CNT, OL_SHIP_OFFER_CNT, OL_WEB_PAGE_CNT, OL_WEB_SITE_CNT, OL_SHIP_MODE_CNT, OL_WH_CNT, OL_PRM_CNT, OL_NET_PRFT_DM_A, OL_NET_PRFT_DM_B, OL_NET_PRFT_DM_C, OL_NET_PRFT_DM_D, OL_RET_RTRN_QTY, OL_RTRN_AMT, OL_RTRN_TX, OL_RTRN_AMT_INC_TX, OL_RET_FEE, OL_RTRN_SHIP_CST, OL_RFNDD_CSH, OL_REVERSED_CHRG, OL_ACCOUNT_CREDIT, OL_RTRNED_YR_CNT, OL_RTRNED_MM_CNT, OL_RTRITM_CNT, OL_RFNDD_CUST_CNT, OL_RFNDD_AREA_CNT, OL_RFNDD_DEMO_CNT, OL_RFNDD_OFFER_CNT, OL_RTRNING_CUST_CNT, OL_RTRNING_AREA_CNT, OL_RTRNING_DEMO_CNT, OL_RTRNING_OFFER_CNT, OL_RTRWEB_PAGE_CNT, OL_REASON_CNT, OL_NET_LOSS, OL_NET_LOSS_DM_A, OL_NET_LOSS_DM_B, OL_NET_LOSS_DM_C','BAD_RECORDS_ACTION'='FORCE','BAD_RECORDS_LOGGER_ENABLE'='FALSE')""
")
+ }
+
+ test("test to check result for double data type") {
+ val result = sql("select OL_SALES_PRICE from oscon_carbon_old limit 10").count()
+ assert(result.equals(10L))
+ }
+
+ override def afterAll: Unit = {
+ sql("DROP TABLE IF EXISTS oscon_carbon_old")
+ }
+
+}
[2/2] incubator-carbondata git commit: [CARBONDATA-696] Fixed Null
Pointer Exception for double data type without fraction This closes #695
Posted by ja...@apache.org.
[CARBONDATA-696] Fixed Null Pointer Exception for double data type without fraction This closes #695
Project: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/commit/e81dec7f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/tree/e81dec7f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/diff/e81dec7f
Branch: refs/heads/master
Commit: e81dec7f7254dc7bb5ecb09d6f5a56a9a9cd2798
Parents: b615892 852ab80
Author: jackylk <ja...@huawei.com>
Authored: Mon Mar 27 20:34:14 2017 +0530
Committer: jackylk <ja...@huawei.com>
Committed: Mon Mar 27 20:34:14 2017 +0530
----------------------------------------------------------------------
.../CompressionNonDecimalMaxMinInt.java | 9 -----
.../none/CompressionNoneDefault.java | 6 ---
.../compression/none/CompressionNoneLong.java | 6 ---
.../src/test/resources/oscon_10.csv | 12 ++++++
.../allqueries/DoubleDataTypeTest.scala | 40 ++++++++++++++++++++
5 files changed, 52 insertions(+), 21 deletions(-)
----------------------------------------------------------------------