Centos7.6安装sqllineage（sql血缘分析工具）

pip安装

sqllineage-1.3.3.tar.gz

GitHub : https://github.com/reata/sqllineage

#普通用户
[root@etl ~]# su - apl
[apl@etl ~]$ pip3 install sqllineage

测试

[apl@etl ~]$ mkdir sql
[apl@etl ~]$ cd sql
[apl@etl sql]$ vi test.sql
drop table if exists test;
create table test as 
select a.*,b.dept_name
from ods.sales a, dim.dept b 
where a.dept_no = b.dept_no
distributed by (sales_id);
[apl@etl sql]$ sqllineage -f test.sql 
Statements(#): 2
Source Tables:
    dim.dept
    ods.sales
Target Tables:
    <default>.test