[jira] [Updated] (CARBONDATA-4008) IN filter on date column is returning 0 results when 'carbon.push.rowfilters.for.vector' is true

Posted by Akash R Nilugal (Jira) on Nov 23, 2020; 5:05am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Updated-CARBONDATA-4008-IN-filter-on-date-column-is-returning-0-results-when-carbon-push-rowfile-tp103382.html


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

Kunal Kapoor updated CARBONDATA-4008:
-------------------------------------
    Fix Version/s:     (was: 2.1.0)
                   2.1.1

> IN filter on date column is returning 0 results when 'carbon.push.rowfilters.for.vector' is true
> ------------------------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-4008
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4008
>             Project: CarbonData
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 2.0.0
>            Reporter: Venugopal Reddy K
>            Priority: Major
>             Fix For: 2.1.1
>
>          Time Spent: 4h 50m
>  Remaining Estimate: 0h
>
> *Issue:*
> IN filter with date column in condition is returning 0 results when 'carbon.push.rowfilters.for.vector' is set to true.
>  
> *Steps to reproduce:*
> sql("set carbon.push.rowfilters.for.vector=true")
> sql("create table test_table(i int, dt date, ts timestamp) stored as carbondata")
> sql("insert into test_table select 1, '2020-03-30', '2020-03-30 10:00:00'")
> sql("insert into test_table select 2, '2020-07-04', '2020-07-04 14:12:15'")
> sql("insert into test_table select 3, '2020-09-23', '2020-09-23 12:30:45'")
> sql("select * from test_table where dt IN ('2020-03-30', '2020-09-23')").show()

--
This message was sent by Atlassian Jira
(v8.3.4#803005)