Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@carbondata.incubator.apache.org
Date: Wed, 29 Mar 2017 14:09:41 +0000 (UTC)
From: "Liang Chen (JIRA)" <jira@apache.org>
To: issues@carbondata.incubator.apache.org
Message-ID: <JIRA.13043247.1487162155000.154469.1490796581881@Atlassian.JIRA>
In-Reply-To: <JIRA.13043247.1487162155000@Atlassian.JIRA>
References: <JIRA.13043247.1487162155000@Atlassian.JIRA> <JIRA.13043247.1487162155146@jira-lw-us.apache.org>
Subject: [jira] [Resolved] (CARBONDATA-708) Between operator does not work
 properly in carbondata.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Wed, 29 Mar 2017 14:09:49 -0000


     [ https://issues.apache.org/jira/browse/CARBONDATA-708?page=3Dcom.atla=
ssian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Liang Chen resolved CARBONDATA-708.
-----------------------------------
       Resolution: Fixed
         Assignee: Bhavya Aggarwal
    Fix Version/s: 1.1.0-incubating

> Between operator does not work properly in carbondata.
> ------------------------------------------------------
>
>                 Key: CARBONDATA-708
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-708
>             Project: CarbonData
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 1.1.0-incubating
>         Environment: Spark 2.1
>            Reporter: SWATI RAO
>            Assignee: Bhavya Aggarwal
>            Priority: Minor
>             Fix For: 1.1.0-incubating
>
>         Attachments: 100_hive_test.csv
>
>          Time Spent: 4h
>  Remaining Estimate: 0h
>
> Incorrect result displays.
> Note:Issue exist when you take Latest_HOUR as a String but if you take La=
test_HOUR as a int then it's working fine.
> Steps to reproduce:
> 1:Create table using following Command
> " create table Carbon_automation (imei string,deviceInformationId int,MAC=
 string,deviceColor string,device_backColor string,modelId string,marketNam=
e string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,ser=
ies string,productionDate timestamp,bomCode string,internalModels string, d=
eliveryTime string, channelsId string, channelsName string , deliveryAreaId=
 string, deliveryCountry string, deliveryProvince string, deliveryCity stri=
ng,deliveryDistrict string, deliveryStreet string, oxSingleNumber string, A=
ctiveCheckTime string, ActiveAreaId string, ActiveCountry string, ActivePro=
vince string, Activecity string, ActiveDistrict string, ActiveStreet string=
, ActiveOperatorId string, Active_releaseId string, Active_EMUIVersion stri=
ng, Active_operaSysVersion string, Active_BacVerNumber string, Active_BacFl=
ashVer string, Active_webUIVersion string, Active_webUITypeCarrVer string,A=
ctive_webTypeDataVerNumber string, Active_operatorsVersion string, Active_p=
honePADPartitionedVersions string, Latest_YEAR int, Latest_MONTH int, Lates=
t_DAY int, 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 stri=
ng, Latest_webUIVersion string, Latest_webUITypeCarrVer string, Latest_webT=
ypeDataVerNumber string, Latest_operatorsVersion string, Latest_phonePADPar=
titionedVersions string, Latest_operatorId string, gamePointDescription str=
ing,gamePointId double,contractNumber double,imei_count int) STORED BY 'org=
.apache.carbondata.format' TBLPROPERTIES ('DICTIONARY_INCLUDE'=3D'deviceInf=
ormationId,Latest_YEAR,Latest_MONTH,Latest_DAY')"
> 2:Load Data with following command
> " LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/HiveData' INTO TABLE Carbon_a=
utomation OPTIONS('DELIMITER'=3D',','QUOTECHAR'=3D'"','BAD_RECORDS_ACTION'=
=3D'FORCE','FILEHEADER'=3D'imei,deviceInformationId,MAC,deviceColor,device_=
backColor,modelId,marketName,AMSize,ROMSize,CUPAudit,CPIClocked,series,prod=
uctionDate,bomCode,internalModels,deliveryTime,channelsId,channelsName,deli=
veryAreaId,deliveryCountry,deliveryProvince,deliveryCity,deliveryDistrict,d=
eliveryStreet,oxSingleNumber,contractNumber,ActiveCheckTime,ActiveAreaId,Ac=
tiveCountry,ActiveProvince,Activecity,ActiveDistrict,ActiveStreet,ActiveOpe=
ratorId,Active_releaseId,Active_EMUIVersion,Active_operaSysVersion,Active_B=
acVerNumber,Active_BacFlashVer,Active_webUIVersion,Active_webUITypeCarrVer,=
Active_webTypeDataVerNumber,Active_operatorsVersion,Active_phonePADPartitio=
nedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_areaId,L=
atest_country,Latest_province,Latest_city,Latest_district,Latest_street,Lat=
est_releaseId,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber=
,Latest_BacFlashVer,Latest_webUIVersion,Latest_webUITypeCarrVer,Latest_webT=
ypeDataVerNumber,Latest_operatorsVersion,Latest_phonePADPartitionedVersions=
,Latest_operatorId,gamePointId,gamePointDescription,imei_count')"
> 3:Run the Query
> select Latest_DAY,Latest_HOUR,count(distinct AMSize) as AMSize_number,sum=
(gamePointId+contractNumber) as total from Carbon_automation where Latest_H=
OUR between 12 and 15 group by Latest_DAY,Latest_HOUR order by total desc
> 4:No Result display:
> +-------------+--------------+----------------+--------+--+
> | Latest_DAY  | Latest_HOUR  | AMSize_number  | total  |
> +-------------+--------------+----------------+--------+--+
> +-------------+--------------+----------------+--------+--+
> No rows selected (2.133 seconds).
> 5:CSV Attached "100_hive_test.csv"
> Expected Result:Correct Result should be display.


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