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

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

    XMLWordPrintableJSON

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

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

              Dates

                Created:
                Updated:
                Resolved: