René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"有count函数的字段没列出来","articleBody":"SQL：\r\ninsert into xxxxxxxxxxxxxxx\r\nselect\r\n        NVL (area_name, '全省'),\r\n        count(\r\n                distinct case\r\n                        when jc_fir_lvl_svctype = '移网'\r\n                        and is_iot = '0'\r\n                        and is_mon_dev = '1' then user_id\r\n                end\r\n        ) + count(\r\n                distinct case\r\n                        when jc_fir_lvl_svctype = '宽带'\r\n                        and is_iot = '0'\r\n                        and is_mon_dev = '1' then user_id\r\n                end\r\n        ) 发展量,\r\n        count(\r\n                distinct case\r\n                        when jc_fir_lvl_svctype = '移网'\r\n                        and is_iot = '0'\r\n                        and is_mon_dev = '1' then user_id\r\n                end\r\n        ) 移网发展量,\r\n        count(\r\n                distinct case\r\n                        when jc_fir_lvl_svctype = '宽带'\r\n                        and is_iot = '0'\r\n                        and is_mon_dev = '1' then user_id\r\n                end\r\n        ) 宽带发展量\r\nfrom\r\n        PER_086_DWE.DWE_V_D_CUS_GRID_USER_INFO_Z\r\nwhere\r\n        month_id = '202405'\r\n        and DAY_ID = '29'\r\n        and SCENE_2ND in ('城区直销', '农村直销')\r\n        and SCENE_TYPE \u003c\u003e '政企'\r\n        and collection_type = 'HQ'\r\ngroup by\r\n        rollup (area_name)\r\n        \r\n输出：\r\nc:\\RPA_TEST\\python_data_lineage-main\u003epython dlineage.py /t mysql /text  /s  /f ..\\test.sql\r\n..\\test.sql is not a text file.\r\nNVL (area_name, '全省') depends on: PER_086_DWE.DWE_V_D_CUS_GRID_USER_INFO_Z.area_name\r\n","author":{"url":"https://github.com/wangxn52","@type":"Person","name":"wangxn52"},"datePublished":"2024-06-06T09:27:42.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/2/python_data_lineage/issues/2"}