Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@carbondata.incubator.apache.org
Date: Tue, 11 Apr 2017 12:37:41 +0000 (UTC)
From: "Rahul Kumar (JIRA)" <jira@apache.org>
To: issues@carbondata.incubator.apache.org
Message-ID: <JIRA.13038880.1485778892000.256018.1491914261584@Atlassian.JIRA>
In-Reply-To: <JIRA.13038880.1485778892000@Atlassian.JIRA>
References: <JIRA.13038880.1485778892000@Atlassian.JIRA> <JIRA.13038880.1485778892523@jira-lw-us.apache.org>
Subject: [jira] [Commented] (CARBONDATA-688) Abnormal behaviour of double
 datatype when used in DICTIONARY_INCLUDE and filtering null values
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Tue, 11 Apr 2017 12:37:51 -0000


    [ https://issues.apache.org/jira/browse/CARBONDATA-688?page=3Dcom.atlas=
sian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D=
15964302#comment-15964302 ]=20

Rahul Kumar commented on CARBONDATA-688:
----------------------------------------

[~geetikagupta],
This is working fine now . You can close it.

> Abnormal behaviour of double datatype when used in DICTIONARY_INCLUDE and=
 filtering null values
> -------------------------------------------------------------------------=
----------------------
>
>                 Key: CARBONDATA-688
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-688
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-query
>    Affects Versions: 1.1.0-incubating
>         Environment: Spark 2.1
>            Reporter: Geetika Gupta
>            Priority: Minor
>         Attachments: 100_olap_C20.csv
>
>
> I tried to create a table having double as a column and load null values =
into that table. When I performed the select query on the table, it is disp=
laying wrong data.
> Below are the commands used:
> Create table :
> create table  Comp_VMALL_DICTIONARY_INCLUDE (imei string,deviceInformatio=
nId int,MAC string,deviceColor string,device_backColor string,modelId strin=
g,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked=
 string,series string,productionDate timestamp,bomCode string,internalModel=
s string, deliveryTime string, channelsId string, channelsName string , del=
iveryAreaId string, deliveryCountry string, deliveryProvince string, delive=
ryCity string,deliveryDistrict string, deliveryStreet string, oxSingleNumbe=
r string, ActiveCheckTime string, ActiveAreaId string, ActiveCountry string=
, ActiveProvince string, Activecity string, ActiveDistrict string, ActiveSt=
reet string, ActiveOperatorId string, Active_releaseId string, Active_EMUIV=
ersion string, Active_operaSysVersion string, Active_BacVerNumber string, A=
ctive_BacFlashVer string, Active_webUIVersion string, Active_webUITypeCarrV=
er string,Active_webTypeDataVerNumber string, Active_operatorsVersion strin=
g, 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_d=
istrict string, Latest_street string, Latest_releaseId string, Latest_EMUIV=
ersion string, Latest_operaSysVersion string, Latest_BacVerNumber string, L=
atest_BacFlashVer string, Latest_webUIVersion string, Latest_webUITypeCarrV=
er string, Latest_webTypeDataVerNumber string, Latest_operatorsVersion stri=
ng, Latest_phonePADPartitionedVersions string, Latest_operatorId string, ga=
mePointDescription string,gamePointId double,contractNumber BigInt)  STORED=
 BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'=3D'im=
ei,deviceInformationId,productionDate,gamePointId,Latest_DAY,contractNumber=
');
> Load command:
> LOAD DATA INPATH  'hdfs://localhost:54311/BabuStore/DATA/100_olap_C20.csv=
' INTO table Comp_VMALL_DICTIONARY_INCLUDE options ('DELIMITER'=3D',', 'QUO=
TECHAR'=3D'"', 'BAD_RECORDS_ACTION'=3D'FORCE','FILEHEADER'=3D'imei,deviceIn=
formationId,MAC,deviceColor,device_backColor,modelId,marketName,AMSize,ROMS=
ize,CUPAudit,CPIClocked,series,productionDate,bomCode,internalModels,delive=
ryTime,channelsId,channelsName,deliveryAreaId,deliveryCountry,deliveryProvi=
nce,deliveryCity,deliveryDistrict,deliveryStreet,oxSingleNumber,contractNum=
ber,ActiveCheckTime,ActiveAreaId,ActiveCountry,ActiveProvince,Activecity,Ac=
tiveDistrict,ActiveStreet,ActiveOperatorId,Active_releaseId,Active_EMUIVers=
ion,Active_operaSysVersion,Active_BacVerNumber,Active_BacFlashVer,Active_we=
bUIVersion,Active_webUITypeCarrVer,Active_webTypeDataVerNumber,Active_opera=
torsVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Lat=
est_DAY,Latest_HOUR,Latest_areaId,Latest_country,Latest_province,Latest_cit=
y,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,gamePoint=
Description');
> Select query:
> select gamePointId  from Comp_VMALL_DICTIONARY_INCLUDE where gamePointId =
IS NOT NULL order by gamePointId;
> select gamePointId from Comp_VMALL_DICTIONARY_INCLUDE where gamePointId i=
s NULL;
> The first select command displays null values as well and the second comm=
and displays no values.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)