Overview 

This addition will allow users to see the history of directives made to a column of data.

Goals

User should be able to see lineage information, ie. directives, for columns

Storing lineage information should have minimal/no impact to the wrangler application

User Stories

• As a user, I should be able to see the directives applied to a column of data.

• As a user, I should be able to see the directives applied to a column of data over any period of time.

• As a user, I should be able to add tags and properties to specific columns of data (stretch)

Design

Save directives for each column in AST format after parsing of directives along with necessary information (time, dataset/stream name/id, etc.).

Use TMS to send information to platform.

Unmarshal and store in HBase.

Access to lineage should only be available through the platform

Questions

• How to get source and sink datasets?
• Does ParseTree have all necessary information for every directive?

Approach

Approach #1:

Store directives during execution of each step

Advantages:

• Less assumptions

Disadvantages:

• Add getter to each step class + sometimes (~30%) local variable
• Slower

Approach #2 (Preferred):

Compute lineage without looking at data by backtracking

Advantages:

• No instance variables added to step classes
• Faster

Disadvantages:

• Requires stricter rule on directives, ie. every rename must give old and new name. See * below for why
• More assumption based, ie. parse-as-<> assumes that the output fields are from all the input fields

*Backtrack starting with columns A,B,C. Previous directive is "set-columns A B C". The directive before that is "filter-row-if-matched <column> <regex>" where <column> is nameOfOwner. No way of knowing what nameOfOwner refers to without looking at data.

API changes

New Programmatic APIs

FieldLevelLineage Java class that contains all necessary information to be sent to CDAP platform

Instance should be initialized passing in list of final columns after wrangling.

store() takes a ParseTree and stores all the necessary information into lineages.

Stores lineage for each column in lineage instance variable which is a map to ASTs.

public class FieldLevelLineage {
  private class BranchingStepNode {
    boolean continueDown;
    Step directive;
    Map<String, Integer> branches;
    // constructors, toString()
  }
  private String dataSetName; // dataset/stream name/id
  private final long startTime;
  private final String programName;
  private final String[] finalColumns;
  private final Set<String> currentColumns; // not sure if needed depending on parse tree implementation
  private final Map<String, List<BranchingStepNode>> lineage; // main storage

  public FieldLevelLineage(String dataSetName, String[] columnNames) {...}

  // getters for startTime, programName, dataSetName, finalColumns
  // setter for dataSetName  
 
  // Helpers for store

  public void store(ParseTree tree) {
    List<String> readCols, addCols, modifyCols, dropCols, renameCols, swapCols;
	/**
     * Go through tree one directive at a time
     * For each column associated with the directive put name of column into associated list based on label 
     * From these 6 lists store correctly into lineage
	 */
  }
}

Parse Tree: All columns should be labeled one of:  {Read, Drop, Modify, Add, Swap, Rename}. Read: column's name or values are read but not changed. Drop: column is dropped. Modify: column's values altered. Add: column is added. Swap: column's name is swapped with the name of another column. Rename: column's name is changed.

For Read, Drop, Modify, and Add, something like this -> Column: Name, Label: add.

For Swap, Rename, something like this -> Column: body_5 DOB, Label: rename. // Basically some way of having both names, currently using a space. Old/new for rename, A/B for swap.

For Read, Modify, and Add: instead of column name can return {"all columns", "all columns minus _ _ _ _ ", "all columns formatted %s_%d"}, along with label.

For Swap, Rename, and Drop must explicitly return name of all columns involved.

Algorithm visual:  lineage ----------------------------------------------------------------------------------------------------->     List for name column  -------------->  Example wrangler application

New REST APIs

/v3/namespaces/{namespace-id}/datasets/{dataset-id}/columns/{column-id}/lineage?start=<start-ts>&end=<end-ts>&maxLevels=<max-levels>

/v3/namespaces/{namespace-id}/streams/{stream-id}/columns/{column-id}/lineage?start=<start-ts>&end=<end-ts>&maxLevels=<max-levels>

CLI Impact or Changes

TBD

UI Impact or Changes

• Add interface to metadata table when viewing dataset to see lineage of columns possibly by clicking on column:
  
• When a column is clicked on will look something like:
  

Security Impact 

Should be none, TBD

Impact on Infrastructure Outages 

Storage in HBase; Impact TBD.

Test Scenarios

Releases

Release 4.3.0

Release 4.4.0

Related Work

• Fixing TextDirectives and parsing of directives in general