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

["Venugopal Reddy K (Jira)" <ji...@apache.org>]

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

Venugopal Reddy K resolved CARBONDATA-4008.
-------------------------------------------
    Resolution: Fixed

It is fixed with [PR 3953|https://github.com/apache/carbondata/pull/3953]

> 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)