Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-4008

IN filter on date column is returning 0 results when 'carbon.push.rowfilters.for.vector' is true

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.0.0
    • 2.1.1
    • core
    • None

    Description

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

      Attachments

        Activity

          People

            Unassigned Unassigned
            VenuReddy Venugopal Reddy K
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4h 50m
                4h 50m