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

Nested inline view produces incorrect result when referencing the same column implicitly

    Details

      Description

      Reproduce step:

      CREATE TABLE t (a int);
      INSERT INTO TABLE t VALUES(NULL);
      select count(*) from t;     =>  1
      create view vv (aa, bb) as select a aa, a bb from t;
      select count(*) from vv;     =>  0
      

      In query plan there is predicates: a = a, and this filters out null.

      This affects view because impala rewrites this view to nested select statement.

        Attachments

          Activity

            People

            • Assignee:
              HuaisiXu Huaisi Xu
              Reporter:
              HuaisiXu Huaisi Xu
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: