Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11493

Predicate with integer column equals double evaluates to false

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 0.14.0, 1.0.0, 1.2.0, 1.2.1, 2.0.0
    • Fix Version/s: 2.0.0
    • Component/s: Query Planning
    • Labels:
      None
    • Target Version/s:

      Description

      Filters with integer column equals double constant evaluates to false everytime. Negative double constant works fine.

      explain select * from orc_ppd where t = 10.0;
      OK
      Stage-0
         Fetch Operator
            limit:-1
            Select Operator [SEL_2]
               outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
               Filter Operator [FIL_1]
                  predicate:false (type: boolean)
                  TableScan [TS_0]
                     alias:orc_ppd
      
      explain select * from orc_ppd where t = -10.0;
      OK
      Stage-0
         Fetch Operator
            limit:-1
            Select Operator [SEL_2]
               outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
               Filter Operator [FIL_1]
                  predicate:(t = (- 10.0)) (type: boolean)
                  TableScan [TS_0]
                     alias:orc_ppd
      

        Attachments

        1. HIVE-11493.01.patch
          3 kB
          Pengcheng Xiong
        2. HIVE-11493.02.patch
          28 kB
          Pengcheng Xiong
        3. HIVE-11493.03.patch
          28 kB
          Pengcheng Xiong
        4. HIVE-11493.04.patch
          28 kB
          Pengcheng Xiong

          Activity

            People

            • Assignee:
              pxiong Pengcheng Xiong
              Reporter:
              prasanth_j Prasanth Jayachandran
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: