forked from HamaWhiteGG/flink-sql-lineage
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path2_data.sql
48 lines (39 loc) · 63.8 KB
/
2_data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
INSERT INTO lineage.bas_user (user_id, username, password, avatar, locked, create_time, modify_time, invalid) VALUES (1, 'demo', 'demo', 'iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAAB2UlEQVR42u3bIW5CQRCA4XcYbNG4XqEBB6aiFkGCJ0FxIiQWEmwTDIbQA9QgySNzgZc8sRNYPvHrzc58dpr1rmlr6fN/2w7v16LFGzXNrAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOhqeRi036dZ8Ua3fXEA8UbGX2Jm1QCID5VeTG3FzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADoBxKlT6SaXVbs4fqhHMbOM3TQZmr/+NlXd02UUM8vYDQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArw0g4/hgep5bas9iZimHIYb93gEAgCEAIAAEgAAQAAJAAAgAASAABIAAEAACQAAIAAEgAASAABAAAkAvDCBOkEr38ztOu6Yp/ZesK6eYWcZuqroNjFOn0n+JNxyHAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADPAOABx11T7Usu+c0AAAAASUVORK5CYII=', 0, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_user (user_id, username, password, avatar, locked, create_time, modify_time, invalid) VALUES (2, 'admin', 'admin', 'iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAABwklEQVR42u3dIQ4CMRAF0AoUHo3AEDSHQW4QJEiyCQIBCYIzcAcOgONqJXMBNhVtSPPE15P+vspJ027Y5l5yec3z/ZOqJmb01FkCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWgKIA/WSw3WVh3FTNTGjp85S7RfTMnFBtV9MzOipMwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJjK7T2zGFKY6KwbAKfnwmpYYaIzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAnwCOj2Wunf15DUBhorMWd+PTqD8F4NcwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAqXy/WLeKhH4jDAAAAAElFTkSuQmCC', 0, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_user (user_id, username, password, avatar, locked, create_time, modify_time, invalid) VALUES (3, 'HamaWhite', '123456', 'iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAAB1ElEQVR42u3dIYpCURSA4Zfcg2GKvDBBBqsMgm2SIGKaKYIbcR2TTDb34FLciXLsKoZz8D2+8OfLOferl9vMh9tLdrvJ7HJeDdLbtMv0WeKMilliZxV30wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA3QUQB2V3mH0C8GKxs4q7aSqGqapPAKoCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB42HHe3haXXZxz+hmmVjlLbwDsv8cl79zigrJniTMqZomdAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAwDMA2Q8pov/pl4chLxY7q7gbn0b5NQwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOB+v6P1baDsFh9/6bPEGRWzxM56A0DvGwAAWAIAAkAACAABIAAEgAAQAAJAAAgAASAABIAAEAACQAAIAAEgANTdrr/Kam2i+hYqAAAAAElFTkSuQmCC', 0, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_user (user_id, username, password, avatar, locked, create_time, modify_time, invalid) VALUES (4, 'Asteria', '123456', 'iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAAB80lEQVR42u3bIW5CURAF0L8INoBiDZUkCFQFClNTDLKqClUUCgWqqvUYJKLJX0BFd8BKHpku4CcV80Jej7h6MneOne5h9llaybkfl59rl5qY0VJnHQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAwFAWT7vyun1Oz9f3KB1AzKixS3TWDIBYKPswrSU6AwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA+DcAXjbrsly9pSZmAHCnAOJA2bvEDAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAALgXANmPFJHd8RGAPyY6q3GbrqV3qpYA1AoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMBgTpfJ76tTdvbv83L4mKYmZtTYJTprBkAUV+PP7dyP03eJGTV2ic4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACGcgMMZ+UtKnNWWQAAAABJRU5ErkJggg==', 0, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_user (user_id, username, password, avatar, locked, create_time, modify_time, invalid) VALUES (5, 'Cattleya', '123456', 'iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAABxklEQVR42u3bIQpCQRCA4c3ewBuIJotZsXkBi0EEwSJYtBgMdsEqZq/5ZN4NDDv4Hl/48zCzX91yHU+a2q3Wm6a8PtXbLZbVd4kZGbvEzTLepgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACZAIb3R1O72eHUHq52o8ut+i4xI2OXuFnG25QMzdPjOUVzu1DlXWJGxi5xs4y3AQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACg2wAyPh/Mt3sAfixulvIxJGOZrPoEICsAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAoMMA4gtSXxo839UBxIw+3Szlb6D+OEcAwBEAEAACQAAIAAEgAASAABAAAkAACAABIAAEgAAQAAJAAAgAAaDO9gWMGFcNBFkuLwAAAABJRU5ErkJggg==', 0, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_role (role_id, role_name, create_time, modify_time, invalid) VALUES (1, 'USER', 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_role (role_id, role_name, create_time, modify_time, invalid) VALUES (2, 'ADMIN', 1674565178000, 1674565178000, 0);
INSERT INTO lineage.rel_role_user (rid, role_id, user_id, invalid) VALUES (1, 1, 1, 0);
INSERT INTO lineage.rel_role_user (rid, role_id, user_id, invalid) VALUES (2, 2, 2, 0);
INSERT INTO lineage.rel_role_user (rid, role_id, user_id, invalid) VALUES (3, 1, 3, 0);
INSERT INTO lineage.rel_role_user (rid, role_id, user_id, invalid) VALUES (4, 1, 4, 0);
INSERT INTO lineage.rel_role_user (rid, role_id, user_id, invalid) VALUES (5, 1, 5, 0);
INSERT INTO lineage.bas_permission (permission_id, permission_group, permission_name, permission_code, create_time, modify_time, invalid) VALUES (1, 'plugins', 'add plugin', 'system:plugin:add', 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_permission (permission_id, permission_group, permission_name, permission_code, create_time, modify_time, invalid) VALUES (2, 'plugins', 'edit plugin', 'system:plugin:edit', 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_permission (permission_id, permission_group, permission_name, permission_code, create_time, modify_time, invalid) VALUES (3, 'plugins', 'delete plugin', 'system:plugin:delete', 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_permission (permission_id, permission_group, permission_name, permission_code, create_time, modify_time, invalid) VALUES (4, 'plugins', 'disable plugin', 'system:plugin:disable', 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_permission (permission_id, permission_group, permission_name, permission_code, create_time, modify_time, invalid) VALUES (5, 'plugins', 'list plugin', 'system:plugin:list', 1674565178000, 1674565178000, 0);
INSERT INTO lineage.rel_role_permission (rid, role_id, permission_id, invalid) VALUES (1, 1, 5, 0);
INSERT INTO lineage.rel_role_permission (rid, role_id, permission_id, invalid) VALUES (2, 2, 1, 0);
INSERT INTO lineage.rel_role_permission (rid, role_id, permission_id, invalid) VALUES (3, 2, 2, 0);
INSERT INTO lineage.rel_role_permission (rid, role_id, permission_id, invalid) VALUES (4, 2, 3, 0);
INSERT INTO lineage.rel_role_permission (rid, role_id, permission_id, invalid) VALUES (5, 2, 4, 0);
INSERT INTO lineage.rel_role_permission (rid, role_id, permission_id, invalid) VALUES (6, 2, 5, 0);
INSERT INTO lineage.bas_plugin (plugin_id, plugin_name, plugin_code, descr, default_plugin, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (1, 'Flink16', 'flink1.16.x', 'Field lineage plugin for flink1.16', 1, 2, 2, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_plugin (plugin_id, plugin_name, plugin_code, descr, default_plugin, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (2, 'Flink14', 'flink1.14.x', 'Field lineage plugin for flink1.14', 0, 2, 2, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_catalog (catalog_id, plugin_id, catalog_name, catalog_type, default_database, descr, properties, default_catalog, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (1, 1, 'Flink16_memory', 'generic_in_memory', 'default', 'The MemoryCatalog is an in-memory implementation of a catalog. All objects will be available only for the lifetime of the session.', null, 1, 1, 1, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_table (table_id, catalog_id, `database`, table_name, ddl, descr, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (1, 1, 'default', 'ods_mysql_users', 'Q1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMgb2RzX215c3FsX3VzZXJzICgKICAgIGlkIEJJR0lOVCBQUklNQVJZIEtFWSBOT1QgRU5GT1JDRUQsCiAgICBuYW1lIFNUUklORywKICAgIGJpcnRoZGF5IFRJTUVTVEFNUCgzKSwKICAgIHRzIFRJTUVTVEFNUCgzKSwKICAgIHByb2NfdGltZSBhcyBwcm9jdGltZSAoKQogICkKV0lUSAogICgKICAgICdjb25uZWN0b3InPSdteXNxbC1jZGMnLAogICAgJ2hvc3RuYW1lJz0nMTI3LjAuMC4xJywKICAgICdwb3J0Jz0nMzMwNicsCiAgICAndXNlcm5hbWUnPSdyb290JywKICAgICdwYXNzd29yZCc9J3h4eCcsCiAgICAnc2VydmVyLXRpbWUtem9uZSc9J0FzaWEvU2hhbmdoYWknLAogICAgJ2RhdGFiYXNlLW5hbWUnPSdkZW1vJywKICAgICd0YWJsZS1uYW1lJz0ndXNlcnMnCiAgKQ==', 'system built-in table', 1, 1, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_table (table_id, catalog_id, `database`, table_name, ddl, descr, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (2, 1, 'default', 'dwd_hudi_users', 'Q1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMKICBkd2RfaHVkaV91c2VycyAoCiAgICBpZCBCSUdJTlQgUFJJTUFSWSBLRVkgTk9UIEVORk9SQ0VELAogICAgbmFtZSBTVFJJTkcsCiAgICBjb21wYW55X25hbWUgU1RSSU5HLAogICAgYmlydGhkYXkgVElNRVNUQU1QKDMpLAogICAgdHMgVElNRVNUQU1QKDMpLAogICAgYHBhcnRpdGlvbmAgVkFSQ0hBUigyMCkKICApIFBBUlRJVElPTkVEIEJZIChgcGFydGl0aW9uYCkKV0lUSAogICgKICAgICdjb25uZWN0b3InPSdodWRpJywKICAgICd0YWJsZS50eXBlJz0nQ09QWV9PTl9XUklURScsCiAgICAncGF0aCcgPSAnL2h1ZGkvdXNlcnMnLAogICAgJ3JlYWQuc3RyZWFtaW5nLmVuYWJsZWQnPSd0cnVlJywKICAgICdyZWFkLnN0cmVhbWluZy5jaGVjay1pbnRlcnZhbCc9JzEnCiAgKQ==', 'system built-in table', 1, 1, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_table (table_id, catalog_id, `database`, table_name, ddl, descr, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (3, 1, 'default', 'dim_mysql_company', 'Q1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMgZGltX215c3FsX2NvbXBhbnkgKAogICAgdXNlcl9pZCBCSUdJTlQsCiAgICBjb21wYW55X25hbWUgU1RSSU5HCikgV0lUSCAoCiAgICAnY29ubmVjdG9yJz0namRiYycsCiAgICAndXJsJz0namRiYzpteXNxbDovLzEyNy4wLjAuMTozMzA2L2RlbW8/dXNlU1NMPWZhbHNlJmNoYXJhY3RlckVuY29kaW5nPVVURi04JywKICAgICd1c2VybmFtZSc9J3Jvb3QnLAogICAgJ3Bhc3N3b3JkJz0neHh4JywKICAgICd0YWJsZS1uYW1lJz0nY29tcGFueScKKQ==', 'system built-in table', 1, 1, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_table (table_id, catalog_id, `database`, table_name, ddl, descr, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (4, 1, 'default', 'dws_users_cnt', 'Q1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMgZHdzX3VzZXJzX2NudCAoIAogICAgaWQgQklHSU5UIFBSSU1BUlkgS0VZIE5PVCBFTkZPUkNFRCAsCiAgICBuYW1lX2NudCBCSUdJTlQgLCAKICAgIGNvbXBhbnlfbmFtZV9jbnQgQklHSU5UIAopV0lUSCAoIAogICAgJ2Nvbm5lY3RvcicgPSAnaHVkaScgLCAKICAgICd0YWJsZS50eXBlJyA9ICdNRVJHRV9PTl9SRUFEJyAKKSA=', 'system built-in table', 1, 1, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_task (task_id, catalog_id, task_name, descr, `database`, task_source, task_status, task_log, table_graph, column_graph, lineage_time, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (1, 1, 'first-demo', 'Demo', 'default', 'SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEsCiAgICBDT05DQVQoYS5uYW1lLGIuY29tcGFueV9uYW1lKSwKICAgIGIuY29tcGFueV9uYW1lLCAKICAgIGEuYmlydGhkYXksCiAgICBhLnRzLAogICAgREFURV9GT1JNQVQoYS5iaXJ0aGRheSwgJ3l5eXlNTWRkJykgYXMgcApGUk9NCiAgICBvZHNfbXlzcWxfdXNlcnMgQVMgYQpKT0lOCiAgICBkaW1fbXlzcWxfY29tcGFueSBGT1IgU1lTVEVNX1RJTUUgQVMgT0YgYS5wcm9jX3RpbWUgQVMgYiAKT04gYS5pZCA9IGIudXNlcl9pZDsKCklOU0VSVCBJTlRPIAogICAgZHdzX3VzZXJzX2NudCAKU0VMRUNUICAgICAgICAKICAgIGlkLCAgICAgICAKICAgIENPVU5UKERJU1RJTkNUIG5hbWUpLCAgICAgICAgCiAgICBDT1VOVChESVNUSU5DVCBjb21wYW55X25hbWUpIApGUk9NICAgICAgIAogICAgZHdkX2h1ZGlfdXNlcnMgCkdST1VQIEJZICAgICAgICAKICAgIGlk', 0, '', '{"edgeSet":[{"edgeId":35,"source":{"childIdSet":[31],"childrenCnt":1,"columnNodeList":[{"childIdSet":[32],"childrenCnt":1,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[34],"childrenCnt":1,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_memory.default.dwd_hudi_users","parentIdSet":[1,18]},"sqlSource":"SU5TRVJUIElOVE8gCiAgICBkd3NfdXNlcnNfY250IApTRUxFQ1QgICAgICAgIAogICAgaWQsICAgICAgIAogICAgQ09VTlQoRElTVElOQ1QgbmFtZSksICAgICAgICAKICAgIENPVU5UKERJU1RJTkNUIGNvbXBhbnlfbmFtZSkgCkZST00gICAgICAgCiAgICBkd2RfaHVkaV91c2VycyAKR1JPVVAgQlkgICAgICAgIAogICAgaWQ=","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":32,"nodeName":"id","parentIdSet":[8],"tableNodeId":31},{"childIdSet":[],"childrenCnt":0,"nodeId":33,"nodeName":"name_cnt","parentIdSet":[9],"tableNodeId":31},{"childIdSet":[],"childrenCnt":0,"nodeId":34,"nodeName":"company_name_cnt","parentIdSet":[10],"tableNodeId":31}],"nodeId":31,"nodeName":"Flink16_memory.default.dws_users_cnt","parentIdSet":[7]}},{"edgeId":21,"source":{"childIdSet":[7],"childrenCnt":2,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},{"childIdSet":[9,10],"childrenCnt":4,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18}],"nodeId":18,"nodeName":"Flink16_memory.default.dim_mysql_company","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEsCiAgICBDT05DQVQoYS5uYW1lLGIuY29tcGFueV9uYW1lKSwKICAgIGIuY29tcGFueV9uYW1lLCAKICAgIGEuYmlydGhkYXksCiAgICBhLnRzLAogICAgREFURV9GT1JNQVQoYS5iaXJ0aGRheSwgJ3l5eXlNTWRkJykgYXMgcApGUk9NCiAgICBvZHNfbXlzcWxfdXNlcnMgQVMgYQpKT0lOCiAgICBkaW1fbXlzcWxfY29tcGFueSBGT1IgU1lTVEVNX1RJTUUgQVMgT0YgYS5wcm9jX3RpbWUgQVMgYiAKT04gYS5pZCA9IGIudXNlcl9pZA==","target":{"childIdSet":[31],"childrenCnt":1,"columnNodeList":[{"childIdSet":[32],"childrenCnt":1,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[34],"childrenCnt":1,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_memory.default.dwd_hudi_users","parentIdSet":[1,18]}},{"edgeId":14,"source":{"childIdSet":[7],"childrenCnt":2,"columnNodeList":[{"childIdSet":[8],"childrenCnt":2,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_memory.default.ods_mysql_users","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEsCiAgICBDT05DQVQoYS5uYW1lLGIuY29tcGFueV9uYW1lKSwKICAgIGIuY29tcGFueV9uYW1lLCAKICAgIGEuYmlydGhkYXksCiAgICBhLnRzLAogICAgREFURV9GT1JNQVQoYS5iaXJ0aGRheSwgJ3l5eXlNTWRkJykgYXMgcApGUk9NCiAgICBvZHNfbXlzcWxfdXNlcnMgQVMgYQpKT0lOCiAgICBkaW1fbXlzcWxfY29tcGFueSBGT1IgU1lTVEVNX1RJTUUgQVMgT0YgYS5wcm9jX3RpbWUgQVMgYiAKT04gYS5pZCA9IGIudXNlcl9pZA==","target":{"childIdSet":[31],"childrenCnt":1,"columnNodeList":[{"childIdSet":[32],"childrenCnt":1,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[34],"childrenCnt":1,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_memory.default.dwd_hudi_users","parentIdSet":[1,18]}}],"nodeMap":{"Flink16_memory.default.dim_mysql_company":{"childIdSet":[7],"childrenCnt":2,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},{"childIdSet":[9,10],"childrenCnt":4,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18}],"nodeId":18,"nodeName":"Flink16_memory.default.dim_mysql_company","parentIdSet":[]},"Flink16_memory.default.dws_users_cnt":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":32,"nodeName":"id","parentIdSet":[8],"tableNodeId":31},{"childIdSet":[],"childrenCnt":0,"nodeId":33,"nodeName":"name_cnt","parentIdSet":[9],"tableNodeId":31},{"childIdSet":[],"childrenCnt":0,"nodeId":34,"nodeName":"company_name_cnt","parentIdSet":[10],"tableNodeId":31}],"nodeId":31,"nodeName":"Flink16_memory.default.dws_users_cnt","parentIdSet":[7]},"Flink16_memory.default.dwd_hudi_users":{"childIdSet":[31],"childrenCnt":1,"columnNodeList":[{"childIdSet":[32],"childrenCnt":1,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[34],"childrenCnt":1,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_memory.default.dwd_hudi_users","parentIdSet":[1,18]},"Flink16_memory.default.ods_mysql_users":{"childIdSet":[7],"childrenCnt":2,"columnNodeList":[{"childIdSet":[8],"childrenCnt":2,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_memory.default.ods_mysql_users","parentIdSet":[]}}}', '{"edgeSet":[{"edgeId":15,"source":{"childIdSet":[8],"childrenCnt":2,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[32],"childrenCnt":1,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7}},{"edgeId":40,"source":{"childIdSet":[34],"childrenCnt":1,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":34,"nodeName":"company_name_cnt","parentIdSet":[10],"tableNodeId":31},"transform":"COUNT(DISTINCT company_name)"},{"edgeId":22,"source":{"childIdSet":[9,10],"childrenCnt":4,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"target":{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"transform":"CONCAT(ods_mysql_users.name, dim_mysql_company.company_name)"},{"edgeId":28,"source":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7}},{"edgeId":36,"source":{"childIdSet":[32],"childrenCnt":1,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":32,"nodeName":"id","parentIdSet":[8],"tableNodeId":31}},{"edgeId":24,"source":{"childIdSet":[9,10],"childrenCnt":4,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"target":{"childIdSet":[34],"childrenCnt":1,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7}},{"edgeId":26,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7}},{"edgeId":17,"source":{"childIdSet":[9],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"transform":"CONCAT(ods_mysql_users.name, dim_mysql_company.company_name)"},{"edgeId":30,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7},"transform":"DATE_FORMAT(birthday, \'yyyyMMdd\')"},{"edgeId":38,"source":{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":33,"nodeName":"name_cnt","parentIdSet":[9],"tableNodeId":31},"transform":"COUNT(DISTINCT name)"}],"nodeMap":{"Flink16_memory.default.dwd_hudi_users.id":{"childIdSet":[32],"childrenCnt":1,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},"Flink16_memory.default.dwd_hudi_users.name":{"childIdSet":[33],"childrenCnt":1,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"Flink16_memory.default.ods_mysql_users.birthday":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"Flink16_memory.default.dwd_hudi_users.ts":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},"Flink16_memory.default.dws_users_cnt.company_name_cnt":{"childIdSet":[],"childrenCnt":0,"nodeId":34,"nodeName":"company_name_cnt","parentIdSet":[10],"tableNodeId":31},"Flink16_memory.default.dws_users_cnt.id":{"childIdSet":[],"childrenCnt":0,"nodeId":32,"nodeName":"id","parentIdSet":[8],"tableNodeId":31},"Flink16_memory.default.dim_mysql_company.user_id":{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},"Flink16_memory.default.ods_mysql_users.id":{"childIdSet":[8],"childrenCnt":2,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"Flink16_memory.default.dwd_hudi_users.birthday":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},"Flink16_memory.default.ods_mysql_users.proc_time":{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1},"Flink16_memory.default.ods_mysql_users.ts":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"Flink16_memory.default.ods_mysql_users.name":{"childIdSet":[9],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"Flink16_memory.default.dws_users_cnt.name_cnt":{"childIdSet":[],"childrenCnt":0,"nodeId":33,"nodeName":"name_cnt","parentIdSet":[9],"tableNodeId":31},"Flink16_memory.default.dwd_hudi_users.company_name":{"childIdSet":[34],"childrenCnt":1,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},"Flink16_memory.default.dwd_hudi_users.partition":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7},"Flink16_memory.default.dim_mysql_company.company_name":{"childIdSet":[9,10],"childrenCnt":4,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18}}}', 1691427811733, 1, 1, 1674565178000, 1691427210190, 0);
INSERT INTO lineage.bas_task (task_id, catalog_id, task_name, descr, `database`, task_source, task_status, task_log, table_graph, column_graph, lineage_time, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (2, 1, 'join-demo', 'Join demo', 'default', 'SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEgLAogICAgQ09OQ0FUKGEubmFtZSwgYi5jb21wYW55X25hbWUpICwgCiAgICBiLmNvbXBhbnlfbmFtZSAsIAogICAgYS5iaXJ0aGRheSAsCiAgICBhLnRzICwKICAgIERBVEVfRk9STUFUKGEuYmlydGhkYXksICd5eXl5TU1kZCcpIGFzIHAKRlJPTQogICAgb2RzX215c3FsX3VzZXJzIEFTIGEKSk9JTgogICAgZGltX215c3FsX2NvbXBhbnkgQVMgYgpPTiBhLmlkID0gYi51c2VyX2lk', 0, '', '{"edgeSet":[{"edgeId":14,"source":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEgLAogICAgQ09OQ0FUKGEubmFtZSwgYi5jb21wYW55X25hbWUpICwgCiAgICBiLmNvbXBhbnlfbmFtZSAsIAogICAgYS5iaXJ0aGRheSAsCiAgICBhLnRzICwKICAgIERBVEVfRk9STUFUKGEuYmlydGhkYXksICd5eXl5TU1kZCcpIGFzIHAKRlJPTQogICAgb2RzX215c3FsX3VzZXJzIEFTIGEKSk9JTgogICAgZGltX215c3FsX2NvbXBhbnkgQVMgYgpPTiBhLmlkID0gYi51c2VyX2lk","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1,18]}},{"edgeId":21,"source":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18}],"nodeId":18,"nodeName":"Flink16_Memory.default.dim_mysql_company","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEgLAogICAgQ09OQ0FUKGEubmFtZSwgYi5jb21wYW55X25hbWUpICwgCiAgICBiLmNvbXBhbnlfbmFtZSAsIAogICAgYS5iaXJ0aGRheSAsCiAgICBhLnRzICwKICAgIERBVEVfRk9STUFUKGEuYmlydGhkYXksICd5eXl5TU1kZCcpIGFzIHAKRlJPTQogICAgb2RzX215c3FsX3VzZXJzIEFTIGEKSk9JTgogICAgZGltX215c3FsX2NvbXBhbnkgQVMgYgpPTiBhLmlkID0gYi51c2VyX2lk","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1,18]}}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"Flink16_Memory.default.dim_mysql_company":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18}],"nodeId":18,"nodeName":"Flink16_Memory.default.dim_mysql_company","parentIdSet":[]},"Flink16_Memory.default.dwd_hudi_users":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1,18]}}}', '{"edgeSet":[{"edgeId":15,"source":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7}},{"edgeId":22,"source":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"transform":"CONCAT(ods_mysql_users.name, dim_mysql_company.company_name)"},{"edgeId":28,"source":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7}},{"edgeId":24,"source":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7}},{"edgeId":26,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7}},{"edgeId":17,"source":{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"transform":"CONCAT(ods_mysql_users.name, dim_mysql_company.company_name)"},{"edgeId":30,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7},"transform":"DATE_FORMAT(birthday, \'yyyyMMdd\')"}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users.id":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.ods_mysql_users.birthday":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dim_mysql_company.company_name":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"Flink16_Memory.default.dwd_hudi_users.name":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.name":{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dim_mysql_company.user_id":{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},"Flink16_Memory.default.dwd_hudi_users.company_name":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.proc_time":{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.birthday":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.ts":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.id":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.ts":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.partition":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}}}', 1691339188621, 1, 1, 1674565178000, 1691339187121, 0);
INSERT INTO lineage.bas_task (task_id, catalog_id, task_name, descr, `database`, task_source, task_status, task_log, table_graph, column_graph, lineage_time, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (3, 1, 'lookup-join-demo', 'Lookup join demo', 'default', 'SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEsCiAgICBDT05DQVQoYS5uYW1lLGIuY29tcGFueV9uYW1lKSwKICAgIGIuY29tcGFueV9uYW1lLCAKICAgIGEuYmlydGhkYXksCiAgICBhLnRzLAogICAgREFURV9GT1JNQVQoYS5iaXJ0aGRheSwgJ3l5eXlNTWRkJykgYXMgcApGUk9NCiAgICBvZHNfbXlzcWxfdXNlcnMgQVMgYQpKT0lOCiAgICBkaW1fbXlzcWxfY29tcGFueSBGT1IgU1lTVEVNX1RJTUUgQVMgT0YgYS5wcm9jX3RpbWUgQVMgYiAKT04gYS5pZCA9IGIudXNlcl9pZA==', 0, '', '{"edgeSet":[{"edgeId":21,"source":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18}],"nodeId":18,"nodeName":"Flink16_Memory.default.dim_mysql_company","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEsCiAgICBDT05DQVQoYS5uYW1lLGIuY29tcGFueV9uYW1lKSwKICAgIGIuY29tcGFueV9uYW1lLCAKICAgIGEuYmlydGhkYXksCiAgICBhLnRzLAogICAgREFURV9GT1JNQVQoYS5iaXJ0aGRheSwgJ3l5eXlNTWRkJykgYXMgcApGUk9NCiAgICBvZHNfbXlzcWxfdXNlcnMgQVMgYQpKT0lOCiAgICBkaW1fbXlzcWxfY29tcGFueSBGT1IgU1lTVEVNX1RJTUUgQVMgT0YgYS5wcm9jX3RpbWUgQVMgYiAKT04gYS5pZCA9IGIudXNlcl9pZA==","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1,18]}},{"edgeId":14,"source":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgYS5pZCBhcyBpZDEsCiAgICBDT05DQVQoYS5uYW1lLGIuY29tcGFueV9uYW1lKSwKICAgIGIuY29tcGFueV9uYW1lLCAKICAgIGEuYmlydGhkYXksCiAgICBhLnRzLAogICAgREFURV9GT1JNQVQoYS5iaXJ0aGRheSwgJ3l5eXlNTWRkJykgYXMgcApGUk9NCiAgICBvZHNfbXlzcWxfdXNlcnMgQVMgYQpKT0lOCiAgICBkaW1fbXlzcWxfY29tcGFueSBGT1IgU1lTVEVNX1RJTUUgQVMgT0YgYS5wcm9jX3RpbWUgQVMgYiAKT04gYS5pZCA9IGIudXNlcl9pZA==","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1,18]}}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"Flink16_Memory.default.dim_mysql_company":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18}],"nodeId":18,"nodeName":"Flink16_Memory.default.dim_mysql_company","parentIdSet":[]},"Flink16_Memory.default.dwd_hudi_users":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1,18]}}}', '{"edgeSet":[{"edgeId":15,"source":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7}},{"edgeId":22,"source":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"transform":"CONCAT(ods_mysql_users.name, dim_mysql_company.company_name)"},{"edgeId":28,"source":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7}},{"edgeId":24,"source":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7}},{"edgeId":26,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7}},{"edgeId":17,"source":{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"transform":"CONCAT(ods_mysql_users.name, dim_mysql_company.company_name)"},{"edgeId":30,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7},"transform":"DATE_FORMAT(birthday, \'yyyyMMdd\')"}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users.id":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.ods_mysql_users.birthday":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dim_mysql_company.company_name":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":20,"nodeName":"company_name","parentIdSet":[],"tableNodeId":18},"Flink16_Memory.default.dwd_hudi_users.name":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3,20],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.name":{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dim_mysql_company.user_id":{"childIdSet":[],"childrenCnt":0,"nodeId":19,"nodeName":"user_id","parentIdSet":[],"tableNodeId":18},"Flink16_Memory.default.dwd_hudi_users.company_name":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[20],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.proc_time":{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.birthday":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.ts":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.id":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.ts":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.partition":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}}}', 1691338821290, 1, 1, 1691338068375, 1691338191645, 0);
INSERT INTO lineage.bas_task (task_id, catalog_id, task_name, descr, `database`, task_source, task_status, task_log, table_graph, column_graph, lineage_time, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (4, 1, 'udf-demo', 'UDF demo', 'default', 'SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgaWQsCiAgICBteV9zdWZmaXhfdWRmKG5hbWUpLAogICAgbmFtZSBhcyBjb21wYW55X25hbWUsIAogICAgYmlydGhkYXksCiAgICB0cywKICAgIERBVEVfRk9STUFUKGJpcnRoZGF5LCAneXl5eU1NZGQnKSAKRlJPTQogICAgb2RzX215c3FsX3VzZXJzCg==', 0, '', '{"edgeSet":[{"edgeId":14,"source":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9,10],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8KICAgIGR3ZF9odWRpX3VzZXJzClNFTEVDVAogICAgaWQsCiAgICBteV9zdWZmaXhfdWRmKG5hbWUpLAogICAgbmFtZSBhcyBjb21wYW55X25hbWUsIAogICAgYmlydGhkYXksCiAgICB0cywKICAgIERBVEVfRk9STUFUKGJpcnRoZGF5LCAneXl5eU1NZGQnKSAKRlJPTQogICAgb2RzX215c3FsX3VzZXJz","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1]}}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9,10],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"Flink16_Memory.default.dwd_hudi_users":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1]}}}', '{"edgeSet":[{"edgeId":15,"source":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7}},{"edgeId":23,"source":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7}},{"edgeId":19,"source":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7}},{"edgeId":21,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7}},{"edgeId":17,"source":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},"transform":"my_suffix_udf(name)"},{"edgeId":25,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7},"transform":"DATE_FORMAT(birthday, \'yyyyMMdd\')"}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users.id":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.company_name":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.proc_time":{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.ods_mysql_users.birthday":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.birthday":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.ts":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.id":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.name":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.name":{"childIdSet":[9,10],"childrenCnt":2,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.ts":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.partition":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}}}', 1691338796042, 1, 1, 1691338352066, 1691338715960, 0);
INSERT INTO lineage.bas_task (task_id, catalog_id, task_name, descr, `database`, task_source, task_status, task_log, table_graph, column_graph, lineage_time, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (5, 1, 'abs_sum_demo', 'Complex transform demo', 'default', 'IElOU0VSVCBJTlRPIAogICAgZHdkX2h1ZGlfdXNlcnMKU0VMRUNUIAogICAgQUJTKHN1bV9pZCkgLAogICAgbmFtZSAsCiAgICBjb21wYW55X25hbWUgLAogICAgYmlydGhkYXkxICwKICAgIHRzICwKICAgIHAKRlJPTSAoCiAgICBTRUxFQ1QgCiAgICAgICAgU1VNKGlkKSBBUyBzdW1faWQgLAogICAgICAgIG5hbWUsCiAgICAgICAgJzEnIEFTIGNvbXBhbnlfbmFtZSAsCiAgICAgICAgTk9XKCkgQVMgYmlydGhkYXkxICwgCiAgICAgICAgTk9XKCkgQVMgdHMgLCAKICAgICAgICBEQVRFX0ZPUk1BVChiaXJ0aGRheSwgJ3l5eXlNTWRkJykgQVMgcApGUk9NIAogICAgb2RzX215c3FsX3VzZXJzCkdST1VQIEJZICAKICAgIG5hbWUsIAogICAgREFURV9GT1JNQVQoYmlydGhkYXksICd5eXl5TU1kZCcpKSA=', 0, '', '{"edgeSet":[{"edgeId":14,"source":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[13],"childrenCnt":1,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8gCiAgICBkd2RfaHVkaV91c2VycwpTRUxFQ1QgCiAgICBBQlMoc3VtX2lkKSAsCiAgICBuYW1lICwKICAgIGNvbXBhbnlfbmFtZSAsCiAgICBiaXJ0aGRheTEgLAogICAgdHMgLAogICAgcApGUk9NICgKICAgIFNFTEVDVCAKICAgICAgICBTVU0oaWQpIEFTIHN1bV9pZCAsCiAgICAgICAgbmFtZSwKICAgICAgICAnMScgQVMgY29tcGFueV9uYW1lICwKICAgICAgICBOT1coKSBBUyBiaXJ0aGRheTEgLCAKICAgICAgICBOT1coKSBBUyB0cyAsIAogICAgICAgIERBVEVfRk9STUFUKGJpcnRoZGF5LCAneXl5eU1NZGQnKSBBUyBwCkZST00gCiAgICBvZHNfbXlzcWxfdXNlcnMKR1JPVVAgQlkgIAogICAgbmFtZSwgCiAgICBEQVRFX0ZPUk1BVChiaXJ0aGRheSwgJ3l5eXlNTWRkJykp","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1]}}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[13],"childrenCnt":1,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"Flink16_Memory.default.dwd_hudi_users":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1]}}}', '{"edgeSet":[{"edgeId":15,"source":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},"transform":"ABS(SUM(id))"},{"edgeId":17,"source":{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7}},{"edgeId":19,"source":{"childIdSet":[13],"childrenCnt":1,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7},"transform":"DATE_FORMAT(birthday, \'yyyyMMdd\')"}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users.id":{"childIdSet":[8],"childrenCnt":1,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.company_name":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.proc_time":{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.ods_mysql_users.birthday":{"childIdSet":[13],"childrenCnt":1,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.birthday":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.ts":{"childIdSet":[],"childrenCnt":0,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.id":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[2],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.name":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.name":{"childIdSet":[9],"childrenCnt":1,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.ts":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.partition":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}}}', 1691339136757, 1, 1, 1691338980380, 1691339127608, 0);
INSERT INTO lineage.bas_task (task_id, catalog_id, task_name, descr, `database`, task_source, task_status, task_log, table_graph, column_graph, lineage_time, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (6, 1, 'udtf-demo', 'UDTF demo', 'default', 'IElOU0VSVCBJTlRPIAogICAgZHdkX2h1ZGlfdXNlcnMKU0VMRUNUIAogICAgbGVuZ3RoICwKICAgIG5hbWUgLAogICAgd29yZCBBUyBjb21wYW55X25hbWUgLAogICAgYmlydGhkYXkgLAogICAgdHMgLAogICAgREFURV9GT1JNQVQoYmlydGhkYXksJ3l5eXlNTWRkJykKRlJPTSAKICAgIG9kc19teXNxbF91c2VycwpMRUZUIEpPSU4gCiAgICBMQVRFUkFMIFRBQkxFKG15X3NwbGl0X3VkdGYobmFtZSkpIE9OIFRSVUU=', 0, '', '{"edgeSet":[{"edgeId":14,"source":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[8,9,10],"childrenCnt":3,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"sqlSource":"SU5TRVJUIElOVE8gCiAgICBkd2RfaHVkaV91c2VycwpTRUxFQ1QgCiAgICBsZW5ndGggLAogICAgbmFtZSAsCiAgICB3b3JkIEFTIGNvbXBhbnlfbmFtZSAsCiAgICBiaXJ0aGRheSAsCiAgICB0cyAsCiAgICBEQVRFX0ZPUk1BVChiaXJ0aGRheSwneXl5eU1NZGQnKQpGUk9NIAogICAgb2RzX215c3FsX3VzZXJzCkxFRlQgSk9JTiAKICAgIExBVEVSQUwgVEFCTEUobXlfc3BsaXRfdWR0ZihuYW1lKSkgT04gVFJVRQ==","target":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1]}}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users":{"childIdSet":[7],"childrenCnt":1,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},{"childIdSet":[8,9,10],"childrenCnt":3,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1}],"nodeId":1,"nodeName":"Flink16_Memory.default.ods_mysql_users","parentIdSet":[]},"Flink16_Memory.default.dwd_hudi_users":{"childIdSet":[],"childrenCnt":0,"columnNodeList":[{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}],"nodeId":7,"nodeName":"Flink16_Memory.default.dwd_hudi_users","parentIdSet":[1]}}}', '{"edgeSet":[{"edgeId":19,"source":{"childIdSet":[8,9,10],"childrenCnt":3,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7},"transform":"my_split_udtf(name).word"},{"edgeId":23,"source":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7}},{"edgeId":17,"source":{"childIdSet":[8,9,10],"childrenCnt":3,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7}},{"edgeId":15,"source":{"childIdSet":[8,9,10],"childrenCnt":3,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[3],"tableNodeId":7},"transform":"my_split_udtf(name).length"},{"edgeId":21,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7}},{"edgeId":25,"source":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"target":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7},"transform":"DATE_FORMAT(birthday, \'yyyyMMdd\')"}],"nodeMap":{"Flink16_Memory.default.ods_mysql_users.id":{"childIdSet":[],"childrenCnt":0,"nodeId":2,"nodeName":"id","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.company_name":{"childIdSet":[],"childrenCnt":0,"nodeId":10,"nodeName":"company_name","parentIdSet":[3],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.proc_time":{"childIdSet":[],"childrenCnt":0,"nodeId":6,"nodeName":"proc_time","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.ods_mysql_users.birthday":{"childIdSet":[11,13],"childrenCnt":2,"nodeId":4,"nodeName":"birthday","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.birthday":{"childIdSet":[],"childrenCnt":0,"nodeId":11,"nodeName":"birthday","parentIdSet":[4],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.ts":{"childIdSet":[12],"childrenCnt":1,"nodeId":5,"nodeName":"ts","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.id":{"childIdSet":[],"childrenCnt":0,"nodeId":8,"nodeName":"id","parentIdSet":[3],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.name":{"childIdSet":[],"childrenCnt":0,"nodeId":9,"nodeName":"name","parentIdSet":[3],"tableNodeId":7},"Flink16_Memory.default.ods_mysql_users.name":{"childIdSet":[8,9,10],"childrenCnt":3,"nodeId":3,"nodeName":"name","parentIdSet":[],"tableNodeId":1},"Flink16_Memory.default.dwd_hudi_users.ts":{"childIdSet":[],"childrenCnt":0,"nodeId":12,"nodeName":"ts","parentIdSet":[5],"tableNodeId":7},"Flink16_Memory.default.dwd_hudi_users.partition":{"childIdSet":[],"childrenCnt":0,"nodeId":13,"nodeName":"partition","parentIdSet":[4],"tableNodeId":7}}}', 1691339489100, 1, 1, 1691339274970, 1691339482534, 0);
INSERT INTO lineage.bas_function (function_id, catalog_id, function_name, `database`, invocation, function_path, class_name, descr, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (1, 1, 'my_suffix_udf', 'default', 'flink_suffix_udf(String1)', 'functions/function-a/function-a.jar', 'com.hw.lineage.flink.table.udf.functiona.FlinkSuffixFunction', 'return String', 1, 1, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_function (function_id, catalog_id, function_name, `database`, invocation, function_path, class_name, descr, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (2, 1, 'my_prefix_udf', 'default', 'flink_prefix_udf(String1,Integer2)', 'functions/function-b/function-b.jar', 'com.hw.lineage.flink.table.udf.functionb.FlinkPrefixFunction', 'return String', 1, 1, 1674565178000, 1674565178000, 0);
INSERT INTO lineage.bas_function (function_id, catalog_id, function_name, `database`, invocation, function_path, class_name, descr, create_user_id, modify_user_id, create_time, modify_time, invalid) VALUES (3, 1, 'my_split_udtf', 'default', 'flink_split_udtf(String1)', 'functions/function-b/function-b.jar', 'com.hw.lineage.flink.table.udf.functionb.FlinkSplitFunction', 'return ROW<word STRING, length INT>', 1, 1, 1674565178000, 1674565178000, 0);