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

Wrong data displayed for <= filter for timestamp column(dictionary column)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • None
    • None

    Description

      Issue:
      <= filter is giving wrong results for timestamp dictioinary column

      Steps to reproduce:
      (1) Create a table with a timestamp dictionary column
      create table t1(dob timestamp) stored by 'carbondata' TBLPROPERTIES ('DICTIONARY_INCLUDE'='dob')
      (2) Load data
      1970-01-01 05:30:00 (same value as 300 records)
      (3) Apply filter on table
      select count from t1 where dob=cast('1970-01-01 05:30:00' as timestamp);
      --------

      count(1)

      --------

      300

      --------
      select count from t1 where dob<=cast('1970-01-01 05:30:00' as timestamp);
      --------

      count(1)

      --------

      1

      --------

      Both the queries should give us the same results.

      Solution:
      In less than equal to filter, we are considering surrogate 2 as default value. But surrogate 1 is for default value.

      Attachments

        Activity

          People

            dhatchayani dhatchayani
            dhatchayani dhatchayani
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: