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

No navigator lineage for CREATE/ALTER VIEW statements

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.2
    • Fix Version/s: Impala 2.2
    • Component/s: Frontend
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: