[jira] [Commented] (CARBONDATA-852) Less than or equal to operator(<=) does not work properly in Range Filter.

2017-05-10 Thread sounak chakraborty (JIRA) 

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

sounak chakraborty commented on CARBONDATA-852:
---

I think all inserted data to dob columns are null as it doesnt match the 
predefined format. Can you please check it? In case they are null no data will 
be returned and the output is correct.

> Less than or equal to operator(<=) does not work properly in Range Filter.
> --
>
> Key: CARBONDATA-852
> URL: https://issues.apache.org/jira/browse/CARBONDATA-852
> Project: CarbonData
>  Issue Type: Bug
>  Components: data-load
>Affects Versions: 1.1.0
> Environment: Spark 2-1
>Reporter: Vinod Rohilla
>Assignee: Vinod Rohilla
>Priority: Minor
> Attachments: 2000_UniqData.csv
>
>
> Less than or equal (<=) to operator does not work properly in range filter.
> Steps to reproduces:
> 1)Create table:
> CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION 
> string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 
> bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 
> decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 
> int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES 
> ("TABLE_BLOCKSIZE"= "256 MB");
> 2)Load Data in a table:
> LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/2000_UniqData.csv' into 
> table uniqdata OPTIONS('DELIMITER'=',' , 
> 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
> 3: Run the Query.
> select dob from uniqdata where dob <= '1972-12-10' and dob >= '1972-12-01';
> 4:Result on beeline:
> ++--+
> |  dob   |
> ++--+
> | 1972-12-01 01:00:03.0  |
> | 1972-12-02 01:00:03.0  |
> | 1972-12-03 01:00:03.0  |
> | 1972-12-04 01:00:03.0  |
> | 1972-12-05 01:00:03.0  |
> | 1972-12-06 01:00:03.0  |
> | 1972-12-07 01:00:03.0  |
> | 1972-12-08 01:00:03.0  |
> | 1972-12-09 01:00:03.0  |
> ++--+
> Expected Result: It should include " 1972-12-10 " in the result set.



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

[jira] [Commented] (CARBONDATA-852) Less than or equal to operator(<=) does not work properly in Range Filter.

2017-05-10 Thread Vinod Rohilla (JIRA) 

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

Vinod Rohilla commented on CARBONDATA-852:
--

Hi [~sounak]

I have attached the CSV.Please check.

Thanks!
Vinod Rohilla

> Less than or equal to operator(<=) does not work properly in Range Filter.
> --
>
> Key: CARBONDATA-852
> URL: https://issues.apache.org/jira/browse/CARBONDATA-852
> Project: CarbonData
>  Issue Type: Bug
>  Components: data-load
>Affects Versions: 1.1.0
> Environment: Spark 2-1
>Reporter: Vinod Rohilla
>Assignee: Vinod Rohilla
>Priority: Minor
> Attachments: 2000_UniqData.csv
>
>
> Less than or equal (<=) to operator does not work properly in range filter.
> Steps to reproduces:
> 1)Create table:
> CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION 
> string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 
> bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 
> decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 
> int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES 
> ("TABLE_BLOCKSIZE"= "256 MB");
> 2)Load Data in a table:
> LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/2000_UniqData.csv' into 
> table uniqdata OPTIONS('DELIMITER'=',' , 
> 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
> 3: Run the Query.
> select dob from uniqdata where dob <= '1972-12-10' and dob >= '1972-12-01';
> 4:Result on beeline:
> ++--+
> |  dob   |
> ++--+
> | 1972-12-01 01:00:03.0  |
> | 1972-12-02 01:00:03.0  |
> | 1972-12-03 01:00:03.0  |
> | 1972-12-04 01:00:03.0  |
> | 1972-12-05 01:00:03.0  |
> | 1972-12-06 01:00:03.0  |
> | 1972-12-07 01:00:03.0  |
> | 1972-12-08 01:00:03.0  |
> | 1972-12-09 01:00:03.0  |
> ++--+
> Expected Result: It should include " 1972-12-10 " in the result set.



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

[jira] [Commented] (CARBONDATA-852) Less than or equal to operator(<=) does not work properly in Range Filter.

2017-05-10 Thread sounak chakraborty (JIRA) 

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

sounak chakraborty commented on CARBONDATA-852:
---

Can you attach the CSV file?

> Less than or equal to operator(<=) does not work properly in Range Filter.
> --
>
> Key: CARBONDATA-852
> URL: https://issues.apache.org/jira/browse/CARBONDATA-852
> Project: CarbonData
>  Issue Type: Bug
>  Components: data-load
>Affects Versions: 1.1.0
> Environment: Spark 2-1
>Reporter: Vinod Rohilla
>Assignee: sounak chakraborty
>Priority: Minor
>
> Less than or equal (<=) to operator does not work properly in range filter.
> Steps to reproduces:
> 1)Create table:
> CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION 
> string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 
> bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 
> decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 
> int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES 
> ("TABLE_BLOCKSIZE"= "256 MB");
> 2)Load Data in a table:
> LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/2000_UniqData.csv' into 
> table uniqdata OPTIONS('DELIMITER'=',' , 
> 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
> 3: Run the Query.
> select dob from uniqdata where dob <= '1972-12-10' and dob >= '1972-12-01';
> 4:Result on beeline:
> ++--+
> |  dob   |
> ++--+
> | 1972-12-01 01:00:03.0  |
> | 1972-12-02 01:00:03.0  |
> | 1972-12-03 01:00:03.0  |
> | 1972-12-04 01:00:03.0  |
> | 1972-12-05 01:00:03.0  |
> | 1972-12-06 01:00:03.0  |
> | 1972-12-07 01:00:03.0  |
> | 1972-12-08 01:00:03.0  |
> | 1972-12-09 01:00:03.0  |
> ++--+
> Expected Result: It should include " 1972-12-10 " in the result set.



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

[jira] [Commented] (CARBONDATA-852) Less than or equal to operator(<=) does not work properly in Range Filter.

2017-05-08 Thread Ravindra Pesala (JIRA) 

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

Ravindra Pesala commented on CARBONDATA-852:


[~vin7149] Please verify again this issue on master, it seems this is already 
fixed.

> Less than or equal to operator(<=) does not work properly in Range Filter.
> --
>
> Key: CARBONDATA-852
> URL: https://issues.apache.org/jira/browse/CARBONDATA-852
> Project: CarbonData
>  Issue Type: Bug
>  Components: data-load
>Affects Versions: 1.1.0
> Environment: Spark 2-1
>Reporter: Vinod Rohilla
>Assignee: sounak chakraborty
>Priority: Minor
>
> Less than or equal (<=) to operator does not work properly in range filter.
> Steps to reproduces:
> 1)Create table:
> CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION 
> string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 
> bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 
> decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 
> int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES 
> ("TABLE_BLOCKSIZE"= "256 MB");
> 2)Load Data in a table:
> LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/2000_UniqData.csv' into 
> table uniqdata OPTIONS('DELIMITER'=',' , 
> 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
> 3: Run the Query.
> select dob from uniqdata where dob <= '1972-12-10' and dob >= '1972-12-01';
> 4:Result on beeline:
> ++--+
> |  dob   |
> ++--+
> | 1972-12-01 01:00:03.0  |
> | 1972-12-02 01:00:03.0  |
> | 1972-12-03 01:00:03.0  |
> | 1972-12-04 01:00:03.0  |
> | 1972-12-05 01:00:03.0  |
> | 1972-12-06 01:00:03.0  |
> | 1972-12-07 01:00:03.0  |
> | 1972-12-08 01:00:03.0  |
> | 1972-12-09 01:00:03.0  |
> ++--+
> Expected Result: It should include " 1972-12-10 " in the result set.



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