You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Vinod Rohilla (JIRA)" <ji...@apache.org> on 2017/06/16 08:21:01 UTC
[jira] [Created] (CARBONDATA-1184) Incorrect value displays in
double data type.
Vinod Rohilla created CARBONDATA-1184:
-----------------------------------------
Summary: Incorrect value displays in double data type.
Key: CARBONDATA-1184
URL: https://issues.apache.org/jira/browse/CARBONDATA-1184
Project: CarbonData
Issue Type: Bug
Components: sql
Environment: Spark 2.1
Reporter: Vinod Rohilla
Priority: Minor
Attachments: 100_olap_C20.csv
Incorrect value displays to the user in double datatype.
Step to reproduces:
1:Create table:
create table VMALL_DICTIONARY_EXCLUDE (imei string,deviceInformationId int,MAC string,deviceColor string,device_backColor string,modelId string,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series string,productionDate timestamp,bomCode string,internalModels string, deliveryTime string, channelsId string, channelsName string , deliveryAreaId string, deliveryCountry string, deliveryProvince string, deliveryCity string,deliveryDistrict string, deliveryStreet string, oxSingleNumber string, ActiveCheckTime string, ActiveAreaId string, ActiveCountry string, ActiveProvince string, Activecity string, ActiveDistrict string, ActiveStreet string, ActiveOperatorId string, Active_releaseId string, Active_EMUIVersion string, Active_operaSysVersion string, Active_BacVerNumber string, Active_BacFlashVer string, Active_webUIVersion string, Active_webUITypeCarrVer string,Active_webTypeDataVerNumber string, Active_operatorsVersion string, Active_phonePADPartitionedVersions string, Latest_YEAR int, Latest_MONTH int, Latest_DAY Decimal(30,10), Latest_HOUR string, Latest_areaId string, Latest_country string, Latest_province string, Latest_city string, Latest_district string, Latest_street string, Latest_releaseId string, Latest_EMUIVersion string, Latest_operaSysVersion string, Latest_BacVerNumber string, Latest_BacFlashVer string, Latest_webUIVersion string, Latest_webUITypeCarrVer string, Latest_webTypeDataVerNumber string, Latest_operatorsVersion string, Latest_phonePADPartitionedVersions string, Latest_operatorId string, gamePointDescription string,gamePointId double,contractNumber BigInt) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_EXCLUDE'='imei');
2:Load Data:
LOAD DATA INPATH 'hdfs://localhost:54310/100_olap_C20.csv' INTO table VMALL_DICTIONARY_EXCLUDE options ('DELIMITER'=',', 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE', 'FILEHEADER'='imei,deviceInformationId,MAC,deviceColor,device_backColor,modelId,marketName,AMSize,ROMSize,CUPAudit,CPIClocked,series,productionDate,bomCode,internalModels,deliveryTime,channelsId,channelsName,deliveryAreaId,deliveryCountry,deliveryProvince,deliveryCity,deliveryDistrict,deliveryStreet,oxSingleNumber,contractNumber,ActiveCheckTime,ActiveAreaId,ActiveCountry,ActiveProvince,Activecity,ActiveDistrict,ActiveStreet,ActiveOperatorId,Active_releaseId,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_BacFlashVer,Active_webUIVersion,Active_webUITypeCarrVer,Active_webTypeDataVerNumber,Active_operatorsVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_areaId,Latest_country,Latest_province,Latest_city,Latest_district,Latest_street,Latest_releaseId,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_BacFlashVer,Latest_webUIVersion,Latest_webUITypeCarrVer,Latest_webTypeDataVerNumber,Latest_operatorsVersion,Latest_phonePADPartitionedVersions,Latest_operatorId,gamePointId,gamePointDescription');
3: Run Select Query.
select gamePointId from VMALL_DICTIONARY_EXCLUDE;
4: Result:
0: jdbc:hive2://localhost:10000> select gamePointId from VMALL_DICTIONARY_EXCLUDE;
+-----------------------+--+
| gamePointId |
+-----------------------+--+
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
+-----------------------+--+
| gamePointId |
+-----------------------+--+
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| 9.223372036854776E18 |
| NULL |
+-----------------------+--+
105 rows selected (0.163 seconds)
Expected Result: Correct Value should be displayed to user as saved in CSV
gamePointId
214748364890349000000000
214748364890349000000000
214748364890349000000000
214748364890349000000000
214748364890349000000000
429496729780698000000000
644245094671047000000000
1073741824451750000000000
1717986919122790000000000
2791728743574540000000000
4509715662697330000000000
7301444406271870000000000
11811160068969200000000000
19112604475241100000000000
30923764544210300000000000
50036369019451300000000000
80960133563661600000000000
130996502583113000000000000
211956636146774000000000000
342953138729887000000000000
554909774876662000000000000
897862913606549000000000000
1452772688483210000000000000
1452772688483210000000000000
2350635602089760000000000000
3803408290572970000000000000
6154043892662730000000000000
9957452183235700000000000000
16111496075898400000000000000
26068948259134100000000000000
42180444335032600000000000000
68249392594166700000000000000
110429836929199000000000000000
178679229523366000000000000000
289109066452565000000000000000
467788295975931000000000000000
756897362428497000000000000000
1224685658404430000000000000000
1981583020832920000000000000000
3206268679237350000000000000000
5187851700070280000000000000000
8394120379307630000000000000000
13581972079377900000000000000000
21976092458685500000000000000000
35558064538063400000000000000000
57534156996749000000000000000000
93092221534812400000000000000000
150626378531561000000000000000000
243718600066374000000000000000000
394344978597935000000000000000000
638063578664309000000000000000000
1032408557262240000000000000000000
1670472135926550000000000000000000
2702880693188800000000000000000000
4373352829115350000000000000000000
7076233522304150000000000000000000
11449586351419500000000000000000000
18525819873723700000000000000000000
29975406225143200000000000000000000
48501226098866800000000000000000000
78476632324010000000000000000000000
126977858422877000000000000000000000
205454490746887000000000000000000000
332432349169763000000000000000000000
537886839916650000000000000000000000
870319189086414000000000000000000000
1408206029003060000000000000000000000
2278525218089480000000000000000000000
3686731247092540000000000000000000000
5965256465182020000000000000000000000
9651987712274560000000000000000000000
15617244177456600000000000000000000000
25269231889731100000000000000000000000
40886476067187700000000000000000000000
66155707956918900000000000000000000000
107042184024107000000000000000000000000
173197891981025000000000000000000000000
280240076005132000000000000000000000000
453437967986157000000000000000000000000
733678043991289000000000000000000000000
1187116011977450000000000000000000000000
1920794055968740000000000000000000000000
3107910067946180000000000000000000000000
5028704123914920000000000000000000000000
8136614191861100000000000000000000000000
13165318315776000000000000000000000000000
21301932507637100000000000000000000000000
34467250823413100000000000000000000000000
55769183331050300000000000000000000000000
90236434154463400000000000000000000000000
146005617485514000000000000000000000000000
236242051639977000000000000000000000000000
382247669125491000000000000000000000000000
618489720765468000000000000000000000000000
1000737389890960000000000000000000000000000
1619227110656430000000000000000000000000000
2619964500547390000000000000000000000000000
4239191611203810000000000000000000000000000
6859156111751200000000000000000000000000000
11098347722955000000000000000000000000000000
17957503834706200000000000000000000000000000
29055851557661200000000000000000000000000000
47013355392367400000000000000000000000000000
47013355392367400000000000000000000000000000
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)