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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (Jira)
Venugopal Reddy K created CARBONDATA-4008:
---------------------------------------------

             Summary: IN filter with date column in condition 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
             Fix For: 2.1.0


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