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) |
Free forum by Nabble | Edit this page |