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

Filter operator does not work for List

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Patch Available
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None

      Description

      create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 bigint);
      
      insert into table1 values (1, 10000, 'ccl',2014, 11);
      insert into table1 values (1, 10000, 'ccl',2015, 11);
      insert into table1 values (1, 10000, 'ccl',2014, 11);
      insert into table1 values (1, 10000, 'ccl',2013, 11);
      
      -- INCORRECT
      SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in (struct(2014,11));
      -- CORRECT
      SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in (struct('2014','11'));
      

        Attachments

        1. HIVE-18999.03.patch
          14 kB
          Steve Yeom
        2. HIVE-18999.02.patch
          14 kB
          Steve Yeom
        3. HIVE-18999.01.patch
          14 kB
          Steve Yeom

          Activity

            People

            • Assignee:
              steveyeom2017 Steve Yeom
              Reporter:
              steveyeom2017 Steve Yeom
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: