Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

update statement column lineage #487

Closed
maoxingda opened this issue Dec 3, 2023 · 1 comment · Fixed by #524
Closed

update statement column lineage #487

maoxingda opened this issue Dec 3, 2023 · 1 comment · Fixed by #524
Labels
enhancement New feature or request

Comments

@maoxingda
Copy link
Contributor 

update 
    public.tgt_tbl1
set 
    email = s.email
from
    public.src_tbl1 s
where
    s.id = tgt_tbl1.id
;
@maoxingda maoxingda added the enhancement New feature or request label Dec 3, 2023
@reata
Copy link
Owner

reata commented Dec 3, 2023

Column lineage for UPDATE statement is not supported as of v1.4.8.

It should be quite similar to what we did with MERGE statement.

maoxingda added a commit to maoxingda/sqllineage that referenced this issue Jan 2, 2024
@maoxingda
feat: update statement column lineage (reata#487)
d8d968e
maoxingda added a commit to maoxingda/sqllineage that referenced this issue Jan 2, 2024
@maoxingda
feat: update statement column lineage (reata#487)
235549f
@maoxingda maoxingda mentioned this issue Jan 2, 2024
Merged
maoxingda added a commit to maoxingda/sqllineage that referenced this issue Jan 2, 2024
@maoxingda
feat: update statement column lineage (reata#487)
e9f05e5
maoxingda added a commit to maoxingda/sqllineage that referenced this issue Jan 2, 2024
@maoxingda
feat: update statement column lineage (reata#487)
2ec1af2
@reata reata closed this as completed in #524 Jan 6, 2024
reata added a commit that referenced this issue Jan 6, 2024
@maoxingda @reata
feat: update statement column lineage (#487) (#524)
c84110d 
* feat: update statement column lineage (#487)

* refactor: extract utils

* refactor: sqllineage.core.parser.sqlfluff.extractors.select.SelectExtractor.extract

* fix: flake8

* 2nd round of refactor

* refactor: remove UpdateExtractor dependency on SourceHandlerMixin

* refactor: remove find_table_from_from_expression_or_join_clause

* refactor: remove tables local variable

---------

Co-authored-by: reata <reddevil.hjw@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: update statement column lineage (#487) maoxingda/sqllineage
2 participants
@reata @maoxingda