[BUG]L2.fact_match_players表关键空值合理性排查 #5

New Issue

jacky · 2026-01-25T00:58:43+08:00

jacky commented

2026-01-25 00:58:43 +08:00

==================== Table: fact_match_players ====================
Total Rows: 1790
------------------------------------------------------------
             Field  Nulls  Null%  Zeros  Zero%  Unique                                            Example
      damage_total      0   0.00   1790 100.00       1                                                  0
        hold_total      0   0.00   1790 100.00       1                                                  0
 many_assists_cnt5      0   0.00   1790 100.00       1                                                  0
     flash_assists      0   0.00   1790 100.00       1                                                  0
   damage_received      0   0.00   1790 100.00       1                                                  0
    damage_receive      0   0.00   1790 100.00       1                                                  0
          kd_ratio      0   0.00   1790 100.00       1                                                0.0

排查表内的空值是否正常。
文件来源：ETL/verify/verify_deep.py产出。
如果是真实空值，保留不变；如果是来源空值或命名有无，考虑修改schema与数据库删除无效字段。
首先产出原因，然后来选择下一步操作。

``` ==================== Table: fact_match_players ==================== Total Rows: 1790 ------------------------------------------------------------ Field Nulls Null% Zeros Zero% Unique Example damage_total 0 0.00 1790 100.00 1 0 hold_total 0 0.00 1790 100.00 1 0 many_assists_cnt5 0 0.00 1790 100.00 1 0 flash_assists 0 0.00 1790 100.00 1 0 damage_received 0 0.00 1790 100.00 1 0 damage_receive 0 0.00 1790 100.00 1 0 kd_ratio 0 0.00 1790 100.00 1 0.0 ``` 排查表内的空值是否正常。文件来源：ETL/verify/verify_deep.py产出。如果是真实空值，保留不变；如果是来源空值或命名有无，考虑修改schema与数据库删除无效字段。首先产出原因，然后来选择下一步操作。

xunyulin230420 was assigned by jacky

2026-01-25 01:04:35 +08:00

jacky added this to the [BUG] BUG排查看板 project 2026-01-25 01:44:29 +08:00

jacky moved this to High Priority in [BUG] BUG排查看板 on 2026-01-25 01:44:33 +08:00

jacky added the Kind/Bug

Priority

High

2

labels 2026-01-25 01:52:55 +08:00

jacky closed this issue

2026-01-30 17:27:20 +08:00

Sign in to join this conversation.