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

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.1.1
    • Component/s: core
    • Labels:
      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

            • Assignee:
              Unassigned
              Reporter:
              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