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

No navigator lineage for CREATE/ALTER VIEW statements

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 2.2
    • Impala 2.2
    • Frontend
    • None

    Description

      If you run the following queries, I expect the last query to generate lineage, but it doesn't:

      CREATE TABLE dst
      (
      a INT,
      b BIGINT,
      c STRING,
      d DOUBLE,
      e BIGINT,
      f BIGINT
      ) PARTITIONED BY ( p1 int, p2 string );
      CREATE TABLE src1
      (
      s1 INT,
      s2 BIGINT,
      s3 STRING,
      s4 FLOAT
      );
      CREATE TABLE src2 LIKE src1;
      CREATE VIEW view1 AS
      SELECT *
      FROM src1;
      CREATE VIEW view2 AS
      WITH w
      AS (SELECT s1,
      s2
      FROM src1)
      SELECT t1.s1,
      t1.s2,
      t2.s3,
      t2.s4
      FROM w t1,
      src2 t2
      WHERE t1.s1 = t2.s1;

      Attachments

        Activity

          People

            Unassigned Unassigned
            lv Lars Volker
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: