Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2921

"is not null" does not work in some case

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: Impala 2.2.2
    • Fix Version/s: None
    • Component/s: Backend

      Description

      I have two table foo and foo2, I found "is not null" does not work in some case:

      table foo:

      create table foo(k1 string, v int) stored as parquet;
      insert into foo values('a', 10), ('b', 20);
      

      table foo2:

      create table foo2(k1 string, k2 string) stored as parquet;
      insert into foo2 values('a', 'c');
      

      After I establishing foo and foo2, the result of following statement is not correct:

      WITH t1
      AS (
      	SELECT k2
      		,sum(v) AS v
      	FROM foo
      	LEFT JOIN foo2 using (k1)
      	GROUP BY k2
      	)
      SELECT *, k2 is null
      FROM t1
      WHERE k2 IS NOT NULL
      

      (NULL, 20, true) is also selected, which should be omitted

        Attachments

        1. 1.png
          7 kB
          Qinlong Guo

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              guoqinlong_impala_42f0 Qinlong Guo
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: