http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Resolved-CARBONDATA-4008-IN-filter-on-date-column-is-returning-0-results-when-carbon-push-rowfie-tp105161.html
Venugopal Reddy K resolved CARBONDATA-4008.
> 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()