[jira] [Reopened] (CARBONDATA-707) Less ( < ) than operator does not work properly in carbondata.

["SWATI RAO (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CARBONDATA-707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

SWATI RAO reopened CARBONDATA-707:
----------------------------------

not working

> Less ( < ) than operator does not work properly in carbondata. 
> ---------------------------------------------------------------
>
>                 Key: CARBONDATA-707
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-707
>             Project: CarbonData
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 1.1.0
>         Environment: Spark 2.1
>            Reporter: SWATI RAO
>            Priority: Minor
>             Fix For: 1.1.0
>
>         Attachments: 100_hive_test.csv
>
>
> Incorrect result displays 
> Steps to Reproduces:
> 1:Create table using following Command
> " create table Carbon_automation (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 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 string, Latest_webUIVersion string, Latest_webUITypeCarrVer string, Latest_webTypeDataVerNumber string, Latest_operatorsVersion string, Latest_phonePADPartitionedVersions string, Latest_operatorId string, gamePointDescription string,gamePointId double,contractNumber double,imei_count int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES ('DICTIONARY_INCLUDE'='deviceInformationId,Latest_YEAR,Latest_MONTH,Latest_DAY')"
> 2:Load Data with following command
> " LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/HiveData' INTO TABLE Carbon_automation 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,imei_count')"
> 3:Run the Query 
> " Select imei,gamePointId, channelsId,series from Carbon_automation where  channelsId < 4 ORDER BY gamePointId limit 5 "
> 4:Incorrect Result displays as follows:
> +------------+--------------+-------------+----------+--+
> |    imei    | gamePointId  | channelsId  |  series  |
> +------------+--------------+-------------+----------+--+
> | 1AA100050  | 29.0         | 1           | 2Series  |
> | 1AA100014  | 151.0        | 3           | 5Series  |
> | 1AA100011  | 202.0        | 1           | 0Series  |
> | 1AA100018  | 441.0        | 4           | 8Series  |
> | 1AA100060  | 538.0        | 4           | 8Series  |
> +------------+--------------+-------------+----------+--+
> 5 rows selected (0.237 seconds)
> 5:CSV Attached: "100_hive_test.csv"
> Expected Result: It should not display channel id 4 as per query.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)