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

          Issue Links

            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: