carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashwini K (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-1184) Incorrect value displays in double data type.
Date Thu, 06 Jul 2017 11:19:00 GMT

    [ https://issues.apache.org/jira/browse/CARBONDATA-1184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16076374#comment-16076374
] 

Ashwini K commented on CARBONDATA-1184:
---------------------------------------

Hi , As per the table structure the value from the csv file is read as string and stored as
a Double objects .What you are seeing as the output format as " 9.223372036854776E18 " is
the default print format for Double . Please use a number formatter at the client side to
the required format .

> 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
>            Assignee: Ashwini K
>            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)

Mime
View raw message