[
https://issues.apache.org/jira/browse/CARBONDATA-1725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
dhatchayani updated CARBONDATA-1725:
------------------------------------
Description:
*Issue:*
<= filter is giving wrong results for timestamp dictioinary column
*Steps to reproduce:*
(1) Create a table with a timestamp dictionary column
create table t1(dob timestamp) stored by 'carbondata' TBLPROPERTIES
('DICTIONARY_INCLUDE'='dob')
(2) Load data
1970-01-01 05:30:00 (same value as 300 records)
(3) Apply filter on table
select count(*) from t1 where dob=cast('1970-01-01 05:30:00' as timestamp);
+--------+
|count(1)|
+--------+
|300 |
+--------+
select count(*) from t1 where dob<=cast('1970-01-01 05:30:00' as timestamp);
+--------+
|count(1)|
+--------+
|1 |
+--------+
Both the queries should give us the same results.
*+Solution:+*
In less than equal to filter, we are considering surrogate 2 as default value.
But surrogate 1 is for default value.
was:
*Issue:*
<= filter is giving wrong results for timestamp dictioinary column
*Steps to reproduce:*
(1) Create a table with a timestamp dictionary column
create table t1(dob timestamp) stored by 'carbondata' TBLPROPERTIES
('DICTIONARY_INCLUDE'='dob')
(2) Load data
1970-01-01 05:30:00 (same value as 300 records)
(3) Apply filter on table
select count(*) from t1 where dob=cast('1970-01-01 05:30:00' as timestamp);
+--------+
|count(1)|
+--------+
|300 |
+--------+
select count(*) from t1 where dob<=cast('1970-01-01 05:30:00' as timestamp);
+--------+
|count(1)|
+--------+
|1 |
+--------+
Both the queries should give us the same results.
Solution:
In less than equal to filter, we are considering surrogate 2 as default value.
But surrogate 1 is for default value.
> Wrong data displayed for <= filter for timestamp column(dictionary column)
> --------------------------------------------------------------------------
>
> Key: CARBONDATA-1725
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1725
> Project: CarbonData
> Issue Type: Bug
> Reporter: dhatchayani
> Assignee: dhatchayani
>
> *Issue:*
> <= filter is giving wrong results for timestamp dictioinary column
> *Steps to reproduce:*
> (1) Create a table with a timestamp dictionary column
> create table t1(dob timestamp) stored by 'carbondata' TBLPROPERTIES
> ('DICTIONARY_INCLUDE'='dob')
> (2) Load data
> 1970-01-01 05:30:00 (same value as 300 records)
> (3) Apply filter on table
> select count(*) from t1 where dob=cast('1970-01-01 05:30:00' as timestamp);
> +--------+
> |count(1)|
> +--------+
> |300 |
> +--------+
> select count(*) from t1 where dob<=cast('1970-01-01 05:30:00' as timestamp);
> +--------+
> |count(1)|
> +--------+
> |1 |
> +--------+
> Both the queries should give us the same results.
> *+Solution:+*
> In less than equal to filter, we are considering surrogate 2 as default
> value. But surrogate 1 is for default value.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
